Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
OBEncounter
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| EncounterSID | INTEGER | ? | MANDATORY | System generated unique id using Encounter sequence. |
| RecordStatus | CHARACTER(1) | MANDATORY | Record Status: Active (A), Inactive (I) | |
| VisitType | CHAR(15) | OPTIONAL | Initial Visit Return Visit Post-Partum Visit | |
| FollowupIn | INTEGER | 0 | OPTIONAL | Number of units, as defined by FollowUpUnit |
| FollowupUnit | CHAR(15) | OPTIONAL | Days Weeks Months Years | |
| FollowupType | CHAR(1) | OPTIONAL | Followup Type Flag: Appointment (A), Recall (R), Phone (P). | |
| Comments | CHAR(200) | OPTIONAL | Comments: Free text entered by user on the Postpartum form. | |
| GestationalAge | INTEGER | OPTIONAL | Gestational Age value at the time of that encounter. This value is stored in days and clients reads/writes it in weeks/days. Server code does this conversion. | |
| 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. |
| ClinicalCaseSID | INTEGER | ? | MANDATORY | System generated unique for the records on this table. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| OBPregnancy | OBEncounter.ClinicalCaseSID = OBPregnancy.ClinicalCaseSID | CASCADE if OBEncounter exists |
| Encounter | OBEncounter.EncounterSID = Encounter.EncounterSID | RESTRICT if OBEncounter exists |
| Child Table | Join Phrase | When deleting OBEncounter record... |
|---|---|---|
| OBInitialVisit | OBInitialVisit.EncounterSID = OBEncounter.EncounterSID | CASCADE if OBInitialVisit exists |
| OBInitialVisitFinding | OBInitialVisitFinding.EncounterSID = OBEncounter.EncounterSID | CASCADE if OBInitialVisitFinding exists |
| OBPostpartumVisit | OBPostpartumVisit.EncounterSID = OBEncounter.EncounterSID | CASCADE if OBPostpartumVisit exists |
| OBPrenatalVisit | OBPrenatalVisit.EncounterSID = OBEncounter.EncounterSID | CASCADE if OBPrenatalVisit exists |
| OBUltraSound | OBUltraSound.EncounterSID = OBEncounter.EncounterSID | CASCADE if OBUltraSound exists |