skip to Main Content

Pricing & Purchase HHIC will accept, process and fulfill requests for the purchase and use of HHIC Data. Our online Dataset Catalog provides information on the year-by-year pricing and availability of HHIC data.  Information about the data associated with each file is provided on this page. After reviewing the information, please submit the Pricing & Purchase form with desired dataset and your contact information. We will contact you regarding your request within 3 business days.

Thank-you for your interest in purchasing data from HHIC.

Inpatient

(Effective from January 1995)

Variable Description Type/Length
REC_ID Discharge Rec ID Number(10)
DIS_TYPE Discharge Type: Inpatient Char(10)
MPI HHIC-assigned ID to track a patient across hospitals and levels of service. Char(10)
HHIC PAT ID HHIC assigned identifier for each unique MRN Number(10)
ADM_YM Admission Year and Month Char(6)
DIS_YM Discharge Year and Month Char(6)
BIRTH_YM Year and month of birth Char(6)
DSLE Number of days since the last event (Inpatient, ER, Observation, or Same day Surg) by patient’s MPI. Char(6)
DIS_SEQ Discharge sequential order by the patient’s MPI and discharge date. Num(5)
AGE Patient age at admission (ages 90 and over are grouped to 90). Number(3)
AGED Patient age in days for patient less than 2 years old. Number(5)
AGEW Patient age in weeks for patient less than 2 years old. Number(5)
AGEM Patient age in months for patient less than 2 years old. Num(5)
HEIGHT Patient Height in inches at admission. (Effective from Jan 2015) Num(5)
WEIGHT Patient Weight in pounds at admission (Effective from Jan 2015) Num(5)
BMI Pateint BMI at admission. (Effective form Jan 2015) Num(5)
HOSP_ID Hospital’s Medicare provider number as assigned by CMS. Char(6)
HOSP_IND Hospital Classification: Urban or Rural Char(10)
HOSP_CNTY Hospital County Char(25)
SES Geographic patient regions based on a patient’s socio-economic status; population for each region 20,000 or more Char(20)
HHIC_CNTY The patient county of residence. The Kalawao county was merged into the Maui county due to its small population size. Char(20)
RACE The race or ethnicity with which the patient most closely identifies. There are 34 race categories. (Effective from Jan 2010) Char(50)
RACE2 HHIC conformed races (11 Race Categories) (Effective from 1995) Char(50)
GENDER Patient’s gender: M-Male or F-Female Char(1)
ADM_SRC The source of this admission. Char(15)
ADM_TYPE The type of admission, based on UB04 classification. Char(20)
PDISP Patient disposition or discharge status. Char(50)
PDISP_CATG Patient disposition category Char(50)
DIED_IND Indicates in-hospital mortality – Yes or No Char(1)
APR_MDC All Patients Refined Major Diagnostic Category Num(2)
APR_DRG All Patients Refined Diagnosis Related Groups- system that classifies patients according to their reason of admission. Num(3)
APR_SPEC Grouping of diagnosis related APR-DRGs, e.g. cardiology related APR-DRGs are grouped into the Specialty category “Cardiology”. Char(50)
APR_ROM Risk of Mortality (1-Minor, 2-Moderate, 3-Major, 4-Extreme, 0-Unspecified) Char(1)
APR_SOI Severity of Illness (1-Minor, 2-Moderate, 3-Major, 4-Extreme, 0-Unspecified) Char(1)
APR_SERVICE_LINE Grouping of diagnosis related APRDRGs, e.g. cardiology related APRDRGs are grouped into the Specialty category “Cardiology”. Char(50)
APR_CASEMIX Relative value assigned to a each APRDRG. The CMI value is used in determining the allocation of resources to care for and/or treat the patients in the group. Num(8,4)
APR_EXP_LOS Expected Length of Stay in days (for APR/SOI subclass) Num(5)
APR_EXP_CHARGE Expected Charges (for APR/SOI subclass) Num(8)
APR_EXP_MORT_CNT Expected Mortality Cnt Num(5)
MS_DRG Medicare Severity Diagnosis-related Groups – used by CMS to provide greater reimbursement to hospitals serving more severely ill patients. Num(3)
MS_MDC Major Diagnostic Category Num(2)
MS_SERVICE_LINE Grouping of diagnosis related MSDRGs, e.g. cardiology related MSDRGs are grouped into the Specialty category “Cardiology”. Char(50)
MS_CASEMIX Relative value assigned to a each MSDRG. The CMI value is used in determining the allocation of resources to care for and/or treat the patients in the group. Num(8,4)
PAYER Primary Source of Payment, Payer Source Char(50)
PAYER_TYPE Payer Type: Medicare, Medicaid, Private Insurance, Uninsured, Others Char(50)
TOT_CHRG Total billed charge of hospital stay. Number(8)
EST_COST Estimated Costs (Inpatient Only) Cost is estimated using department-level cost to charge ratios (CCRs) from the CMS cost reports Number(10,2)
LOS Length of Stay – Total number of days from admission date to discharge date. Number(5)
READM_IND Readmission Indicator: 1-Initial Rdmission, 2-Readmission, and blank-Not eligible for readmission (e.g. Transfers). Char(1)
READM_SEQ Readmission Sequence – 1-Initial Admission, 2 through N-sequence within the readmission chain. A readmission chain is a sequence of readmissions that are all related to a single initial discharge. Number(3)
PDIAG Principal Diagnosis Code Char(10)
ODIAGnn (nn=01-37) Secondary Diagnosis Codes Char(10)
PPOA Principal Present on Admission indicator Char(1)
OPOAnn (nn=01-37) Secondary Present on Admission indicators. Char(1)
PPROC Principal Procedure Code Char(10)
OPROCnn(nn=01-34) Secondary Procedure Codes Char(10)
CMS Hospital Acquired Condition (HAC) Effective from October 2015
HAC01 CMS HAC Indicator 1 – Foreign Object Retained After Surgery Char(1)
HAC02 CMS HAC Indicator 2 – Air Embolism Char(1)
HAC03 CMS HAC Indicator 3 – Blood Incompatibility Char(1)
HAC04 CMS HAC Indicator 4 – Stage III and VI Pressure Ulcers Char(1)
HAC05 CMS HAC indicator 5 – Falls and Trauma Char(1)
HAC06 CMS HAC Indicator 6 – Cathether-Associated Urinary Tract Infection Char(1)
HAC07 CMS HAC Indicator 7 – Vascular Catherter-Associated Infection Char(1)
HAC08 CMS HAC Indicator 8 – Mediastinitis After Coronary Bypass Graft Char(1)
HAC09 CMS HAC Indicator 9 – Manifesations of Poor Glycemic Control Char(1)
HAC10 CMS HAC Indicator 10 – Deep Vein Thrombosis (DVT) / Pumonary Embolism (PE) with Total Knee or Hip Replacement Char(1)
HAC11 CMS HAC Indicator 11 – Surgical Site Infection – Bariatric Surgery Char(1)
HAC12 CMS HAC Indicator 12 – Surgical Site Infection – Certain Orthopedic Procedures Char(1)
HAC13 CMS HAC Indicator 13 – Surgical Site Infection – Following Cardiac Implantable Electronic Device (CIED) procedures Char(1)
HAC14 CMS HAC Indicator 14 – Iatrogenic Pneumothroax w/ Venous Catheterization Char(1)
AHRQ Patient Safety Indicators (PSI) For more information, please refer to the AHRQ website. (Effective from October 2015)
PSI02 AHRQ Patient Safety Indicator 2 – Death Rate in Low-Mortality Diagnosis Related Groups. (Numerator = 1 and Denominator = 0 or 1) Char(1)
PSI03 AHRQ PSI 3 – Pressure Ulcer Rate (Numerator = 1 and Denominator = 0 or 1) Char(1)
PSI04 AHRQ PSI 4 – Death Rate among Surgical Inpatients with Serious Treatable Conditions (Numerator = 1 and Denominator = 0 or 1) Char(1)
PSI05 AHRQ PSI 5 – Retained Surgical Item or Unretrieved Device Fragment Count (Numerator = 1 and Denominator = 0 or 1) Char(1)
PSI06 AHRQ PSI 6 – Iatrogenic Pneumothorax Rate Char(1)
PSI07 AHRQ PSI 7 – Central Venous Catheter-related Blod Stream Infection Rate (Numerator = 1 and Denominator = 0 or 1) Char(1)
PSI08 AHRQ PSI 8 – In Hospital Fall with Hip Fracture Rate (Numerator = 1 and Denominator = 0 or 1) Char(1)
PSI09 AHRQ PSI 9 – Perioperative Hemorrhage or Hematoma Rate (Numerator = 1 and Denominator = 0 or 1) Char(1)
PSI10 AHRQ PSI 10 – Postoperative Acute Kidney Injury Requiring Dialysis (Numerator = 1 and Denominator = 0 or 1) Char(1)
PSI11 AHRQ PSI 11 – Postoperative Respiratory Failure Rate (Numerator = 1 and Denominator = 0 or 1) Char(1)
PSI12 AHRQ PSI 12 – Postoperative Pulmonary Embolism or Deep Vein Thrombosis Rate (Numerator = 1 and Denominator = 0 or 1) Char(1)
PSI13 AHRQ PSI 13 – Postoperative Sepsis Rate (Numerator = 1 and Denominator = 0 or 1) Char(1)
PSI14 AHRQ PSI 14 – Postoperative Wound Dehiscence Rate (Numerator = 1 and Denominator = 0 or 1) Char(1)
PSI15 AHRQ PSI 15 – Unrecognized Abdominopelvic Accidental Puncture/Laceration Rate (Numerator = 1 and Denominator = 0 or 1) Char(1)
PSI16 AHRQ PSI 16 – Transfusion Reaction Count (Numerator = 1) Char(1)
PSI17 AHRQ PSI 17 – Birth Trauma Rate – Injury to Neonate (Numerator = 1 and Denominator = 0 or 1) Char(1)
PSI18 AHRQ PSI 18 – Obstetric Trauma Rate – Vaginal Delivery with Instrument Char(1)
PSI19 AHRQ PSI 19 – Obstetric Trauma Rate – Vaginal Delivery without Instrument Char(1)
Emergency

