DOCS_RCVD_PED_VITALS
Description:
Contains pediatric vitals (aka birth history) received through external documents and stored in DXR.

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 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 PED_VITAL_REF_ID VARCHAR No
This item stores the unique reference identifier associated with the pediatric vital.
6 PED_VITAL_SOURCE_VALUE VARCHAR No
This item stores the source value of a received pediatric vital before it is converted.
7 PED_VITAL_SOURCE_UNIT VARCHAR No
This item stores the source unit of a received pediatric vital before it is converted.
8 PED_VITAL_BIRTH_LENGTH_CM NUMERIC No
This item stores the patient birth length (unit is cm).
9 PED_VITAL_BIRTH_WEIGHT_KG NUMERIC No
This item stores the patient weight when discharged after birth (unit is kg).
10 PED_VITAL_BIRTH_HC_IN_CM NUMERIC No
This item stores the patient head circumference at birth (unit is cm).
11 PED_VITAL_APGAR_1_C_NAME VARCHAR No
This item stores the patient APGAR 1 score (0-10).
May contain organization-specific values: Yes
Category Entries:
0
1
2
3
4
5
6
7
8
9
10
12 PED_VITAL_APGAR_5_C_NAME VARCHAR No
This item stores the patient APGAR 5 score (0-10).
The category values for this column were already listed for column: PED_VITAL_APGAR_1_C_NAME
13 PED_VITAL_APGAR_10_C_NAME VARCHAR No
This item stores the patient APGAR 10 score (0-10).
The category values for this column were already listed for column: PED_VITAL_APGAR_1_C_NAME
14 PED_VITAL_GEST_AGE INTEGER No
This item stores the patient gestation age at birth (unit is days).
15 PED_VITAL_NOURISH_HAD_BM_YN VARCHAR No
This item stores the patient was nourished with breast milk at birth.
May contain organization-specific values: No
Category Entries:
No
Yes
16 PED_VITAL_NRSH_MTHD_HAD_FRM_YN VARCHAR No
This item stores the patient was nourished with formula at birth.
The category values for this column were already listed for column: PED_VITAL_NOURISH_HAD_BM_YN
17 PED_VITAL_DELIV_METHOD_C_NAME VARCHAR No
This item stores the patient delivery method.
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
18 PED_VITAL_HOSP_DAYS NUMERIC No
This item stores the duration of the patient stay at birth (unit is days).
19 PED_VITAL_DISCHARGE_WEIGHT_KG NUMERIC No
This item stores the patient weight when discharged after birth (unit is kg).
20 PED_VITAL_MULT_BIRTH_TOTAL_NUM INTEGER No
This item holds the total number of births during the mother's labor and delivery of this newborn patient.
21 PED_VITAL_MULTI_BIRTH_ORDER INTEGER No
For multiple births, the place in the birth order of the current newborn patient.
22 PED_VITAL_SOURCE_DXR_CSN NUMERIC No
This item will store the contact serial number of the DXR record that owns the instance of this ped vital.
23 PED_VITAL_LAST_UPD_DTTM DATETIME (UTC) No
This item stores the instant the vitals were most recently updated.
24 PAT_DEL_UTC_DTTM DATETIME (UTC) No
Patient delivery instant (UTC).
25 PED_VITAL_NOUR_METH_C_NAME VARCHAR No
This item stores the nourishment method for the patient.
May contain organization-specific values: Yes
Category Entries:
Breast Fed
Bottle Fed
Unknown
Not Asked
Bottle Fed - Breast Milk
Bottle Fed - Formula
26 PED_VITAL_LABOR_DURATION VARCHAR No
Stores the duration of labor.
27 PED_VITAL_HOSP_NAME VARCHAR No
This item stores the name of the hospital where the patient was born.
28 PED_VITAL_HOSP_LOC VARCHAR No
This item stores the location of the hospital where born.
29 PED_VITAL_COMMENT VARCHAR No
This item stores the comments for a patient's birth history.