PREGNANCY_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pregnancy Action
Definition: Used for tracking access and interaction with a person's pregnancy history record.
Table Type: ACTIVITY





Column Detail - PREGNANCY_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N Date/time at which the action was taken
ACTION_TYPE_CD DOUBLE N Type of action taken
ACTION_TZ DOUBLE N Time zone in which the action was taken
PREGNANCY_ACTION_ID DOUBLE N PRIMARY KEY
PREGNANCY_ID DOUBLE N Pregnancy on which the action was taken
PREGNANCY_INSTANCE_ID DOUBLE N The PREGNANCY_INSTANCE_ID value from the PREGNANCY_INSTANCE table that this action corresponds to.
PRSNL_ID DOUBLE N Provider taking the action
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - PREGNANCY_ACTION


Child Column in PREGNANCY_ACTION(FK) Parent Table Name Parent Column Name
Parents: PREGNANCY_ID PREGNANCY_INSTANCE PREGNANCY_INSTANCE_ID
PREGNANCY_INSTANCE_ID PREGNANCY_INSTANCE PREGNANCY_INSTANCE_ID


PREGNANCY_CHILD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pregnancy Child
Definition: This table stores the data relating to a particular child of a pregnancy
Table Type: ACTIVITY





Column Detail - PREGNANCY_CHILD


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ANESTHESIA_TXT VARCHAR(60) Y Free text description of type of anesthesia used during delivery procedure
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CHILD_COMMENT_ID DOUBLE N LONG_TEXT id for a comment related to the child
CHILD_NAME VARCHAR(60) Y Name of the child
DELIVERY_DATE_PRECISION_FLAG DOUBLE N Indicates the level of precision known for the delivery date (day, week, month, year) 0 = day; 1 = month; 2 = year
DELIVERY_DATE_QUALIFIER_FLAG DOUBLE N Provides additional detail for imprecise delivery dates (about, after, before)0 = no qualifier; 1 = before; 2 = about; 3 = after; 4 = Date Only - Time should not be used.
DELIVERY_DT_TM DATETIME Y Date/time at which the child was delivered
DELIVERY_HOSPITAL VARCHAR(60) Y Location in which the child was delivered
DELIVERY_METHOD_CD DOUBLE N Method by which the child was delivered
DELIVERY_PROVIDER_NAME VARCHAR(60) Y Name of provider/physician who has performed this delivery.
DELIVERY_TZ DOUBLE N Time zone in which the child was delivered
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FATHER_NAME VARCHAR(60) Y Name of child's father
GENDER_CD DOUBLE N Gender of the child
GESTATION_AGE DOUBLE N Child's gestational age, in days, on date of delivery
GESTATION_TERM_TXT VARCHAR(20) Y Child's gestational age when user is not sure of exact gestation weeks and days
LABOR_DURATION DOUBLE N Duration in minutes of thelabor for the delivery of the child.
NEONATE_OUTCOME_CD DOUBLE N Indicates the outcome of the pregnancy for the child
PERSON_ID DOUBLE N Identifies the child on the PERSON table, if a corresponding record exists
PREGNANCY_CHILD_ID DOUBLE N PRIMARY KEY
PREGNANCY_ID DOUBLE N PREGNANCY INSTANCE ID
PREGNANCY_INSTANCE_ID DOUBLE N The PREGNANCY_INSTANCE_ID value from the PREGNANCY_INSTANCE table that this action corresponds to.
PRETERM_LABOR_TXT VARCHAR(255) N Free text description of preterm labor occurring during the pregnancy
RESTRICT_PERSON_ID_IND DOUBLE N A value of 1 indicates that the relationship between the person_id and this pregnancy has been made restricted and should not be used to correlate data from that chart with the pregnancy.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VBAC_IND DOUBLE Y Indicates whether this delivery is vaginal birth after cesarean (VBAC) or not. Value 1 indicates it is vbac and 0 indicates it is not vbac.
WEIGHT_AMT DOUBLE Y Birth weight
WEIGHT_UNIT_CD DOUBLE N Unit of measurement for birth weight



Relationship Detail - PREGNANCY_CHILD


