HSP_ACCT_MULT_DRGS
Description:
This table contains multiple diagnosis related group information for hospital accounts.

Primary Key
Column Name Ordinal Position
HSP_ACCOUNT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 HSP_ACCOUNT_ID NUMERIC No
The hospital account ID with associated Single Billing Office information.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 DRG_ID_TYPE_ID NUMERIC No
From the list of diagnosis-related group (DRG) filed to the hospital account, the unique ID of DRG code set for this row.
4 DRG_ID_TYPE_ID_ID_TYPE_NAME VARCHAR No
The name of the ID Type.
5 DRG_MPI_CODE VARCHAR No
This column extracts the Master Patient Index (MPI) IDs of diagnosis-related group (DRG) codes entered in the Multiple DRG grid of Hospital Billing - Coding for each Hospital Account. The MPI IDs shown here will be the IDs that correspond to the DRG MPI Type extracted in the DRG_ID_TYPE_ID column.
6 DRG_REIMBURSEMENT NUMERIC No
From the list of diagnosis-related groups (DRGs) filed to the hospital account, the expected reimbursement amount for the DRG in this row.
7 DRG_MDC_VALUE VARCHAR No
From the list of diagnosis-related group (DRG) filed to the hospital account, the Major Diagnostic Category value for the DRG in this row.
8 DRG_WEIGHT NUMERIC No
From the list of DRGs filed to the hospital account, the weight for the DRG in this row.
9 DRG_PS_NAME VARCHAR No
From the list of diagnosis-related groups (DRGs) filed to the hospital account, the severity of illness (SOI) category ID associated with the DRG in this row.
May contain organization-specific values: No
Category Entries:
Refinement not possible
Minor
Moderate
Major
Extreme
Principal Dx Used for SOI/ROM Calc
Excluded
Duplicate Diagnosis
Excluded Complication of Care
10 DRG_ROM_NAME VARCHAR No
The Risk of Mortality (ROM) category ID associated with the DRG is in this row. Epic Released Entries: 0- Refinement not possible 1- Minor 2- Moderate 3- Major 4- Extreme 5- Principal Dx Used for SOI/ROM Calc 6- Excluded 7- Duplicate Diagnosis 8- Excluded Complication of Care
The category values for this column were already listed for column: DRG_PS_NAME
11 DRG_SHORT_LOS VARCHAR No
The unique identifier for the treatment plan record.
12 DRG_LONG_LOS VARCHAR No
From the list of diagnosis-related group (DRG) filed to the hospital account, the long length of stay for the DRG in this row.
13 DRG_AMLOS VARCHAR No
From the list of DRGs filed to the hospital account, the arithmetic mean length of stay for the DRG in this row.
14 DRG_GMLOS VARCHAR No
From the list of diagnosis-related group (DRG) filed to the hospital account, the geometric mean length of stay for the DRG in this row.
15 DRG_CST_OTLR_THRSH NUMERIC No
The diagnosis-related group (DRG) cost outlier threshold for the hospital account.
16 DRG_DAY_OTLR_THRSH NUMERIC No
The diagnosis-related group (DRG) day outlier threshold for the hospital account.
17 DRG_NRM_PT_RMB_AMT NUMERIC No
The normal patient reimbursal amount for diagnosis-related group (DRG) on the hospital account.
18 DRG_TG_FED_BLND_RT NUMERIC No
The target fed blended rate for DRG on the hospital account.
19 DRG_COND_CODE NUMERIC No
The diagnosis-related group (DRG) condition code on the hospital account.
20 DRG_FORMULA NUMERIC No
The diagnosis-related group (DRG) formula information on the hospital account.
21 DRG_LOS INTEGER No
The diagnosis-related group (DRG) LOS for the hospital account.
22 DRG_PAT_STATUS VARCHAR No
The patient status for the diagnosis-related group (DRG) on the hospital account.
23 DRG_ISP_SHR_AJ_AMT NUMERIC No
The dispensed share adjustment amount for the diagnosis-related group (DRG) on the hospital account.
24 DRG_INDIR_MED_AMT NUMERIC No
The indirect medicated monetary amount for the diagnosis-related group (DRG) on the hospital account.
25 DRG_CAPITAL_AMT NUMERIC No
The capital monetary amount for the DRG on the hospital account.
26 DRG_OTLR_RMB_AMT NUMERIC No
The outlier reimbursement monetary amount for the diagnosis-related group (DRG) on the hospital account.
27 DRG_CHG_CLM_AMT NUMERIC No
The total diagnosis-related group (DRG) charges on claim for this DRG on this hospital account.
28 DRG_OUTLIER_TYPE INTEGER No
The outlier type for the diagnosis-related group (DRG) on the hospital account.
29 DRG_OUTLIER_DAYS INTEGER No
The number of outlier days for the diagnosis-related group (DRG) on the hospital account.
30 DRG_OTLR_CST_AMT NUMERIC No
The monetary outlier cost for the diagnosis-related group (DRG) on the hospital account.
31 DRG_OUTLIER_REIMB NUMERIC No
The outlier reimbursement for the diagnosis-related group (DRG) on the hospital account.
32 DRG_CMT VARCHAR No
The comment associated with the diagnosis-related group (DRG) on the hospital account.
33 DRG_QLFR_C_NAME VARCHAR No
Additional diagnosis-related group (DRG) Qualifier for the DRG Type and Code.
May contain organization-specific values: Yes
Category Entries:
HAC Dx Included
Analyzed DRG
Admission DRG
PPC DRG
PPC Admit DRG
34 DRG_BILLING_FLAG_YN VARCHAR No
Indicates the diagnosis-related group (DRG) that is the primary Billing DRG for the hospital account.
May contain organization-specific values: No
Category Entries:
No
Yes
35 DRG_ECCS NUMERIC No
The ECCS (episode clinical complexity score) associated with the DRG.