AP_CLAIM_CHANGE_HX

Description: |
The AP_CLAIM_CHANGE_HX table contains the change history of an accounts payable claim.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
CLAIM_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | CLAIM_ID | NUMERIC | No |
The unique identifier of the accounts payable claim record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | CHANGE_TIME | DATETIME (Local) | No |
The date and time of change to the claim.
4 | ACTION_C_NAME | VARCHAR | No |
The Change History Action category ID for the claim record. Indicates the item changed on the claim (i.e. workflow, workflow other status, etc.).
May contain organization-specific values: No
Category Entries:
Coverage Selection for Crossover
Downstream Crossover Claim
Possible Duplicate Warning
Claim Restoration
Automatic Action
Referring Provider
Attachment
MC Claims Workflow
Provider
Place of Service
Operating Provider
Other Provider
Attending Provider
Rendering Provider
Supervising Provider
Vendor
Coverage Selection
Owning Business Segment
Referrals
Deny Claim Source
Frozen Status Change
Claim Specialty
Status Change
AP Status Change
Date Received
CMS Unclean Status
Date Received by Carrier
Claim EOB Code
Background Adjudication Queue Entry ID
Network Override
Service Change
Workflow Other Status
Workflow Print Status
Is Clinically Invalid Claim?
Override Is Clinically Invalid Claim?
Trait 1 Evaluation
Trait 2 Evaluation
Trait 3 Evaluation
Trait 4 Evaluation
Trait 5 Evaluation
Upstream Crossover Claim
Original Claim for this Reversal Claim
Original Claim for this Corrected Claim
Original Claim for this Adjustment Claim
Third-Party Pricer
Finalization Status
Override Interest Start Date
Adjustment Interest Start Date
Held for AP Reasons Change
Modifiers
Assoc Diags
Service Line EOB Codes
Assigned Referrals
POS Type
Revenue Code
DRG Code
PPS Price - For PPS Code
Service Line Billed
Payer Initiated Reduction
Primary Insurance Amount
Primary Patient Portion
Override Allowed Amount Reason
Override Disallowed Amount Reason
NDC Code
NDC Quantity
NDC Units
NDC Prescription Number
NDC Link Sequence Number
NDC Section 340B
Original Downcoded Code
Original Downcoded Qualifying Payment Amount
Override Service Interest Start Date
Service Code
Quantity
Service From Date
Service To Date
Type Of Service
External System Action
5 | CHANGE_HX_CMT | VARCHAR | No |
The comment associated with the change.
6 | CHANGE_HX_USER_ID | VARCHAR | No |
The unique ID of user making the change.
7 | CHANGE_HX_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
8 | CHANGE_HX_CODEEDIT | VARCHAR | No |
The code edit reason associated with the change.
9 | CHANGE_HX_TX_ID | NUMERIC | No |
The transaction ID associated with change.
10 | CHANGE_HX_PREV_REC_OR_CAT | VARCHAR | No |
The record or category ID stored in the item before changes were made. This column will contain the translated record or category CID if CID translation is enabled.
11 | CHANGE_HX_NEW_REC_OR_CAT | VARCHAR | No |
The record or category ID stored in the item after changes were made. This column will contain the translated record or category CID if CID translation is enabled.