AP_CLAIM_EXPORT_HISTORY

Description:

This table contains the history of a claim's outgoing 837 exports and encounter reporting data.

Primary Key

Column Name	Ordinal Position
CLAIM_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CLAIM_ID	NUMERIC	No
	The unique identifier for the 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	EXPORT_TYPE_C_NAME	VARCHAR	No
	The export type for this row of export history. May contain organization-specific values: Yes Category Entries: Reprice and Export-only Claims Subrogation Claims AP Claims Ad Hoc 3rd-Party Pricing Split Risk Crossover Paid Claims Encounter Reporting External Pricing Pre-Pay Audit Pre-Pay Audit: Update
4	EXPORT_SUBTYPE_C_NAME	VARCHAR	No
	The export subtype for this row of export history, if there is a subtype for the export. May contain organization-specific values: No Category Entries: Create or Update Crossover Cancel Crossover
5	EXPORT_BATCH_PAYER_ID_PAYOR_NAME	VARCHAR	No
	The name of the payor.
6	CLAIM_RUN_IDENT	INTEGER	No
	The export batching claim run ID that processed and includes this claim. If a claim errored during processing due to edit checks, no claim run identifier is set in this column.
7	CLAIM_RECON_ID	VARCHAR	No
	The unique ID of the Claim Reconciliation record that tracks the encounter and reconciliation data for this row.
8	EXPORT_DEST_PAYER_ID_PAYOR_NAME	VARCHAR	No
	The name of the payor.
9	EXPORT_CEV_RECORD_ID	NUMERIC	No
	The unique ID of the most recent claim values record created for this row's outgoing claim export data.