Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
EncounterEvent
Table Definition  Parent Tables  Child Tables
Table DefinitionField | Datatype | Default | Null Option | Comment |
---|---|---|---|---|
EncounterSID | INTEGER | ?   | MANDATORY | System generated unique id using Encounter sequence. |
EventCode | CHARACTER(20) |   | MANDATORY | System set event code. |
CreateStamp | CHARACTER(14) |   | MANDATORY | System generated date/time stamp record was created. |
ChargeSID | INTEGER | ?   | OPTIONAL | System generated id using the Charge sequence. |
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. |
CreateUser | INTEGER | ?   | OPTIONAL | User ID of user that created the record. |
Note | CHARACTER(32000) |   | OPTIONAL | Event note. |
Parent Table | Join Phrase | When deleting parent record... |
---|---|---|
Charge | EncounterEvent.ChargeSID = Charge.ChargeSID | SET NULL if EncounterEvent exists |
Encounter | EncounterEvent.EncounterSID = Encounter.EncounterSID | CASCADE if EncounterEvent exists |
Child Table | Join Phrase | When deleting EncounterEvent record... |
---|