(Effective from January 2000)

Variable Description Type/Length
REC_ID Discharge Rec ID Number(10)
MPI HHIC-assigned ID to track a patient across hospitals and levels of service. Char(10)
HHIC PAT ID HHIC assigned identifier for each unique MRN Number(10)
ADM_YM Admission Year and Month Char(6)
DIS_YM Discharge Year and Month Char(6)
BIRTH_YM Year and month of birth Char(6)
DSLE Number of days since the last event (Inpatient, ER, Observation, or Same day Surg) by patient’s MPI. Char(6)
DIS_SEQ Discharge sequential order by the patient’s MPI and discharge date. Num(5)
AGE Patient age at admission (ages 90 and over are grouped to 90). Number(3)
AGED Patient age in days for patient less than 2 years old. Number(5)
AGEW Patient age in weeks for patient less than 2 years old. Number(5)
AGEM Patient age in months for patient less than 2 years old. Num(5)
HOSP_ID Hospital’s Medicare provider number as assigned by CMS. Char(6)
HOSP_IND Hospital Classification: Urban or Rural Char(10)
HOSP_CNTY Hospital County Char(25)
SES Geographic patient regions based on a patient’s socio-economic status Char(20)
HHIC_CNTY The patient county of residence. The Kalawao county was merged into the Maui county due to its small population size. Char(20)
RACE The race or ethnicity with which the patient most closely identifies. There are 34 race categories. (Effective from Jan 2010) Char(50)
RACE2 HHIC conformed races (11 Race Categories) (Effective from 1995) Char(50)
GENDER Patient’s gender: M-Male or F-Female Char(1)
ADM_SRC The source of this admission. Char(15)
ADM_TYPE The priority of this admission. Char(20)
PDISP Patient disposition or discharge status. Char(50)
PDISP_CATG Patient disposition category Char(50)
DIED_IND Indicates in-hospital mortality – Yes or No Char(1)
APR_MDC All Patients Refined Major Diagnostic Category Num(2)
APR_DRG All Patients Refined Diagnosis Related Groups- system that classifies patients according to their reason of admission. Num(3)
APR_SPEC Grouping of diagnosis related APR-DRGs, e.g. cardiology related APR-DRGs are grouped into the Specialty category “Cardiology”. Char(50)
MS_DRG Medicare Severity Diagnosis-related Groups – used by CMS to provide greater reimbursement to hospitals serving more severely ill patients. Num(3)
MS_MDC Major Diagnostic Category Num(2)
MS_SERVICE_LINE Char(50)
MS_CASEMIX The non-transfer adjusted case mix index based on the MS-DRGs billed on the claim in the year the claim was incurred. Num(8,4)
PAYER Payer Sources Char(50)
PAYER_TYPE Payer Type: Medicare, Medicaid, Private Insurance, Uninsured, Others Char(50)
TOT_CHRG Total billed charge of hospital stay. Number(8)
PDIAG Principal Diagnosis Code Char(10)
ODIAGnn (nn=01-37) Secondary Diagnosis Codes Char(10)

