Overview Top Package Entity

Dimensional Warehouse Model Data Model

---

Entity Diabetes Care Analysis Snapshot

Description

A snapshot fact table which includes measures, time stamps and indicators required for diabetes care.

Attributes

BMI Value Finding Ts

BMI Value Qty

BP Observation Ts

BP Value UOM Cd

Calendar Dk

Condition Dk

Diabetes Onset Dt

Diabetes Type Cd

Diastolic BP Value Qty

Foot Exam Ind

Foot Exam Ts

Geographic Area Dk

HbA1c Value Finding Ts

HbA1c Value Qty

HbA1c Value UOM Cd

HDLC Value Finding Ts

HDLC Value Qty

HDLC Value UOM Cd

LDLC Value Finding Ts

LDLC Value Qty

LDLC Value UOM Cd

Lipid Finding Ts

Load Info Sk

Nephropathy Assessment Ind

Nephropathy Assessment Ts

Patient Dk

Practitioner Dk

Provider Dk

Retinopathy Assessment Ind

Retinopathy Assessment Ts

Systolic BP Value Qty

Tenant Sk

Tobacco Cessation Counselling Ind

Tobacco Cessation Counselling Ts

Tobacco Use Finding Ts

Tobacco Use Ind

Relationship

Diabetes Care Analysis Snapshot_Patient Dimension_FK

Diabetes Care Analysis Snapshot_Practitioner Dimension_FK

Diabetes Care Analysis Snapshot_Provider Dimension_FK

Diabetes Care Analysis Snapshot_Calendar Dimension_FK

Diabetes Care Analysis Snapshot_Geographic Area Dimension_FK

Diabetes Care Analysis Snapshot_Condition Dimension_FK

Primary Key

Diabetes Care Analysis Snapshot PK

Dependencies

NONE

Reverse Dependencies

Attribute Details

 BMI Value Finding Ts

Description	Body Mass Index calculation and recorded Timestamp
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 BMI Value Qty

Description	Body Mass Index assessed and recorded quantity
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 BP Observation Ts

Description	Blood Pressure value Observation Timestamp
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 BP Value UOM Cd

Description	Blood Pressure Unit of Measure.
Data Type	Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 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

---

 Condition 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

---

 Diabetes Onset Dt

Description	Date of Diabetes disease onset
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Diabetes Type Cd

Description	Code to identify the type of diabetes and complications.
Data Type	Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Diastolic BP Value Qty

Description	Diastolic Blood Pressure (BP) value for a given period of analysis
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Foot Exam Ind

Description	Indicator to Identify if a Diabetic Patient had their feet examined for diabetic foot ulcer for a given period of analysis
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Foot Exam Ts

Description	Foot Examination occurrence Timestamp
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
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

---

 HbA1c Value Finding Ts

Description	Hemoglobin A1c (HbA1c) test results timestamp
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 HbA1c Value Qty

Description	Hemoglobin A1c (HbA1c) test results value quantity.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 HbA1c Value UOM Cd

Description	HbA1c Unit of Measure Code.
Data Type	Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 HDLC Value Finding Ts

Description	High-density lipoprotein Cholesterol test results timestamp
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 HDLC Value Qty

Description	Quantity value of High-density lipoprotein also known as Good Cholesterol.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 HDLC Value UOM Cd

Description	HDLC Unit of Measure Code.
Data Type	Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 LDLC Value Finding Ts

Description	Low-density lipoprotein (LDL) test results timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 LDLC Value Qty

Description	Low-density lipoprotein (LDL) test results value quantity.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 LDLC Value UOM Cd

Description	The unit of measure in which the low-density lipoprotein cholesterol (LDL-C) value quantity is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Lipid Finding Ts

Description	Lipid test results timestamp.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Nephropathy Assessment Ind

Description	Indicator to identify if a patient has been tested for disease or abnormality of the kidney, during the period of analysis, e.g. Urine Microalbumin Test.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Nephropathy Assessment Ts

Description	Kidney Examination Timestamp
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
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

---

 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

---

 Retinopathy Assessment Ind

Description	Indicator to identify if a diabetic patient has received a retinal or dilated eye examination by an eye care professional during the period of analysis.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Retinopathy Assessment Ts

Description	Eye Examination Result Timestamp
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Systolic BP Value Qty

Description	Systolic Blood Pressure (BP) value for a given period of analysis
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Tobacco Cessation Counselling Ind

Description	An indication of whether patient identified as tobacco users has received cessation intervention through discussion or recommendation of cessation methods and strategies by a qualified healthcare practitioner, during the period of analysis.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Tobacco Cessation Counselling Ts

Description	The date and time a patient was counselled on Tobacco Cessation.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Tobacco Use Finding Ts

Description	Time stamp for the Tobacco use indication for the patient.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Tobacco Use Ind

Description	An indication to identify if the Patient is a Tobacco User.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

 Diabetes Care Analysis Snapshot_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	Diabetes Care Analysis Snapshot
Child Multiplicity	ZERO_TO_MANY
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

---

 Diabetes Care Analysis Snapshot_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Diabetes Care Analysis Snapshot
Child Multiplicity	ZERO_TO_MANY
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

---

 Diabetes Care Analysis Snapshot_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Diabetes Care Analysis Snapshot
Child Multiplicity	ZERO_TO_MANY
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

---

 Diabetes Care Analysis Snapshot_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Diabetes Care Analysis Snapshot
Child Multiplicity	ZERO_TO_MANY
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

---

 Diabetes Care Analysis Snapshot_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Diabetes Care Analysis Snapshot
Child Multiplicity	ZERO_TO_MANY
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

---

 Diabetes Care Analysis Snapshot_Condition Dimension_FK

Is Identifying Relationship	true
Child Table	Diabetes Care Analysis Snapshot
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Condition 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

 Diabetes Care Analysis Snapshot PK

Key Attribute	Geographic Area Dk
Key Attribute	Patient Dk
Key Attribute	Practitioner Dk
Key Attribute	Provider Dk
Key Attribute	Calendar Dk
Key Attribute	Condition Dk

---

Overview Top Package Entity

Dimensional Warehouse Model Data Model