|
Name |
Type |
Discontinued? |
|
1 |
CLP_ID |
NUMERIC |
No |
|
|
|
The ID of the claim record that entered the claim edit workqueue. |
|
|
2 |
SERV_AREA_ID_LOC_NAME |
VARCHAR |
No |
|
|
|
The name of the revenue location. |
|
|
3 |
LOC_ID_LOC_NAME |
VARCHAR |
No |
|
|
|
The name of the revenue location. |
|
|
4 |
PAYOR_ID_PAYOR_NAME |
VARCHAR |
No |
|
|
|
|
5 |
BENEFIT_PLAN_ID_BENEFIT_PLAN_NAME |
VARCHAR |
No |
|
|
|
The name of the benefit plan record. |
|
|
6 |
PROV_ID_PROV_NAME |
VARCHAR |
No |
|
|
|
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table. |
|
|
7 |
COVERAGE_ID |
NUMERIC |
No |
|
|
|
The coverage ID that appears on the claim. |
|
|
8 |
ACCOUNT_ID |
NUMERIC |
No |
|
|
|
The account ID that appears on the claim. |
|
|
9 |
TOTAL_CHARGES |
NUMERIC |
No |
|
|
|
The dollar amount of charges on the claim. |
|
|
10 |
TOTAL_PAYMENTS |
NUMERIC |
No |
|
|
|
The dollar amount in payments that appear on the claim. This applies to claims that have already had payments made on them. |
|
|
11 |
INVOICE_ID |
NUMERIC |
No |
|
|
|
The ID of the invoice record associated with the claim. |
|
|
12 |
INVOICE_NUMBER |
VARCHAR |
No |
|
|
|
The invoice number that appears on the claim. NOTE: This is not the same as the invoice ID. |
|
|
13 |
POS_ID_LOC_NAME |
VARCHAR |
No |
|
|
|
The name of the revenue location. |
|
|
14 |
PREDETERMINATION_YN |
VARCHAR |
No |
|
|
|
Stores a Yes/No indicator that the associated record represents a request for a predetermination of benefits. |
May contain organization-specific values: No |
Category Entries: |
No |
Yes |
|
|
15 |
BILL_AREA_ID |
NUMERIC |
No |
|
|
|
Stores the Bill Area (BIL .1) associated with the claim. |
|
|
16 |
BILL_AREA_ID_BILL_AREA_NAME |
VARCHAR |
No |
|
|
|
The record name of this bill area, financial subdivision, or financial division. |
|
|
17 |
TOTAL_DUE |
VARCHAR |
No |
|
|
|
The total amount due on the claim. |
|
|
18 |
TOTAL_INS_DUE |
NUMERIC |
No |
|
|
|
Stores the insurance amount due for the charges on the claim. |
|
|
19 |
TOTAL_PAT_DUE |
NUMERIC |
No |
|
|
|
Stores the patient amount due for the charges on the claim. |
|
|
20 |
TOTAL_NONCVD_AMT |
NUMERIC |
No |
|
|
|
Stores the total non-covered amount associated with the charges on the claim. |
|
|
21 |
TOTAL_ADJ_AMT |
NUMERIC |
No |
|
|
|
Stores the total adjustment amount posted to the charges on the claim. |
|
|