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.