| Dimensional Warehouse Model Data Model |
Description | A set of measures based on NHS Maternity Services Data Set. This group of measures focuses on prenatal screening. Refer to the Information Requirements section of the dataset for more information. |
Primary Key | |
![]() |
Dependencies | |
![]() |
Reverse Dependencies | |
![]() |
Attribute Details |
Description | The proportion of positive anomaly screening resulted babies per number of babies screened. Formula: [A/B] (see dependencies and their labels for measures used in the formula) |
Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Description | The number of babies who have been identified as having a risk of anomaly based on serum screening results or ultrasound scan results. |
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 |
Description | The number of babies assesseed using blood tests and ultrasounds to detect any physical abnormalities or conditions during antenatal care. |
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 |
Description | The number of pregnant women who had their fetal anomaly scan done during the gestation period: 18 weeks 0 days to 20 weeks + 6 days. |
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 |
Description | The number of pregnant mothers who completed a haemoglobinopathy serum screening test to detect Sickle Cell Disease or Thalassemia. |
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 |
Description | The number of pregnant mothers diagnosed with Sickle Cell Disease through haemoglobinopathy serum screening. |
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 |
Description | The number of pregnant mothers diagnosed with Thalassemia through haemoglobinopathy serum screening. |
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 |
Description | The number of pregnant mothers offered a haemoglobinopathy serum screening test to detect Sickle Cell Disease or Thalassemia. |
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 |
Description | The number of women whose pregnancies are at risk based on their maternal serum screening results. For Example: Iron Deficiency Homozygote or compound heterozygote neither of genetic significance Significant Carrier Homozygote or compound heterozygote either or both of genetic significance Significant disorder Repeat Required |
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 |
Description | The number of pregnant women who have serum screening testing done to detect any fetal anomalies as part of their antenatal care. |
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 |
Description | The number of pregnant women who are offered serum screening tests to detect any fetal anomalies as part of their antenatal care. |
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 |
Description | The number of pregnant women who are serum screened for Rubella Antibodies as part of their antenatal care before gestation age 9 weeks + 6 days. |
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 |
Description | The number of pregnant women whose Blood Group is known based on serum screening. This is identified to prevent haemolytic disease of the newborn (HDN) and to identify possible transfusion problems. |
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 |
Description | The number of pregnant women whose Red Cell Antibody status is determined using on serum screening. This is identified to prevent haemolytic disease of the newborn (HDN) and to identify possible transfusion problems. |
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 |
Description | The number of pregnant women whose Rhesus D status is known based on serum screening. This is identified to prevent haemolytic disease of the newborn (HDN) and to identify possible transfusion problems. |
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 |
Description | The number of pregnant woman given a booklet on Down's Syndrome screening as part of their antenatal care. |
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 |
Description | The number of pregnant woman given a booklet on fetal anomaly screening as part of their antenatal care. |
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 |
Description | The number of pregnant women who are offered a Dating Ultrasound Scan during gestational age 10 weeks + 0 days and 13 weeks + 6 days to determine the actual gestational length. |
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 |
Description | The number of pregnant women who are offered Asymtomatic Bacteriuria urine testing as part of their antenatal care. It is used to determine if the mother has a urinary infection. |
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 |
Description | The number of pregnant women who are offered the Hepatitis B serum screening as part of their antenatal care. |
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 |
Description | The number of pregnant women who are offered the Rubella Antibody serum screening as part of their antenatal care. It is used to determine if the mother has immunity to Rubella or not. |
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 |
Description | The number of pregnant women whose blood group and rhesus status is known using antenatal serum screening. For Example: A+ O+ B- AB- A- |
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 |
Description | The number of pregnant women who are serum screened for Hepatitis B as part of their antenatal care before gestation age 9 weeks + 6 days. |
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 |
Description | The number of pregnant women who do not have a Dating Ultrasound Scan between 10-13.6 weeks as part of their antenatal care. |
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 |
Description | The number of pregnant women who have a Dating Ultrasound Scan and the gestational age is calculated as being 10-13.6 weeks. |
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 |
Description | The number of pregnant women whose fetal anomaly screening does not indicate Down's Syndrome in the fetus. |
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 |
Description | The number of pregnant women whose fetal anomaly screening indicates the fetus has Down's Syndrome. |
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 |
Description | The number of pregnant women who are reported as positive for Hepatitis B through antenatal serum screening. |
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 |
Description | The number of pregnant women who are reported as positive for Rubella antibodies through antenatal serum screening. This means they are immune to the Rubella virus. |
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 |
Description | The number of pregnant women who are deemed high risk for developing pre-eclampsia based on antenatal assessment and screening. |
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 |
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 |
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 |
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 |
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 |
Is Identifying Relationship | true |
Child Table | NHS - Prenatal Screening Analysis |
Child Multiplicity | ZERO_TO_ONE |
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 |
Is Identifying Relationship | true |
Child Table | NHS - Prenatal Screening Analysis |
Child Multiplicity | ZERO_TO_ONE |
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 |
Is Identifying Relationship | true |
Child Table | NHS - Prenatal Screening Analysis |
Child Multiplicity | ZERO_TO_ONE |
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 |
Is Identifying Relationship | true |
Child Table | NHS - Prenatal Screening Analysis |
Child Multiplicity | ZERO_TO_ONE |
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 |
Is Identifying Relationship | true |
Child Table | NHS - Prenatal Screening Analysis |
Child Multiplicity | ZERO_TO_ONE |
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 |
Is Identifying Relationship | true |
Child Table | NHS - Prenatal Screening Analysis |
Child Multiplicity | ZERO_TO_ONE |
Child Referential Integrity: On Delete | NONE |
Child Referential Integrity: On Insert | NONE |
Child Referential Integrity: On Update | NONE |
Parent Table | Point Of Care Location Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | NHS - Prenatal Screening Analysis |
Child Multiplicity | ZERO_TO_ONE |
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 |
Is Identifying Relationship | true |
Child Table | NHS - Prenatal Screening Analysis |
Child Multiplicity | ZERO_TO_ONE |
Child Referential Integrity: On Delete | NONE |
Child Referential Integrity: On Insert | NONE |
Child Referential Integrity: On Update | NONE |
Parent Table | Diagnosis Code Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | NHS - Prenatal Screening Analysis |
Child Multiplicity | ZERO_TO_ONE |
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 |
Is Identifying Relationship | true |
Child Table | NHS - Prenatal Screening Analysis |
Child Multiplicity | ZERO_TO_ONE |
Child Referential Integrity: On Delete | NONE |
Child Referential Integrity: On Insert | NONE |
Child Referential Integrity: On Update | NONE |
Parent Table | Lab Test Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | NHS - Prenatal Screening Analysis |
Child Multiplicity | ZERO_TO_ONE |
Child Referential Integrity: On Delete | NONE |
Child Referential Integrity: On Insert | NONE |
Child Referential Integrity: On Update | NONE |
Parent Table | Imaging Procedure 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 |
Key Attribute | Calendar Dk |
Key Attribute | Patient Dk |
Key Attribute | Encounter Dk |
Key Attribute | Practitioner Dk |
Key Attribute | Provider Dk |
Key Attribute | Point Of Care Location Dk |
Key Attribute | Geographic Area Dk |
Key Attribute | Diagnosis Code Dk |
Key Attribute | Condition Dk |
Key Attribute | Lab Test Dk |
Key Attribute | Imaging Procedure Dk |
| Dimensional Warehouse Model Data Model |