Entity NHS - Prenatal Screening Analysis

DescriptionA 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.

Attributes
Anomaly Detection RateAnomaly Detection Rate
Calendar DkCalendar Dk
Condition DkCondition Dk
Diagnosis Code DkDiagnosis Code Dk
Encounter DkEncounter Dk
Geographic Area DkGeographic Area Dk
Imaging Procedure DkImaging Procedure Dk
Lab Test DkLab Test Dk
Number Of Babies Screened Antenatally At Risk Of AnomalyNumber Of Babies Screened Antenatally At Risk Of Anomaly
Number Of Babies Screened For AnomaliesNumber Of Babies Screened For Anomalies
Number Of Fetal Anomaly Scans Performed Between 18 Weeks + 0 Days And 20 Weeks + 6 DaysNumber Of Fetal Anomaly Scans Performed Between 18 Weeks + 0 Days And 20 Weeks + 6 Days
Number Of People Accepted Serum Screening For Sickle Cell Disease/ThalassemiaNumber Of People Accepted Serum Screening For Sickle Cell Disease/Thalassemia
Number Of People Diagnosed With Sickle Cell DiseaseNumber Of People Diagnosed With Sickle Cell Disease
Number Of People Diagnosed With ThalassemiaNumber Of People Diagnosed With Thalassemia
Number Of People Offered Serum Screening For Sickle Cell Disease/ThalassemiaNumber Of People Offered Serum Screening For Sickle Cell Disease/Thalassemia
Number Of Pregnancies At Risk Of Being Affected Due To Maternal Serum Screening ResultsNumber Of Pregnancies At Risk Of Being Affected Due To Maternal Serum Screening Results
Number Of Serum Screening Tests CompletedNumber Of Serum Screening Tests Completed
Number Of Serum Screening Tests OfferedNumber Of Serum Screening Tests Offered
Number Of Women Are Screened For Rubella Antibodies Within 9 Weeks + 6 DaysNumber Of Women Are Screened For Rubella Antibodies Within 9 Weeks + 6 Days
Number Of Women For Whom Blood Group Is IdentifiedNumber Of Women For Whom Blood Group Is Identified
Number Of Women For Whom Red Cell Antibodies Is IdentifiedNumber Of Women For Whom Red Cell Antibodies Is Identified
Number Of Women For Whom Rhesus D Status Is IdentifiedNumber Of Women For Whom Rhesus D Status Is Identified
Number Of Women Given Information About Down's Syndrome Screening At First ContactNumber Of Women Given Information About Down's Syndrome Screening At First Contact
Number Of Women Given Written Information About Screening For Fetal AnomaliesNumber Of Women Given Written Information About Screening For Fetal Anomalies
Number Of Women Offered An Early Ultrasound Scan Between 10 Weeks + 0 Days And 13 Weeks + 6 DaysNumber Of Women Offered An Early Ultrasound Scan Between 10 Weeks + 0 Days And 13 Weeks + 6 Days
Number Of Women Offered Screening For Asymptomatic BacteriuriaNumber Of Women Offered Screening For Asymptomatic Bacteriuria
Number Of Women Offered Screening For Hepatitis BNumber Of Women Offered Screening For Hepatitis B
Number Of Women Offered Screening For Rubella AntibodyNumber Of Women Offered Screening For Rubella Antibody
Number Of Women Tested For Blood Group And RhD Status In Early PregnancyNumber Of Women Tested For Blood Group And RhD Status In Early Pregnancy
Number Of Women Who Are Screened For Hepatitis B Within 9 Weeks + 6 DaysNumber Of Women Who Are Screened For Hepatitis B Within 9 Weeks + 6 Days
Number Of Women Who Do Not Have An Early Dating Ultrasound Scan Between 10-13.6 WksNumber Of Women Who Do Not Have An Early Dating Ultrasound Scan Between 10-13.6 Wks
Number Of Women Who Have An Early Dating Ultrasound Scan Between 10-13.6 WksNumber Of Women Who Have An Early Dating Ultrasound Scan Between 10-13.6 Wks
Number Of Women Who Screen Negative For Down's SyndromeNumber Of Women Who Screen Negative For Down's Syndrome
Number Of Women Who Screen Positive For Down's SyndromeNumber Of Women Who Screen Positive For Down's Syndrome
Number Of Women Who Screen Positive For Hepatitis BNumber Of Women Who Screen Positive For Hepatitis B
Number Of Women Who Screen Positive For Rubella AntibodyNumber Of Women Who Screen Positive For Rubella Antibody
Number Of Women With High Risk Of Pre-Eclampsia Identified At Early Antenatal AppointmentNumber Of Women With High Risk Of Pre-Eclampsia Identified At Early Antenatal Appointment
Patient DkPatient Dk
Point Of Care Location DkPoint Of Care Location Dk
Practitioner DkPractitioner Dk
Provider DkProvider Dk

