Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
OBInitialVisit
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) | |
| HCGPosDate | DATE | OPTIONAL | Date when HCG results came out positive. | |
| HCGFlag | CHAR(1) | OPTIONAL | HCG Test flag: 'serum' or 'urine'. | |
| HCGLevel | INTEGER | 0 | OPTIONAL | HCG Test result. |
| UsePCDforEDD | CHAR(1) | OPTIONAL | Use Probable Conception Date for calculating Estimated Delivery Date Flag (Y/N). | |
| PregNote | CHAR(5000) | OPTIONAL | New Pregnancy Note: Free text entered by user on the New Pregnancy Registration form or in the New Pregnancy section of the OB History page of Initial Visit tab. | |
| PMPDate | DATE | OPTIONAL | Previous Mestrual Period date. | |
| MenarcheOnsetAge | INTEGER | 0 | OPTIONAL | Onset Date of Menarche for the patient. |
| MenstrualDuration | INTEGER | 0 | OPTIONAL | Menstrual Duration in days. |
| MenstrualFrequency | INTEGER | 0 | OPTIONAL | Mestrual Frequency in days. |
| MenstrualRegularity | CHAR(1) | OPTIONAL | Menstrual Cycle regular Flag: Regular (R), Irregular (I). | |
| MenstrualNote | CHAR(5000) | OPTIONAL | Menstrual Note: Free text entered by user in the Menstrual History section of the OB History page of Initial Visit. | |
| HusbandBirthWtLB | INTEGER | 0 | OPTIONAL | Lb portion of the husband birth weight. |
| HusbandBirthWtOZ | INTEGER | 0 | OPTIONAL | Oz portion of the husband birth weight. |
| PatientBirthWtLB | INTEGER | 0 | OPTIONAL | Lb portion of the patient birth weight. |
| PatientBirthWtOZ | INTEGER | 0 | OPTIONAL | Oz portion of the patient birth weight. |
| PrevHighBirthWtLB | INTEGER | 0 | OPTIONAL | Lb portion of the highest birth weight in the family. |
| PrevHighBirthWtOZ | INTEGER | 0 | OPTIONAL | Oz portion of the highest birth weight in the family. |
| HxOfTraumaBirth | CHAR(1) | OPTIONAL | History of Traumatic birth in the family Flag: (Y/N). | |
| FamilyOBHxNote | CHAR(5000) | OPTIONAL | Family OB History Note: Free text entered by user in the Family OB History section of the OB History page of Initial Visit. | |
| UAProtein | CHAR(8) | OPTIONAL | UA Dipstick Protein result - Deprecated and moved to OBPrenatalVisit. | |
| UAGlucose | CHAR(8) | OPTIONAL | UA Dipstick Glucose result - Deprecated and moved to OBPrenatalVisit. | |
| UANitrite | CHAR(8) | OPTIONAL | UA Dipstick Nitrite result - Deprecated and moved to OBPrenatalVisit. | |
| 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. 'Y' - If the pregnancy was first handled by a provider outside the practice. | |
| 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). |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| OBEncounter | OBInitialVisit.EncounterSID = OBEncounter.EncounterSID | CASCADE if OBInitialVisit exists |
| Child Table | Join Phrase | When deleting OBInitialVisit record... |
|---|