Table Detail Report

PREGNANCY_ESTIMATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pregnancy Estimate
Definition: This table is used for recording the estimates of delivery date (and related information) for a pregnancy
Table Type: ACTIVITY





Column Detail - PREGNANCY_ESTIMATE


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.
AUTHOR_ID DOUBLE N ID which identifies the provider that recorded this estimate of delivery date. Value is from the PRSNL table.
BIPARIETAL_DIAMETER DOUBLE Y Measurement used in estimating gestational age (millimeters)
CONFIRMATION_CD DOUBLE N The confirmation level of the measurement of estimated delivery date.
CROWN_RUMP_LENGTH DOUBLE Y Measurement used in estimating gestational age (millimeters)
DESCRIPTOR_CD DOUBLE N Description of the advanced reproductive technology method
DESCRIPTOR_FLAG DOUBLE N Represents descriptive data pertaining to the method
DESCRIPTOR_TXT VARCHAR(255) Y Textual description relating to the method of estimation
EDD_COMMENT_ID DOUBLE N LONG_TEXT id that relates to a comment entered for the delivery date estimation
ENTERED_DT_TM DATETIME Y Date at which a user entered or altered a pregnancy estimate
EST_DELIVERY_DT_TM DATETIME Y Estimated delivery date
EST_DELIVERY_TZ DOUBLE Y Contains time zone information of EST_DELIVERY_DT_TM column
EST_GEST_AGE_DAYS DOUBLE N Estimated gestational age at time of measurement
HEAD_CIRCUMFERENCE DOUBLE Y Measurement used in estimating gestational age (millimeters)
METHOD_CD DOUBLE N The method by which the delivery date was determined
METHOD_DT_TM DATETIME N Date/time that the method of estimation occurred (for example, ultrasound date)
METHOD_TZ DOUBLE Y Contains time zone information of METHOD_DT_TM column
PREGNANCY_ESTIMATE_ID DOUBLE N PRIMARY KEY
PREGNANCY_ID DOUBLE N The pregnancy to which this delivery date estimate is related
PREV_PREG_ESTIMATE_ID DOUBLE N PREVIOUS PRENANCY EST ID OF GROUP
STATUS_FLAG DOUBLE N Indicates finality of the estimate
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_ESTIMATE


Child Column in PREGNANCY_ESTIMATE(FK) Parent Table Name Parent Column Name
Parents: PREV_PREG_ESTIMATE_ID PREGNANCY_ESTIMATE PREGNANCY_ESTIMATE_ID
PREGNANCY_ID PREGNANCY_INSTANCE PREGNANCY_INSTANCE_ID
AUTHOR_ID PRSNL PERSON_ID




Parent Column in PREGNANCY_ESTIMATE (PK) Child Table Name Child Column Name
Children: PREGNANCY_ESTIMATE_ID PREGNANCY_DETAIL PREGNANCY_ESTIMATE_ID
PREGNANCY_ESTIMATE PREV_PREG_ESTIMATE_ID


PREGNANCY_INFORMATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: PREGNANCY INFORMATION
Definition: This table contains key clinical information used in a pregnancy assessment
Table Type: ACTIVITY





Column Detail - PREGNANCY_INFORMATION


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The details saved by clinician is active or not
BEGIN_DT_TM DATETIME N Information entered date and time
ENCNTR_ID DOUBLE N Foreign key to encounter table
END_DT_TM DATETIME Y N/A at this point of time
FILTER_TYPE_TXT VARCHAR(25) Y Filter type would hold the type of the information the clinician saves.
LONG_TEXT_ID DOUBLE N Foreign key to long_text. Pregnancy related Information saved by a Clinician
PERSON_ID DOUBLE N Foreign key to Person table
PREGNANCY_INFORMATION_ID DOUBLE N PRIMARY KEY
PRSNL_ID DOUBLE N Foreign key to prsnl table. User who saved the Pregnancy information
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_INFORMATION


Child Column in PREGNANCY_INFORMATION(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PERSON_ID PERSON PERSON_ID
PRSNL_ID PRSNL PERSON_ID


PREGNANCY_INSTANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Pregnancy Instanceq
Definition: Stores data relating to active and historical pregnancies
Table Type: ACTIVITY





Column Detail - PREGNANCY_INSTANCE


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
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.
CONFIRMED_DT_TM DATETIME Y CONFIRMED DATE TIME
CONFIRMED_TZ DOUBLE Y Contains time zone information of confirmed_dt_tm column
ENCNTR_ID DOUBLE Y Identifier for the encounter table
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.
HISTORICAL_IND DOUBLE N Indicates that a pregnancy was documented as past history and was never an active pregnancy.
ORGANIZATION_ID DOUBLE N SEQUENCE NAME:ORGANIZATION_SEQ This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
OVERRIDE_COMMENT VARCHAR(255) Y Text documenting the reason a pregnancy may not be resolved past its expected end
PERSON_ID DOUBLE N PERSON to which the pregnancy is related
PREGNANCY_ID DOUBLE N Original instance id for a logical grouping representing a single pregnancy
PREGNANCY_INSTANCE_ID DOUBLE N PRIMARY KEY
PREG_END_DT_TM DATETIME Y Date/time the pregnancy was resolved, the presence of this value indicates that a pregnancy is historical rather than a currently active pregnancy
PREG_START_DT_TM DATETIME Y Date/time the pregnancy began
PROBLEM_ID DOUBLE N PROBLEM that generally represents the pregnancy
SENSITIVE_IND DOUBLE N Indicates if the pregnancy needs to be handle according to rules for sensitivity
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.



Relationship Detail - PREGNANCY_INSTANCE


Child Column in PREGNANCY_INSTANCE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
PREGNANCY_ID PREGNANCY_INSTANCE PREGNANCY_INSTANCE_ID
PROBLEM_ID PROBLEM PROBLEM_INSTANCE_ID




Parent Column in PREGNANCY_INSTANCE (PK) Child Table Name Child Column Name
Children: PREGNANCY_INSTANCE_ID PREGNANCY_ACTION PREGNANCY_ID
PREGNANCY_ACTION PREGNANCY_INSTANCE_ID
PREGNANCY_CHILD PREGNANCY_ID
PREGNANCY_CHILD PREGNANCY_INSTANCE_ID
PREGNANCY_ENTITY_R PREGNANCY_ID
PREGNANCY_ENTITY_R PREGNANCY_INSTANCE_ID
PREGNANCY_ESTIMATE PREGNANCY_ID
PREGNANCY_INSTANCE PREGNANCY_ID
PREGNANCY_SEC_LBL PREGNANCY_ID