Relationship
NHS - Prenatal Screening Analysis_Calendar Dimension_FKNHS - Prenatal Screening Analysis_Calendar Dimension_FK
NHS - Prenatal Screening Analysis_Patient Dimension_FKNHS - Prenatal Screening Analysis_Patient Dimension_FK
NHS - Prenatal Screening Analysis_Encounter Dimension_FKNHS - Prenatal Screening Analysis_Encounter Dimension_FK
NHS - Prenatal Screening Analysis_Practitioner Dimension_FKNHS - Prenatal Screening Analysis_Practitioner Dimension_FK
NHS - Prenatal Screening Analysis_Provider Dimension_FKNHS - Prenatal Screening Analysis_Provider Dimension_FK
NHS - Prenatal Screening Analysis_Point Of Care Location Dimension_FKNHS - Prenatal Screening Analysis_Point Of Care Location Dimension_FK
NHS - Prenatal Screening Analysis_Geographic Area Dimension_FKNHS - Prenatal Screening Analysis_Geographic Area Dimension_FK
NHS - Prenatal Screening Analysis_Diagnosis Code Dimension_FKNHS - Prenatal Screening Analysis_Diagnosis Code Dimension_FK
NHS - Prenatal Screening Analysis_Condition Dimension_FKNHS - Prenatal Screening Analysis_Condition Dimension_FK
NHS - Prenatal Screening Analysis_Lab Test Dimension_FKNHS - Prenatal Screening Analysis_Lab Test Dimension_FK
NHS - Prenatal Screening Analysis_Imaging Procedure Dimension_FKNHS - Prenatal Screening Analysis_Imaging Procedure Dimension_FK

Primary Key
NHS - Prenatal Screening Analysis PKNHS - Prenatal Screening Analysis PK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Anomaly Detection Rate
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Calendar Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Condition Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Diagnosis Code Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Encounter Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Geographic Area Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Imaging Procedure Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Lab Test Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Babies Screened Antenatally At Risk Of Anomaly
DescriptionThe number of babies who have been identified as having a risk of anomaly based on serum screening results or ultrasound scan results.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Babies Screened For Anomalies
DescriptionThe number of babies assesseed using blood tests and ultrasounds to detect any physical abnormalities or conditions during antenatal care.

Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Fetal Anomaly Scans Performed Between 18 Weeks + 0 Days And 20 Weeks + 6 Days
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of People Accepted Serum Screening For Sickle Cell Disease/Thalassemia
DescriptionThe number of pregnant mothers who completed a haemoglobinopathy serum screening test to detect Sickle Cell Disease or Thalassemia.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of People Diagnosed With Sickle Cell Disease
DescriptionThe number of pregnant mothers diagnosed with Sickle Cell Disease through haemoglobinopathy serum screening.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of People Diagnosed With Thalassemia
DescriptionThe number of pregnant mothers diagnosed with Thalassemia through haemoglobinopathy serum screening.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of People Offered Serum Screening For Sickle Cell Disease/Thalassemia
DescriptionThe number of pregnant mothers offered a haemoglobinopathy serum screening test to detect Sickle Cell Disease or Thalassemia.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Pregnancies At Risk Of Being Affected Due To Maternal Serum Screening Results
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Serum Screening Tests Completed
DescriptionThe number of pregnant women who have serum screening testing done to detect any fetal anomalies as part of their antenatal care.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Serum Screening Tests Offered
DescriptionThe number of pregnant women who are offered serum screening tests to detect any fetal anomalies as part of their antenatal care.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women Are Screened For Rubella Antibodies Within 9 Weeks + 6 Days
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women For Whom Blood Group Is Identified
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women For Whom Red Cell Antibodies Is Identified
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women For Whom Rhesus D Status Is Identified
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women Given Information About Down's Syndrome Screening At First Contact
DescriptionThe number of pregnant woman given a booklet on Down's Syndrome screening as part of their antenatal care.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women Given Written Information About Screening For Fetal Anomalies
DescriptionThe number of pregnant woman given a booklet on fetal anomaly screening as part of their antenatal care.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women Offered An Early Ultrasound Scan Between 10 Weeks + 0 Days And 13 Weeks + 6 Days
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women Offered Screening For Asymptomatic Bacteriuria
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women Offered Screening For Hepatitis B
DescriptionThe number of pregnant women who are offered the Hepatitis B serum screening as part of their antenatal care.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women Offered Screening For Rubella Antibody
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women Tested For Blood Group And RhD Status In Early Pregnancy
DescriptionThe number of pregnant women whose blood group and rhesus status is known using antenatal serum screening.

