Table Description
Attributes (16)
AttributeKeyNullableDescriptionDDL Type
dependencyTraceIDYesNoAn ascending number uniquely identifying the recordSVR_INT64
pcsID  Change set ID, if applicableSVR_INT64
pcsID2  Secondary change set ID, if applicableSVR_INT64
timestamp1  Time stamp of this event SVR_DATETIME
status1  Status code of the PCS, if applicableSVR_STRING<10>
status2  Secondary status code of the PCS, if applicable SVR_STRING<10>
instDataID  The instance data ID if applicableSVR_INT64
traceType  The type of this trace record. Can be: - link determination to PCS - link PCS to child PCS - link PCI in batch to its original PCS SVR_STRING<10>
txType  The transaction type, corresponding to what would appear on the AuditTrail table. Can be online/deferred/batch/other. SVR_STRING<1>
ticketID  The instance data ID if applicableSVR_INT64
instanceID  The instance data ID if applicableSVR_INT64
caseID  The case ID, if applicableSVR_INT64
determinationID  Determination ID, if applicableSVR_INT64
count1  General purpose count field 1. SVR_INT64
count2  General purpose count field 2. SVR_INT64
txID  Identifier for current transaction. SVR_INT64
Indices (1)
Index NameAttributes
DepTraceCaseTimestampIDXcaseID, timestamp1
Related Pages (38)
AppealWizard_listCreoleDecisionsForDetermination
Check Eligibility (DefaultICProduct_checkEligibilityCaseDetermination)
Current Determination (DefaultICProduct_listCreoleDecisions)
DefaultICProduct_listCreoleDecisionsForDetermination
Manual Eligibility Check (DefaultICProduct_readManualEligibilityCheckDecision)
Enable Special Enrollment Shopping Experience (HCR_enableAndLogSpecialEnrollmentShopping)
Enable Special Enrollment Shopping Experience (HCR_enableSpecialEnrollmentShopping)
Home (HCRChildrenHealthInsurancePlan)
HCRChildrenHealthInsurancePlan_panelDetails
HCREmergencyMedicaid_panelDetails
Home (HCREmergencyMedicaidHome)
HCREmployerSponsoredInsurace_panelDetails
Home (HCREmployerSponsoredInsuraceHome)
HCRExemption_panelDetails
Home (HCRExemptionHome)
Home (HCRInsuranceAssistance)
HCRInsuranceAssistance_panelDetails
HCRStateBasicHealthPlan_panelDetails
Home (HCRStateBasicHealthPlanPDHome)
HCRUnassistedQualifiedHealthPlan_panelDetails
Home (HCRUnassistedQualifiedHealthPlanHome)
Work Eligibility (IntegratedCase_caParticipationWorkEligibility)
Work Eligibility (IntegratedCase_faParticipationWorkEligibility)
Check Eligibility (ProductDelivery_checkEligibilityCaseDetermination)
ProductDelivery_errorDetermination
ProductDelivery_listCaseApprovalEventCreoleDecisions
View Decision (ProductDelivery_listCaseApprovalEventCreoleDecisionsViewOnly)
Determination Results (ProductDelivery_listCreoleDecisions)
ProductDelivery_listCreoleDecisionsForDetermination
Determination Results (ProductDelivery_listMACreoleDecision)
Determination Results (ProductDelivery_listMACreoleDecisions)
ProductDelivery_listSubmitForApprovalCreoleDecisions
ProductDelivery_listSubmitForApprovalCreoleDecisionsViewOnly
Manual Eligibility Check (ProductDelivery_readManualEligibilityCheckDecision)
Check Eligibility (ServiceDelivery_checkEligibilityCaseDetermination)
Manual Eligibility Check (ServiceDelivery_readManualEligibilityCheckDecision)
Home (StreamlinedMedicaid_home)
StreamlinedMedicaid_panelDetails