Dimensional Warehouse Model Data Model

Entity

Entity Prenatal Care Quality Analysis

Description

The analysis of the quality of prenatal care given expectant mothers by Health Plan Organization providers, during a specific period of analysis.

Attributes
Calendar Dk
Condition Dk
Coverage Agreement Dimension Dk
Geographic Area Dk
Group Dk
Health Plan Product Dk
Number Of Prenatal Patients In Roster
Number Of Prenatal Patients Screened For Antibodies
Number Of Prenatal Patients Tested For Blood Group
Number Of Prenatal Patients Tested For Gestational Diabetes
Number Of Prenatal Patients With Prenatal Flowsheet
Number Of Prenatal Women Over 35 Offered Amniocentesis Or Chronic Villus Sampling
Percentage Of Prenatal Patients Screened For Antibodies
Percentage Of Prenatal Patients Tested For Blood Group
Percentage Of Prenatal Patients Tested For Gestational Diabetes
Percentage Of Prenatal Patients With Prenatal Flowsheet
Percentage Of Prenatal Women Over 35 Offered Amniocentesis Or Chronic Villus Sampling
Plan Member Dk
Practitioner Dk
Provider Dk

Relationship
Prenatal Care Quality Analysis_Calendar Dimension_FK
Prenatal Care Quality Analysis_Geographic Area Dimension_FK
Prenatal Care Quality Analysis_Plan Member Dimension_FK
Prenatal Care Quality Analysis_Condition Dimension_FK
Prenatal Care Quality Analysis_Group Dimension_FK
Prenatal Care Quality Analysis_Provider Dimension_FK
Prenatal Care Quality Analysis_Practitioner Dimension_FK
Prenatal Care Quality Analysis_Health Plan Product Dimension_FK
Prenatal Care Quality Analysis_Coverage Agreement Dimension_FK

Primary Key
Prenatal Care Quality 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

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

Coverage Agreement Dimension 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

Health Plan Product 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

Number Of Prenatal Patients In Roster

Description	The number of prenatal members under the care of an obstetrician or in the patient panel of a primary care physician.
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

Number Of Prenatal Patients Screened For Antibodies

Description	The number of patients receiving an antibody screening during the first or second prenatal care visit.
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

Number Of Prenatal Patients Tested For Blood Group

Description	The number of patients who have a blood group (ABO) and D (Rh) type determined by the second prenatal care visit.
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

Number Of Prenatal Patients Tested For Gestational Diabetes

Description	The number of patients screened for gestational diabetes.
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

Number Of Prenatal Patients With Prenatal Flowsheet

Description	The number of patients with a prenatal flowsheet in use by the date of the first physician visit. The flow sheet contains at a minimum: blood pressure, weight, urine protein, uterine size, fetal heart tones, and estimated date of delivery.
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

Number Of Prenatal Women Over 35 Offered Amniocentesis Or Chronic Villus Sampling

Description	The number of patients aged 35 years and older at the time of expected delivery who are offered amniocentesis or chronic villus sampling.
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

Percentage Of Prenatal Patients Screened For Antibodies

Description	This measure is used to assess the percentage of patients receiving an antibody screening during the first or second prenatal care visit. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of Prenatal Patients Tested For Blood Group

Description	This measure is used to assess the percentage of patients who have a blood group (ABO) and D (Rh) type determined by the second prenatal care visit. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of Prenatal Patients Tested For Gestational Diabetes

Description	This measure is used to assess the percentage of patients screened for gestational diabetes. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of Prenatal Patients With Prenatal Flowsheet

Description	This measure is used to assess the percentage of patients with a prenatal flowsheet in use by the date of the first physician visit. The flowsheet contains at a minimum: blood pressure, weight, urine protein, uterine size, fetal heart tones, and estimated date of delivery. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of Prenatal Women Over 35 Offered Amniocentesis Or Chronic Villus Sampling

Description	This measure is used to assess the percentage of patients aged 35 years and older at the time of expected delivery who are offered amniocentesis or chronic villus sampling. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Plan Member 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

Relationship Details

Prenatal Care Quality Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Prenatal Care Quality Analysis
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

Prenatal Care Quality Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Prenatal Care Quality Analysis
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

Prenatal Care Quality Analysis_Plan Member Dimension_FK

Is Identifying Relationship	true
Child Table	Prenatal Care Quality Analysis
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	Plan Member Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Prenatal Care Quality Analysis_Condition Dimension_FK

Is Identifying Relationship	true
Child Table	Prenatal Care Quality Analysis
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

Prenatal Care Quality Analysis_Group Dimension_FK

Is Identifying Relationship	true
Child Table	Prenatal Care Quality Analysis
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	Group Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Prenatal Care Quality Analysis_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Prenatal Care Quality Analysis
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

Prenatal Care Quality Analysis_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Prenatal Care Quality Analysis
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

Prenatal Care Quality Analysis_Health Plan Product Dimension_FK

Is Identifying Relationship	true
Child Table	Prenatal Care Quality Analysis
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	Health Plan Product Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Prenatal Care Quality Analysis_Coverage Agreement Dimension_FK

Is Identifying Relationship	true
Child Table	Prenatal Care Quality Analysis
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	Coverage Agreement 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

Prenatal Care Quality Analysis PK

Key Attribute	Plan Member Dk
Key Attribute	Condition Dk
Key Attribute	Provider Dk
Key Attribute	Practitioner Dk
Key Attribute	Health Plan Product Dk
Key Attribute	Calendar Dk
Key Attribute	Geographic Area Dk
Key Attribute	Group Dk
Key Attribute	Coverage Agreement Dimension Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model