Admitted Patient Data Collection – Variable information Variable (variable name in data) Description/Notes Codes Comments Hospital type (hospital_type) Flag to indicate if facility is public or private. 1=Public hospital 2=Private hospital Acute Hospital Flag (acute_flag) Indicates whether or not the patient received the service at an acute facility. This is one of the variables required in order to identify services provided in an acute hospital. Formerly known as ‘acuteflg’ Age (age_recode) The age in years of the patient derived from subtracting the date of birth from the date of admission. Age has been re-coded, using the ‘yrdiff’ SAS function that returns the difference in years between birth date (from STAY table) and episode start date. Formerly known as ‘age’.
date (birth_date) Full date of birth will only be supplied if sufficient justification is supplied that age is insufficient. Date of birth may otherwise be supplied as MMYYYY. Formerly as ‘dob’. Procedure block number (block_numP, All procedures are grouped into blocks of similar characteristics (body site and/or particular procedural intervention) to assist with data aggregation. ICD-10-AM Formerly known as ‘procbl1’-‘procbl50’. Clinical codeset (clinical_codeset) An identifier to identify the current classification scheme a procedure or diagnosis has been mapped to. Trial
Condition onset flag (clinical_onset_flagP, A qualifier for each coded diagnosis to indicate the onset of the condition relative to the beginning of the episode of care, as represented by a code. 1 = Condition with onset during the episode of admitted patient care 2 = Condition not noted as arising during the episode of admitted patient care 9 = Not reported Formerly known as ‘coflag_m1’-‘coflag_m10’, ‘coflag_pl1’-‘coflag_p3’. Available from 1 July 2008. Contract status (contract_status_public, contract_status_private) An indication whether or not the admitted patient service being provided during this stay in hospital is being performed under a contractual agreement with another facility or health service. 0 = Single Facility Admitted Patient Care 1 = Contract Service Provided at this Facility 2 = Not a Contract Service Provided at this Facility 3 = Full Care Purchased from a Private Facility 4 = Part Care Purchased from a Private Facility 5 = Part Care Obtained from another Public Facility 7 = Part Care Provided for another Public Facility 8 = Part Care Provided for a Private Facility R = Community Residential Formerly as ’contract’. Country of (SACC) (country_of_birth_SACC) The country in which the patient was born Codes are Standard Australian Classification of Countries Formerly known as ‘cobsacc’. Country of usual residence (country_of_usual_residence) The country where the patient's home address is located. Codes are Standard Australian Classification of Countries Previously not available.
DRG mode of separation (drg_mode_of_separation) Status at separation of person (discharge / transfer / death) and place to which the person is released (where applicable). The values used for DRG Mode of Separation are as defined by the National Health Data Dictionary for 'Mode of Separation'. Previously not available. From 2014-15 this variable is only available for public hospitals. Department of Veterans Affairs card type (DVA_card_type) Indicates the type of Veterans Affairs card 1 =White Card 2 = Gold Card 3 = Orange Card Formerly known as ‘DVAtype’.
Emergency status (emergency_status_recode) Urgency of admission. Indicates whether or not, in the opinion of the treating clinician, the admission was an emergency, that is, care or treatment was required within 24 hours. Applies to Public Hospital data only Emergency status has been re-coded as follows: if source of referral =’Type change admission’' then emergency status is re-coded to ‘3’ (Urgency Not Assigned). if emergency status =’ 4’ then emergency status is re-coded to ‘ 3’. if emergency status recode =’ 5’ then emergency status is re-coded to ‘ 2. 1 = Emergency 2 = Non-Emergency/Planned 3 = Urgency Not Assigned 4 = Maternity/Newborn 5 = Regular Same Day Planned Admissions Formerly as ‘emergncy’. Emergency Department Status (ed_status) A flag that indicates whether a patient during an episode of care has been treated within the emergency department, and if so, whether they were also admitted to a ward. 1 =Entire episode within ED (for Level >=3) only 2= Episode includes ED (for Level >=3) and ward 3= Episode with no ED involvement 4= Entire episode within ED (for Level 1 or 2) only 5= Episode includes ED (for Level 1 or 2) and ward 9= Not assigned Previously not available.
Episode day stay length of stay in The number of a patient who is admitted and separated on the same day is admitted to the hospital. Episode_day_stay_los has been re-coded as follows: for public hospitals: Episode_day_stay_los is renamed to Episode_day_stay_los_recode. for private hospitals: episode_day_stay_los_recode = integer part of (episode_day_stay_los divided by 10) Formerly as ‘dolos’. From 2014-15 this variable is only available for public hospitals. Episode end date (episode_end_date) The date on which an admitted patient completes an episode of care, by either a formal discharge from the hospital or by a statistical type change to a subsequent episode. Formerly known as ‘sepdate’. Episode end time (episode_end_time) The time on which an admitted patient completes an episode of care, by either a formal discharge from the hospital or by a statistical type change to a subsequent episode. Formerly known as ‘septime’.
Financial sub program (financial_sub_program) A code to identify the various components of the mental health financial program to aid in the identification of service specific activities, and the identification of where the primary episode of care costs were incurred. B = Child & Adolescent Care C = General & Adult Care D = Older People Psychiatric Care E = Forensic Psychiatric Care Previously not available. This variable is available for public hospitals only. Health insurance on admission (health_insurance_on_admit) Indicates whether the person receiving the inpatient service is insured with top or basic cover, or not insured at the time of admission. This variable is not intended to indicate whether or not the person utilises hospital benefit entitlements. 0 = No cover – private patient 1 = Full – private patient 2 = Basic cover – private patient 3 = No cover 4 = Ancillary cover only – private patient 5 = No cover – public patient 6 = Full – public patient 7 = cover – public patient 8 = Ancillary cover only – public patient 9 = Unknown/Not stated ** Other** = invalid data Formerly known as ‘inssat’.
in ICU (hours_in_icu) The number of hours the patient spent in a designated intensive care unit for this episode of care. Formerly known as ‘icuhours’. Hours on mechanical ventilation (hours_on_mech_ventilation) The total number of completed hours that the patient has spent on mechanical ventilation during the episode of care. Formerly as ‘hrsmechv’. Indigenous status (indigenous_status) Whether the person is Aboriginal or Torres Strait Islander, on the person’s own self-report. See notes above regarding access to this variable. 1 = Aboriginal 2 = Torres Strait Islander 3 = Aboriginal and Torres Strait Islander origin 4 = Neither Aboriginal nor Torres Strait Islander 5 = Indigenous – not further specified 8 = Declined to respond 9 = Unknown Formerly as ‘abtsi’.
Payment status on separation (payment_status_on_sep) Indicates the payment status of the patient. See Attachment 4 – Payment Status on Separation Formerly known as ‘payst_v4’. Peer group (peer_group) Facility peer grouping. The grouping is updated annually by the Ministrry of Health. Therefore, a small number of hospitals are classified into different peer groups in different years. This is one of the variables required in order to identify services provided in an acute hospital. See Attachment 5. – Peer Group Formerly as ‘hcdbpeer’. Peer group is missing for private hospitals. For more information please see:
Sex (sex) The biological sex of the patient. Post and Pre Sex Redefining Procedures are coded to the biological sex at birth, not their newly assigned sex. Transvestites are coded to their biological sex, not their gender role 1 =Male 2 = Female 3 = Indeterminate/Intersex 4 = Transgender 9 = Not stated/inadequately described/unknown Also known as ‘sex’ previously.
SRG version (SRG_version) The version number of the Service Related Group. Formerly known as ‘base_srg_version’. From 2014-15 this variable is only available for public hospitals. State of residence (state_of_recidence_recode) Indicates the Australian state of residence for the patient. 0 = Overseas / No fixed address / Not stated 1 = New South Wales 2 = Victoria 3 = Queensland 4 = South Australia 5 = Western Australia 6 = Tasmania 7 = Northern Territory 8 = Australian Capital Territory 9 = Other Territories State of usual residence for public facilities have been re-coded to numeric values: 'OS' to '0' 'NSW' to '1' 'VIC' to '2 'QLD' to '3' 'SA' to '4 'WA' to '5' 'TAS' to '6’ 'NT' to '7' 'ACT' to '8’ 'OT' to '9’ 'AAT' to '9’ 'NS' to '0' Formerly known as ‘stateres’.
Stay number (encrypted) (stay_number_e) The unique HIE stay number for each period of stay. Formerly known as ‘staynum_encrypted’. Unit type on admission (unit_type_on_admission) The designation of each bed, in of type of care or group of patients, which the patient is accommodated in during his/her stay in hospital. See Attachment 7 – unit type on admission Formerly known as ‘unittyp2’. From 2014-15 this variable is only available for public hospitals. Unqualified baby bed days (unqual_baby_bed_days) The number days a newborn was unqualified the Health Insurance Act. Formerly known as ‘unqualday’. LGA 2001 CODE (LGA_2001_Code)* Local Government Area 2001 LGA 2006 CODE (LGA_2006_Code)* Local Government Area 2006 LGA 2011 CODE (LGA_2011_Code)* Local Government Area 2011 LHD 2010 CODE (LHD_2010_code) Local Health District of residence (2010 boundaries) See Attachment 8 – Local Health District Formerly as ‘lhn10res’. PHN 2015 CODE (PHN_2015_Code Primary Health Network 2015
Attachment 2 – Financial Code Description 12 Department of Veterans Affairs - General Overnight 23 Department of Veterans Affairs Claim - Same Day Band 2 24 Department of Veterans Affairs Claim - Same Day Band 3 25 Department of Veterans Affairs Claim - Same Day Band 4 32 Department of Veterans Affairs Claim - Nursing Home Type 56 Department of Veterans Affairs Claim - Same Day Band 1a 57 Department of Veterans Affairs Claim - Same Day Band 1b 58 Department of Veterans Affairs Claim - Same Day Band 1c AC Residential Aged Care - General - Shared Ward AD Residential Aged Care - Department of Veterans Affairs AO Residential Aged Care - Other Compensable AS Residential Aged Care - General - Single Room AT Residential Aged Care - Transcover Compensation AV Residential Aged Care - NSW Motor Accident Authority Compensation AW Residential Aged Care - Workers Compensation BD Brain Dead Organ Donor - Procurement BO Boarder (Other than Self Contained Unit) BS Boarder (Self Contained Unit) C1 Other Compensable - Critical - Same Day C2 Other Compensable - Non-Critical - Same Day C3 Other Compensable - Critical - Overnight C4 Other Compensable - Non-Critical - Overnight CU Resident - Confused & Disturbed Elderly (CADE) Bed/Unit DC Deferred Classification DO Organ Donor - Overseas Visitor E2 Medicare Card Holder - Elected Doctor - General - Same Day Band 2 E3 Medicare Card Holder - Elected Doctor - General - Same Day Band 3 E4 Medicare Card Holder - Elected Doctor - General - Same Day Band 4 EA Medicare Card Holder - Elected Doctor - General - Same Day Band 1a
EB Medicare Card Holder - Elected Doctor - General - Same Day Band 1b EC Medicare Card Holder - Elected Doctor - General - Same Day Band 1c EN Medicare Card Holder - Elected Doctor - Nursing Home Type - Shared Ward Election ER Medicare Card Holder - Elected Doctor - Nursing Home Type - Single Room Election ES Medicare Card Holder - Elected Doctor - General - Single Room Election EW Medicare Card Holder - Elected Doctor - General - Overnight - Shared Ward Election HO Resident - Hostel M2 Medicare Card Holder - Hospital Doctor - General - Same Day Band 2 M3 Medicare Card Holder - Hospital Doctor - General - Same Day Band 3 M4 Medicare Card Holder - Hospital Doctor - General - Same Day Band 4 MA Medicare Card Holder - Hospital Doctor - General - Same Day Band 1a MB Medicare Card Holder - Hospital Doctor - General - Same Day Band 1b MC Medicare Card Holder - Hospital Doctor - General - Same Day Band 1c MN Medicare Card Holder - Hospital Doctor - Nursing Home Type - Shared Ward Election MW Medicare Card Holder - Hospital Doctor - General - Overnight - Shared Ward Election ND Overseas Visitor - Norfolk Island - Same Day NO Overseas Visitor - Norfolk Island - Overnight OA Overseas Visitor - Asylum Seeker - Overnight OD Overseas Visitor - Other - Same Day OO Overseas Visitor - Other - Overnight OS Overseas Visitor - Asylum Seeker - Same Day PD Prisoner - Hospital Doctor - Same Day PO Prisoner - Hospital Doctor - Overnight R2 Overseas Visitor - Reciprocal - Hospital Doctor - Same Day Band 2 R3 Overseas Visitor - Reciprocal - Hospital Doctor - Same Day Band 3 R4 Overseas Visitor - Reciprocal - Hospital Doctor - Same Day Band 4 RA Overseas Visitor - Reciprocal - Hospital Doctor - Same Day Band 1a RB Overseas Visitor - Reciprocal - Hospital Doctor - Same Day Band 1b RC Overseas Visitor - Reciprocal - Hospital Doctor - Same Day Band 1c RN Overseas Visitor - Reciprocal - Hospital Doctor - Nursing Home Type RP Drug / Research Patient RW Overseas Visitor - Reciprocal - Hospital Doctor - General - Overnight S1 Psychiatric Hospital - Interstate Resident - Same Day S2 Psychiatric Hospital - Interstate Resident - Overnight
S3 Psychiatric Hospital - Overseas Visitor - Same Day S4 Psychiatric Hospital - Overseas Visitor - Overnight SD Psychiatric Hospital - NSW Resident - Same Day SO Psychiatric Hospital - NSW Resident - Overnight T1 TransCover Compensation - Critical - Same Day T2 TransCover Compensation - Non-Critical - Same Day T3 TransCover Compensation - Critical - Overnight T4 TransCover Compensation - Non-Critical - Overnight TD Overseas Visitor - Tuberculosis - Hospital Doctor - Same Day TO Overseas Visitor - Tuberculosis - Hospital Doctor - Overnight - Shared Ward Election U1 Medicare Card Holder - Unqualified Newborn of Public Patient - Same Day U2 Medicare Card Holder - Unqualified Newborn of Public Patient - Overnight U3 Medicare Card Holder - Unqualified Newborn of Private Patient - Same Day U4 Medicare Card Holder - Unqualified Newborn of Private Patient - Overnight U5 Overseas Visitor - Reciprocal - Unqualified Newborn - Same Day U6 Overseas Visitor - Reciprocal - Unqualified Newborn - Overnight U7 Overseas Visitor - Other - Unqualified Newborn - Same Day U8 Overseas Visitor - Other - Unqualified Newborn - Overnight V1 NSW Motor Accident Authority Compensation - Critical - Same Day V2 NSW Motor Accident Authority Compensation - Non-Critical - Same Day V3 NSW Motor Accident Authority Compensation - Critical - Overnight V4 NSW Motor Accident Authority Compensation - Non-Critical - Overnight VD Overseas Visitor - Victim of Crime - Hospital Doctor - Same Day VO Overseas Visitor - Victim of Crime - Hospital Doctor - Overnight - Shared Ward Election W1 Workers Compensation - Critical Care - Same Day W2 Workers Compensation - Non-Critical Care - Same Day W3 Workers Compensation - Critical Care - Overnight W4 Workers Compensation - Non-Critical Care - Overnight **OTHER** Invalid Data
Attachment 6 – Service Related Groups Code Description 11 Cardiology 12 Interventional Cardiology 13 Dermatology 14 Endocrinology 15 Gastroenterology 16 Diagnostic GI Endoscopy 17 Haematology 18 Immunology & Infections 19 Medical Oncology 20 Chemotherapy 21 Neurology 22 Renal Medicine 23 Renal Dialysis 24 Respiratory Medicine 25 Rheumatology 26 Pain Management 27 Non Subspecialty Medicine 41 Breast Surgery 42 Cardiothoracic Surgery 43 Colorectal Surgery 44 Upper GIT Surgery 45 Head & Neck Surgery 46 Neurosurgery 47 Dentistry 48 Ear, Nose & Throat 49 Orthopaedics 50 Ophthalmology 51 Plastic & Reconstructive Surgery 52 Urology 53 Vascular Surgery 54 Non Subspecialty Surgery 61 Transplantation 62 Extensive Burns 63 Tracheostomy 71 Gynaecology 72 Obstetrics 73 Qualified Neonate 74 Unqualified Neonate 75 Perinatology 81 Drug & Alcohol 82 Psychiatry - Acute 83 Psychiatry - Non Acute 84 Rehabilitation 85 Non Acute Geriatric 86 Palliative Care 87 Maintenance 99 Unallocated