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.