Dimensional Warehouse Model Data Model

Entity

Entity NHS - Diagnostic Imaging Analysis

Description

A set of measures based on the NHS Diagnostic Imaging dataset.

Attributes
Calendar Dk
Count Of Cancer Related Diagnostic Imaging Activity
Count Of Imaging Activity
Diagnosis Related Group Dk
Encounter Dk
Geographic Area Dk
Group Dk
Imaging Procedure Dk
Median Number Of Days From Date Of Test Request To Date of Test
Median Number Of Days From Date Of Test Request To Date of Test For Cancer Diagnostic Imaging Exams
Median Number Of Days From Date Of Test To Date of Issued Test Report For Cancer Diagnostic Imaging Exams
Median Number Of Days From Date Of Test To Date of Test Report Issued
Patient Dk
Point Of Care Location Dk
Practitioner Dk
Provider Dk
Service Line Dk

Relationship
NHS - Diagnostic Imaging Analysis_Calendar Dimension_FK
NHS - Diagnostic Imaging Analysis_Patient Dimension_FK
NHS - Diagnostic Imaging Analysis_Encounter Dimension_FK
NHS - Diagnostic Imaging Analysis_Practitioner Dimension_FK
NHS - Diagnostic Imaging Analysis_Provider Dimension_FK
NHS - Diagnostic Imaging Analysis_Point Of Care Location Dimension_FK
NHS - Diagnostic Imaging Analysis_Geographic Area Dimension_FK
NHS - Diagnostic Imaging Analysis_Group Dimension_FK
NHS - Diagnostic Imaging Analysis_Service Line Dimension_FK
NHS - Diagnostic Imaging Analysis_Imaging Procedure Dimension_FK
NHS - Diagnostic Imaging Analysis_Diagnosis Related Group Dimension_FK

Primary Key
NHS - Diagnostic Imaging Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Calendar Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Count Of Cancer Related Diagnostic Imaging Activity

Description	The number of Diagnostic Imaging Exams requested as part of cancer diagnosing.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Count Of Imaging Activity

Description	The number of Diagnostic Imaging Exams.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Diagnosis Related Group Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Encounter Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Geographic Area Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Group Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Imaging Procedure Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Median Number Of Days From Date Of Test Request To Date of Test

Description	The median length of time expressed in days from when the diagnostic imaging exam is ordered to when the exam is completed.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Median Number Of Days From Date Of Test Request To Date of Test For Cancer Diagnostic Imaging Exams

Description	The median length of time expressed in days from when the cancer diagnostic imaging exam is requested to when the actual exam was carried out.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Median Number Of Days From Date Of Test To Date of Issued Test Report For Cancer Diagnostic Imaging Exams

Description	The median length of time expressed in days from when the cancer diagnostic imaging exam is completed to when the results are published on a report.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Median Number Of Days From Date Of Test To Date of Test Report Issued

Description	The median length of time expressed in days from when the diagnostic imaging exam is completed to when the results are published on a report.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Point Of Care Location Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Practitioner Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Provider Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Service Line Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Relationship Details

NHS - Diagnostic Imaging Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	NHS - Diagnostic Imaging Analysis
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

NHS - Diagnostic Imaging Analysis_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	NHS - Diagnostic Imaging Analysis
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Patient Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

NHS - Diagnostic Imaging Analysis_Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	NHS - Diagnostic Imaging Analysis
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Encounter Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

NHS - Diagnostic Imaging Analysis_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	NHS - Diagnostic Imaging Analysis
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Practitioner Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

NHS - Diagnostic Imaging Analysis_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	NHS - Diagnostic Imaging Analysis
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Provider Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

NHS - Diagnostic Imaging Analysis_Point Of Care Location Dimension_FK

Is Identifying Relationship	true
Child Table	NHS - Diagnostic Imaging Analysis
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Point Of Care Location Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

NHS - Diagnostic Imaging Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	NHS - Diagnostic Imaging Analysis
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Geographic Area Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

NHS - Diagnostic Imaging Analysis_Group Dimension_FK

Is Identifying Relationship	true
Child Table	NHS - Diagnostic Imaging Analysis
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Group Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

NHS - Diagnostic Imaging Analysis_Service Line Dimension_FK

Is Identifying Relationship	true
Child Table	NHS - Diagnostic Imaging Analysis
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Service Line Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

NHS - Diagnostic Imaging Analysis_Imaging Procedure Dimension_FK

Is Identifying Relationship	true
Child Table	NHS - Diagnostic Imaging Analysis
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Imaging Procedure Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

NHS - Diagnostic Imaging Analysis_Diagnosis Related Group Dimension_FK

Is Identifying Relationship	true
Child Table	NHS - Diagnostic Imaging Analysis
Child Multiplicity	ZERO_TO_ONE
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Diagnosis Related Group Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

NHS - Diagnostic Imaging Analysis PK

Key Attribute	Calendar Dk
Key Attribute	Patient Dk
Key Attribute	Encounter Dk
Key Attribute	Practitioner Dk
Key Attribute	Provider Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Geographic Area Dk
Key Attribute	Group Dk
Key Attribute	Service Line Dk
Key Attribute	Imaging Procedure Dk
Key Attribute	Diagnosis Related Group Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model