Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
OBPatient
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PracticeID | INTEGER | ? | MANDATORY | FK - Practice table. |
| PatientID | INTEGER | ? | MANDATORY | FK - Patient table. |
| RecordStatus | CHAR(1) | MANDATORY | Record Status: Active (A), Inactive (I) | |
| PregTotal | INTEGER | 0 | OPTIONAL | User entered total number of pregnancies. |
| PregFullTerm | INTEGER | 0 | OPTIONAL | User entered: Number of pregnancies that lasted full term. |
| PregPremature | INTEGER | 0 | OPTIONAL | User entered: Number of pregnancies ended prematurely. |
| PregAbortionInduced | INTEGER | 0 | OPTIONAL | User entered: Number of induced abortions. |
| PregAbortionSpont | INTEGER | 0 | OPTIONAL | User entered: Number of spontaneous abortions. |
| PregEctopic | INTEGER | 0 | OPTIONAL | User entered: Number of ectopic pregnancies. |
| PregMultipleBirths | INTEGER | 0 | OPTIONAL | User entered: Pregnancies ended with multiple births. |
| PregLiving | INTEGER | 0 | OPTIONAL | User entered: Number of children living. |
| BirthingPlanFlag | CHAR(1) | OPTIONAL | User entered: Flag to indicate that birthing plan is on file. Values are (Y/N). | |
| CurrentPregnancySID | INTEGER | ? | OPTIONAL | FK - ClinicalCaseSID From OBPregnancy for the current pregnancy. Null for non-pregnancy patient. |
| PrevPregEndDate | DATE | OPTIONAL | End date of the previous pregnancy. This is a sting in YYYYMMDD format and is kept here fore quick access. | |
| UpdatedStamp | CHARACTER(14) | OPTIONAL | Time stamp when this record was last updated . | |
| UpdatedUser | INTEGER | ? | OPTIONAL | User Id of the user who last updated it. |
| 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. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| OBPregnancy | OBPatient.CurrentPregnancySID = OBPregnancy.ClinicalCaseSID | CASCADE if OBPatient exists |
| Patient | OBPatient.PracticeID = Patient.PracticeID and OBPatient.PatientID = Patient.PatientID |
CASCADE if OBPatient exists |
| Child Table | Join Phrase | When deleting OBPatient record... |
|---|