CLM_EDIT_WQ_DETAIL

Description:

This table contains one row for each transaction on a claim that is or has been in the claim error pool. This table updates records for transactions on claims that are still in the claim error pool but leaves the records for transactions on claims that are no longer in the error pool. There is only one date field concerning when the record was created, EXTRACT_DATE, which functions as in CLM_EDIT_WQ_DETAIL. After the claim has left the claim error pool, the last record will remain in the table indefinitely.

Primary Key

Column Name	Ordinal Position
CLP_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CLP_ID	NUMERIC	No
	The ID of the claim record that entered the claim edit workqueue.
2	LINE	INTEGER	No
	The line number of the transaction that appears on the claim record.
3	PERFORMING_PROV_ID	VARCHAR	No
	The ID of the provider who performed the transaction's service(s).
4	REFERRAL_PROV_ID	VARCHAR	No
	The ID of the transaction's referring provider.
5	REFERRAL_PROV_ID_REFERRING_PROV_NAM	VARCHAR	No
	The name of the referral source.
6	ORIG_AMOUNT	NUMERIC	No
	The original amount of the transaction.
7	AMOUNT_DUE	NUMERIC	No
	The amount of money due for the transaction at the time of the extract.
8	DEPARTMENT_ID	NUMERIC	No
	The department ID where the transaction originated.
9	REV_LOC_ID	NUMERIC	No
	The revenue location where the transaction originated.
10	PROC_ID	NUMERIC	No
	The procedure ID for the transaction.
11	SERVICE_DATE	DATETIME	No
	The date for which services were performed.
12	POST_DATE	DATETIME	No
	The date the transaction was posted.
13	BILLING_PROV_ID	VARCHAR	No
	The ID of the provider to whom services are being billed.
14	POS_ID	NUMERIC	No
	The place of service where the transaction originated.
15	VISIT_NUMBER	VARCHAR	No
	The visit number within the account that corresponds to the transaction. This number uniquely identifies the visit within the account only.