Discharge Diagnosis, Discharge Procedure, Discharge Revenue, and Discharge HCPCS data variables provided as linkable separate files as appropriate.

Moms & Babies

Mom attributes will be repeated for each baby discharge. (Effective from January 2000)

Variable Description Type/Length
Mom Attributes
REC_ID Discharge Rec ID Number(10)
MPI HHIC-assigned ID to track a patient across hospitals and levels of service. Char(10)
HHIC PAT ID HHIC assigned identifier for each unique MRN Number(10)
ADM_YM Admission Year and Month Char(6)
DIS_YM Discharge Year and Month Char(6)
BIRTH_YM The patient birth year and month. Char(6)
DSLE Number of days since the last event (Inpatient, ER, Observation, or Same day Surg) by patient’s MPI. Char(6)
DIS_SEQ Discharge sequential order by the patient’s MPI and discharge date. Num(5)
AGE The patient age at admission (ages 90 and over are grouped to age 90). Number(3)
AGED Patient age in days for patient less than 2 years old. Number(5)
AGEW Patient age in weeks for patient less than 2 years old. Number(5)
AGEM Patient age in months for patient less than 2 years old. Num(5)
HEIGHT The patient height in inches taken duing this stay. (Effective from Jan 2015) Num(5)
WEIGHT The patient weight in pounds taken during this stay. (Effective from Jan 2015) Num(5)
BMI The patient Body Mass Index (BMI) taken during this stay. (Effective form Jan 2015) Num(5)
HOSP_ID Hospital’s Medicare provider number as assigned by CMS. Char(6)
HOSP_IND Hospital Classification: Urban or Rural Char(10)
HOSP_CNTY Hospital County Char(25)
SES Geographic patient regions based on a patient’s socio-economic status Char(20)
HHIC_CNTY The patient county of residence. The Kalawao county was merged into the Maui county due to its small population size. Char(20)
RACE The race or ethnicity with which the patient most closely identifies. There are 34 race categories. (Effective from Jan 2010) Char(50)
RACE2 HHIC conformed races (11 Race Categories) (Effective from 1995) Char(50)
ADM_SRC The source of this admission. Char(15)
ADM_TYPE The priority of this admission. Char(20)
PDISP The patient disposition or discharge status. Char(50)
DIED_IND Indicates in-hospital mortality – Yes or No Char(1)
APR_MDC All Patients Refined Major Diagnostic Category Num(2)
APR_DRG All Patients Refined Diagnosis Related Groups- system that classifies patients according to their reason of admission. Num(3)
APR_SPEC Grouping of diagnosis related APR-DRGs, e.g. cardiology related APR-DRGs are grouped into the Specialty category “Cardiology”. Char(50)
APR_ROM Risk of Mortality (1-Minor, 2-Moderate, 3-Major, 4-Extreme, 0-Unspecified) Char(1)
APR_SOI Severity of Illness (1-Minor, 2-Moderate, 3-Major, 4-Extreme, 0-Unspecified) Char(1)
APR_SERVICE_LINE Grouping of diagnosis related APRDRGs, e.g. cardiology related APRDRGs are grouped into the Specialty category “Cardiology”. Char(50)
APR_CASEMIX Relative value assigned to a each APRDRG. The case mix value is used in determining the allocation of resources to care for and/or treat the patients in the group. Num(8,4)
APR_EXP_LOS Expected Length of Stay in days Num(5)
APR_EXP_CHARGE Expected Charges Num(8)
APR_EXP_MORT_CNT Expected Mortality Cnt Num(5)
MS_DRG Medicare Severity Diagnosis-related Groups – used by CMS to provide greater reimbursement to hospitals serving more severely ill patients. Num(3)
MS_MDC Major Diagnostic Category Num(2)
MS_SERVICE_LINE Grouping of diagnosis related MSDRGs, e.g. cardiology related MSDRGs are grouped into the Specialty category “Cardiology”. Char(50)
MS_CASEMIX The non-transfer adjusted case mix index based on the MS-DRGs billed on the claim in the year the claim was incurred. Num(8,4)
PAYER Payer Sources Char(50)
PAYER_TYPE Payer Type: Medicare, Medicaid, Private Insurance, Uninsured, Others Char(50)
TOT_CHRG Total billed charge of hospital stay. Number(8)
EST_COST Estimated Costs (Inpatient Only) Cost is estimated using department-level cost to charge ratios (CCRs) from the CMS accounting system Number(10,2)
LOS Length of Stay – Total number of days from admission date to discharge date. Number(5)
PDIAG Principal Diagnosis Code Char(10)
ODIAGnn (nn=01-37) Secondary Diagnosis Codes Char(10)
PPOA Principal Present on Admission indicator Char(1)
OPOAnn (nn=01-37) Secondary Present on Admission indicators. Char(1)
PPROC Principal Procedure Code Char(10)
OPROCnn(nn=01-34) Secondary Procedure Codes Char(10)
MULTI_TYPE Multiple births: Single, Twins, Triplets, Quadruplets, or Other multiple pregnancy Char(20)
STD_IND STD Indicator where 0-No or 1-Yes Char(1)
SUBAB_IND Substance Abuse Indicator where 0-No or 1-Yes Char(1)
GESTDEL_IND Gestional Diabetes Indicator where 0-No or 1-Yes Char(1)
PREM_IND Premature Delivery Indicator where 0-No or 1-Yes Char(1)
MSLB Number of months since her last birth (in Months) Num(3)
PREVC_IND Previous C-Section Indicator where 0-No or 1-Yes Char(1)
STILLBORN_IND Stillborn Indicator where 0-No or 1-Yes Char(1)
STERILE_IND Sterile Indicator where 0-No or 1-Yes Char(1)
TRANSF_UNITS Number of Transfusion Units Num(3)
ICU_DAYS Number of ICU Days Num(3)
Baby Attributes
BREC_ID Baby Discharge Rec ID Number(10)
BMPI HHIC-assigned ID to track a patient across hospitals and levels of service. Char(10)
BHHIC PAT ID HHIC assigned identifier for each unique MRN Number(10)
BADM_YM Admission Year and Month Char(6)
BDIS_YM Discharge Year and Month Char(6)
BBIRTH_YM Year and month of birth Char(6)
BDSLE Number of days since the last event (Inpatient, ER, Observation, or Same day Surg) by patient’s MPI. Char(6)
BDIS_SEQ Discharge sequential order by the patient’s MPI and discharge date. Num(5)
BAGE Patient age at admission (ages 90 and over are grouped to 90). Number(3)
BAGED Patient age in days for patient less than 2 years old. Number(5)
BAGEW Patient age in weeks for patient less than 2 years old. Number(5)
BAGEM Patient age in months for patient less than 2 years old. Num(5)
BHEIGHT Height in inches taken during this stay. (Effective from Jan 2015) Num(5)
BWEIGHT Weight in pounds taken during this stay. (Effective from Jan 2015) Num(5)
BBMI Body Mass Index (BMI) taken during this stay. (Effective form Jan 2015) Num(5)
BHOSP_ID Hospital’s Medicare provider number as assigned by CMS. Char(6)
BHOSP_IND Hospital Classification: Urban or Rural Char(10)
BHOSP_CNTY Hospital County Char(25)
BSES Geographic patient regions based on a patient’s socio-economic status Char(20)
BHHIC_CNTY The patient county of residence. The Kalawao county was merged into the Maui county due to its small population size. Char(20)
BRACE The race or ethnicity with which the patient most closely identifies. There are 34 race categories. (Effective from Jan 2010) Char(50)
BRACE2 HHIC conformed races (11 Race Categories) (Effective from 1995) Char(50)
BGENDER Patient’s gender: M-Male or F-Female Char(1)
BADM_SRC The source of this admission. Char(15)
BADM_TYPE The priority of this admission. Char(20)
BPDISP Patient disposition or discharge status. Char(50)
BDIED_IND Indicates in-hospital mortality – Yes or No Char(1)
BAPR_MDC All Patients Refined Major Diagnostic Category Num(2)
BAPR_DRG All Patients Refined Diagnosis Related Groups- system that classifies patients according to their reason of admission. Num(3)
BAPR_SPEC Grouping of diagnosis related APR-DRGs, e.g. cardiology related APR-DRGs are grouped into the Specialty category “Cardiology”. Char(50)
BAPR_ROM Risk of Mortality (1-Minor, 2-Moderate, 3-Major, 4-Extreme, 0-Unspecified) Char(1)
BAPR_SOI Severity of Illness (1-Minor, 2-Moderate, 3-Major, 4-Extreme, 0-Unspecified) Char(1)
BAPR_SERVICE_LINE Grouping of diagnosis related APRDRGs, e.g. cardiology related APRDRGs are grouped into the Specialty category “Cardiology”. Char(50)
BAPR_CASEMIX Relative value assigned to a each MSDRG. The CMI value is used in determining the allocation of resources to care for and/or treat the patients in the group. Num(8,4)
BAPR_EXP_LOS Expected Length of Stay in days Num(5)
BAPR_EXP_CHARGE Expected Charges Num(8)
BAPR_EXP_MORT_CNT Expected Mortality Cnt Num(5)
BMS_DRG Medicare Severity Diagnosis-related Groups – used by CMS to provide greater reimbursement to hospitals serving more severely ill patients. Num(3)
BMS_MDC Major Diagnostic Category Num(2)
BMS_SERVICE_LINE Grouping of diagnosis related MSDRGs, e.g. cardiology related MSDRGs are grouped into the Specialty category “Cardiology”. Char(50)
BMS_CASEMIX The non-transfer adjusted case mix index based on the MS-DRGs billed on the claim in the year the claim was incurred. Num(8,4)
BPAYER Payer Sources Char(50)
BPAYER_TYPE Payer Type: Medicare, Medicaid, Private Insurance, Uninsured, Others Char(50)
BTOT_CHRG Total billed charge of hospital stay. Number(8)
BEST_COST Estimated Costs (Inpatient Only) Cost is estimated using department-level cost to charge ratios (CCRs) from the CMS accounting system Number(10,2)
BLOS Length of Stay – Total number of days from admission date to discharge date. Number(5)
BPDIAG Principal Diagnosis Code Char(10)
BODIAGnn (nn=01-37) Secondary Diagnosis Codes Char(10)
BPPOA Principal Present on Admission indicator Char(1)
BOPOAnn (nn=01-37) Secondary Present on Admission indicators. Char(1)
BPPROC Principal Procedure Code Char(10)
BOPROCnn(nn=01-34) Secondary Procedure Codes Char(10)
Observation

