OB_HSB_DELIVERY

Description: |
This table contains information about the delivery for this pregnancy, as entered in Stork's Delivery Summary activity.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
SUMMARY_BLOCK_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | SUMMARY_BLOCK_ID | NUMERIC | No |
The unique ID assigned to the episode record (HSB .1).
2 | OB_DEL_2ND_STAGE_HR | INTEGER | No |
This column stores the length of the second stage of labor in number of hours.
3 | OB_DEL_1ST_STAGE_HR | INTEGER | No |
This column stores the length of the first stage of labor in number of hours.
4 | OB_DEL_1ST_STAGE_M | INTEGER | No |
This column stores the length of the first stage of labor in the number of minutes, and is added to OB_DEL_1ST_STAGE_HR to produce the total time.
5 | OB_DEL_2ND_STAGE_M | INTEGER | No |
This column stores the length of the second stage of labor in the number of minutes, and is added to OB_DEL_2ND_STAGE_HR to produce the total time.
6 | OB_DEL_3RD_STAGE_M | INTEGER | No |
This column stores the length of the third stage of labor in the number of minutes, and is added to OB_DEL_3RD_STAGE_HR to produce the total time.
7 | OB_DEL_BLOOD_LOSS | INTEGER | No |
Stores the amount of blood lost in the delivery, in milliliters.
8 | OB_DEL_COMPL_CMT | VARCHAR | No |
Stores the comments for any complications associated with this delivery.
9 | OB_DEL_REP_PACKETS | INTEGER | No |
Stores the number of suture packets used on a patient during laceration/episiotomy repair from delivery.
10 | OB_DELIVERY_DATE | DATETIME | No |
This item holds the date when this pregnancy was completed. This is the latest date of delivery of all the newborns associated with the pregnancy. This column should not be used to determine the birth date of the baby.
11 | OB_DEL_3RD_STAGE_HR | INTEGER | No |
This column stores the length of the third stage of labor in number of hours.
12 | OB_DEL_CRV_RPE_DTTM | DATETIME (Local) | No |
Stores the date and time when cervical ripening occurred.
13 | OB_DEL_DIL_CMP_DTTM | DATETIME (Local) | No |
Stores the date and time that dilation was complete and/or the mother entered the second stage of labor for this pregnancy.
14 | OB_DEL_ONSET_DTTM | DATETIME (Local) | No |
Stores the date and time that labor began for this pregnancy.
15 | OB_DEL_PRES_REF_C_NAME | VARCHAR | No |
Stores the presentation reference point category number for the delivery. The data for this column are entered in the Delivery Summary activity and stored in the delivery records.
May contain organization-specific values: Yes
16 | OB_DEL_PRES_LR_C_NAME | VARCHAR | No |
Stores the laterality of presentation (left-right) category number for the delivery. Data for this column are entered in the Delivery Summary activity and stored in the delivery records.
May contain organization-specific values: Yes
17 | OB_DEL_PRES_AP_C_NAME | VARCHAR | No |
Stores the anterior or posterior position of presentation category number. The data for this column are entered in the Delivery Summary activity and stored in the delivery records.
May contain organization-specific values: Yes
18 | OB_DEL_CHEST_CIRC | NUMERIC | No |
Stores the baby's chest circumference measurement at birth, in inches.
19 | OB_DEL_ANALGES_CMNT | VARCHAR | No |
Stores the analgesia comments recorded in the Delivery Summary. This information is stored in the delivery records.
20 | OB_DEL_PLCENTA_DTTM | DATETIME (UTC) | No |
Stores the date and time the placenta was delivered. This data is stored in UTC time rather than local time. You may need to convert this data for display in reports. For deliveries documented in the Delivery Summary, the local time can be found in OB_HSB_DELIVERY_2.OB_DEL_PLCENTA_LOC_DTTM.
21 | OB_DEL_DELIV_MD_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
22 | OB_DEL_APGAR_SK_1_C_NAME | VARCHAR | No |
Stores the baby's skin color Apgar score at one minute after birth. This information is stored in the delivery records.
May contain organization-specific values: Yes
Category Entries:
0
1
2
23 | OB_DEL_APGAR_SK_5_C_NAME | VARCHAR | No |
Stores the baby's skin color Apgar score at five minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
24 | OB_DEL_APGAR_SK10_C_NAME | VARCHAR | No |
Stores the baby's skin color Apgar score at ten minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
25 | OB_DEL_APGAR_HR_1_C_NAME | VARCHAR | No |
Stores the baby's heart rate Apgar score at one minute after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
26 | OB_DEL_APGAR_HR_5_C_NAME | VARCHAR | No |
Stores the baby's heart rate Apgar score at five minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
27 | OB_DEL_APGAR_HR10_C_NAME | VARCHAR | No |
Stores the baby's heart rate Apgar score at ten minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
28 | OB_DEL_APGAR_GR_1_C_NAME | VARCHAR | No |
Stores the baby's grimace Apgar score at one minute after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
29 | OB_DEL_APGAR_GR_5_C_NAME | VARCHAR | No |
Stores the baby's grimace Apgar score at five minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
30 | OB_DEL_APGAR_GR10_C_NAME | VARCHAR | No |
Stores the baby's grimace Apgar score at ten minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
31 | OB_DEL_APGAR_MU_1_C_NAME | VARCHAR | No |
Stores the baby's muscle tone Apgar score at one minute after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
32 | OB_DEL_APGAR_MU_5_C_NAME | VARCHAR | No |
Stores the baby's muscle tone Apgar score at five minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
33 | OB_DEL_APGAR_MU10_C_NAME | VARCHAR | No |
Stores the baby's muscle tone Apgar score at ten minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
34 | OB_DEL_APGAR_BR_1_C_NAME | VARCHAR | No |
Stores the baby's breathing Apgar score at one minute after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
35 | OB_DEL_APGAR_BR_5_C_NAME | VARCHAR | No |
Stores the baby's breathing Apgar score at five minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
36 | OB_DEL_APGAR_BR10_C_NAME | VARCHAR | No |
Stores the baby's breathing Apgar score at ten minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
37 | OB_DEL_BIRTH_LENGTH | NUMERIC | No |
Stores the infant's length at birth, in inches.
38 | OB_DEL_BIRTH_WT | NUMERIC | No |
Stores the infant's weight at birth in ounces.
39 | OB_DEL_HEAD_CIRCUM | NUMERIC | No |
Stores the infant's head circumference at birth, in inches. This information is entered in the Delivery Summary activity and is stored in the delivery records.
40 | OB_DEL_APGAR_1_C_NAME | VARCHAR | No |
Stores the baby's total Apgar score at one minute after birth. This information is stored in the delivery records.
May contain organization-specific values: Yes
Category Entries:
0
1
2
3
4
5
6
7
8
9
10
41 | OB_DEL_APGAR_5_C_NAME | VARCHAR | No |
Stores the baby's total Apgar score at five minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_1_C_NAME
42 | OB_DEL_APGAR_10_C_NAME | VARCHAR | No |
Stores the baby's total Apgar score at ten minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_1_C_NAME
43 | OB_DEL_DELIV_METH_C_NAME | VARCHAR | No |
Stores the delivery method at birth. The data for this column are entered in the Delivery Summary activity and stored in the delivery records.
May contain organization-specific values: Yes
Category Entries:
Vaginal, Spontaneous
C-Section, Low Transverse
Vertical C-Section
C-Section, Unspecified
Vaginal, Vacuum (Extractor)
Vaginal, Forceps
Vaginal, Breech
Non-Spontaneous Vaginal Delivery
VBAC, Spontaneous
C-Section, Low Vertical
C-Section, Classical
Biochemical
44 | OB_DEL_ANOMALIES | VARCHAR | No |
Stores the observed fetal anomalies. This information is stored in the delivery records.
45 | OB_DEL_BIRTH_DTTM | DATETIME (UTC) | No |
Stores the date and time of delivery for a delivery record. For values that are not fully confident (for example, if just the year was documented), the confidence is stored in the OB_HX_OUTC_FUZZY_C column. For those values, this column contains the UTC representation of midnight on the earliest date that the value could represent, relative to the time zone where the delivery was documented. This data is stored in UTC time rather than local time. You may need to convert this data for display in reports. For deliveries documented in the Delivery Summary, the local time can be found in PATIENT.BIRTH_DATE.
46 | OB_DEL_DEPT_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
47 | PUSHING_START_DTTM | DATETIME (UTC) | No |
The instant when the mother starts to push for the first time. This data is stored in UTC time rather than local time. You may need to convert this data for display in reports. For deliveries documented in the Delivery Summary, the local time can be found in OB_HSB_DELIVERY_2.PUSHING_START_LOC_DTTM.
48 | ROM_TO_DELIVER | INTEGER | No |
This item displays the amount of time (in seconds) from rupture of membranes until the patient delivers. For pregnancy episodes, if there are multiples, it will calculate the length of time from the earliest rupture instant documented on a delivery record through to the latest delivery instant.
49 | OB_DEL_STEROIDS_C_NAME | VARCHAR | No |
This column displays whether the mother received steroids for fetal lung maturation prior to delivery. This column links to the category table ZC_OB_DEL_STEROIDS. The column is looking for documentation in the Delivery Summary.
May contain organization-specific values: No
Category Entries:
Full Course
Partial Course
None
Unknown
50 | MOTHER_ANTIBIO_YN | VARCHAR | No |
This column displays 'Y' or 'N' depending on whether or not the mother received antibiotics during labor. The column is looking for documentation in the Delivery Summary.
May contain organization-specific values: No
Category Entries:
Yes
No
51 | FORCEPS_DEL_ATT_YN | VARCHAR | No |
This column displays 'Y' or 'N' depending on whether or not a forceps delivery was attempted during this labor. The column is looking for documentation in the Delivery Summary.
May contain organization-specific values: No
Category Entries:
No
Yes
52 | VACUUM_DEL_ATT_YN | VARCHAR | No |
This column displays 'Y' or 'N' depending on whether or not a vacuum delivery was attempted during this labor. The column is looking for documentation in the Delivery Summary.
The category values for this column were already listed for column: FORCEPS_DEL_ATT_YN
53 | LABOR_ATTEMPT_YN | VARCHAR | No |
This column displays 'Y' or 'N' depending on whether or not a trial of labor was attempted. This can apply to both vaginal and c-section deliveries. The column is looking for documentation in the Delivery Summary.
The category values for this column were already listed for column: FORCEPS_DEL_ATT_YN
54 | OB_DEL_APGAR_15_C_NAME | VARCHAR | No |
Stores the baby's total Apgar score at fifteen minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_1_C_NAME
55 | OB_DEL_APGAR_20_C_NAME | VARCHAR | No |
Stores the baby's total Apgar score at twenty minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_1_C_NAME
56 | OB_DEL_APGAR_SK15_C_NAME | VARCHAR | No |
Stores the baby's skin color Apgar score at fifteen minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
57 | OB_DEL_APGAR_HR15_C_NAME | VARCHAR | No |
Stores the baby's heart rate Apgar score at fifteen minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
58 | OB_DEL_APGAR_GR15_C_NAME | VARCHAR | No |
Stores the baby's grimace Apgar score at fifteen minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
59 | OB_DEL_APGAR_MU15_C_NAME | VARCHAR | No |
Stores the baby's muscle tone Apgar score at fifteen minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
60 | OB_DEL_APGAR_BR15_C_NAME | VARCHAR | No |
Stores the baby's breathing Apgar score at fifteen minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
61 | OB_DEL_APGAR_SK20_C_NAME | VARCHAR | No |
Stores the baby's skin color Apgar score at twenty minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
62 | OB_DEL_APGAR_HR20_C_NAME | VARCHAR | No |
Stores the baby's heart rate Apgar score at twenty minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
63 | OB_DEL_APGAR_GR20_C_NAME | VARCHAR | No |
Stores the baby's grimace Apgar score at twenty minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
64 | OB_DEL_APGAR_MU20_C_NAME | VARCHAR | No |
Stores the baby's muscle tone Apgar score at twenty minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
65 | OB_DEL_APGAR_BR20_C_NAME | VARCHAR | No |
Stores the baby's breathing Apgar score at twenty minutes after birth. This information is stored in the delivery records.
The category values for this column were already listed for column: OB_DEL_APGAR_SK_1_C_NAME
66 | OB_HX_GEST_AGE | INTEGER | No |
Stores the pregnancy gestational age (GA) in days for an outcome in OB history.
67 | OB_HX_DEL_SITE_C_NAME | VARCHAR | No |
Stores the delivery site for an outcome in OB history.
May contain organization-specific values: Yes
Category Entries:
Other
68 | OB_HX_CLINICIAN_FT | VARCHAR | No |
Stores the delivering clinician for an outcome in OB history. This is free text.
69 | OB_HX_INFANT_SEX_C_NAME | VARCHAR | No |
Stores the sex of the baby.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Nonbinary
X
Other
70 | OB_HX_OUTC_FUZZY_C_NAME | VARCHAR | No |
This item stores the confidence of the outcome date in OB_DEL_BIRTH_DTTM. If anything less than a full date and time was documented for the outcome date (for example, if just the year was documented), this column indicates how granular the documented value was.
May contain organization-specific values: No
Category Entries:
Year
Month
Date
71 | OB_HX_OUTCOME_C_NAME | VARCHAR | No |
Stores the outcome type for an outcome documented in OB history for a patient.
May contain organization-specific values: No
Category Entries:
Current
Term
Preterm
Abortion
Gravida
Para
Induced Abortion
Spontaneous Abortion
Ectopic
Molar
72 | CONT_START_PAT_DTTM | DATETIME (Local) | No |
This column stores the date and time the contractions started according to the patient.
73 | DILATION_START_DTTM | DATETIME (Local) | No |
This column stores the date and time that active dilation started for the patient.
74 | SKIN_TO_SKIN_DTTM | DATETIME (Local) | No |
Stores the date and time that skin to skin with the baby was initiated.
75 | CORD_CLAMP_DTTM | DATETIME (UTC) | No |
This column stores the instant the umbilical cord was clamped. For deliveries documented in the Delivery Summary, the local time can be found in OB_HSB_DELIVERY_2.CORD_CLAMP_LOC_DTTM.
76 | INDUCTION_DTTM | DATETIME (Local) | No |
This column stores date and time of induction for delivery.
77 | DECISION_DTTM | DATETIME (UTC) | No |
This column stores the instant the decision was made for an emergent c-section. For deliveries documented in the Delivery Summary, the local time can be found in OB_HSB_DELIVERY_2.DECISION_LOC_DTTM.
78 | BREAST_FEED_ST_DTTM | DATETIME (UTC) | No |
This column stores the instant that breastfeeding was initiated. For deliveries documented in the Delivery Summary, the local time can be found in OB_HSB_DELIVERY_2.BREAST_FEED_ST_LOC_DTTM.
79 | SKIN_TO_SKIN_END_DTTM | DATETIME (Local) | No |
Stores the date that skin to skin was completed.
80 | ABDOMINAL_GIRTH | NUMERIC | No |
The measurement of the baby's abdominal girth.