dim_submitted_coding_system (dim_submitted_coding_system) Appendix C: List of Views The table views used in this datamart are shown below. View Name Description Admission Age view A view of the shared Age Band dimension table. (dim_admission_age) Date view A view of the shared Global Time dimension table. (dim_birth_date) Birth Location view A view of the Location table. (dim_birth_location) Discharge Age view A view of the shared Age Band dimension (dim_discharge_age) DRG v31 view (dim_drg_v31) Agency view A view of the shared Agency Facility dimension table. (dim_event_agency) dim_event_end_date (dim_event_end_date) dim_event_facility (dim_event_facility) 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_submitted_coding_system (dim_submitted_coding_system) Appendix C: List of Views The table views used in this datamart are shown below. View Name Description Admission Age view (dim_admission_age) A view of the shared Age Band dimension table. Date view (dim_birth_date) A view of the shared Global Time dimension table. Birth Location view (dim_birth_location) A view of the Location table. Discharge Age view (dim_discharge_age) A view of the shared Age Band dimension DRG v31 view (dim_drg_v31) Agency view (dim_event_agency) A view of the shared Agency Facility dimension table. dim_event_end_date (dim_event_end_date) dim_event_facility (dim_event_facility) 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)