(Effective from January 2011)

Variable Description Type/Length
REC_ID Discharge Rec ID Number(10)
MPI HHIC-assigned ID to track a patient across hospitals and levels of service. Char(10)
HHIC PAT ID HHIC assigned identifier for each unique MRN Number(10)
ADM_YM Admission Year and Month Char(6)
DIS_YM Discharge Year and Month Char(6)
BIRTH_YM Year and month of birth Char(6)
DSLE Number of days since the last event (Inpatient, ER, Observation, or Same day Surg) by patient’s MPI. Char(6)
DIS_SEQ Discharge sequential order by the patient’s MPI and discharge date. Num(5)
AGE Patient age at admission (ages 90 and over are grouped to 90). Number(3)
AGED Patient age in days for patient less than 2 years old. Number(5)
AGEW Patient age in weeks for patient less than 2 years old. Number(5)
AGEM Patient age in months for patient less than 2 years old. Num(5)
HOSP_ID Hospital’s Medicare provider number as assigned by CMS. Char(6)
HOSP_IND Hospital Classification: Urban or Rural Char(10)
HOSP_CNTY Hospital County Char(25)
SES Geographic patient regions based on a patient’s socio-economic status Char(20)
HHIC_CNTY The patient county of residence. The Kalawao county was merged into the Maui county due to its small population size. Char(20)
RACE The race or ethnicity with which the patient most closely identifies. There are 34 race categories. (Effective from Jan 2010) Char(50)
RACE2 HHIC conformed races (11 Race Categories) (Effective from 1995) Char(50)
GENDER Patient’s gender: M-Male or F-Female Char(1)
ADM_SRC The source of this admission. Char(15)
ADM_TYPE The priority of this admission. Char(20)
PDISP Patient disposition or discharge status. Char(50)
PDISP_CATG Patient disposition category Char(50)
DIED_IND Indicates in-hospital mortality – Yes or No Char(1)
APR_MDC All Patients Refined Major Diagnostic Category Num(2)
APR_DRG All Patients Refined Diagnosis Related Groups- system that classifies patients according to their reason of admission. Num(3)
APR_SPEC Grouping of diagnosis related APR-DRGs, e.g. cardiology related APR-DRGs are grouped into the Specialty category “Cardiology”. Char(50)
MS_DRG Medicare Severity Diagnosis-related Groups – used by CMS to provide greater reimbursement to hospitals serving more severely ill patients. Num(3)
MS_MDC Major Diagnostic Category Num(2)
MS_SERVICE_LINE Char(50)
MS_CASEMIX The non-transfer adjusted case mix index based on the MS-DRGs billed on the claim in the year the claim was incurred. Num(8,4)
PAYER Payer Sources Char(50)
PAYER_TYPE Payer Type: Medicare, Medicaid, Private Insurance, Uninsured, Others Char(50)
TOT_CHRG Total billed charge of hospital stay. Number(8)
PDIAG Principal Diagnosis Code Char(10)
ODIAGnn (nn=01-37) Secondary Diagnosis Codes Char(10)

