Dimensional Warehouse Model Data Model

Entity

Entity Prevention And Screening Snapshot

Description

A snapshot fact table which includes measures, time stamps and indicators relating to disease testing, vacination and immunization.

Attributes
Admission Ts
Advance Care Planning Ind
Advance Care Planning Ts
BMI Assessment Ind
BMI Assessment Ts
Breast Cancer Screening Ind
Breast Cancer Screening Ts
Calendar Dk
Cervical Cancer Screening Ind
Cervical Cancer Screening Ts
Chicken Pox Vaccination Ind
Chicken Pox Vaccination Ts
Chlamydia Screening Ind
Chlamydia Screening Ts
Colorectal Cancer Screening Ind
Colorectal Screening Ts
Condition Dk
Discharge Ts
DTaP Vaccination Ind
DTaP Vaccination Ts
Functional Status Assessment Ind
Functional Status Assessment Ts
Geographic Area Dk
Glaucoma Screening Ind
Glaucoma Screening Ts
HepA Vaccination Ind
HepA Vaccination Ts
HepB Vaccination Ind
HepB Vaccination Ts
HiB Vaccination Ind
HiB Vaccination Ts
Human Papillomavirus Vaccination Ind
Human Papillomavirus Vaccination Ts
Influenza Vaccination Ind
Influenza Vaccination Ts
Inpatient Ind
Lead Poisoning Screening Ind
Lead Poisoning Screening Ts
Load Info Sk
Medication Review Ind
Medication Review Ts
Meningococcal Vaccination Ind
Meningococcal Vaccination Ts
MMR Vaccination Ind
MMR Vaccination Ts
Nutrition Counselling Ind
Nutrition Counselling Ts
Outpatient Ind
Pain Screening Ind
Pain Screening Ts
Patient Dk
Physical Activity Counselling Ind
Physical Activity Counselling Ts
Pneumococcal Conjugate Vaccination Ind
Pneumococcal Conjugate Vaccination Ts
Polio Vaccination Ind
Polio Vaccination Ts
Practitioner Dk
Primary Care Practitioner Visit Ind
Primary Care Practitioner Visit Ts
Provider Dk
PSA Screening Ind
PSA Screening Ts
Rotavirus Vaccination Ind
Rotavirus Vaccination Ts
Tenant Sk

Relationship
Prevention And Screening Snapshot_Geographic Area Dimension_FK
Prevention And Screening Snapshot_Calendar Dimension_FK
Prevention And Screening Snapshot_Condition Dimension_FK
Prevention And Screening Snapshot_Practitioner Dimension_FK
Prevention And Screening Snapshot_Patient Dimension_FK
Prevention And Screening Snapshot_Provider Dimension_FK

Primary Key
Prevention And Screening Snapshot PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Admission Ts

Description	The date and time a patient was admitted to a healthcare facility, usually as an inpatient. It may also be used to reflect the date and time of an out-patient or emergency patient registration.
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

Advance Care Planning Ind

Description	Indicator to show whether the patient has discussed advance care planning.
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

Advance Care Planning Ts

Description	The date and time of the latest advance care planning visit.
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 Assessment Ind

Description	Indicator to show that the patient had their Body Mass Index assessed and recorded.
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

BMI Assessment Ts

Description	Date and time when the patient had their Body Mass Index assessed and recorded.
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

Breast Cancer Screening Ind

Description	Indicator to show whether the patient has been screened for breast cancer.
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

Breast Cancer Screening Ts

Description	The date and time when the patient was most recently screened for breast cancer.
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

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

Cervical Cancer Screening Ind

Description	Indicator to show whether the patient had cervical cancer screening.
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

Cervical Cancer Screening Ts

Description	The date and time when the patient was most recently screened for cervical cancer.
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

Chicken Pox Vaccination Ind

Description	Indicator to show that the patient had recieved the chicken pox (VZV) vaccine.
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

Chicken Pox Vaccination Ts

Description	Date and time when the patient had recieved the chicken pox (VZV) vaccine.
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

Chlamydia Screening Ind

Description	Indicator to show whether the patient had been screened for chlamydia.
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

Chlamydia Screening Ts

Description	The date and time when the patient was most recently screened for chlamydia.
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

Colorectal Cancer Screening Ind

Description	Indicator to show whether the patient had appropriate screening for colorectal cancer.
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

Colorectal Screening Ts

Description	The date and time when the patient was most recently screened for colorectal cancer.
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

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

Discharge Ts

Description	The date and time a patient was released or discharged from a healthcare facility following an admission.
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

DTaP Vaccination Ind

Description	Indicator to show that the patient had recieved diphtheria toxoids and acellular pertussis vaccine (DTaP).
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

DTaP Vaccination Ts

Description	Date and time when the patient had recieved diphtheria toxoids and acellular pertussis vaccine (DTaP).
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

Functional Status Assessment Ind

Description	Indicator to show whether the patient had their functional status assessed.
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

Functional Status Assessment Ts

Description	Date and time when the patient had their functional status assessed.
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

Glaucoma Screening Ind

Description	Indicator to show whether the patient had appropriate screening for glaucoma.
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

