skip to Main Content

Pricing & Purchase HHIC will accept, process and fulfill requests for the purchase and use of HHIC Data. Our online Data 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-3Q 2017)

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)
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)
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_SERVICE_LINE 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_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_RATE 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-3Q 2017)

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)
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)
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_SERVICE_LINE 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 Grouping of diagnosis related APR-DRG, e.g., cardiology related APR-DRGs are grouped into the Specilty category “Cardiology”. Char(50)
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)
LOS Length of Stay in days Num(5)
HOMELESS_IND Homeless Indicator: 0-No and 1-Yes Char(1)
PDIAG Principal Diagnosis Code Char(10)
ODIAGnn (nn=01-37) Secondary Diagnosis Codes Char(10)
PPROC Principal ICD9/10 Procedure Code Char(10)
OPROCnn (nn=01-34) Secondary ICD9/10 Procedure 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-3Q 2017)

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)
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_SERVICE_LINE 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_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)
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_SERVICE_LINE 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_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-3Q 2017)

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)
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)
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_SERVICE_LINE 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 *Grouping of diagnosis related APR-DRG, e.g., cardiology related APR-DRGs are grouped into the Specilty category “Cardiology”. Char(50)
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)
PPROC Principal ICD9/10 Procedure Code Char(10)
OPROCnn (nn=01-34) Secondary ICD9/10 Procedure 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-3Q 2017)

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)
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)
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)
PPROC Principal ICD9/10 Procedure Code Char(10)
OPROCnn (nn=01-34) Secondary ICD9/10 Procedure Codes Char(10)

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

Lab Result Variables
Discharge Lab Results – Effective from January 2012 for Inpatient discharges.)
Column Description Type/Length
REC_ID HHIC Lab Result Identifier Number(10)
DIS_ID Discharge Rec ID Number(10)
LOINC LOINC code of the lab test. Char(10)
LAB_NAME Name of the lab test Char(100)
OBSRV_YM The month and year when the lab test was taken. (Format: YYYYMM) Char(6)
LAB_AT_ADM Lab test was performed at Hospital admission: Y-Yes or N-No Char(1)
OBSRV_UNIT Observation unit of measurement. Char(15)
OBSRV_VALUE Observation Values Char(100)
RESULT_CATG Result Category: Normal, Below Normal, Above Normal, or Not Specified. Char(20)
List of Lab tests*:
Lab Test/Name
Chemistry
Albumin
Alkaline phosphatase
Blood urea nitrogen (BUN)
Bilirubin (total)
Calcium
Chloride
Creatine kinase-MB
Creatinine
Glucose
Gamma glutamyl transferase
Potassium
Phosphate
BNP
Sodium
Troponin I
SGOT
SGPT
Blood Gas
pO2
pCO2
pH(arterial)
Base excess
Bicarbonate
Hematology
Hemoglobin
Hematocrit
Partial thromboplastin time (PTT)
Prothrombin time (PT)
INR
Platelet count
White blood count (WBC)
Microbiology
Blood culture
Urine culture
Sputum culture
Toxicology ALPHA-HYDROXYALPRAZOLAM
AMPHETAMINES
AMPHETAMINES/METHAMPHET.
BARBITURATES
BENZODIAZEPINES
COCAINE
CODEINE
ETHANOL
ETHANOL, CLINICAL URINE
HYDROCODONE
HYDROMORPHONE
LORAZEPAM
MDMA
METHADONE
METHAMPHETAMINES
METHYLENEDIOXYMETHAMPHETAMINE
NORDIAZEPAM
OPIATES
OXAZEPAM
OXYCODONE
OXYCODONE/OXYMORPHONE
OXYMORPHONE
PCP / PHENCYCLIDINE
TEMAZEPAM
TETRAHYDROCANNABINOL
TOTAL MORPHINE
TRICYCLIC ANTIDEPRESSANTS

*NOTE: Chemistry, Blood Gas, Hematology, Microbiology: inpatient admission lab tests; Toxicology results include inpatient, ER, Observation.

Back To Top