Table Description
Lite Agency Referral: A Lite agency referral is created to refer a client to an external agency for a program offering.

Example

For example, a client may have a referral created for them where a program offering is recommended from a particular external agency.
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::LiteAgencyReferral::LiteAgencyReferral
Controlling File: ReferralsLite\model\Packages\Entity\LiteReferral\LiteAgencyReferral\LiteAgencyReferral.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
liteReferralIDkeyno INTERNAL_ID SVR_INT64
externalAgencyBranchOfferingIDdetailsyesNote: 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>
Foreign Keys (2)
ChildParent
LiteAgencyReferral.externalAgencyBranchOfferingIDExternalAgencyBranchOffering.externalAgencyBranchOfferingID
LiteAgencyReferral.liteReferralIDLiteReferral.liteReferralID
Indices (1)
Index NameAttributes
IND_1451355554externalAgencyBranchOfferingID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
removeremove Standard Operation 
Related Pages (0)