We use cookies from Google Analytics to improve our website. By accepting, you will receive these cookies from open.epic. Decline if you wish to use open.epic without these cookies. Read our privacy policy here.

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.