Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
OBUltraSound
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| UltrasoundSID | INTEGER | ? | MANDATORY | System generated unique identifier for records in this table. SID is generated using the OBChart sequence. |
| RecordStatus | CHARACTER(1) | MANDATORY | Record Status: Active (A), Inactive (I) | |
| EncounterSID | INTEGER | ? | MANDATORY | System generated unique id using Encounter sequence. |
| FacilityID | INTEGER | OPTIONAL | Facility ID. | |
| USDate | DATE | OPTIONAL | Ultrasound Date. | |
| USTypeTrans | CHAR(1) | OPTIONAL | Transvaginal Ultrasound: Y/N flag. | |
| USTypeAbd | CHAR(1) | OPTIONAL | Ultrasound for Abdomin: Y/N flag. | |
| ImageSID | INTEGER | OPTIONAL | Image SID - external image unique. | |
| NumGestSacs | INTEGER | OPTIONAL | Numbers of Gestational sacs. | |
| FetalCount | INTEGER | 0 | OPTIONAL | Number of Fetuses. |
| GestationalAge | INTEGER | OPTIONAL | Gestational Age. | |
| GABasisGSDiam | CHAR(1) | OPTIONAL | Y/N flag: Gestational Age (GA) Basis is GS Diameter. | |
| GABasisCRL | CHAR(1) | OPTIONAL | Y/N flag: Gestational Age (GA) Basis is Crown Rump Length (CRL). | |
| GABasisBPD | CHAR(1) | OPTIONAL | Y/N flag: Gestational Age (GA) Basis is Biparietal Diameter (PBD). | |
| GABasisFL | CHAR(1) | OPTIONAL | Y/N flag: Gestational Age (GA) Basis is Femur Length (FL). | |
| PredictedEDD | DATE | OPTIONAL | Predicted Estimated Date of Delivery. | |
| Comments | CHAR(5000) | OPTIONAL | Ultrasound comments: Free text entered by the user. | |
| CranialContentsFlag | CHAR(1) | OPTIONAL | N/P/A flag values for Normal, Poorly visualized and Abnormal. | |
| FaceFlag | CHAR(1) | OPTIONAL | N/P/A flag values for Normal, Poorly visualized and Abnormal. | |
| HeartViewFlag | CHAR(1) | OPTIONAL | N/P/A flag values for Normal, Poorly visualized and Abnormal. | |
| AortaFlag | CHAR(1) | OPTIONAL | N/P/A flag values for Normal, Poorly visualized and Abnormal. | |
| StomachFlag | CHAR(1) | OPTIONAL | N/P/A flag values for Normal, Poorly visualized and Abnormal. | |
| DiaphragmFlag | CHAR(1) | OPTIONAL | N/P/A flag values for Normal, Poorly visualized and Abnormal. | |
| KidneyFlag | CHAR(1) | OPTIONAL | N/P/A flag values for Normal, Poorly visualized and Abnormal. | |
| BladderFlag | CHAR(1) | OPTIONAL | N/P/A flag values for Normal, Poorly visualized and Abnormal. | |
| CordInsertionFlag | CHAR(1) | OPTIONAL | N/P/A flag values for Normal, Poorly visualized and Abnormal. | |
| VesselCordFlag | CHAR(1) | OPTIONAL | N/P/A flag values for Normal, Poorly visualized and Abnormal. | |
| SpineFlag | CHAR(1) | OPTIONAL | N/P/A flag values for Normal, Poorly visualized and Abnormal. | |
| RadiusUlnaFlag | CHAR(1) | OPTIONAL | N/P/A flag values for Normal, Poorly visualized and Abnormal. | |
| UpperExtremFlag | CHAR(1) | OPTIONAL | N/P/A flag values for Normal, Poorly visualized and Abnormal. | |
| LowerExtremFlag | CHAR(1) | OPTIONAL | N/P/A flag values for Normal, Poorly visualized and Abnormal. | |
| AmniFluidIndex | INTEGER | OPTIONAL | Amniotic Fluid Index (cm) | |
| NonStressTestFlag | CHAR(1) | OPTIONAL | Non ReactiveTest flag: Values R (Reactive) and N (Non-Reactive). | |
| AmniFluidScore | CHAR(1) | OPTIONAL | Amniotic Fluid Score - 0/2. | |
| GrossMovScore | CHAR(1) | OPTIONAL | Gross Movement Score - 0/2. | |
| BreathMovScore | CHAR(1) | OPTIONAL | Breathing Movement Score: 0/2. | |
| FetalToneScore | CHAR(1) | OPTIONAL | Fetal Tone Score: 0/2. | |
| NonStressScore | CHAR(1) | OPTIONAL | Non-stress test score: 0/2. | |
| UpdatedUser | INTEGER | ? | OPTIONAL | User ID of user who last updated this record. |
| UpdatedStamp | CHARACTER(14) | OPTIONAL | Timestamp when this record was updated last. | |
| 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... |
|---|---|---|
| OBEncounter | OBUltraSound.EncounterSID = OBEncounter.EncounterSID | CASCADE if OBUltraSound exists |
| Child Table | Join Phrase | When deleting OBUltraSound record... |
|---|---|---|
| OBUltrasoundFetus | OBUltrasoundFetus.UltrasoundSID = OBUltraSound.UltrasoundSID | CASCADE if OBUltrasoundFetus exists |