Table Description
Participant Triage: Holds information about Participant Triages. Triage provides a way for agencies to gauge a client's needs when they phone or visit the agency. For example a client may have an immediate need for food for his or her family. Triage will identify these needs and provide a list of suitable services and programs to help meet those needs. 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'.
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::Intake::IntakeModules::IntakeTriage::Entity::ParticipantTriage
Controlling File: Intake\model\Packages\IntakeModules\IntakeTriage\Entity\Entity.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
participantTriageIDkeynoThe internal system identifier of the IntakeTriage record.INTERNAL_ID SVR_INT64
concernRoleIDdetailsyesThe concern role id.CONCERN_ROLE_ID SVR_INT64
userNamedetailsyesThe userName of casewroker that created the triage 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'.USER_NAME SVR_STRING<64>
firstRanDateTimedetails The first timein which a triage was ranCURAM_DATETIME SVR_DATETIME
lastRanDateTimedetails The last time in which a triage was ranCURAM_DATETIME SVR_DATETIME
recordStatusdetails  RECORD_STATUS_CODERecordStatusSVR_STRING<10>
triageStatusdetails  CODETABLE_CODE SVR_STRING<10>
triageResultIDdetailsyesThe Intake Process assoicated with the triageINTERNAL_ID SVR_INT64
Foreign Keys (4)
ChildParent
ParticipantTriage.concernRoleIDConcernRole.concernRoleID
ParticipantTriage.triageResultIDTriageResult.triageResultID
TriageExecution.participantTriageIDParticipantTriage.participantTriageID
TriageNote.participantTriageIDParticipantTriage.participantTriageID
Indices (2)
Index NameAttributes
ParticipantTriageResultIdxtriageResultID
ParticipantTrgConcernRoleIDIdxconcernRoleID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: participantTriageID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchActiveByConcernRoleIDreadmultiORDER_BY: firstRanDateTime
Search for active triage records for a specific concern role. 
Related Pages (4)