Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
OBPregnancy
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ClinicalCaseSID | INTEGER | ? | MANDATORY | System generated unique for the records on this table. |
| RecordStatus | CHARACTER(1) | MANDATORY | Record Status: Active (A), Inactive (I) | |
| PregnancyStatus | CHAR(15) | MANDATORY | (A)ctive (H)istorical or Pregnant, but initial visit not-signed - Only initial visit may be edited Pregnant, initial visit signed - Only return visits may be created/edited Not pregnant, but pregnancy not signed - Only post-partum visits may be created/edited Not pregant, pregnancy signed. - Preganancy may not be edited. | |
| GestationalAge | INTEGER | OPTIONAL | Gestational Age at Delivery time. This is a static value entered on the Delivery Info or Past Pregnancy form. This vlaue is stored in Days but the client reads/writes it in Weeks. Server code does the conversion. (This is to make is consistent with GA in OBEncounter.) | |
| LengthOfLabor | DECIMAL(10,2) | OPTIONAL | Length of Labor in hrs. | |
| BirthCount | INTEGER | OPTIONAL | Number of children delivered. | |
| Anesthesia | CHAR(15) | OPTIONAL | System defined. Type of Anesthesia used. Field is supported by the lookup types:[OBAnesthesia]. Values are defined in the LookupCode table for the above lookup types. | |
| PlaceOfBirth | CHAR(60) | OPTIONAL | Place where delivery happened. | |
| Complications | CHAR(5000) | OPTIONAL | Complications: Free text entered by the user. | |
| Comments | CHAR(5000) | OPTIONAL | Comments: Free text entered as comments on the delivery. | |
| BaseLineWeightLB | INTEGER | 0 | OPTIONAL | Lb portion of the baseline weight of the patient at start of the pregnancy. |
| BaseLineWeightOZ | INTEGER | 0 | OPTIONAL | Oz portion of the baseline weight of the patient at start of the pregnancy. |
| PlannedFacilityID | INTEGER | ? | OPTIONAL | FK - From Service Center table. |
| PlannedDeliveryType | CHAR(15) | OPTIONAL | System defined. Planned Delivery Type to be used. Field is supported by the lookup types:[OBDeliveryType]. Values are defined in the LookupCode table for the above lookup types. | |
| AnesthesiaChoice | CHAR(15) | OPTIONAL | System defined. Choice of type of Anesthesia to be used at the time of delivery. Field is supported by the lookup types:[OBAnesthType]. Values are defined in the LookupCode table for the above lookup types. | |
| TubalLigation | CHAR() | OPTIONAL | Choice for Tubal Ligation at delivery time. | |
| PediatricianID | INTEGER | ? | OPTIONAL | FK - RefDoctor table. |
| Circumcision | CHAR(1) | OPTIONAL | Choice of circumcision at delivery time. | |
| BirthPlanComments | CHAR(5000) | OPTIONAL | Comments for Birthing plan: Free text entered by the user on birthing plan. | |
| BirthPlanUpdatedUser | INTEGER | ? | OPTIONAL | User ID of the user last updated the birthing plan. |
| BirthPlanUpdatedStamp | CHAR(14) | OPTIONAL | Timestamp when the birthing plan was last updated. | |
| LatestEDDSID | INTEGER | ? | OPTIONAL | SID of the history record containing latest EDD. Not linked to OBEDDHistory. If latest EDDSID is deleted, this field needs to be manually updated to point to the new latest EDDSID or set to NULL. DEPRECATED - OBSOLETE - NO LONGER USED |
| LMPDate | DATE | OPTIONAL | Latest Value of the Last Menstual Periods (LMP) Date. | |
| LMPFlag | CHAR(1) | OPTIONAL | LMP Flag: Is Normal (Y), Is not Normal (N). | |
| PCDate | DATE | OPTIONAL | Latest value of Probable Conception Date. | |
| OnBCP | CHAR(1) | OPTIONAL | On Birth Control Pills Flag (Y/N). | |
| HCGPosDate | DATE | OPTIONAL | Date when the HCG test came out positive. | |
| HCGFlag | CHAR(1) | OPTIONAL | Type of HCG test done: 'urine' or 'serum'. | |
| HCGLevel | INTEGER | 0 | OPTIONAL | HCG Test result. |
| UpdatedUser | INTEGER | ? | OPTIONAL | User ID of user who last udated this record. |
| UpdatedStamp | CHAR(14) | OPTIONAL | Timestamp when this record was last updated. | |
| TMSCatalogSID | INTEGER | ? | OPTIONAL | System generated document identifier. The identifier value is obtained from the DOCUMENT sequence. |
| TimeStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was last written. | |
| LastUser | INTEGER | ? | OPTIONAL | User ID of user that last wrote the record. |
| CreateStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was created. | |
| CreateUser | INTEGER | ? | OPTIONAL | User ID of user that created the record. |
| TransferredCareInFlag | CHAR(1) | OPTIONAL | User entered. This field is Y if the pregnancy was first handled by a provider outside the practice. | |
| TransferCareOutDate | DATE | OPTIONAL | Date care transferred to another practice | |
| TransferCareOutComment | CHAR(5000) | OPTIONAL | Comment associated with transfer of care to another practice | |
| PrimaryProviderID | INTEGER | ? | OPTIONAL | FK |
| MultipleFHRFlag | CHARACTER(1) | OPTIONAL | Y/N flag indicating fetal heart rate for 2 fetuses | |
| InitialCareDate | DATE | ? | OPTIONAL | Date prenatal care was started (even if outside the practice). This is used for FPAR reporting, Table 6B, Section B (as of 2008 spec). |
| DeliveryProviderID | INTEGER | ? | OPTIONAL | The provider that delivered the baby. FK - From Provider |
| PartnerName | CHAR(60) | OPTIONAL | Partner name for the current pregnancy (Optional). | |
| PartnerRelToPatient | CHAR(50) | OPTIONAL | Partner relationship to patient. | |
| HaveMetPartner | CHAR(20) | OPTIONAL | Free-form text field for data relating to whether the provider has met the partner. | |
| PartnerPhoneNumber | CHAR(20) | OPTIONAL | Free-form text field for partner contact phone information. | |
| DeliveryProviderName | CHAR(60) | OPTIONAL | The free text entered name of provider that delivered the baby when no ProviderID reference was available in the database. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Provider | OBPregnancy.DeliveryProviderID = Provider.ProviderID | SET NULL if OBPregnancy exists |
| RefDoctor | OBPregnancy.PrimaryProviderID = RefDoctor.RefDoctorID | SET NULL if OBPregnancy exists |
| TMSCatalog | OBPregnancy.TMSCatalogSID = TMSCatalog.CatalogSID | SET NULL if OBPregnancy exists |
| ServiceCenter | OBPregnancy.PlannedFacilityID = ServiceCenter.ServiceCenterID | SET NULL if OBPregnancy exists |
| RefDoctor | OBPregnancy.PediatricianID = RefDoctor.RefDoctorID | SET NULL if OBPregnancy exists |
| ClinicalCase | OBPregnancy.ClinicalCaseSID = ClinicalCase.ClinicalCaseSID | CASCADE if OBPregnancy exists |
| Child Table | Join Phrase | When deleting OBPregnancy record... |
|---|---|---|
| OBPregnancyActivity | OBPregnancyActivity.ClinicalCaseSID = OBPregnancy.ClinicalCaseSID | CASCADE if OBPregnancyActivity exists |
| OBEncounter | OBEncounter.ClinicalCaseSID = OBPregnancy.ClinicalCaseSID | CASCADE if OBEncounter exists |
| OBPatient | OBPatient.CurrentPregnancySID = OBPregnancy.ClinicalCaseSID | CASCADE if OBPatient exists |
| OBBirth | OBBirth.ClinicalCaseSID = OBPregnancy.ClinicalCaseSID | CASCADE if OBBirth exists |