CLM_EDIT_WQ_CLM

Description: |
This table contains the basic information pertaining to a claim in a claim edit workqueue. Rows for claims still in the error pool will be updated.
Note that there are two date fields: EXTRACT_DATE indicates the most recent update where a claim was in the error pool. CLM_PROCESS_DATE indicates when the claim was originally processed and entered the error pool.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
CLP_ID | 1 |

Column Information

| 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 |
The name of the payor.
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.
22 | PAT_ID | VARCHAR | No |
The patient ID associated with this CLP.