Table Description
Situation: A Situation is a concern that a participant is facing that is included as part of an action plan so that it may be addressed,

An situation may be directly associated with an action or allegation within an investigation or may just be part of an overall action plan in an investigation.

Example

Examples of Situations are that participant may have financial problems or social attachment concerns that must be addressed..
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::Situation::Entity::Situation
Controlling File: core\model\Packages\Reference Model\Service Layer\Situation\Entity\Situation_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
situationIDkeynoUnique internal reference number of the situation record.SITUATION_ID SVR_INT64
actionPlanIDdetails Unique internal reference number of the action plan record to which the action plan is associated.INTERNAL_ID SVR_INT64
situationCategorydetails The type of situation to be addressed by the action. ACTION_SITUATION_CATEGORYActionSituationCategorySVR_STRING<10>
situationRequiringActiondetails Description of the situation that needs to be addressed by the action.ACTION_SITUATION_REQUIRING_ACTION SVR_STRING<200>
expectedEndDatedetails The date on which the action addressing the situation is expected to be completed. CURAM_DATE SVR_DATE
actualEndDatedetails The date on which the action addressing the situation is actually completed or is not longer effective. CURAM_DATE SVR_DATE
outcomedetails The outcome of the action addressing the situationACTION_OUTCOMEActionOutcomeSVR_STRING<10>
commentsdetails Narrative associated with the situation.COMMENTS SVR_STRING<300>
recordStatusdetails Status of the situation record. The values are 'Active' or 'Canceled'. Logical deletion is supported.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: situationID
PRE_DATA_ACCESS: yes
Method to create new Situation record. 
readread Method to read a Situation record. 
modifymodify Method to modify a Situation record. 
searchActiveByActionPlanIDnsmultiPRE_DATA_ACCESS: yes
 		Method to read Situation records for specified actionPlanID.SQL
searchByActionnsmultiPRE_DATA_ACCESS: yes
 		Method to read Situation records for specified actionID.SQL
searchSituationsForAssociationnsmultiPRE_DATA_ACCESS: yes
 		Method to read Situation details list records for specified actionPlanID and not linked with specified actionID.SQL
cancelnsmodifyPRE_DATA_ACCESS: yes
Method to cancel a Situation record. 
searchByActionPlanIDnsmulti  SQL
Related Pages (16)