Entity Pregnancy

DescriptionA record of pregnancy information that influences the coverage eligibility.

Attributes
Estimated Gestational Age Range at EnrollmentEstimated Gestational Age Range at Enrollment
Expected Date of DeliveryExpected Date of Delivery
Last Menstrual Period End DateLast Menstrual Period End Date

Relationship
Pregnancy_Coverage Eligibility_FKPregnancy_Coverage Eligibility_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Estimated Gestational Age Range at Enrollment
DescriptionAn indicator that shows the estimated stage of the pregnancy at the time of enrollment.

For example:
28 weeks or more
2nd Trimester
Enrollment before pregnancy
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Expected Date of Delivery
DescriptionThe expected date of childbirth.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Last Menstrual Period End Date
DescriptionThe date upon which the last menstrual period ended.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Pregnancy_Coverage Eligibility_FK
Is Identifying Relationshipfalse
Child TablePregnancy
Child Role Nameaffects
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCoverage Eligibility
Parent Role Nameis affected by
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE