Entity Prenatal Screening Snapshot

DescriptionA snapshot fact table which includes measures, time stamps and indicators relating to prenatal screening.

Attributes
Anomaly IndAnomaly Ind
Anomaly Risk IndAnomaly Risk Ind
Anomaly Risk TsAnomaly Risk Ts
Anomaly Screening TsAnomaly Screening Ts
Asymptomatic Bacteriuria Screening Status IndAsymptomatic Bacteriuria Screening Status Ind
Asymptomatic Bacteriuria Screening Status TsAsymptomatic Bacteriuria Screening Status Ts
Blood Group Identification IndBlood Group Identification Ind
Blood Group Identification TsBlood Group Identification Ts
Calendar DkCalendar Dk
Condition DkCondition Dk
Diagnosis Code DkDiagnosis Code Dk
Down's Syndrome Diagnosis IndDown's Syndrome Diagnosis Ind
Down's Syndrome Diagnosis TsDown's Syndrome Diagnosis Ts
Down's Syndrome Screening IndDown's Syndrome Screening Ind
Down's Syndrome Screening TsDown's Syndrome Screening Ts
Early Dating Ultrasound Scan Status IndEarly Dating Ultrasound Scan Status Ind
Early Dating Ultrasound Scan Status TsEarly Dating Ultrasound Scan Status Ts
Encounter DkEncounter Dk
Fetal Anomaly Scan Screening Status IndFetal Anomaly Scan Screening Status Ind
Fetal Anomaly Scan Screening Status TsFetal Anomaly Scan Screening Status Ts
Geographic Area DkGeographic Area Dk
Gestational AgeGestational Age
Hepatitis B Diagnosis IndHepatitis B Diagnosis Ind
Hepatitis B Diagnosis TsHepatitis B Diagnosis Ts
Hepatitis B Screening Status IndHepatitis B Screening Status Ind
Hepatitis B Screening Status TsHepatitis B Screening Status Ts
Imaging Procedure DkImaging Procedure Dk
Lab Test DkLab Test Dk
Patient DkPatient Dk
Point Of Care Location DkPoint Of Care Location Dk
Positive Rubella Antibody Screening IndPositive Rubella Antibody Screening Ind
Positive Rubella Antibody Screening TsPositive Rubella Antibody Screening Ts
Positive Serum Screening Results IndPositive Serum Screening Results Ind
Positive Serum Screening Results TsPositive Serum Screening Results Ts
Practitioner DkPractitioner Dk
Pre-Eclampsia High Risk Identification IndPre-Eclampsia High Risk Identification Ind
Pre-Eclampsia High Risk Identification TsPre-Eclampsia High Risk Identification Ts
Provider DkProvider Dk
Red Cell Antibodies Identification IndRed Cell Antibodies Identification Ind
Red Cell Antibodies Identification TsRed Cell Antibodies Identification Ts
Rhesus Group Identification IndRhesus Group Identification Ind
Rhesus Group Identification TsRhesus Group Identification Ts
Rubella Antibody Screening Status IndRubella Antibody Screening Status Ind
Rubella Antibody Screening Status TsRubella Antibody Screening Status Ts
Serum Screening Status IndSerum Screening Status Ind
Serum Screening Status TsSerum Screening Status Ts
Sickle Cell Disease/Thalassemia Screening Status IndSickle Cell Disease/Thalassemia Screening Status Ind
Sickle Cell Disease/Thalassemia Screening Status TsSickle Cell Disease/Thalassemia Screening Status Ts
Sickle Cell Disease Diagnosis IndSickle Cell Disease Diagnosis Ind
Sickle Cell Disease Diagnosis TsSickle Cell Disease Diagnosis Ts
Thalassemia Diagnosis IndThalassemia Diagnosis Ind
Thalassemia Diagnosis TsThalassemia Diagnosis Ts
Written Down's Syndrome Screening Information IndWritten Down's Syndrome Screening Information Ind
Written Down's Syndrome Screening Information TsWritten Down's Syndrome Screening Information Ts
Written Fetal Anomaly Screening Information IndWritten Fetal Anomaly Screening Information Ind
Written Fetal Anomaly Screening Information TsWritten Fetal Anomaly Screening Information Ts

