Table Description
COMMENTS=nbsp;Internal Referral
: nbsp;An internal referral is created to refer a client to an internal agency participant.
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::InternalReferral::InternalReferral
Controlling File: ReferralsLite\model\Packages\Entity\LiteReferral\InternalReferral\InternalReferral.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
caseIDdetailsyes

CaseID of the CaseHeader in respect of which this CaseParticipantRole was entered.

CASE_ID SVR_INT64
caseParticipantRoleIDdetailsyes

A case participant for whom an internal referral has been created.

CASE_PARTICIPANT_ROLE_ID SVR_INT64
internalReferralIDkeynoUnique identifier of the related lite referral with which the referral link is associated.INTERNAL_ID SVR_INT64
internalAgencyIDdetails 

An internal agency to which the participant was referred to.

INTERNAL_ID SVR_INT64
applicationIDdetailsyes

ApplicationID of the Application in respect of which this CaseParticipantRole was entered.

INTERNAL_ID SVR_INT64
programTypedetails The type of product this referral relates to.PROGRAM_OFFERING_TYPEProgramTypeSVR_STRING<10>
assessmentTimerStartDatedetails Holds the date from which the assessment timer would be started.CURAM_DATE SVR_DATE
assignedTodetailsyesThe name of the user for whom this referral has been assigned.USER_NAME SVR_STRING<64>
Foreign Keys (4)
ChildParent
InternalReferral.applicationIDApplication.applicationID
InternalReferral.caseIDCaseHeader.caseID
InternalReferral.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
InternalReferral.internalReferralIDLiteReferral.liteReferralID
Indices (4)
Index NameAttributes
IND_833746576caseID
IND__22424442applicationID
IND_289058990assignedTo
IND_1550698223caseParticipantRoleID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
searchByCasereadmulti Retrieves all internal referral records based on the case ID. 
searchByApplicationreadmulti Retrieves all internal referral records based on the application ID. 
searchByAssignedToreadmulti Retrieves all internal referral records based on the user to whom referrals have been assigned. 
readread Standard Operation 
modifymodify Standard Operation 
insertinsert Standard Operation 
removeremove Standard Operation 
Related Pages (25)