Table Description
HCR COC Status: The status for the change of circumstances process within HCR.

Captures various statuses for the change of circumstances process within HCR.

Example

For example, a Citizen initiates a COC process. This COC will have a recorded status of started. When the Citizen signs and submits a COC, it will have a status of signed and submitted.
Model Details
Location in Model: Logical View::MetaModel::Curam::HCROnline::Service Layer::entity::HCRCOCStatus::HCRCOCStatus
Controlling File: HCROnline\model\Service Layer\Entity\Entity.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
hcrCoCStatusIDkeynoUnique identifier for this table.HCR_COC_STATUS_ID SVR_INT64
lifeEventTypeIDdetailsnoThe life event identifier.HCR_COC_LIFE_EVENT_TYPE_ID SVR_INT64
concernRoleIDdetailsnoThe identifier of the citizen's concern role record.CONCERN_ROLE_ID SVR_INT64
caseIDdetailsnoThe identifier of the ongoing case that the COC is being performed on.CASE_ID SVR_INT64
statusdetailsnoThe status of the COC process.HCR_COC_STATUSHCRCocStatusSVR_STRING<10>
lifeEventIDdetailsnoThe life event identifier.HCR_COC_LIFE_EVENT_ID SVR_INT64
categorydetailsnoThe category the status falls into e.g. statuses of COC processing in progress and COC with case worker both fall into the COC in progress category.HCR_COC_CATEGORYHCRCocCategorySVR_STRING<10>
timestampdetailsnoDate/Time for the action.CURAM_DATETIME SVR_DATETIME
Indices (3)
Index NameAttributes
COCLEIDIndexlifeEventID
caseIDCategoryIndexcaseID, category
caseCoCStatusIdxcaseID, status
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: hcrCoCStatusID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchHistoryByLifeEventIDnsmulti Returns a list of HCRCOCStatusHistory records by searching across HCRCoCStatus and HCRCoCStatusHistory and order by date/time descending so that the history appears in reverse chronological orderSQL
readByLifeEventIDnsread Returns a single record based on the LifeEventID. 
readread Standard Operation 
searchByCaseAndStatusreadmulti Returns a list of HCRCOCStatus records based on caseID and status. 
Related Pages (2)