Glaucoma Screening Ts

Description	The date and time when the patient was screened for glaucoma.
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

HepA Vaccination Ind

Description	Indicator to show whether the patient had recieved the hepatitis A (HepA) vaccine.
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

HepA Vaccination Ts

Description	Date and time when the patient had recieved the hepatitis A (HepA) vaccine.
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

HepB Vaccination Ind

Description	Indicator to show whether the patient had recieved the hepatitis B (HepB) vaccine.
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

HepB Vaccination Ts

Description	Date and time when the patient had recieved the hepatitis B (HepB) vaccine.
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

HiB Vaccination Ind

Description	Indicator to show whether the patient had recievedthe H influenza type B (HiB) vaccine.
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

HiB Vaccination Ts

Description	Date and time when the patient had recieved the H influenza type B (HiB) vaccine.
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

Human Papillomavirus Vaccination Ind

Description	Indicator to show whether the patient had recieved the human papillomavirus vaccine.
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

Human Papillomavirus Vaccination Ts

Description	Date and time when the patient had recieved the human papillomavirus vaccine.
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

Influenza Vaccination Ind

Description	Indicator to show whether the patient had recieved the influenza vaccine.
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

Influenza Vaccination Ts

Description	Date and time when the patient had most recently recieved the influenza vaccine.
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

Inpatient Ind

Description	An Indicator to Identify an Inpatient. Inpatient is a type of encounter in which the patient visits the healthcare facility and stays overnight and is assigned a bed. An encounter groups a number of healthcare events, typically commencing with an admission or transfer into the healthcare facility and ends with a discharge or transfer out.
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

Lead Poisoning Screening Ind

Description	Indicator to show whether the patient had been screened for lead poisoning.
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

Lead Poisoning Screening Ts

Description	The date and time when the patient was most recently screened for lead poisoning.
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

Medication Review Ind

Description	Indicator to show whether the patient had a visit for medication review.
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

Medication Review Ts

Description	The date and time of the latest visit for a medication review.
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

Meningococcal Vaccination Ind

Description	Indicator to show that the patient had recieved the meningococcal vaccine.
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

Meningococcal Vaccination Ts

Description	Date and time when the patient had recieved the meningococcal vaccine.
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

MMR Vaccination Ind

Description	Indicator to show whether the patient had recieved the measles, mumps and rubella (MMR) vaccine.
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

MMR Vaccination Ts

Description	Date and time when the patient had recieved the measles, mumps and rubella (MMR) vaccine.
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

Nutrition Counselling Ind

Description	Indicator to show whether the patient had a visit for nutrition counselling.
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

Nutrition Counselling Ts

Description	The date and time of the latest visit for nutrition counselling.
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

Outpatient Ind

Description	An indicator to identify and Outpatient. Outpatient is a type of encounter that takes place when the patient visits the healthcare facility but does not stay overnight and it is not assigned a bed.
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

Pain Screening Ind

Description	Indicator to show whether the patient had appropriate pain screening.
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

Pain Screening Ts

Description	The date and time when the patient most recently had appropriate pain screening.
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

Physical Activity Counselling Ind

Description	Indicator to show whether the patient had a visit for physical activity counselling.
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

Physical Activity Counselling Ts

Description	The date and time of the latest visit for physical activity counselling.
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

Pneumococcal Conjugate Vaccination Ind

Description	Indicator to show whether the patient had recieved the pneumococcal conjugate (PCV) vaccine.
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

Pneumococcal Conjugate Vaccination Ts

Description	Date and time when the patient had recieved the pneumococcal conjugate (PCV) vaccine.
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

Polio Vaccination Ind

Description	Indicator to show whether the patient had recieved the polio vaccine.
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

Polio Vaccination Ts

Description	Date and time when the patient had recieved the polio vaccine.
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

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

Primary Care Practitioner Visit Ind

Description	Indicator to show whether the patient had a visit with a Primary Care Provider (PCP).
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

Primary Care Practitioner Visit Ts

Description	The date and time of the latest visit with a Primary Care Provider (PCP).
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

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

PSA Screening Ind

Description	Indicator to show whether the patient had been screened for prostate cancer using prostate-specific antigen (PSA)-based screening.
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

PSA Screening Ts

Description	The date and time when the patient was most recently screened for prostate cancer using prostate-specific antigen (PSA)-based screening.
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

Rotavirus Vaccination Ind

Description	Indicator to show whether the patient had recieved the rotavirus (RV) vaccine.
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

Rotavirus Vaccination Ts

Description	Date and time when the patient had recieved the rotavirus (RV) vaccine.
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

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

Relationship Details

Prevention And Screening Snapshot_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Prevention And Screening 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

Prevention And Screening Snapshot_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Prevention And Screening 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

Prevention And Screening Snapshot_Condition Dimension_FK

Is Identifying Relationship	true
Child Table	Prevention And Screening 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

Prevention And Screening Snapshot_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Prevention And Screening 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

Prevention And Screening Snapshot_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	Prevention And Screening 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

Prevention And Screening Snapshot_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Prevention And Screening 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

Primary Key Details

Prevention And Screening 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