Dimensional Warehouse Model Data Model

Entity

Entity Musculoskeletal Analysis Snapshot

Description

A snapshot fact table which consists of measures, indicators and timestamps related to musculoskeletal conditions.

Attributes
Admission Ts
Bone Mineral Density Test Ind
Bone Mineral Density Test Ts
Calendar Dk
Condition Dk
Discharge Ts
DMARD Dispense Qty
DMARD Dispense Ts
Fracture Diagnosis Ts
Fracture Ind
Geographic Area Dk
Imaging Study Ind
Imaging Study Ts
Inpatient Ind
Load Info Sk
Low Back Pain Diagnosis Ts
Low Back Pain Ind
Osteoporosis Medication Prescription Ind
Osteoporosis Medication Prescription Ts
Outpatient Ind
Patient Dk
Practitioner Dk
Provider Dk
Rheumatoid Arthritis Diagnosis Ts
Rheumatoid Arthritis Ind
Tenant Sk

Relationship
Musculoskeletal Analysis Snapshot_Practitioner Dimension_FK
Musculoskeletal Analysis Snapshot_Provider Dimension_FK
Musculoskeletal Analysis Snapshot_Geographic Area Dimension_FK
Musculoskeletal Analysis Snapshot_Condition Dimension_FK
Musculoskeletal Analysis Snapshot_Calendar Dimension_FK
Musculoskeletal Analysis Snapshot_Patient Dimension_FK

Primary Key
Musculoskeletal Analysis 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

Bone Mineral Density Test Ind

Description	Indicator to identify if a patient had bone mineral density (BMD) 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

Bone Mineral Density Test Ts

Description	Date and time when the bone mineral density (BMD) test was performed.
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

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

DMARD Dispense Qty

Description	The quantity of any disease-modifying anti-rheumatic drug (DMARD) dispensed to the patient with rheumatoid arthritis.
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

DMARD Dispense Ts

Description	Date and time when a disease-modifying anti-rheumatic drug (DMARD) was most recently dispensed to a patient with rheumatoid arthritis.
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

Fracture Diagnosis Ts

Description	Date and time when the patient was diagnosed with fracture.
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

Fracture Ind

Description	Indicator to identify if a patient has been diagnosed with fracture.
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

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

Imaging Study Ind

Description	Indicator to identify if a patient had an imaging study (plain X-ray, MRI, CT scan).
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

Imaging Study Ts

Description	Date and time when the imaging study (plain X-ray, MRI, CT scan) was performed.
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

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

Low Back Pain Diagnosis Ts

Description	Date and time when the patient was diagnosed with low back pain.
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

Low Back Pain Ind

Description	Indicator to identify if a patient has been diagnosed with low back pain.
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

Osteoporosis Medication Prescription Ind

Description	The indicator to show if the patient has been prescribed a drug to treat or prevent osteoporosis.
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

Osteoporosis Medication Prescription Ts

Description	Dispense date and time the patient was most recently prescribed a drug to treat or prevent osteoporosis.
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

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

Rheumatoid Arthritis Diagnosis Ts

Description	Date and time when the patient was diagnosed with rheumatoid arthritis.
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

Rheumatoid Arthritis Ind

Description	Indicator to identify if a patient has been diagnosed with rheumatoid arthritis.
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

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

Musculoskeletal Analysis Snapshot_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Musculoskeletal 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

Musculoskeletal Analysis Snapshot_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Musculoskeletal 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

Musculoskeletal Analysis Snapshot_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Musculoskeletal 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

Musculoskeletal Analysis Snapshot_Condition Dimension_FK

Is Identifying Relationship	true
Child Table	Musculoskeletal 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

Musculoskeletal Analysis Snapshot_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Musculoskeletal 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

Musculoskeletal Analysis Snapshot_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	Musculoskeletal 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

Primary Key Details

Musculoskeletal 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