Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
ProcedureEvent
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ProcedureEventSID | INTEGER | ? | MANDATORY | System generated id using the ProcedureEvent sequence. |
| ChargeSID | INTEGER | ? | OPTIONAL | FK |
| AilmentSID | INTEGER | ? | OPTIONAL | FK |
| ProcedureCode | CHARACTER(10) | MANDATORY | FK | |
| Source | CHARACTER(1) | MANDATORY | The source flag is used to indicate which entity parented the procedure event. Possible values are (C)harge or (E)ncounter. | |
| EncounterSID | INTEGER | ? | OPTIONAL | FK |
| ReferralSID | INTEGER | ? | OPTIONAL | System generated unique number using the ReferralSID. |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| StaffID | INTEGER | ? | MANDATORY | FK |
| SupervisingStaffID | INTEGER | ? | OPTIONAL | FK |
| ServiceCenterID | INTEGER | ? | OPTIONAL | FK |
| Units | DECIMAL(10,3) | 0 | MANDATORY | Number of times the procedure was performed or the quantity of a supply or drug. |
| DurationType | CHARACTER(1) | OPTIONAL | Duration type is set to either (M)inutes, (H)ours or (D)ays. The duration type is supported by the lookup type DurationType. | |
| Duration | INTEGER | 0 | OPTIONAL | Length in time procedure took to perform (time is stored as seconds). |
| TOSCode | CHARACTER(3) | OPTIONAL | FK | |
| FromServiceDate | DATE | OPTIONAL | Service date charge started from. | |
| ToServiceDate | DATE | OPTIONAL | Service date charge ended at. | |
| StartTime | INTEGER | 0 | OPTIONAL | User entered start time of procedure (time is stored as seconds since midnight). |
| StopTime | INTEGER | 0 | OPTIONAL | User entered stop time of procedure (time is stored as seconds since midnight). |
| Voided | CHARACTER(1) | OPTIONAL | Programmatically set flag to indicate that the procedure event was voided when the associated charge was voided. Possible values are (Y)es or (N)o. | |
| 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. |
| FamilyPlanning | CHARACTER(1) | OPTIONAL | Indicates if the procedure is due to family planning requirements. Validate through the confirmation lookup type: Possible values: (Y)es (N)o | |
| EPSDT | CHAR(1) | OPTIONAL | Indicates if the procedure is due to screening requirements. Validate through the confirmation lookup type: Possible values: (Y)es (N)o | |
| MinutesPerUnit | INTEGER | 0 | OPTIONAL | Records the minutes per unit used during Charge Posting. |
| ReductionPercent | DECIMAL(10,2) | OPTIONAL | Records the reduction percent used during Charge Posting. | |
| PatientID | INTEGER | ? | OPTIONAL | FK |
| POSCode | CHARACTER(3) | MANDATORY | FK | |
| EPSDTReferral | CHAR(2) | OPTIONAL | Records the EPSDT Referral value from charge posting. Validated through the EPSDTRefCode lookup. | |
| TimeStampUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the TimeStamp. This field contains the Date, Time and timezone offset. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Patient | ProcedureEvent.PracticeID = Patient.PracticeID and ProcedureEvent.PatientID = Patient.PatientID |
NONE if ProcedureEvent exists |
| Procedure | ProcedureEvent.ProcedureCode = Procedure.ProcedureCode | RESTRICT if ProcedureEvent exists |
| Charge | ProcedureEvent.ChargeSID = Charge.ChargeSID | CASCADE if ProcedureEvent exists |
| Ailment | ProcedureEvent.AilmentSID = Ailment.AilmentSID | RESTRICT if ProcedureEvent exists |
| ServiceCenter | ProcedureEvent.ServiceCenterID = ServiceCenter.ServiceCenterID | RESTRICT if ProcedureEvent exists |
| Staff | ProcedureEvent.PracticeID = Staff.PracticeID and ProcedureEvent.StaffID = Staff.StaffID |
RESTRICT if ProcedureEvent exists |
| Encounter | ProcedureEvent.EncounterSID = Encounter.EncounterSID | SET NULL if ProcedureEvent exists |
| Staff | ProcedureEvent.PracticeID = Staff.PracticeID and ProcedureEvent.SupervisingStaffID = Staff.StaffID |
RESTRICT if ProcedureEvent exists |
| Referral | ProcedureEvent.ReferralSID = Referral.ReferralSID | SET NULL if ProcedureEvent exists |
| Child Table | Join Phrase | When deleting ProcedureEvent record... |
|---|---|---|
| ProcedureEventDiag | ProcedureEventDiag.ProcedureEventSID = ProcedureEvent.ProcedureEventSID | CASCADE if ProcedureEventDiag exists |