CLM_VALUES_2

Description: |
All values associated with a claim are stored in the Claim External Value record. The CLM_VALUES_2 table holds claim-level values set by the system during claims processing or by user edits.

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 | ADMSN_TYP | VARCHAR | No |
The admission type for the claim.
3 | ADMSN_SRC | VARCHAR | No |
The admission source for the claim.
4 | DISCHRG_DISP | VARCHAR | No |
The patient's discharge status, also referred to as the discharge disposition.
5 | RFL_NUM | VARCHAR | No |
The referral number for the claim.
6 | AUTH_NUM | VARCHAR | No |
The prior authorization number for the claim.
7 | SPEC_PROG_IND | VARCHAR | No |
The indicator that the services on the claim were rendered under one of a list of special programs.
8 | CLM_DELAY_RSN | VARCHAR | No |
The reason code explaining why the claim was submitted after the payer's normal filing deadline.
9 | AUTH_EXCEPT_CD | VARCHAR | No |
The code explaining why services that normally need authorization were performed without the necessary authorization.
10 | PAT_AMT_PAID | NUMERIC | No |
The amount already paid by the patient.
11 | PAT_AMT_DUE | NUMERIC | No |
The amount estimated to be the patient's responsibility.
12 | AUTO_ACDNT_STATE | VARCHAR | No |
The state in which an automobile accident occurred.
13 | AUTO_ACDNT_CNTRY | VARCHAR | No |
The country in which an automobile accident occurred. It is only populated when the accident occurred outside the United States.
14 | MAMM_CERT_NUM | VARCHAR | No |
The provider's certification number when the claim contains mammography services.
15 | CLIA_NUM | VARCHAR | No |
The Clinical Laboratory Improvement Amendment (CLIA) number when the claim contains lab services.
16 | DEMO_PRJ_ID | VARCHAR | No |
The identifier for claims billed under atypical rules (e.g., pilot programs, clinical trials).
17 | SPINAL_MAN_COND_CD | VARCHAR | No |
The patient's condition when the claim contains chiropractic services.
18 | EPSDT_CERT_APPLIES | VARCHAR | No |
The indicator that identifies whether an Early and Periodic Screening, Diagnostic, and Treatment (EPSDT) referral was given to the patient.
19 | ORTHO_TOT_MO | INTEGER | No |
The total number of months of orthodontic treatment.
20 | ORTHO_MO_REMAIN | INTEGER | No |
The number of months of orthodontic treatment remaining for a transfer patient.
21 | ADMSN_DX_QUAL | VARCHAR | No |
The qualifier that identifies the code set for the admission diagnosis for the claim.
22 | ADMSN_DX | VARCHAR | No |
The admission diagnosis for the claim.
23 | DRG | VARCHAR | No |
The Diagnosis Related Group (DRG) determined for the claim.
24 | ANES_SURG_PROC | VARCHAR | No |
The HCPCS code of the surgical procedure performed under anesthesia when the code needs to be reported on the anesthesia claim.
25 | OUTSIDE_LAB | VARCHAR | No |
The indicator that the claim includes purchased services rendered by an independent provider.
26 | OUTSIDE_LAB_CHG | NUMERIC | No |
The price of the purchased services.
27 | CLM_FROM_DT | DATETIME | No |
The earliest date represented on the claim. This date could be the minimum service date for an outpatient or professional claim or the admission date for an inpatient claim.
28 | CLM_TO_DT | DATETIME | No |
The latest date represented on the claim. This date could be the maximum service date for an outpatient or professional claim or the discharge date for an inpatient claim.
29 | ADMSN_DT | DATETIME | No |
The admission date on the claim. For outpatient claims, this date represents the visit or start of care date.
30 | ADMSN_TM | DATETIME (Local) | No |
The time at which the patient was admitted to the facility. This time is only available for institutional claims. Note that the value is the exact time, including both the hour and minutes.
31 | DISCHG_DT | DATETIME | No |
The discharge date on the claim.
32 | DISCHG_TM | DATETIME (Local) | No |
The time at which the patient was discharged. This time is only available for institutional claims. Note that the value is the exact time, including both the hour and minutes.
33 | ILL_INJ_DT | DATETIME | No |
The date in which the patient was injured or when the current illness was first noticed.
34 | INIT_TREAT_DT | DATETIME | No |
The initial treatment date when the claim represents a series of visits (e.g., physical therapy, spinal manipulation, dialysis, pregnancy).
35 | LST_SEEN_DT | DATETIME | No |
The date the patient was last seen by the attending or supervising provider.
36 | ACUTE_MANIF_DT | DATETIME | No |
The date acute symptoms first manifested.
37 | ACDNT_DT | DATETIME | No |
The date the automobile accident occurred.
38 | LMP_DT | DATETIME | No |
The date of the last menstrual period.
39 | LST_XRAY_DT | DATETIME | No |
The date of the last X-Ray.
40 | HEAR_VIS_RX_DT | DATETIME | No |
The date on which the prescription was written for hearing devices or vision frames and lenses.
41 | DISAB_START_DT | DATETIME | No |
The earliest date on which the patient was disabled and could not work.
42 | DISAB_END_DT | DATETIME | No |
The latest date on which the patient was disabled and could not work.
43 | LST_WK_DT | DATETIME | No |
The last date on which the patient was able to perform his or her duties at work.
44 | AUTH_RETURN_WK_DT | DATETIME | No |
The date on which the patient can return to work.
45 | ASSUM_CARE_DT | DATETIME | No |
The date on which care was assumed by another provider during post-operative care.
46 | RELINQ_CARE_DT | DATETIME | No |
The date on which the provider of the claim ceased post-operative care.
47 | ORTHO_BAND_DT | DATETIME | No |
The date orthodontic appliances were placed.
48 | DENT_SRV_DT | DATETIME | No |
The date on which dental services were performed.
49 | SIMILAR_ILL_DT | DATETIME | No |
The earliest date on which symptoms of the same or similar illness were noticed.
50 | AMB_PAT_WT | NUMERIC | No |
The patient's weight (in pounds) when the patient is transported by an ambulance.
51 | AMB_TRANS_RSN_CD | VARCHAR | No |
The code explaining why the patient was transported by ambulance.
52 | AMB_TRANS_DIST | NUMERIC | No |
The distance (in miles) the patient was transported.
53 | AMB_RND_TRIP_DESC | VARCHAR | No |
The note explaining the need for round trip transportation.
54 | AMB_STRETCHER_DESC | VARCHAR | No |
The note explaining the need for a stretcher.
55 | CNTRCT_TYP | VARCHAR | No |
The code representing the type of contract between the provider and the payer.
56 | CNTRCT_AMT | NUMERIC | No |
The amount assigned by the contract between the provider and the payer.
57 | CNTRCT_PCT | NUMERIC | No |
The contract percentage for the claim assigned by the contract between the provider and the payer.
58 | CNTRCT_CD | VARCHAR | No |
The code representing the claim type under the contract between the provider and the payer.
59 | CNTRCT_DISCNT_PCT | NUMERIC | No |
The discount percentage assigned by the contract between the provider and the payer.
60 | CNTRCT_VERS_ID | VARCHAR | No |
The version of the contract used on the claim.
61 | ATT_PROV_NAM_LAST | VARCHAR | No |
The attending provider's last name.
62 | ATT_PROV_NAM_FIRST | VARCHAR | No |
The attending provider's first name.
63 | ATT_PROV_NAM_MID | VARCHAR | No |
The attending provider's middle name.
64 | ATT_PROV_NAM_SUF | VARCHAR | No |
The suffix to the attending provider's name (e.g., Jr, III).
65 | ATT_PROV_NPI | VARCHAR | No |
The attending provider's National Provider Identifier (NPI).
66 | ATT_PROV_TAXONOMY | VARCHAR | No |
The attending provider's taxonomy code.
67 | OPER_PROV_NAM_LAST | VARCHAR | No |
The operating provider's last name.
68 | OPER_PROV_NAM_FIRST | VARCHAR | No |
The operating provider's first name.
69 | OPER_PROV_NAM_MID | VARCHAR | No |
The operating provider's middle name.
70 | OPER_PROV_NAM_SUF | VARCHAR | No |
The suffix to the operating provider's name (e.g., Jr, III).
71 | OPER_PROV_NPI | VARCHAR | No |
The operating provider's National Provider Identifier (NPI).
72 | OTH_PROV_NAM_LAST | VARCHAR | No |
The other operating provider's last name.
73 | OTH_PROV_NAM_FIRST | VARCHAR | No |
The other operating provider's first name.
74 | OTH_PROV_NAM_MID | VARCHAR | No |
The other operating provider's middle name.
75 | OTH_PROV_NAM_SUF | VARCHAR | No |
The suffix to the other operating provider's name (e.g., Jr, III).
76 | OTH_PROV_NPI | VARCHAR | No |
The other operating provider's National Provider Identifier (NPI).
77 | REND_PROV_TYP | VARCHAR | No |
The rendering provider on the claim is a person or a non-person.
78 | REND_PROV_NAM_LAST | VARCHAR | No |
The rendering provider's last name (if a person) or the organization name (if a non-person).
79 | REND_PROV_NAM_FIRST | VARCHAR | No |
The rendering provider's first name. It is only populated when the provider is a person.
80 | REND_PROV_NAM_MID | VARCHAR | No |
The rendering provider's middle name. It is only populated when the provider is a person.
81 | REND_PROV_NAM_SUF | VARCHAR | No |
The suffix to the rendering provider's name (e.g., Jr, III). It is only populated when the provider is a person.
82 | REND_PROV_NPI | VARCHAR | No |
The rendering provider's National Provider Identifier (NPI).
83 | REND_PROV_TAXONOMY | VARCHAR | No |
The rendering provider's taxonomy code.
84 | REF_PROV_NAM_LAST | VARCHAR | No |
The referring provider's last name.
85 | REF_PROV_NAM_FIRST | VARCHAR | No |
The referring provider's first name.
86 | REF_PROV_NAM_MID | VARCHAR | No |
The referring provider's middle name.
87 | REF_PROV_NAM_SUF | VARCHAR | No |
The suffix to the referring provider's name (e.g., Jr, III).
88 | REF_PROV_NPI | VARCHAR | No |
The referring provider's National Provider Identifier (NPI).
89 | REF_PROV_TAXONOMY | VARCHAR | No |
The referring provider's taxonomy code.
90 | SUP_PROV_NAM_LAST | VARCHAR | No |
The supervising provider's last name.
91 | SUP_PROV_NAM_FIRST | VARCHAR | No |
The supervising provider's first name.
92 | SUP_PROV_NAM_MID | VARCHAR | No |
The supervising provider's middle name.
93 | SUP_PROV_NAM_SUF | VARCHAR | No |
The suffix to the supervising provider's name (e.g., Jr, III).
94 | SUP_PROV_NPI | VARCHAR | No |
The supervising provider's National Provider Identifier (NPI).
95 | ASST_SURG_NAM_LAST | VARCHAR | No |
The assistant dental surgeon's last name.
96 | ASST_SURG_NAM_FIRST | VARCHAR | No |
The assistant dental surgeon's first name.
97 | ASST_SURG_NAM_MID | VARCHAR | No |
The assistant dental surgeon's middle name.