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