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