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. nhi_number Column name 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
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
nnpac_data_dictionary_v2.7_2.docx