Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
ApptRecall
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ApptRecallSID | INTEGER | ? | MANDATORY | System generated sequence indentifier. It uses the General Sequence to obtain the Id value. |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| PatientID | INTEGER | ? | MANDATORY | FK |
| RecallDate | DATE | MANDATORY | Date of return appointment. | |
| ServiceCenterID | INTEGER | ? | OPTIONAL | FK |
| StaffID | INTEGER | ? | OPTIONAL | FK |
| ReasonCode | CHARACTER(6) | MANDATORY | FK | |
| CurrentStatus | INTEGER | 0 | OPTIONAL | Status of recall. 0 - Pending recall. 1 - Frist notice sent. 2 - Second notice sent. |
| QCDateBasis | INTEGER | 0 | OPTIONAL | Date basis for determing when to trigger recall date. 1 - based on QC history. 2 - based on recall cycle. |
| 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. |
| DMPendingRecallBatchSID | INTEGER | OPTIONAL | FK to DBPendingRecallBatch. Used to indicate who may have generated this recall notice. | |
| ApptRecallGUID | CHAR(36) | OPTIONAL | Globally Unique ID for the ApptRecall Record. | |
| RecordStatus | CHARACTER(6) | Record_Status_Active | OPTIONAL | Record status is (A)ctive or (I)nactive and will be set to Inactive for Recall records that will no longer be sent to the patient. For Patients with a recall method of PAPER or SECMSG, this will be set to Inactive for recalls that have been printed twice. For GPM Patients, this will be set to Inactive when GPM informs the system that the Recall is inactive through the PatientApptRecallStatusUpdate API. |
| Note | CHAR(19000) | OPTIONAL | Internal comment relating to the recall. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| ServiceCenter | ApptRecall.ServiceCenterID = ServiceCenter.ServiceCenterID | RESTRICT if ApptRecall exists |
| Patient | ApptRecall.PracticeID = Patient.PracticeID and ApptRecall.PatientID = Patient.PatientID |
CASCADE if ApptRecall exists |
| Staff | ApptRecall.PracticeID = Staff.PracticeID and ApptRecall.StaffID = Staff.StaffID |
RESTRICT if ApptRecall exists |
| Child Table | Join Phrase | When deleting ApptRecall record... |
|---|