For Example:
A+
O+
B-
AB-
A-
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women Who Are Screened For Hepatitis B Within 9 Weeks + 6 Days
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women Who Do Not Have An Early Dating Ultrasound Scan Between 10-13.6 Wks
DescriptionThe number of pregnant women who do not have a Dating Ultrasound Scan between 10-13.6 weeks as part of their antenatal care.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women Who Have An Early Dating Ultrasound Scan Between 10-13.6 Wks
DescriptionThe number of pregnant women who have a Dating Ultrasound Scan and the gestational age is calculated as being 10-13.6 weeks.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women Who Screen Negative For Down's Syndrome
DescriptionThe number of pregnant women whose fetal anomaly screening does not indicate Down's Syndrome in the fetus.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women Who Screen Positive For Down's Syndrome
DescriptionThe number of pregnant women whose fetal anomaly screening indicates the fetus has Down's Syndrome.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women Who Screen Positive For Hepatitis B
DescriptionThe number of pregnant women who are reported as positive for Hepatitis B through antenatal serum screening.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women Who Screen Positive For Rubella Antibody
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Women With High Risk Of Pre-Eclampsia Identified At Early Antenatal Appointment
DescriptionThe number of pregnant women who are deemed high risk for developing pre-eclampsia based on antenatal assessment and screening.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Point Of Care Location Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Practitioner Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 NHS - Prenatal Screening Analysis_Calendar Dimension_FK
Is Identifying Relationshiptrue
Child TableNHS - Prenatal Screening Analysis
Child MultiplicityZERO_TO_ONE
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCalendar Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 NHS - Prenatal Screening Analysis_Patient Dimension_FK
Is Identifying Relationshiptrue
Child TableNHS - Prenatal Screening Analysis
Child MultiplicityZERO_TO_ONE
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePatient Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 NHS - Prenatal Screening Analysis_Encounter Dimension_FK
Is Identifying Relationshiptrue
Child TableNHS - Prenatal Screening Analysis
Child MultiplicityZERO_TO_ONE
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableEncounter Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 NHS - Prenatal Screening Analysis_Practitioner Dimension_FK
Is Identifying Relationshiptrue
Child TableNHS - Prenatal Screening Analysis
Child MultiplicityZERO_TO_ONE
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePractitioner Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 NHS - Prenatal Screening Analysis_Provider Dimension_FK
Is Identifying Relationshiptrue
Child TableNHS - Prenatal Screening Analysis
Child MultiplicityZERO_TO_ONE
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableProvider Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 NHS - Prenatal Screening Analysis_Point Of Care Location Dimension_FK
Is Identifying Relationshiptrue
Child TableNHS - Prenatal Screening Analysis
Child MultiplicityZERO_TO_ONE
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePoint Of Care Location Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 NHS - Prenatal Screening Analysis_Geographic Area Dimension_FK
Is Identifying Relationshiptrue
Child TableNHS - Prenatal Screening Analysis
Child MultiplicityZERO_TO_ONE
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableGeographic Area Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 NHS - Prenatal Screening Analysis_Diagnosis Code Dimension_FK
Is Identifying Relationshiptrue
Child TableNHS - Prenatal Screening Analysis
Child MultiplicityZERO_TO_ONE
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableDiagnosis Code Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 NHS - Prenatal Screening Analysis_Condition Dimension_FK
Is Identifying Relationshiptrue
Child TableNHS - Prenatal Screening Analysis
Child MultiplicityZERO_TO_ONE
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCondition Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 NHS - Prenatal Screening Analysis_Lab Test Dimension_FK
Is Identifying Relationshiptrue
Child TableNHS - Prenatal Screening Analysis
Child MultiplicityZERO_TO_ONE
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableLab Test Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 NHS - Prenatal Screening Analysis_Imaging Procedure Dimension_FK
Is Identifying Relationshiptrue
Child TableNHS - Prenatal Screening Analysis
Child MultiplicityZERO_TO_ONE
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableImaging Procedure Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 NHS - Prenatal Screening Analysis PK
Key AttributeCalendar Dk
Key AttributePatient Dk
Key AttributeEncounter Dk
Key AttributePractitioner Dk
Key AttributeProvider Dk
Key AttributePoint Of Care Location Dk
Key AttributeGeographic Area Dk
Key AttributeDiagnosis Code Dk
Key AttributeCondition Dk
Key AttributeLab Test Dk
Key AttributeImaging Procedure Dk