REFLAB_TRANSACTION

Description:

This table contains transaction information for reference labs. Only transactions for reference labs are in this table, and only transactions with type set as charge (column TRAN_TYPE in table CLARITY_TDL_TRAN). These are based on the service area of the transaction which will have the billing system set to reference lab billing (column BILLING_SYSTEM_C in table CLARITY_SA).

Primary Key

Column Name	Ordinal Position
TX_ID	1

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	The unique ID of the transaction.
2	TEST_ID	VARCHAR	No
	The unique ID of the test for this transaction.
3	LAB_ID	VARCHAR	No
	The unique ID of the lab for this transaction.
4	RL_RQG_ID	NUMERIC	No
	The unique ID of the requisition grouper for this transaction.
5	RL_SUBMITTER_ID	NUMERIC	No
	The unique ID of the submitter for this transaction.
6	RL_SUBMITTER_ID_RECORD_NAME	VARCHAR	No
	The name of the submitter record.
7	RL_REQUISITION_ID	NUMERIC	No
	The unique ID of the Requisition for this transaction.
8	RL_SPECIMEN_ID	VARCHAR	No
	The unique ID of the specimen for this transaction.
9	RL_SPECIMEN_LINE	INTEGER	No
	The specimen line of the specimen this transaction belongs to.