Discharge Diagnosis, Discharge Procedure, Discharge Revenue, and Discharge HCPCS data variables provided as linkable separate files as appropriate.

Same Day Surgery

(Effective from January 2008)

Variable Description Type/Length
REC_ID Discharge Rec ID Number(10)
MPI HHIC-assigned ID to track a patient across hospitals and levels of service. Char(10)
HHIC PAT ID HHIC assigned identifier for each unique MRN Number(10)
ADM_YM Admission Year and Month Char(6)
DIS_YM Discharge Year and Month Char(6)
BIRTH_YM Year and month of birth Char(6)
DSLE Number of days since the last event (Inpatient, ER, Observation, or Same day Surg) by patient’s MPI. Char(6)
DIS_SEQ Discharge sequential order by the patient’s MPI and discharge date. Num(5)
AGE Patient age at admission (ages 90 and over are grouped to 90). Number(3)
AGED Patient age in days for patient less than 2 years old. Number(5)
AGEW Patient age in weeks for patient less than 2 years old. Number(5)
AGEM Patient age in months for patient less than 2 years old. Num(5)
HOSP_ID Hospital’s Medicare provider number as assigned by CMS. Char(6)
HOSP_IND Hospital Classification: Urban or Rural Char(10)
HOSP_CNTY Hospital County Char(25)
SES Geographic patient regions based on a patient’s socio-economic status Char(20)
HHIC_CNTY The patient county of residence. The Kalawao county was merged into the Maui county due to its small population size. Char(20)
RACE The race or ethnicity with which the patient most closely identifies. There are 34 race categories. (Effective from Jan 2010) Char(50)
RACE2 HHIC conformed races (11 Race Categories) (Effective from 1995) Char(50)
GENDER Patient’s gender: M-Male or F-Female Char(1)
ADM_SRC The source of this admission. Char(15)
ADM_TYPE The priority of this admission. Char(20)
PDISP Patient disposition or discharge status. Char(50)
PDISP_CATG Patient disposition category Char(50)
DIED_IND Indicates in-hospital mortality – Yes or No Char(1)
APR_MDC All Patients Refined Major Diagnostic Category Num(2)
APR_DRG All Patients Refined Diagnosis Related Groups- system that classifies patients according to their reason of admission. Num(3)
APR_SPEC Grouping of diagnosis related APR-DRGs, e.g. cardiology related APR-DRGs are grouped into the Specialty category “Cardiology”. Char(50)
MS_DRG Medicare Severity Diagnosis-related Groups – used by CMS to provide greater reimbursement to hospitals serving more severely ill patients. Num(3)
MS_MDC Major Diagnostic Category Num(2)
MS_SERVICE_LINE Char(50)
MS_CASEMIX The non-transfer adjusted case mix index based on the MS-DRGs billed on the claim in the year the claim was incurred. Num(8,4)
PAYER Payer Sources Char(50)
PAYER_TYPE Payer Type: Medicare, Medicaid, Private Insurance, Uninsured, Others Char(50)
TOT_CHRG Total billed charge of hospital stay. Number(8)
PDIAG Principal Diagnosis Code Char(10)
ODIAGnn (nn=01-37) Secondary Diagnosis Codes Char(10)

Discharge Diagnosis, Discharge Procedure, Discharge Revenue, and Discharge HCPCS data variables provided as linkable separate files as appropriate.

Back To Top