Table Description
Screening Execution: Holds information about the screening executions. Screening provides a way for agencies to enter client information efficiently and get an immediate evaluation of potential eligibility for multiple programs without going through the full program eligibility assessment and approval process.

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::Intake::Entity::ParticipantScreening::ParticipantScreening
Controlling File: Intake\model\Packages\Entity\ScreeningExecution\ScreeningExecution_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
screeningExecutionIDkeynoThe internal system identifier of the ScreeningExecution record.SCREENING_EXECUTION_ID SVR_INT64
screeningStatusdetails The status of the screening execution.SCREENING_STATUSScreeningStatusSVR_STRING<10>
screeningTypedetails The type of the screening execution.SCREENING_CATEGORY_IDScreeningCategorySVR_STRING<10>
datastoreIDdetailsyesThe ID of the data store used by the screening execution.DATASTORE_UID SVR_INT64
iegExecutionIDdetailsyesThe ID of the IEG script.INTERNAL_ID SVR_INT64
concernRoleIDdetailsyesThe concern role id. 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'.CONCERN_ROLE_ID SVR_INT64
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
userNamedetailsyesThe userName of casewroker that created the triageUSER_NAME SVR_STRING<64>
screeningResultIDdetailsyesThe Intake Process assoicated with the triageINTERNAL_ID SVR_INT64
Foreign Keys (5)
ChildParent
ParticipantScreening.concernRoleIDConcernRole.concernRoleID
ParticipantScreening.datastoreIDDatastoreEntity.entityID
ParticipantScreening.iegExecutionIDIEGExecutionState.executionID
ParticipantScreening.screeningResultIDScreeningResult.screeningResultID
IntakeScreeningExecution.screeningExecutionIDParticipantScreening.screeningExecutionID
Indices (4)
Index NameAttributes
ParticipantScrDataStoreIDIdxdatastoreID
ParticipantScrConcernRoleIDIdxconcernRoleID
ParticipantScrIEGExecIDIdxiegExecutionID
IND__948518670screeningResultID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: screeningExecutionID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchByScreeningTypeAndStatusreadmulti Searches for ScreeningExecution records based on screening type and status. 
searchByIEGExecutionIDreadmulti Searches for ScreeningExecution records based on the IEG execution ID. 
searchByConcernRoleIDreadmulti Searches for ScreeningExecution records based on the concern Role ID. 
Related Pages (11)