HSP_ACCT_BILL_DRG

Description: |
This table contains billing diagnosis related group (DRG) information from the Hospital Accounts Receivable (HAR) master file.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
HSP_ACCOUNT_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | HSP_ACCOUNT_ID | NUMERIC | No |
The hospital account ID with associated billing DRG information.
2 | BL_DRG_COND_CODE | NUMERIC | No |
This column stores the billing diagnosis-related group (DRG) condition code on the hospital account.
3 | BL_DRG_LOS | INTEGER | No |
This column stores the billing DRG length of service in days for the hospital account.
4 | BL_DRG_PAT_STATUS | VARCHAR | No |
The patient status for the billing DRG on the hospital account.
5 | BL_DRG_ECCS | NUMERIC | No |
The ECCS (episode clinical complexity score) associated with the billing DRG.