Event end type code Definition A code identifying how a healthcare event ended Column name event_end_type_code Table name fact_nap_event Data type varchar2(64) Other names Context Layout AA Data domain See the Event End Type code table in Appendix E. for use DW may be used on events that are transferred from ED to an inpatient event. Verification rules Mandatory for ED events with Datetime of service on or after 1 July 2010. Must be a valid code in the Event End Type code table. If not supplied, this field is set to 'UN' Collection methods Related data Datetime of departure Source document Source organisation Event type Definition Code identifying the type of health event. Column name event_type Table name fact_nap_event Data type varchar2(64) Other names Context Layout AA Data domain CR (community referred diagnostic) ED (emergency department) OP (outpatient) Guide for use From 1 Jul 2008 to 31 June 2010, the Event Type was determined from the submitted Purchase Unit Code. From 1st July 2010 the direct reporting of Event type is mandatory as opposed to being derived from the Equivalent Purchase Unit. 'CR' was introduced on 1st July 2010. Verification rules
Detailed code table The 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 Māori nfd 12 Cornish 12 Corsican 52 Costa Rican
12 Norwegian 99 Not Specified 37 Ocean Islander/Banaban 51 12 Orkney Islander 53 Other African nec 44 Other Asian nec 12 Other European 61 nec 61 nfd 41 Other Southeast Asian nec 37 Pacific Peoples nec 30 Pacific Peoples nfd 44 Pakistani 51 Palestinian 32 Palmerston Islander 52 Panamanian 37 Papuan/New Guinean/Irian Jayan 52 Paraguayan 32 Penrhyn Islander 52 Peruvian 37 Phoenix Islander 37 Pitcairn Islander 12 Polish 12 Portuguese 52 Puerto Rican 32 Pukapuka Islander 43 Punjabi 32 Rakahanga Islander 32 Rarotongan 12 Romanian/Rumanian 12 Romany/Gypsy 37 Rotuman/Rotuman Islander 12 Russian 31 Samoan 37 Santa Cruz Islander 12 Sardinian 12 Scottish (Scots) 12 Serb/Serbian 61 Seychelles Islander 12 Shetland Islander 43 Sikh 42 Singaporean Chinese 44 Sinhalese 12 Slavic/Slav 12 Slovak 12 Slovene/Slovenian 37 Society Islander (including Tahitian) 37 Solomon Islander 53 Somali 61 South African coloured 12 South African nec 61 South American Indian 12 Slav (formerly Yugoslav groups) nfd 12 South Slav (formerly Yugoslav) nec 41 Southeast Asian nfd 12 Spanish 44 Sri Lankan nec 44 Sri Lankan nfd 44 Sri Lankan Tamil 12 Swedish 12 Swiss 51 Syrian 42 Taiwanese Chinese 37 Tahitian (including Society Islander) 43 Tamil 41 Thai/Tai/Siamese 44 Tibetan 35 Tokelauan 33 Tongan 37 Torres Strait Islander/Thursday Islander 37 Tuamotu Islander 51 Tunisian 51 Turkish (incl Turkish Cypriot) 37 Tuvalu Islander/Ellice Islander 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 while 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 Leave 8 or 08 Died 9 or 09 Home/Other