DOCS_RCVD_OB_HX
Description:
This table contains OB History information received from other organizations.

Primary Key
Column Name Ordinal Position
DOCUMENT_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 DOCUMENT_ID NUMERIC No
The unique identifier (.1 item) for the document record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 ADOPTION_TYPE_C_NAME VARCHAR No
Adoption type for this delivery.
May contain organization-specific values: Yes
Category Entries:
Open Adoption
Closed Adoption
Surrogate
Safe Surrender
Gestational Carrier
Traditional Surrogate
Hide Mother's Info
Not Applicable
5 ADOPTION_TYPE_NAME VARCHAR No
Category title for the adoption type for this delivery from the source environment.
6 ANTENAT_STEROIDS_C_NAME VARCHAR No
Antenatal steroids given.
May contain organization-specific values: No
Category Entries:
Full Course
Partial Course
None
Unknown
7 CORD_CLAMP_UTC_DTTM DATETIME (UTC) No
Instant when the cord was clamped.
8 DILA_COMPL_UTC_DTTM DATETIME (UTC) No
Instant when dilation completed.
9 FORCEPS_ATTEMPTED_YN VARCHAR No
Whether delivery by forceps was attempted.
May contain organization-specific values: No
Category Entries:
No
Yes
10 LABOR_ATTEMPTED_YN VARCHAR No
Whether a trial of labor was attempted.
The category values for this column were already listed for column: FORCEPS_ATTEMPTED_YN
11 LABOR_ST_UTC_DTTM DATETIME (UTC) No
Instant when labor began.
12 LABOR_TYPE_C_NAME VARCHAR No
The type of labor for this birth.
May contain organization-specific values: No
Category Entries:
Spontaneous Onset of Labor
Induced Onset of Labor
C-Section Without Labor
13 LIVING_STAT_BIRTH_C_NAME VARCHAR No
Living status of the baby at birth.
May contain organization-specific values: Yes
Category Entries:
Living
Deceased
Neonatal Demise
Fetal Demise
14 PLAC_DEL_UTC_DTTM DATETIME (UTC) No
Instant when the placenta was delivered.
15 LIV_STAT_BIRTH_NAME VARCHAR No
Category title for the living status of the baby at birth from the source environment.
16 PUSH_START_UTC_DTTM DATETIME (UTC) No
Instant when pushing began.
17 RUPTURE_UTC_DTTM DATETIME (UTC) No
Instant when rupture of membranes occurred.
18 RUPT_2_DEL_SEC INTEGER No
Time from rupture of membranes to delivery in seconds.
19 SKIN_2_SK_UTC_DTTM DATETIME (UTC) No
Instant when skin to skin was initiated.
20 VAC_ATTEMPTED_YN VARCHAR No
Whether delivery by vacuum was attempted.
The category values for this column were already listed for column: FORCEPS_ATTEMPTED_YN
21 MOM_DEL_ENC_IDENT VARCHAR No
Maternal delivery encounter associated with the birth.
22 BABY_DEL_ENC_IDENT VARCHAR No
Newborn delivery encounter associated with the birth.
23 MOTHER_ARR_UTC_DTTM DATETIME (UTC) No
Instant when the mother arrived at labor and delivery.
24 CERV_RIPE_UTC_DTTM DATETIME (UTC) No
Cervical ripening instant for this delivery.
25 PREGRAVID_WEIGHT NUMERIC No
Pregravid weight for this delivery.
26 PLAN_DEL_MTHD_C_NAME VARCHAR No
Planned delivery method for this delivery.
May contain organization-specific values: No
Category Entries:
Vaginal
C-Section
TOLAC
27 PLAN_DEL_MTHD_NAME_STR VARCHAR No
Category title for the planned delivery method from the source environment.
28 BABY_LINK_PAT_ID VARCHAR No
The link to the baby that was born.