Table Description
CREOLE Program Group Determination: Table containing the determination information for an invocation of the program group rules.
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::HCR::CREOLEDetermination::Entity::CREOLEProgGrpDetermination
Controlling File: HCR\model\CREOLEDetermination\CREOLEDetermination.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
creoleProgGrpDeterminationIDkeynoUnique ID assigned by the system.INTERNAL_ID SVR_INT64
caseIDdetailsnoIdentifier of the case.CASE_ID SVR_INT64
determinationTypedetailsnoThe program group determination type for this determination.PROGRAM_GROUP_DETERMINATION_TYPEProgGrpDeterminationTypeSVR_STRING<10>
determinationDateTimedetailsnoThe date and time that the determination was made.CURAM_DATETIME SVR_DATETIME
createdByUserdetailsyesUser name of the user that created this determination.USER_NAME SVR_STRING<64>
ruleObjectSnapshotDataIDdetailsyesThe ID of the record which stores a snapshot of the CREOLE rule object data used in the determination.INTERNAL_ID SVR_INT64
Foreign Keys (2)
ChildParent
CREOLEProgGrpDetermination.ruleObjectSnapshotDataIDCREOLEProgGrpDeterData.creoleProgGrpDeterDataID
ProgGrpProjectedEligibility.creoleProgGrpDeterminationIDCREOLEProgGrpDetermination.creoleProgGrpDeterminationID
Indices (3)
Index NameAttributes
ProgGrpCaseIDTypeDeterIdxcaseID, determinationType
ProgGrpCaseIDDeterminationIdxcaseID
IND_1309431769ruleObjectSnapshotDataID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: creoleProgGrpDeterminationID
Standard insert method. 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard modify method. 
readread Standard read method. 
searchByCaseIDreadmultiORDER_BY: determinationDateTime
Return the records associated with the specified case ID. 
searchByCaseIDTypereadmultiORDER_BY: determinationDateTime
Return the records associated with the specified case ID and determination type. 
Related Pages (0)