Last Updated: 9/24/2025 12:09:38 PM
Intergy Version: 22.00.00.00
OBUltrasoundFetus
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| UltrasoundSID | INTEGER | ? | MANDATORY | FK - OBUltrasound |
| FetalNumber | INTEGER | MANDATORY | Fetal number: 1, 2, 3 ... | |
| RecordStatus | CHARACTER(1) | MANDATORY | ||
| GSMeanDia | DECIMAL(10,2) | OPTIONAL | GS Meqn Diameter in mm. | |
| YolkSacDia | DECIMAL(10,2) | OPTIONAL | Yolk Sac Diameter in mm. | |
| Tm1CardiacActivity | CHAR(1) | OPTIONAL | Fetal Cardiac Activity (Y/N/ |
|
| Tm1CardiacRate | INTEGER | OPTIONAL | Fetal Cardiac Rate (bpm) for 1st Trimester. | |
| CrownRumpLen | DECIMAL(10,2) | OPTIONAL | Fetal Crown Rump Length (mm). | |
| Position | CHAR(15) | OPTIONAL | Fetal Position: vertex, breech, transverse, oblique. | |
| Movement | CHAR(1) | OPTIONAL | Fetal Movement: Positive (P) / none seen (N). | |
| CardiacActivity | CHAR(1) | OPTIONAL | 2nd/3rd Trimester Fetal Cardiac Activity: Positive (P) / Negative (N). | |
| CardiacRate | INTEGER | OPTIONAL | 2nd/3rd Trimester Fetal Cardiac Rate (bpm). | |
| AmnioticFluid | CHAR(1) | OPTIONAL | Fetal Amniotic Fluid: Normal (N), Decreased (D) or Increased (I). | |
| PlacentaPosition | CHAR(15) | OPTIONAL | Fetal Placenta position: Look up code. | |
| Previa | CHAR(1) | OPTIONAL | Previa: Not Present (N), Partial (P), Complete (C). | |
| BiparietalDia | DECIMAL(10,2) | OPTIONAL | Biparietal diameter (cm). | |
| HeadCircum | DECIMAL(10,2) | OPTIONAL | Head Circumference (cm) | |
| FemurLength | DECIMAL(10,2) | OPTIONAL | Femur Length (cm). | |
| AbdominalCircum | DECIMAL(10,2) | 0 | OPTIONAL | Fetal Abdominal Circumference (cm). |
| EstWeight | INTEGER | OPTIONAL | Estimated Weight (gm). | |
| 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. |
| PlacentalGrade | CHAR(8) | OPTIONAL | Placental Grade (LookupType = OBPlacentalGrade) | |
| Gender | CHAR(1) | OPTIONAL | User selects gender code of fetus. Gender codes are defined in the LookupCode table for the lookup type 'Gender'. Codes for lookup type 'Gender' are not user definable. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| OBUltraSound | OBUltrasoundFetus.UltrasoundSID = OBUltraSound.UltrasoundSID | CASCADE if OBUltrasoundFetus exists |
| Child Table | Join Phrase | When deleting OBUltrasoundFetus record... |
|---|