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
Medical 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
Outgoing - Chart Review Record
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.
13 | CLAIM_OUTCOME_C_NAME | VARCHAR | No |
The outcome of the claim on its way to being paid. Complete: the claim is paid, Error: the claim will not be paid, Partial: the claim is current in the system but not paid yet, Queued: the claim is new.
May contain organization-specific values: No
Category Entries:
queued
complete
error
partial