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