Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
EncounterVitalSet
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| EncounterVitalSetSID | INTEGER | ? | MANDATORY | System-generated unique identifier of the vital. Uses 'Vitals' sequence. |
| EncounterSID | INTEGER | ? | MANDATORY | FK - From Encounter |
| RecordStatus | CHARACTER(1) | Record_Status_Active | MANDATORY | Status of the vital record. Allowed values must be defined in RecordStatus lookup type. Default value is 'A'. |
| VitalDate | DATE | ? | MANDATORY | Date vitals were taken. |
| VitalTime | INTEGER | ? | OPTIONAL | Time vitals were taken. |
| Note | CHARACTER(500) | OPTIONAL | Note about the set of vitals (e.g. patient was nervous). | |
| 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. |
| NoteStamp | CHARACTER(14) | OPTIONAL | Date time stamp when the Vital Note gets added/updated. This will be blank for all existing data prior to 5.00.00. Use the TimeStamp value instead. | |
| VitalDateTimeUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the VitalDate and VitalTime. This field contains the Date, Time and timezone offset. | |
| VitalPregnantEDD | DATE | ? | OPTIONAL | VitalPregnantEDD that is associated with this EncounterVitalSet |
| IsPatientPregnant | LOGICAL | Logical_False | OPTIONAL | Deprecated (since Intergy 21.35), use PregnancyStatus |
| TimeStampUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the TimeStamp. This field contains the Date, Time and timezone offset. | |
| VitalSource | CHARACTER(10) | OPTIONAL | Stores the name of the source that created the vitals | |
| PregnancyStatus | CHAR(15) | OPTIONAL | Describes patient's current pregnancy state. Field is supported by Lookup Type: [PregnancyStatus], which is derived from ValueSet: [US Core Pregnancy Status Codes]. Values are defined in the LookupCode table for the above lookup types. | |
| PregnancyIntent | CHAR(15) | OPTIONAL | Describes patient's intent to become pregnant within a year. Field is supported by Lookup Type: [PregnancyIntent], which is derived from ValueSet: [US Core Pregnancy Intent Codes]. Values are defined in the LookupCode table for the above lookup types. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Encounter | EncounterVitalSet.EncounterSID = Encounter.EncounterSID | CASCADE if EncounterVitalSet exists |
| Child Table | Join Phrase | When deleting EncounterVitalSet record... |
|---|---|---|
| EncounterVital | EncounterVital.EncounterVitalSetSID = EncounterVitalSet.EncounterVitalSetSID | CASCADE if EncounterVital exists |