NAP triage level dimension key Definition Generated artificial key for the dim_nap_triage_level table Column name dim_nap_triage_level_key Table name fact_nap_event Data type integer Other names Context Layout Data domain for use Verification Collection methods Related data Source document Source organisation NHI number Definition A unique 7-character identification number assigned to a healthcare user by the National Health Index (NHI) database. Column name nhi_number Table name fact_nap_event Data type varchar2(64) Other names Health care user id, HCU id Context NHI numbers uniquely identify healthcare users, and allow linking between different data collections. Layout AAANNNN Data domain for use The first three characters of an NHI number must be alpha (but not 'I' or 'O'). The 4th to 6th characters must be numeric. The 7th character is a check digit modulus 11. This may not be the master NHI. The master NHI should be used where it is known. Verification rules There is a verification algorithm which ensures that the NHI number is in the correct format and is valid. Collection methods Related data Source document Source organisation
for use A social group whose members have one or more of the following four characteristics: - they share a sense of common origins - they claim a common and distinctive history and destiny - they possess one or more dimensions of collective cultural individuality - they feel a sense of unique collective solidarity. Verification rules Collection methods Related data Source document Source organisation Event end date submitted Definition Whether the Event End Date Time was provided in an extract or set to the default during the load process. Column name end_date_submitted_flag name fact_nap_event_snapshot Data type char(1) Other names Context Layout Data domain 'Y' - the End Date Time was submitted 'N' - the End date was set to the Date of Service and time of 23:59 Guide for use The default for Event End date was set to the Date of Service and time of 23:59 Verification Collection methods Derived during the Load process. Related data Datetime of end Source document Source organisation Event end type code Definition A code identifying how a healthcare event ended Column name event_end_type_code name fact_nap_event_snapshot Data type varchar2(64) Other names Context
Verification Mandatory for emergency department events with equivalent purchase unit code like ED%A and attendance code like A for all events with a datetime of service > 1 July 2010 Collection methods Related data Source document Source organisation PMS unique identifier Definition A unique ID for the event generated by the source system. Column name pms_unique_identifier name fact_nap_event_snapshot Data type varchar2(64) names Context Layout X(14) Data domain Guide for use Used to source the record Verification rules Collection methods Leading and trailing blanks trimmed during the load Related data Source document Source organisation Purchase unit dimension key Definition Generated artificial key for the dim_purchase_unit table. Column name dim_purchase_unit_key Table name fact_nap_event_snapshot Data type integer Other names Context Layout Data domain Guide for use Verification rules
52 Creole (Latin America) 53 Creole (US) 12 Croat/Croatian 12 Cypriot nfd 12 Czech 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 Greek (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 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 Latin American/Hispanic nfd 12 Latvian 51 Lebanese 51 Libyan 12 Lithuanian 12 Macedonian 37 Malaitian 41 42 Malaysian Chinese 12 Maltese 52 Malvinian Falkland Islander) 32 Mangaia Islander 32 Manihiki Islander 37 Manus Islander 12 Manx 37 Marianas Islander 37 Marquesas Islander 37 Marshall Islander 32 Mauke Islander 61 Mauritian 52 Mexican 51 Middle Eastern nec 51 Middle Eastern nfd 32 Mitiaro Islander 51 Moroccan 37 Nauru Islander 44 Nepalese 37 New Britain Islander 12 New Caledonian 37 New Georgian 37 New Irelander 11 New Zealander 11 New Zealand European 21 New Zealand 52 Nicaraguan 53 Nigerian 34 Niuean 61 North American Indian
12 Norwegian 99 Not Specified 37 Ocean Islander/Banaban 51 Omani 12 Orkney Islander 53 Other African nec 44 Other Asian nec 12 Other European 61 Other nec 61 Other 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 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 African coloured 12 South African nec 61 South American Indian 12 South Slav (formerly Yugoslav groups) nfd 12 South Slav (formerly Yugoslav) nec 41 Southeast 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