Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Appointment
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ApptSID | INTEGER | ? | MANDATORY | System generated unique number using the Appointment sequence. |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| ServiceCenterID | INTEGER | ? | MANDATORY | FK |
| EncounterSID | INTEGER | ? | OPTIONAL | System generated unique id using Encounter sequence. |
| PatientID | INTEGER | ? | OPTIONAL | FK |
| ApptDate | DATE | MANDATORY | User entered date of appointment. | |
| ApptTime | INTEGER | 0 | MANDATORY | User entered appointment time. |
| ApptClass | CHARACTER(6) | OPTIONAL | User selects appointment class. Appointment classes are defined in the LookupCode table for the lookup type 'ApptClass'. Codes for lookup type 'ApptClass' are user definable. | |
| ReasonCode | CHARACTER(6) | OPTIONAL | Valid reason number which corresponds to the patient's appointment. | |
| Note | CHAR(32000) | OPTIONAL | User entered note for the appointment. | |
| ApptStatus | CHARACTER(1) | MANDATORY | System set status of the appointment. Values are obtained from the lookup type 'ApptStatus'. | |
| 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. |
| ReferralSID | INTEGER | ? | OPTIONAL | System generated unique number using the ReferralSID. |
| RescheduledApptSID | INTEGER | ? | OPTIONAL | System Defined - Original apptSID when an appointment is rescheduled. ? if appointment is not from a rescheduled appointment. |
| WriteIn | CHARACTER(50) | OPTIONAL | This field holds the name of the entity that has a write-in appointment. | |
| HL7Updated | CHARACTER(1) | OPTIONAL | This field indicates if HL7 has processed this table entry and will be used by the DB triggers. values "Y" or "N". | |
| VoidedEncounterSID | INTEGER | ? | OPTIONAL | Encounter FK when linked Encounter is voided. |
| TelehealthVisit | LOGICAL | Logical_False | OPTIONAL | Indicates if an appointment is a Telehealth Visit or not. |
| CreateStampUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the CreateStamp. This field contains the Date, Time and timezone offset. | |
| 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... |
|---|---|---|
| Encounter | Appointment.VoidedEncounterSID = Encounter.EncounterSID | SET NULL if Appointment exists |
| Referral | Appointment.ReferralSID = Referral.ReferralSID | RESTRICT if Appointment exists |
| Practice | Appointment.PracticeID = Practice.PracticeID | CASCADE if Appointment exists |
| Patient | Appointment.PracticeID = Patient.PracticeID and Appointment.PatientID = Patient.PatientID |
RESTRICT if Appointment exists |
| Encounter | Appointment.EncounterSID = Encounter.EncounterSID | SET NULL if Appointment exists |
| Child Table | Join Phrase | When deleting Appointment record... |
|---|---|---|
| RxEligRequest | RxEligRequest.ApptSID = Appointment.ApptSID and RxEligRequest.PracticeID = Appointment.PracticeID and RxEligRequest.ServiceCenterID = Appointment.ServiceCenterID |
NONE if RxEligRequest exists |
| ApptQuestionnaire | ApptQuestionnaire.ApptSID = Appointment.ApptSID and ApptQuestionnaire.PracticeID = Appointment.PracticeID and ApptQuestionnaire.ServiceCenterID = Appointment.ServiceCenterID |
CASCADE if ApptQuestionnaire exists |
| RISStudy | RISStudy.ApptSID = Appointment.ApptSID and RISStudy.PracticeID = Appointment.PracticeID and RISStudy.ServiceCenterID = Appointment.ServiceCenterID |
RESTRICT if RISStudy exists |
| Eligibility | Eligibility.ApptSID = Appointment.ApptSID and Eligibility.PracticeID = Appointment.PracticeID and Eligibility.ServiceCenterID = Appointment.ServiceCenterID |
CASCADE if Eligibility exists |
| ApptStaff | ApptStaff.ApptSID = Appointment.ApptSID and ApptStaff.PracticeID = Appointment.PracticeID and ApptStaff.ServiceCenterID = Appointment.ServiceCenterID |
CASCADE if ApptStaff exists |
| ApptRoom | ApptRoom.ApptSID = Appointment.ApptSID and ApptRoom.PracticeID = Appointment.PracticeID and ApptRoom.ServiceCenterID = Appointment.ServiceCenterID |
CASCADE if ApptRoom exists |