Table Description
External Agency Branch Offering: Stores the Program Offerings for an External Agency Branch. Stores the Program Offerings for an External Agency Branch.

Example
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::LiteReferral::Entity::ExternalAgencyBranchOffering::ExternalAgencyBranchOffering
Controlling File: ReferralsLite\model\Packages\Entity\LiteReferral\ExternalAgencyBranchOffering\ExternalAgencyBranchOffering.efx
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
programOfferingIDdetailsyesThe name of the data store schema under which this application was made. Note: A missing foreign key was created for this field in Curam 6.0 SP3. The Allow Nulls on this foreign key field was changed from 'Not Specified' to 'Yes' as this needs to be specifed on creation of the foreign key. However this should be 'No' but to prevent upgrade impact, the constraint could not be tightened from 'Not Specified' to 'No'.INTERNAL_ID SVR_INT64
externalAgencyBranchIDdetailsyesThe name of the data store schema under which this application was made. Note: A missing foreign key was created for this field in Curam 6.0 SP3. The Allow Nulls on this foreign key field was changed from 'Not Specified' to 'Yes' as this needs to be specifed on creation of the foreign key. However this should be 'No' but to prevent upgrade impact, the constraint could not be tightened from 'Not Specified' to 'No'.INTERNAL_ID SVR_INT64
recordStatusdetails  RECORD_STATUS_CODERecordStatusSVR_STRING<10>
externalAgencyBranchOfferingIDkeyno INTERNAL_ID SVR_INT64
Foreign Keys (3)
ChildParent
ExternalAgencyBranchOffering.externalAgencyBranchIDExternalAgencyBranch.externalAgencyBranchID
ExternalAgencyBranchOffering.programOfferingIDProgramOffering.programOfferingID
LiteAgencyReferral.externalAgencyBranchOfferingIDExternalAgencyBranchOffering.externalAgencyBranchOfferingID
Indices (2)
Index NameAttributes
IND__2013286796externalAgencyBranchID
IND_961408126programOfferingID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: externalAgencyBranchOfferingID
Standard Operation 
modifymodify Standard Operation 
readread Standard Operation 
searchByExternalAgencyBranchIDreadmulti   
Related Pages (0)