Other names Accident date, Injury date Context Events resulting from an accident. Layout CCYYMMDD Data domain Partial dates are permissible. Incomplete dates are stored as 'ccyy0101' or 'ccyymm01' and a partial date flag associated with the date is set to the appropriate value. Guide for use External cause date of occurrence and Operation/procedure date are sent in separately but both stored in the same field. If the diagnosis type is 'E' (i.e., external cause event), the date is External cause date of occurrence. Verification rules Optional. Collection methods This field is optional for ICD-10-AM 2nd Edition (and onwards) place of occurrence codes (Y92.x) and activity codes (Y93.x). Related data Diagnosis type Accident date flag Source document Source organisation Procedure ACC date flag Definition Indicates whether the External cause date of occurrence stored is a partial date. Column name procedure_acc_date_flag Table name fact_nmd_diagnosis_procedure Data type char(1) Other names Context Events resulting from an accident. Layout Data domain D where the day portion of the date is missing, default to '01' M where both day and month portions of the date are missing, default to '01/01' Guide for use A partial date flag, set automatically. As the system allows partial dates to be entered, this identifies what field(s) are missing if a partial date is entered. For example, if a date is entered as '00/00/2005', then the date is stored as '01/01/2005' and the partial indicator would be set to 'M'. Verification rules Collection methods Related data External cause date of occurrence Source document Source organisation
Facility Transfer To Definition For transfers, the facility that the healthcare user was transferred to. Column name facility_transfer_to Table name fact_nmd_health_event Data type varchar2(4) Other names Context Layout Data domain See the Facility code table on the Ministry of Health web site at For further information or a printed copy of the code table, contact Analytical Services. Guide for use Unit record information with Facility codes will not be provided to members of the public without the permission of the agency involved. See the Current Data Access Policy on the Ministry of Health web site at http://www.health.govt.nz/nz-health-statistics/access-and-use Verification rules Mandatory for Event End Type Code = 'DA', 'DP', 'DT', 'EA' or 'ET' (Transfers) for the events ending on or after 1 July 2008. Must be a valid code in the Facility code table. Collection methods Related data Facility Code, Event End Type Code Source document Source organisation Ministry of Health Facility code Definition A code that uniquely identifies a healthcare facility. Column name facility_code Table name fact_nmd_health_event Data type varchar2(4) Other names Health agency facility code, Hospital, HAF code, HAFC Context Layout Data domain See the Facility code table on the Ministry of Health web site at For further information or a printed copy of the code table, contact Analytical Services.
Gestation period Definition Time measured from the date of mother's last menstrual period to the date of birth and expressed in completed weeks. Column name gestation_period Table name fact_nmd_health_event Data type varchar2(2) Other names Gestation Context Birth event. Layout XX Data domain XX = not stated 10 - 50 completed weeks Guide for use Verification rules Mandatory for events. Must not be supplied for other event types. If outside 17 to 45 completed weeks, will only be accepted on confirmation. Collection methods Related data Source document Source organisation Health specialty code Definition A classification describing the specialty or service to which a healthcare user has been assigned, which reflects the nature of the services being provided. Column name health_specialty_code Table name fact_nmd_health_event Data type varchar2(3) Other names HSC, Service code, Department code Context Healthcare user on discharge. Layout Data domain See the Health Specialty code table at For further information or a printed copy of the code table, contact Analytical Services. Guide for use Generalist and specialist subspecialty medical and surgical health specialty were retired from 1 July 2001. On 1 July 2007 the following changes took place: M20: Endocrinology and Diabetology ..was discontinued and replaced with..
Event Facility Type view (dim_event_facility_type) dim_event_start_date (dim_event_start_date) Excluded purchase unit dimension (dim_exclu_purchase_unit) Facility transfer from dimension (dim_facility_transfer_from) Facility transfer to dimension (dim_facility_transfer_to) dim_first_consult_date (dim_first_consult_date) dim_last_updated_date (dim_last_updated_date) Mothers Age view (dim_mothers_age) A view of the shared Age Band dimension table. dim_pd_06_clinical_code (dim_pd_06_clinical_code) dim_pd_10_clinical_code (dim_pd_10_clinical_code) dim_pd_11_clinical_code (dim_pd_11_clinical_code) dim_pd_12_clinical_code (dim_pd_12_clinical_code) dim_procedure_acc_date (dim_procedure_acc_date) Psych leave end date view (dim_psych_lv_end_date) A view of the shared Global Time dimension table. dim_referral_date (dim_referral_date) dim_surg_decided_date (dim_surg_decided_date) Appendix D: Data Dictionary Template Introduction This appendix explains how data element attributes are organised in the data dictionary template. of elements Within the dictionary, elements are organised by and then alphabetically. An alphabetical index at the back of the data dictionary (Appendix I) and the graphical data model are intended to assist the user in finding specific elements. Template This table explains the template.
Legal Status code table MDC code table MDC Type code See MDC type on page 141 Occupation code table Principal Health Service Purchaser code table Psychiatric Leave End code table Code tables on web site For code tables on the Ministry of Health web site go to For further information contact Analytical Services. Contact details are given at the front of this dictionary. Appendix F: Logical Groups of Elements Health Event (Administrative) Admission source code Admission type code Client system identifier Event end date Event end type code Event ID Event leave days Event local identifier Event start date summary suppress flag Event supplementary information Event type code Health specialty code Length of stay Mother’s Encrypted NHI Principal health service purchaser Private flag PMS unique identifier Healthcare User Age at admission Age at discharge Country of birth code Date of birth Date of Birth flag Domicile code Encrypted NHI number Ethnic group codes NHI number NZ Resident Status Occupation code Occupation free-text Prioritised ethnicity Sex DRG AN-DRG grouper code version 3.1 CCL Cost Weight Code Cost Weights DRG code DRG grouper type code Excluded Purchase Unit MDC code MDC type NZ DRG code current PCCL Purchase unit Birth Event Age of mother Birth location Birth status Birthweight Gestation period Mental Health Events Legal status code Legal status date Psychiatric leave end code Psychiatric leave end date Clinical Clinical code Clinical code type Clinical coding system ID Diagnosis number Diagnosis sequence Diagnosis type Diagnosis/procedure description Operation/procedure date Total hours on mechanical ventilation hours on CPAP ICU Hours Weight on Admission External Events ACC claim number Accident flag External cause date of occurrence Common Groupings Area unit code Domicile code description Domicile code status Financial year of data Region of agency of treatment Region of treatment TLA of domicile Year of census Year of data Agencies and Facilities Agency address Agency closing date Agency code Agency name Agency opening date Agency type code
Detailed code table The codes used to report ethnicity to MOH are taken from the Statistics NZ Statistical Standard for Ethnicity 2005. This classification is a very detailed 5-digit code: only the first two digits (shown in the table below) are reported to MOH. Use this table to code healthcare user’s self-identified ethnicities. MOH Ethnicity code Country of Ethnicity Affiliation 37 Admiralty Islander 44 Afghani 53 African American 53 African nec 53 African nfd 12 Afrikaner 32 Aitutaki Islander 12 Albanian 51 Algerian 12 American (US) 51 Arab 52 Argentinian 12 Armenian 44 Asian nec 40 Asian nfd 51 Assyrian 32 Atiu Islander 37 Austral Islander 12 Australian 37 Australian Aboriginal 12 Austrian 37 Banaban 44 Bangladeshi 37 Belau/Palau Islander 12 Belgian 12 Belorussian 43 Bengali 37 Bismark Archipelagoan 52 Bolivian 12 Bosnian
37 Bougainvillean 52 Brazilian 12 British nec 12 British nfd 12 Bulgarian 12 Burgher 41 Burmese 12 Byelorussian 41 Cambodian 42 Cambodian Chinese 12 Canadian 37 Caroline Islander 12 Celtic nfd 61 Central American Indian 37 Chamorro 12 Channel Islander 52 Chilean 42 Chinese nec 42 Chinese nfd 52 Colombian 32 Cook Island Maori nfd 12 Cornish 12 Corsican 52 Costa Rican 52 Creole America) 53 Creole (US) 12 Croat/Croatian 12 Cypriot nfd 12 12 Dalmatian 12 Danish 12 Dutch/Netherlands 37 Easter Islander 52 Ecuadorian 51 Egyptian 12 English 53 Eritrean 12 Estonian 53 Ethiopian 44 Eurasian 10 European nfd 12 Falkland Islander/Kelper 36 Fijian (except Fiji Indian/ Indo-Fijian) 43 Fijian Indian/Indo-Fijian 41 Filipino 12 Finnish 12 Flemish 12 French 12 Gaelic 37 Gambier Islander 12 German 53 Ghanian 12 (incl Greek Cypriot) 12 Greenlander 37 Guadalcanalian 37 Guam Islander/Chamorro 52 Guatemalan 43 Gujarati 52 Guyanese 37 Hawaiian 52 Honduran 42 Hong Kong Chinese 12 Hungarian 12 Icelander 37 I-Kiribati/Gilbertese 43 Indian nec 43 Indian nfd 41 Indonesian (incl Javanese/ Sundanese/Sumatran) 61 Inuit/Eskimo 51 Iranian/Persian 51 Iraqi 12 Irish 51 Israeli/Jewish/Hebrew 12 Italian 53 Jamaican 44 Japanese 51 Jordanian 42 Kampuchean Chinese 37 Kanaka/Kanak 53 Kenyan 41 Khmer/Kampuchean/ Cambodian 44 Korean 51 Kurd 41 Lao/Laotian 52 Latin American/Hispanic nec 52 American/Hispanic nfd 12 Latvian 51 Lebanese 51 Libyan 12 Lithuanian 12 Macedonian 37 Malaitian 41 Malay/Malayan 42 Malaysian Chinese 12 Maltese 52 Malvinian Falkland Islander) 32 Mangaia Islander 32 Manihiki Islander 37 Manus Islander 12 Manx
53 Ugandan 12 Ukrainian 52 Uruguayan 37 Vanuatu Islander/New Hebridean 52 Venezuelan 41 Vietnamese 42 Vietnamese Chinese 37 Wake Islander 37 Wallis Islander 12 Welsh 53 West Indian/Caribbean 37 Yap Islander 51 Yemeni 12 Zimbabwean nfd = Not further defined nec = Not elsewhere classified
Event End Type Codes - Mapping to Separation Mode Event End Type Event End Type Description Separation Mode Code EA Discharge from Emergency department acute facility to specialist facility for neonates and burns only 1 or 01 ED Died still in Emergency department acute facility 8 or 08 EI Self discharge from treatment in an Emergency department acute facility with indemnity signed 6 or 06 ER Routine discharge from an Emergency department acute facility 9 or 09 ES Self discharge from treatment in an Emergency department acute facility without indemnity 6 or 06 ET Discharge from Emergency department acute facility to another healthcare facility 4 or 04 3MTM CodefinderTM Separation Mode Codes and Descriptions Separation Mode Code 3M Codefinder Separation Mode Description 1 or 01 Discharge/Transfer to an Hospital 2 or 02 Discharge/Transfer to a Residential Ageing Service 3 or 03 Discharge/Transfer to a Psychiatric Hospital 4 or 04 Discharge/Transfer to Other Health Care Accommodation 5 or 05 Statistical Discharge – Type Change 6 or 06 Left Against Medical Advice 7 or 07 Statistical Discharge from 8 or 08 Died 9 or 09 Home/Other