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.