Child Column in PREGNANCY_CHILD(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
PREGNANCY_ID PREGNANCY_INSTANCE PREGNANCY_INSTANCE_ID
PREGNANCY_INSTANCE_ID PREGNANCY_INSTANCE PREGNANCY_INSTANCE_ID




Parent Column in PREGNANCY_CHILD (PK) Child Table Name Child Column Name
Children: PREGNANCY_CHILD_ID PREGNANCY_CHILD_ENTITY_R PREGNANCY_CHILD_ID


PREGNANCY_CHILD_ENTITY_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pregnancy Child Entity Relation
Definition: Maintains relationships to various entities related to a child of a pregnancy (for example: code set values, clinical events, and nomenclatures)
Table Type: ACTIVITY





Column Detail - PREGNANCY_CHILD_ENTITY_R


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
COMPONENT_TYPE_CD DOUBLE N Indicates the type of related data that the entity represents for the child
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
PARENT_ENTITY_ID DOUBLE N Identifies the related entity on its parent table
PARENT_ENTITY_NAME VARCHAR(30) N NAME OF PARENT TABLE FOR PARENT ENTITY ID
PREGNANCY_CHILD_ENTITY_ID DOUBLE N PRIMARY KEY
PREGNANCY_CHILD_ID DOUBLE N Identifies the child on PREGNANCY_CHILD that the entity is related to
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - PREGNANCY_CHILD_ENTITY_R


Child Column in PREGNANCY_CHILD_ENTITY_R(FK) Parent Table Name Parent Column Name
Parents: PREGNANCY_CHILD_ID PREGNANCY_CHILD PREGNANCY_CHILD_ID


PREGNANCY_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pregnancy DetailT
Definition: This table is used for recording additional details which may pertain to some pregnancy estimates
Table Type: ACTIVITY





Column Detail - PREGNANCY_DETAIL


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BREASTFEEDING_IND DOUBLE N Indicates whether the person was already breastfeeding at time of conception
CONTRACEPTION_DURATION DOUBLE N Duration of contraception use prior to pregnancy, in years
CONTRACEPTION_IND DOUBLE N Indicates whether hormonal contraception was in use at the time of conception
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LMP_SYMPTOMS_TXT VARCHAR(255) Y Description of symptoms that may have accompanied last menstrual period prior to pregnancy
MENARCHE_AGE DOUBLE N Age at menarche, in years
MENSTRUAL_FREQ DOUBLE N Frequency of typical menstrual cycle, in days
PREGNANCY_DETAIL_ID DOUBLE N Primary Key
PREGNANCY_ESTIMATE_ID DOUBLE N The pregnancy estimate to which these details are related
PREGNANCY_TEST_DT_TM DATETIME Y Date of home pregnancy test
PRIOR_MENSES_DT_TM DATETIME Y Date of last menses prior to LMP
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - PREGNANCY_DETAIL


Child Column in PREGNANCY_DETAIL(FK) Parent Table Name Parent Column Name
Parents: PREGNANCY_ESTIMATE_ID PREGNANCY_ESTIMATE PREGNANCY_ESTIMATE_ID


PREGNANCY_ENTITY_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pregnancy Entity Relationship
Definition: Used to store relationships that different entities would have to a pregnancy in a persons pregnancy record (for example, the event id for a summary document)
Table Type: ACTIVITY





Column Detail - PREGNANCY_ENTITY_R


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
COMPONENT_TYPE_CD DOUBLE N Indicates what type of entity is being represented by this row
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
PARENT_ENTITY_ID DOUBLE N Identifies the related entity on its parent table
PARENT_ENTITY_NAME VARCHAR(30) N Name of the table that contains the entity data being related to the pregnancy
PREGNANCY_ENTITY_ID DOUBLE N PRIMARY KEY
PREGNANCY_ID DOUBLE N RELATED PREGNANCY INSTANCE
PREGNANCY_INSTANCE_ID DOUBLE N The PREGNANCY_INSTANCE_ID value from the PREGNANCY_INSTANCE table that this action corresponds to.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - PREGNANCY_ENTITY_R


Child Column in PREGNANCY_ENTITY_R(FK) Parent Table Name Parent Column Name
Parents: PREGNANCY_ID PREGNANCY_INSTANCE PREGNANCY_INSTANCE_ID
PREGNANCY_INSTANCE_ID PREGNANCY_INSTANCE PREGNANCY_INSTANCE_ID