BILLING_NUMS

Description:

Table containing ADT Billing Number information (EPT superitem 25000).

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record; each line represents a different billing account.
3	BILLING_ACCT_NUM	VARCHAR	No
	The billing number for a patient's billing account.
4	BILLING_ACCT_TYPE_C_NAME	VARCHAR	No
	The category number of the billing account type for the associated billing account. May contain organization-specific values: Yes
5	ADMIT_DATE	DATETIME	No
	The admission date for the associated billing account.
6	DISCHARGE_DATE	DATETIME	No
	The discharge date for the associated billing account.
7	BILLING_STATUS_C_NAME	VARCHAR	No
	The category number of the billing status for the associated billing account. May contain organization-specific values: Yes No Entries Defined
8	BILLING_SERVICE_C_NAME	VARCHAR	No
	The category number of the billing service for the associated billing account. May contain organization-specific values: Yes No Entries Defined