HSP_ACCT_ALT_DRGS

Description: |
This table stores the multiple Diagnosis Related Group (DRG) information for the alternate ICD code set when dual coding a hospital account.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | HSP_ACCOUNT_ID | NUMERIC | No |
The unique identifier for the hospital account record.
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 | ALT_DRG_ID_TYPE_ID | NUMERIC | No |
The unique ID of the ID Type associated with this diagnosis related group ID for the alternate code set.
4 | ALT_DRG_ID_TYPE_ID_ID_TYPE_NAME | VARCHAR | No |
The name of the ID Type.
5 | ALT_DRG_QLFR_C_NAME | VARCHAR | No |
Additional diagnosis-related group (DRG) Qualifier for the DRG Type and Code for the alternate code set.
May contain organization-specific values: Yes
Category Entries:
HAC Dx Included
Analyzed DRG
Admission DRG
PPC DRG
PPC Admit DRG
6 | ALT_DRG_ID | VARCHAR | No |
The unique ID of the diagnosis-related group (DRG) code for the alternate code set that is associated with this hospital account.
7 | ALT_DRG_ID_DRG_NAME | VARCHAR | No |
The name of the Diagnoses Related Group name.
8 | ALT_DRG_BILL_FLG_YN | VARCHAR | No |
Indicates the diagnosis-related group (DRG) that is the primary Billing DRG for the hospital account for the alternate code set.
May contain organization-specific values: No
Category Entries:
No
Yes
9 | ALT_DRG_REIMB | NUMERIC | No |
Stores the diagnosis-related group (DRG) reimbursement for the alternate code set.
10 | ALT_DRG_MDC_VALUE | VARCHAR | No |
Stores the Major Diagnostic Category (MDC) values for the alternate code set.
11 | ALT_DRG_WEIGHT | NUMERIC | No |
Stores the diagnosis-related group (DRG) weight for the alternate code set.
12 | ALT_DRG_PS_C_NAME | VARCHAR | No |
Stores the severity of index (SOI) for the diagnosis-related group (DRG) for the alternate code set.
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
13 | ALT_DRG_SHORT_LOS | VARCHAR | No |
Stores the diagnosis-related group (DRG) short length of stay (LOS) for the alternate code set.
14 | ALT_DRG_LONG_LOS | VARCHAR | No |
Stores the diagnosis-related group (DRG) long length of stay (LOS) for the alternate code set.
15 | ALT_DRG_AMLOS | VARCHAR | No |
Stores the diagnosis-related group (DRG) arithmetic mean length of stay (LOS) for the alternate code set.
16 | ALT_DRG_GMLOS | VARCHAR | No |
Stores the diagnosis-related group (DRG) geometric mean length of stay (LOS) for the alternate code set.
17 | ALT_CST_OTLR_THRSH | NUMERIC | No |
Stores the diagnosis-related group (DRG) cost outlier threshold for the alternate code set.
18 | ALT_DAY_OTLR_THRSH | NUMERIC | No |
Stores the diagnosis-related group (DRG) day outlier threshold for the alternate code set.
19 | ALT_OUTLIER_DAYS | INTEGER | No |
Stores the diagnosis-related group (DRG) outlier days for the alternate code set.
20 | ALT_OTLR_CST_AMT | NUMERIC | No |
Stores the diagnosis-related group (DRG) outlier cost for the alternate code set.
21 | ALT_OUTLIER_REIMB | NUMERIC | No |
Stores the diagnosis-related group (DRG) outlier reimbursement amount for the alternate code set.
22 | ALT_PAT_STATUS | VARCHAR | No |
Stores the diagnosis-related group (DRG) reimbursement indicator for the alternate code set.
23 | ALT_DISP_SHARE_ADJ | NUMERIC | No |
Stores the diagnosis-related group (DRG) disproportionate share amount for the alternate code set.
24 | ALT_IND_MED_AMT | NUMERIC | No |
Stores the indirect medicated monetary amount for the alternate diagnosis-related group (DRG) on the hospital account.
25 | ALT_CAPITAL_AMT | NUMERIC | No |
This item stores the diagnosis-related group (DRG) capital amount for the alternate code set.
26 | ALT_DRG_TOT_CHG | NUMERIC | No |
Stores the diagnosis-related group (DRG) total charges on claim for the alternate code set.
27 | ALT_DRG_LOS | INTEGER | No |
Stores the diagnosis-related group (DRG) length of stay (LOS) for the alternate code set.
28 | ALT_NRM_PT_RMB_AMT | NUMERIC | No |
Stores the diagnosis-related group (DRG) normal patient reimbursement for the alternate code set.
29 | ALT_TG_FED_BLND_RT | NUMERIC | No |
Stores the diagnosis-related group (DRG) target federal blended rate for the alternate code set.
30 | ALT_DRG_COND_CODE | INTEGER | No |
Stores the diagnosis-related group (DRG) condition code for the alternate code set.
31 | ALT_DRG_FORMULA | INTEGER | No |
Stores the diagnosis-related group (DRG) formula for the alternate code set.
32 | ALT_DRG_COMMENT | VARCHAR | No |
Stores the diagnosis-related group (DRG) comment for the alternate code set.
33 | ALT_DRG_ROM_C_NAME | VARCHAR | No |
Stores the risk of mortality (ROM) for the diagnosis-related group (DRG) for the alternate code set.
The category values for this column were already listed for column: ALT_DRG_PS_C_NAME
34 | ALT_OL_REIMB_AMT | NUMERIC | No |
Stores the diagnosis-related group (DRG) outlier amount for the alternate code set.
35 | ALT_OUTLIER_TYPE | NUMERIC | No |
Stores the diagnosis-related group (DRG) outlier type for the alternate code set.