| 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 | |
NHS - Prenatal Screening Analysis PK |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Anomaly Detection Rate
| 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 |
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 |
Diagnosis Code 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 |
Imaging Procedure 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 |
Lab Test 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 Babies Screened Antenatally At Risk Of Anomaly
| 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 |
Number Of Babies Screened For Anomalies
| 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 |
Number Of Fetal Anomaly Scans Performed Between 18 Weeks + 0 Days And 20 Weeks + 6 Days
| 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 |
Number Of People Accepted Serum Screening For Sickle Cell Disease/Thalassemia
| 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 |
Number Of People Diagnosed With Sickle Cell Disease
| 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 |
Number Of People Diagnosed With Thalassemia
| 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 |
Number Of People Offered Serum Screening For Sickle Cell Disease/Thalassemia
| 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 |
Number Of Pregnancies At Risk Of Being Affected Due To Maternal Serum Screening Results
| 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 |
Number Of Serum Screening Tests Completed
| 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 |
Number Of Serum Screening Tests Offered
| 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 |
Number Of Women Are Screened For Rubella Antibodies Within 9 Weeks + 6 Days
| 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 |
Number Of Women For Whom Blood Group Is Identified
| 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 |
Number Of Women For Whom Red Cell Antibodies Is Identified
| 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 |
Number Of Women For Whom Rhesus D Status Is Identified
| 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 |
Number Of Women Given Information About Down's Syndrome Screening At First Contact
| 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 |
Number Of Women Given Written Information About Screening For Fetal Anomalies
| 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 |
Number Of Women Offered An Early Ultrasound Scan Between 10 Weeks + 0 Days And 13 Weeks + 6 Days
| 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 |
Number Of Women Offered Screening For Asymptomatic Bacteriuria
| 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 |
Number Of Women Offered Screening For Hepatitis B
| 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 |
Number Of Women Offered Screening For Rubella Antibody
| 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 |
Number Of Women Tested For Blood Group And RhD Status In Early Pregnancy
| 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 |
Number Of Women Who Are Screened For Hepatitis B Within 9 Weeks + 6 Days
| 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 |
Number Of Women Who Do Not Have An Early Dating Ultrasound Scan Between 10-13.6 Wks
| 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 |
Number Of Women Who Have An Early Dating Ultrasound Scan Between 10-13.6 Wks
| 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 |
Number Of Women Who Screen Negative For Down's Syndrome
| 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 |
Number Of Women Who Screen Positive For Down's Syndrome
| 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 |
Number Of Women Who Screen Positive For Hepatitis B
| 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 |
Number Of Women Who Screen Positive For Rubella Antibody
| 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 |
Number Of Women With High Risk Of Pre-Eclampsia Identified At Early Antenatal Appointment
| 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 |
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 |
Point Of Care Location 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 |
NHS - Prenatal Screening Analysis_Calendar Dimension_FK
| 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 |
NHS - Prenatal Screening Analysis_Patient Dimension_FK
| 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 |
NHS - Prenatal Screening Analysis_Encounter Dimension_FK
| 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 |
NHS - Prenatal Screening Analysis_Practitioner Dimension_FK
| 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 |
NHS - Prenatal Screening Analysis_Provider Dimension_FK
| 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 |
NHS - Prenatal Screening Analysis_Point Of Care Location Dimension_FK
| 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 |
NHS - Prenatal Screening Analysis_Geographic Area Dimension_FK
| 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 |
NHS - Prenatal Screening Analysis_Diagnosis Code Dimension_FK
| 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 |
NHS - Prenatal Screening Analysis_Condition Dimension_FK
| 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 |
NHS - Prenatal Screening Analysis_Lab Test Dimension_FK
| 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 |
NHS - Prenatal Screening Analysis_Imaging Procedure Dimension_FK
| 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 |
NHS - Prenatal Screening Analysis PK
| 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 |