CREOLECaseDetermination

This is the main table which owns the record of each determination.

The Engine stores a single row on this table for each determination result which ends up getting stored.

The details stored vary slightly depending on the type of determination being stored (Manual Check /Snapshot/Case Assessment). For data which is common to all types of determination, see the core Entity Relationship Diagram. The tables below show:

the CREOLECaseDetermination data which is populated regardless of the type of determination; and
the CREOLECaseDetermination data which varies according to the type of determination.

Table 1. Population of common CREOLECaseDetermination data
Attribute Name	Value
`creoleCaseDeterminationID`	Unique ID assigned by the system.
`caseID`	Identifier of the case which has its eligibility and entitlement determined.
`determinationDateTime`	The date and time that the determination was made.
`type`	The type of this determination. The value of this attribute governs the varying data stored, as shown in the following table.
`createdByUser`	The user who created this determination.
`determinationResultDataID`	The ID of the record which stores the XML document for the overall determination result.

Table 2. Population of CREOLECaseDetermination data, according to the type of determination
attribute name/determination type	Manual Check	Snapshot	Case Assessment
`assessmentReason`	`blank`	`blank`	Value from the `CaseAssessmentDetReason` code table indicating the reason why the case assessment determination was requested. You are permitted to add new values to this code table to contribute your own assessment reasons if required.
`assessmentStatus`	`blank`	`blank`	Value from the `CaseDeterminationStatus` code table indicating whether this determination is: Current (and thus is being used for deliveries such as financials); or Superseded (and thus has been replaced by a different Current record). Extensions to this code table are not supported.
`snapshotReason`	`blank`	Value from the `CaseSnapshotDetReason` code table indicating the reason that the snapshot was requested. You are permitted to add new values to this code table to contribute your own snapshot reasons if required.	`blank`
`evidenceUsed`	Value from the `CaseDetEvidenceUsed` code table indicating whether the manual check was based off: in-edit changes to evidence; or active evidence only. Extensions to this code table are not supported.	`blank`	`blank`
`ruleObjectSnapshotDataID`	`blank`, unless the application has been configured to record snapshots for manual check determinations (using the `curam.creole.manualeligibilitycheckdetermination.store.ruleobjectsnapshot` environment variable), in which case this attribute stores the ID of the record which stores the XML document of the snapshot of the rule object data used in the determination.	The ID of the record which stores the XML document of the snapshot of the rule object data used in the determination.	The ID of the record which stores the XML document of the snapshot of the rule object data used in the determination.