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	NUMERIC	No
	The unique ID associated with the payer record that this claim used when batched for the export. This is typically the payer for the coverage used to pay the claim.
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	NUMERIC	No
	The unique ID associated with the payer record that this claim export was sent to. This is the payer used to drive the destination payer loop on the outgoing 837.
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.