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
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
nnpac_data_dictionary_v2.7_1.docx