CLM_VALUE_RECORD

Description:

This table holds basic identification and processing information for the claim value record.

Primary Key

Column Name	Ordinal Position
RECORD_ID	1

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	NUMERIC	No
	The unique identifier for the claim values record.
2	RECORD_CREATION_DT	DATETIME	No
	The date the record was created.
3	CLM_TYP_C_NAME	VARCHAR	No
	The type of claim values stored in the record. CMS is used for professional and dental claims. UB is used for institutional claims. May contain organization-specific values: Yes Category Entries: CMS Claim UB Claim State Visit Data State Visit Provider Data Vektis Claim Pharmacy Claim
4	FORM_TYP_C_NAME	VARCHAR	No
	The type of form used during processing. May contain organization-specific values: No Category Entries: Electronic Form Paper Form Both Paper and Electronic
5	CONTEXT_C_NAME	VARCHAR	No
	The direction of the claim file, either incoming or outgoing. This value is only set for Accounts Payable claims. May contain organization-specific values: No Category Entries: Incoming - Initial Outgoing Incoming - Repriced Incoming - Canceled Outgoing - External Pricing Incoming - External Pricing Incoming - Rejected
6	AP_CLAIM_ID	NUMERIC	No
	The claim information record associated with the invoice. This value is only set for Accounts Payable claims.
7	SERV_AREA_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
8	HEALTH_SYS_IDENT	VARCHAR	No
	This item holds the Health System Identifier (HSI) of the source for the claim.
9	SOURCE_ORGANIZATION_ID	NUMERIC	No
	The source organization of the external record. This value is only set for external claims.
10	SOURCE_ORGANIZATION_ID_EXTERNAL_NAME	VARCHAR	No
	Organization's external name used as the display name on forms and user interfaces.
11	CLAIM_RECON_ID	VARCHAR	No
	The claim reconciliation record ID (CRD) associated with the claim data.
12	CRD_CONTACT_DATE_REAL	NUMERIC	No
	The contact date of the claim reconciliation record, in internal format.