Table Description
PDM Run Case Control Failure: The PDM run case control failure table. This stores process rejection steps for PDM cases, for both Business and Technical reasons, for example: if an MA or CHIP case can not be auto renewed a record will be written to this table.
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::Periodic Data Matching::Entity::PDMRunCaseControlFailure
Controlling File: HCR\model\PeriodicDataMatching\Entity\PDMEntity.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
pdmRunCaseControlFailureIDkeynoThe unique identifier of the PDMRunCaseControlFailure.INTERNAL_ID SVR_INT64
pdmRunCaseControlIDdetailsnoForeign Key to the PDMRunCaseControl record that failed processing.INTERNAL_ID SVR_INT64
pdmRunInstanceIDdetailsnoForeign Key to the PDMRunInstance table, this stores details of which instance of a given PDM process step was running when the failure occurred.INTERNAL_ID SVR_INT64
typeCodedetailsnoIndicates if the failure was from a Business or Technical issue.PDM_RUN_CASE_CONTROL_FAILURE_TYPE_CODEPDMRunCaseFailureTypeCodeSVR_STRING<10>
reasonCodedetailsnoThe Reason relevant to the part of the batch process that failed eg "Projected Eligibility", "Eligibility Comparison", "Notice Generation".PDM_RUN_CASE_CONTROL_FAILURE_REASONPDMRunCaseFailureReasonSVR_STRING<10>
messagedetailsnoContains the exception or validation message (populated for both technical and business failures).PDM_RUN_CASE_CONTROL_FAILURE_MESSAGE SVR_STRING<100000>
detailsdetailsyesFull exception stack trace for technical failures.PDM_RUN_CASE_CONTROL_FAILURE_DETAILS SVR_STRING<100000>
dateTimedetailsnoDate and time error occurred.PDM_RUN_CASE_CONTROL_FAILURE_DATETIME SVR_DATETIME
runAttemptdetailsnoIndicates the run attempt for this run case control. This is used to distinguish different status histories in the event that the run case control record is reset.RUN_ATTEMPT SVR_INT32
Foreign Keys (2)
ChildParent
PDMRunCaseControlFailure.pdmRunCaseControlIDPDMRunCaseControl.pdmRunCaseControlID
PDMRunCaseControlFailure.pdmRunInstanceIDPDMRunInstance.pdmRunInstanceID
Indices (3)
Index NameAttributes
PDMRunCaseControlIDXpdmRunCaseControlID
PDMFailureSpanIDXpdmRunCaseControlID, runAttempt, typeCode, reasonCode
IND__1344193582pdmRunInstanceID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
searchByRunCaseControlIDreadmultiORDER_BY: dateTime ASC
Find all of the records relevant to a given run case control. 
readread Standard read method. 
insertinsertAUTO_ID: pdmRunCaseControlFailureID
Standard insert method. 
readByRunCaseControlIDAndRunAttemptnsread Read the failure record corresponding to a given run attempt. 
Related Pages (0)