Relationship
Prenatal Screening Snapshot_Practitioner Dimension_FKPrenatal Screening Snapshot_Practitioner Dimension_FK
Prenatal Screening Snapshot_Provider Dimension_FKPrenatal Screening Snapshot_Provider Dimension_FK
Prenatal Screening Snapshot_Condition Dimension_FKPrenatal Screening Snapshot_Condition Dimension_FK
Prenatal Screening Snapshot_Encounter Dimension_FKPrenatal Screening Snapshot_Encounter Dimension_FK
Prenatal Screening Snapshot_Point Of Care Location Dimension_FKPrenatal Screening Snapshot_Point Of Care Location Dimension_FK
Prenatal Screening Snapshot_Geographic Area Dimension_FKPrenatal Screening Snapshot_Geographic Area Dimension_FK
Prenatal Screening Snapshot_Calendar Dimension_FKPrenatal Screening Snapshot_Calendar Dimension_FK
Prenatal Screening Snapshot_Patient Dimension_FKPrenatal Screening Snapshot_Patient Dimension_FK
Prenatal Screening Snapshot_Diagnosis Code Dimension_FKPrenatal Screening Snapshot_Diagnosis Code Dimension_FK
Prenatal Screening Snapshot_Imaging Procedure Dimension_FKPrenatal Screening Snapshot_Imaging Procedure Dimension_FK
Prenatal Screening Snapshot_Lab Test Dimension_FKPrenatal Screening Snapshot_Lab Test Dimension_FK

Primary Key
Prenatal Screening Snapshot PKPrenatal Screening Snapshot PK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Anomaly Ind
DescriptionIndicates if a person has had anomaly screening.

For Example:
Serum Laboratory Tests
Ultrasound Scan
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Anomaly Risk Ind
DescriptionIndicates if a person has an anomaly risk identified through antenatal screening.

For Example:
Risk of Down's Syndrome
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Anomaly Risk Ts
DescriptionThe date and time that the anomaly risk was identified through antenatal screening.

For Example:
Risk of Down's Syndrome
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Anomaly Screening Ts
DescriptionThe date and time that the anomaly screening was performed.

For Example:
Serum Laboratory Tests
Ultrasound Scan
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Asymptomatic Bacteriuria Screening Status Ind
DescriptionIndicates the status of the Asymptomatic Bacteriuria screening.
For Example:
Offered and Undecided
Offered and Declined
Offered and Accepted
Not Offered
Completed
Resulted
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Asymptomatic Bacteriuria Screening Status Ts
DescriptionThe date and time the Asymptomatic Bacteriuria Screening status was defined.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Group Identification Ind
DescriptionIndicates that a person's Blood Group has been identified.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Group Identification Ts
DescriptionThe date and time a person's Blood Group has been identified.

For Example:
Blood Group A
Blood Group B
Blood Group AB
Blood Group O
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
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



 Down's Syndrome Diagnosis Ind
DescriptionIndicates that a person has been diagnosed with Down's Syndrome.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Down's Syndrome Diagnosis Ts
DescriptionThe date and time a person is diagnosed with Down's Syndrome.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Down's Syndrome Screening Ind
DescriptionIndicates that a person has been screened for Down's Syndrome.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Down's Syndrome Screening Ts
DescriptionThe date and time a person was screened for Down's Syndrome.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Early Dating Ultrasound Scan Status Ind
DescriptionIndicates that status of the Early Dating Ultrasound Scan for the person.
For Example:
Offered and Undecided
Offered and Declined
Offered and Accepted
Not Offered
Completed
Resulted
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Early Dating Ultrasound Scan Status Ts
DescriptionThe date and time the Dating Ultrasound Scan status was defined.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
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



 Fetal Anomaly Scan Screening Status Ind
DescriptionIndicates the status of the Fetal Anomaly Scan screening.
For Example:
Offered and Undecided
Offered and Declined
Offered and Accepted
Not Offered
Completed
Resulted
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Fetal Anomaly Scan Screening Status Ts
DescriptionThe date and time the Fetal Anomaly Screen Screening status was defined.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
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



 Gestational Age
DescriptionThe number of weeks and days of pregnancy which can be calculated using the current date and expected date of delivery.

For Example:
9 weeks 5 days
39 weeks 2 days
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Hepatitis B Diagnosis Ind
DescriptionIndicates that a person has been diagnosed with Hepatitis B.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Hepatitis B Diagnosis Ts
DescriptionThe date and time a person is diagnosed with Hepatitis B.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Hepatitis B Screening Status Ind
DescriptionIndicates the status of the Hepatitis B screening.
For Example:
Offered and Undecided
Offered and Declined
Offered and Accepted
Not Offered
Completed
Resulted
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Hepatitis B Screening Status Ts
DescriptionThe date and time the Hepatitis B Screening status was defined.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
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



 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



 Positive Rubella Antibody Screening Ind
DescriptionIndicates that a person has been screened positive for Rubella Antibodies.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Positive Rubella Antibody Screening Ts
DescriptionThe date and time a person is screened positive for Rubella Antibodies.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Positive Serum Screening Results Ind
DescriptionIndicates that a person's serum screening results are positive for abnormalities.

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/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Positive Serum Screening Results Ts
DescriptionThe date and time a person's serum screening results were reported as being positive for abnormalities.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
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



 Pre-Eclampsia High Risk Identification Ind
