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 unique ID of the user record who created this history row. This column is frequently used to link to the Clarity user records table.
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.