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.