Table Description
COMMENTS=Lite Referral: A lite referral is created to refer a client to an external agency participant or a provider for a service.

Example

For example, a client may have a referral created for them where a program offering is recommended from a particular provider.
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::LiteReferral::LiteReferral
Controlling File: ReferralsLite\model\Packages\Entity\LiteReferral\LiteReferral.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (18)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
liteReferralIDkeyno INTERNAL_ID SVR_INT64
concernRoleIDdetailsno CONCERN_ROLE_ID SVR_INT64
firstNamedetailsno NAME SVR_STRING<131>
lastNamedetailsno NAME SVR_STRING<131>
addressIDdetailsyes ADDRESS_ID SVR_INT64
homePhoneNumberIDdetailsyes PHONE_NUMBER_ID SVR_INT64
workPhoneNumberIDdetailsyes PHONE_NUMBER_ID SVR_INT64
mobilePhoneNumberIDdetailsyes PHONE_NUMBER_ID SVR_INT64
emailAddressIDdetailsyes EMAIL_ADDRESS_ID SVR_INT64
additionalInformationdetails  COMMENTS SVR_STRING<300>
typedetails  REFERRAL_TYPELiteReferralTypeSVR_STRING<10>
statusdetails  REFERRAL_STATUSLiteReferralStatusSVR_STRING<10>
recordStatusdetails  RECORD_STATUS_CODERecordStatusSVR_STRING<10>
startDatedetails  CURAM_DATETIME SVR_DATETIME
referredBydetails  USER_NAME SVR_STRING<64>
commentsdetails  COMMENTS SVR_STRING<300>
withdrawReasondetails  WITHDRAW_REASONReferralWithdrawReasonSVR_STRING<10>
referralNamedetails  NAME SVR_STRING<131>
Foreign Keys (9)
ChildParent
LiteReferral.addressIDAddress.addressID
LiteReferral.concernRoleIDConcernRole.concernRoleID
LiteReferral.emailAddressIDEmailAddress.emailAddressID
LiteReferral.mobilePhoneNumberIDPhoneNumber.phoneNumberID
LiteReferral.workPhoneNumberIDPhoneNumber.phoneNumberID
LiteReferral.homePhoneNumberIDPhoneNumber.phoneNumberID
InternalReferral.internalReferralIDLiteReferral.liteReferralID
LiteAgencyReferral.liteReferralIDLiteReferral.liteReferralID
LiteProviderReferral.liteReferralIDLiteReferral.liteReferralID
Indices (8)
Index NameAttributes
LiteRefTypelIdxtype
LiteRefStatusIdxstatus
LiteRefConcernIdxconcernRoleID
IND__1296738469addressID
IND__381391865emailAddressID
IND_992407676mobilePhoneNumberID
IND_1181976941workPhoneNumberID
IND__2147239329homePhoneNumberID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: liteReferralID
Standard Operation 
modifymodifyGENERATE_AUDIT: yes
OPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
removeremove Standard Operation 
searchByConcernRolereadmulti   
searchByConcernRoleAndTypereadmulti   
Related Pages (4)