DescriptionIndicates that a person has a high risk of developing Pre-Eclampsia during pregnancy.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pre-Eclampsia High Risk Identification Ts
DescriptionThe data and time a person is identified as having a high risk of developing pre-eclampsia during pregnancy.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
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



 Red Cell Antibodies Identification Ind
DescriptionIndicates that a person has been screened positive for Red Cell Antibodies.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Red Cell Antibodies Identification Ts
DescriptionThe date and time a person is screened positive for Red Cell Antibodies.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Rhesus Group Identification Ind
DescriptionIndicates that a person's Rhesus Group has been identified.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Rhesus Group Identification Ts
DescriptionThe date and time a person's Rhesus Group has been identified.

For Example:
RhD negative
RhD positive
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Rubella Antibody Screening Status Ind
DescriptionIndicates the status of the Rubella Antibody screening.
For Example:
Offered and Undecided
Offered and Declined
Offered and Accepted
Not Offered
Completed
Resulted
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Rubella Antibody Screening Status Ts
DescriptionThe date and time the Rubella Antibody Screening status was defined.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Serum Screening Status Ind
DescriptionIndicates the status of the Serum Screening.
For Example:
Offered and Undecided
Offered and Declined
Offered and Accepted
Not Offered
Completed
Resulted
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Serum Screening Status Ts
DescriptionThe date and time the Serum Screening status was defined.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Sickle Cell Disease/Thalassemia Screening Status Ind
DescriptionIndicates the status of the Sickle Cell Disease/Thalassemia screening.
For Example:
Offered and Undecided
Offered and Declined
Offered and Accepted
Not Offered
Completed
Resulted
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Sickle Cell Disease/Thalassemia Screening Status Ts
DescriptionThe date and time the Sickle Cell Disease/Thalassemia Screening status was defined.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Sickle Cell Disease Diagnosis Ind
DescriptionIndicates that a person has been diagnosed with Sickle Cell Disease.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Sickle Cell Disease Diagnosis Ts
DescriptionThe date and time a person is diagnosed with Sickle Cell Disease.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Thalassemia Diagnosis Ind
DescriptionIndicates that a person has been diagnosed with Thalassemia.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Thalassemia Diagnosis Ts
DescriptionThe date and time a person is diagnosed with Thalassemia.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Written Down's Syndrome Screening Information Ind
DescriptionIndicates written information on Down's Syndrome Screening has been given to the patient.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Written Down's Syndrome Screening Information Ts
DescriptionThe data and time the written information on Down's Syndrome was given to the patient.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Written Fetal Anomaly Screening Information Ind
DescriptionIndicates written information on Fetal Anomaly Screening has been given to the patient.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Written Fetal Anomaly Screening Information Ts
DescriptionThe data and time the written information on Fetal Anomaly Screening was given to the patient.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Prenatal Screening Snapshot_Practitioner Dimension_FK
Is Identifying Relationshiptrue
Child TablePrenatal Screening Snapshot
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



 Prenatal Screening Snapshot_Provider Dimension_FK
Is Identifying Relationshiptrue
Child TablePrenatal Screening Snapshot
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



 Prenatal Screening Snapshot_Condition Dimension_FK
Is Identifying Relationshipfalse
Child TablePrenatal Screening Snapshot
Child MultiplicityZERO_TO_MANY
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



 Prenatal Screening Snapshot_Encounter Dimension_FK
Is Identifying Relationshiptrue
Child TablePrenatal Screening Snapshot
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



 Prenatal Screening Snapshot_Point Of Care Location Dimension_FK
Is Identifying Relationshiptrue
Child TablePrenatal Screening Snapshot
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



 Prenatal Screening Snapshot_Geographic Area Dimension_FK
Is Identifying Relationshiptrue
Child TablePrenatal Screening Snapshot
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



 Prenatal Screening Snapshot_Calendar Dimension_FK
Is Identifying Relationshiptrue
Child TablePrenatal Screening Snapshot
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



 Prenatal Screening Snapshot_Patient Dimension_FK
Is Identifying Relationshiptrue
Child TablePrenatal Screening Snapshot
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



 Prenatal Screening Snapshot_Diagnosis Code Dimension_FK
Is Identifying Relationshiptrue
Child TablePrenatal Screening Snapshot
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



 Prenatal Screening Snapshot_Imaging Procedure Dimension_FK
Is Identifying Relationshiptrue
Child TablePrenatal Screening Snapshot
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



 Prenatal Screening Snapshot_Lab Test Dimension_FK
Is Identifying Relationshiptrue
Child TablePrenatal Screening Snapshot
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

Primary Key Details

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