Dimensional Warehouse Model Data Model

Entity

Entity Personal Health Information Vital Sign Snapshot

Description

Vital Signs information related to an individual, captured through health risk assessment, medical record analysis, claim data analysis or otherwise.

Attributes
Abdominal Fat Ind
Abdominal Measurement
Abdominal Unit Of Measure
Arterial Blood Gas Results Qty
Assessed BMI Rating
Blood Group Test Ind
Blood Pressure Diastolic
Blood Pressure Systolic
Blood Pressure Unit of Measure
Blood Type
Body Frame Type
Body Mass Index
Body Mass Index Percentile
Calendar Dk
Encounter Dk
Geographic Area Dk
Glucose Level
Glucose Level Unit of Measure
Glycosylated Hemoglobin A1c Level
Glycosylated Hemoglobin A1c Trend Ind
HDL Cholesterol Level
Height
Height Unit of Measure
Homocysteine Level
Last Menstrual Period End Date
LDL Cholesterol Level
Lipoprotein Level
Load Info Sk
Oxygen Saturation Qty
Patient Dk
Peak Flow Meter Use Ind
Practitioner Dk
Provider Dk
Tenant Sk
Total Cholesterol Level
Triglycerides Level
Triglycerides Unit of Measure
Weight
Weight Measurement Unit

Relationship
Personal Health Information - Vital Sign Snapshot_Patient Dimension_FK
Personal Health Information - Vital Sign Snapshot_Practitioner Dimension_FK
Personal Health Information - Vital Sign Snapshot_Provider Dimension_FK
Personal Health Information - Vital Sign Snapshot_Calendar Dimension_FK
Personal Health Information - Vital Sign Snapshot_Encounter Dimension_FK
Personal Health Information - Vital Sign Snapshot_Geographic Area Dimension_FK

Primary Key
Personal Health Information Vital Sign Snapshot PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Abdominal Fat Ind

Description	Indicates whether (1) or not (0) the Abdominal Measurement value indicates that abdominal fat is present. For example: Waist circumference for man greater than 102 cm (40 in) or for women greater than 88 cm (35 in).
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

Abdominal Measurement

Description	Waist circumference of the person.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Abdominal Unit Of Measure

Description	Abdominal Unit Of Measure specifies the Unit of Measure in which the abdominal measurement is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Arterial Blood Gas Results Qty

Description	The quantity of arterial blood gas resulting from blood gas analyses.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Assessed BMI Rating

Description	A classification of the measurement of an individuals BMI under one of a number of widely used and easily understood categories.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Blood Group Test Ind

Description	Indicator that the patient's blood group (ABO) and D (Rh) type has been determined.
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

Blood Pressure Diastolic

Description	The diastolic blood pressure (lower numeric measurement) of a person.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Blood Pressure Systolic

Description	The systolic blood pressure (upper numerical measurement) of a person.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Blood Pressure Unit of Measure

Description	Blood Pressure Unit of Measure specifies the Unit of Measure in which blood pressure is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Blood Type

Description	The classification of the person's blood with regard to ABO and Rhesus systems in the human blood type profile.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Body Frame Type

Description	A categorization of the person's body frame.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Body Mass Index

Description	This is the calculated Body Mass Index (BMI) of an individual based on a formula of Weight (kgs) /( Height (meters) Squared).
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Body Mass Index Percentile

Description	This is the measured Body Mass Index of an individual child or adolescent expressed as a percentile of a relevant sample of population. The BMI measurements of children and adolescents are not as reliable an indicator of health and obesity as they are growing and changing rapidly. Therefore the BMI reading is plotted against established ranges based on age and gender to estimate the child's BMI percentile.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
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

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

Glucose Level

Description	The person's glucose level reading.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Glucose Level Unit of Measure

Description	Glucose Level Unit of Measure specifies the Unit of Measure in which glucose level is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Glycosylated Hemoglobin A1c Level

Description	The measured level of Glycosylated Hemoglobin (A1c) for the person.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Glycosylated Hemoglobin A1c Trend Ind

Description	Indicates whether successive Glycosylated Hemoglobin A1c Level values are showing a downwards, even or upwards trend. For example: D = Down S = Stable U = Up
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

HDL Cholesterol Level

Description	The measured level of HDL Cholesterol for the person.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Height

Description	The vertical measurement of a person. For example: 180 cm.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Height Unit of Measure

Description	Glucose Level Unit of Measure specifies the Unit of Measure in which Height is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Homocysteine Level

Description	The measured Homocysteine level for the person.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Last Menstrual Period End Date

Description	Date of end of last menstrual period.
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

LDL Cholesterol Level

Description	The measured level of LDL Cholesterol for the person.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Lipoprotein Level

Description	The measured level of Lipoprotein for the person.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
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

Oxygen Saturation Qty

Description	Indicates the oximetry test results.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
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

Peak Flow Meter Use Ind

Description	Indicator that the person owns and uses a peak flow meter.
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

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

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

Total Cholesterol Level

Description	The combined Cholesterol level for the person.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Triglycerides Level

Description	The measured level of Triglycerides for the person.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Triglycerides Unit of Measure

Description	Triglycerides Unit of Measure specifies the Unit of Measure in which triglyceride level is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Weight

Description	The measurement of the heaviness (in kilos or pounds) of a person. For example: 135 lbs. 80 kg.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Weight Measurement Unit

Description	Weight Unit of Measure specifies the Unit of Measure in which weight is expressed. For example: KG Stone
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Personal Health Information - Vital Sign Snapshot_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	Personal Health Information Vital Sign 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

Personal Health Information - Vital Sign Snapshot_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Personal Health Information Vital Sign 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

Personal Health Information - Vital Sign Snapshot_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Personal Health Information Vital Sign 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

Personal Health Information - Vital Sign Snapshot_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Personal Health Information Vital Sign 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

Personal Health Information - Vital Sign Snapshot_Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	Personal Health Information Vital Sign 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	Encounter Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Personal Health Information - Vital Sign Snapshot_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Personal Health Information Vital Sign 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

Primary Key Details

Personal Health Information Vital Sign Snapshot PK

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

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model