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.