OB_TOTAL

Description: |
This patient information table holds the obstetrics information for each patient history contact. The table contains information on multiple births, induced abortions, spontaneous abortions, ectopics, molars, gravidity, parity, abortions, related comments, full-term, premature, living, and live births. These values are all running totals across the patient's lifetime, calculated at the time of the history contact.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ENC_CSN_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ENC_CSN_ID | NUMERIC | No |
Contact serial number is unique across all patients and all contacts
2 | OB_MULTIPLE_BIRTHS | INTEGER | No |
This column holds the number of multiple births.
3 | OB_THERAPEUTIC_AB | INTEGER | No |
This column holds the number of induced abortions. Along with values in columns OB_SPONTANEOUS_AB and OB_ECTOPICS comprise OB_ABORTIONS.
4 | OB_SPONTANEOUS_AB | INTEGER | No |
This column holds the number of spontaneous abortions. Along with the value in OB_THERAPEUTIC_AB and OB_ECTOPICS, comprise OB_ABORTIONS.
5 | OB_ECTOPICS | INTEGER | No |
This column holds the number of ectopic pregnancies. This number is included with the values in column OB_THERAPEUTIC_AB and OB_SPONTANEOUS_AB to calculate the value in OB_ABORTIONS.
6 | OB_GRAVIDITY | VARCHAR | No |
This column holds the number of total pregnancies for a patient. This column is the sum of the values in columns OB_PARITY and OB_ABORTIONS.
7 | OB_PARITY | VARCHAR | No |
The column contains information regarding how many pregnancies the patient carried past a gestational age (GA) of 24 weeks. The value in this column, along with the value in OB_ABORTIONS, comprises OB_GRAVIDITY.
8 | OB_ABORTIONS | VARCHAR | No |
This item is used to comment on obstetrics abortions reported at each contact. This column along with value in column OB_PARITY, makes up column OB_GRAVIDITY. This item is the sum total of columns OB_THERAPEUTIC_AB, OB_SPONTANEOUS_AB, OB_ECTOPICS.
9 | OB_COMMENT | VARCHAR | No |
This holds general comments for the patient's obstetric history.
10 | OB_FULL_TERM | VARCHAR | No |
This holds the number of full term pregnancies for a patient. Along with the value in column OB_PREMATURE, sums to the value in column OB_PARITY.
11 | OB_PREMATURE | VARCHAR | No |
This items holds the number of pregnancies which ended at a premature gestational age (GA). Along with column OB_FULL_TERM, sums to OB_PARITY.
12 | OB_LIVING | VARCHAR | No |
This item holds the number of the patient's currently living children as documented in the obstetric history.
13 | OB_PREG_HX_C_NAME | VARCHAR | No |
This column indicates whether the patient has a history of pregnancy, or if they have not been asked. It uses category values 1, 2, and 3, which represent the string values, 'Yes', 'No', and 'Not asked' respectively. These string values can be found by linking to table ZC_OB_PREG_HX.
May contain organization-specific values: No
Category Entries:
Yes
No
Not Asked
Defer
Not Currently
Never
14 | OB_LIVE_BIRTHS | VARCHAR | No |
A count of the number of children born alive for a patient.
15 | OB_MOLAR | VARCHAR | No |
The number of molar pregnancies the patient has had.