Event Facility Type view (dim_event_facility_type) dim_event_start_date (dim_event_start_date) Excluded purchase unit dimension (dim_exclu_purchase_unit) Facility transfer from dimension (dim_facility_transfer_from) Facility transfer to dimension (dim_facility_transfer_to) dim_first_consult_date (dim_first_consult_date) dim_last_updated_date (dim_last_updated_date) Mothers Age view A view of the shared Age Band dimension table. (dim_mothers_age) dim_pd_06_clinical_code (dim_pd_06_clinical_code) dim_pd_10_clinical_code (dim_pd_10_clinical_code) dim_pd_11_clinical_code (dim_pd_11_clinical_code) dim_pd_12_clinical_code (dim_pd_12_clinical_code) dim_procedure_acc_date (dim_procedure_acc_date) Psych leave end date view A view of the shared Global Time dimension table. (dim_psych_lv_end_date) dim_referral_date (dim_referral_date) dim_surg_decided_date (dim_surg_decided_date) Appendix D: Data Dictionary Template Introduction This appendix explains how data element attributes are organised in the data dictionary template. of elements Within the dictionary, elements are organised by and then alphabetically. An alphabetical index at the back of the data dictionary (Appendix I) and the graphical data model are intended to assist the user in finding specific elements. Template This table explains the template.
Event Facility Type view (dim_event_facility_type) dim_event_start_date (dim_event_start_date) Excluded purchase unit dimension (dim_exclu_purchase_unit) Facility transfer from dimension (dim_facility_transfer_from) Facility transfer to dimension (dim_facility_transfer_to) dim_first_consult_date (dim_first_consult_date) dim_last_updated_date (dim_last_updated_date) Mothers Age view (dim_mothers_age) A view of the shared Age Band dimension table. dim_pd_06_clinical_code (dim_pd_06_clinical_code) dim_pd_10_clinical_code (dim_pd_10_clinical_code) dim_pd_11_clinical_code (dim_pd_11_clinical_code) dim_pd_12_clinical_code (dim_pd_12_clinical_code) dim_procedure_acc_date (dim_procedure_acc_date) Psych leave end date view (dim_psych_lv_end_date) A view of the shared Global Time dimension table. dim_referral_date (dim_referral_date) dim_surg_decided_date (dim_surg_decided_date) Appendix D: Data Dictionary Template Introduction This appendix explains how data element attributes are organised in the data dictionary template. of elements Within the dictionary, elements are organised by and then alphabetically. An alphabetical index at the back of the data dictionary (Appendix I) and the graphical data model are intended to assist the user in finding specific elements. Template This table explains the template.
nmd_data_dictionary_v7.9.docx