Last Updated: 9/24/2025 12:09:38 PM
Intergy Version: 22.00.00.00
RxChangeRequest
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| RxChangeRequestSID | INTEGER | ? | MANDATORY | PK - System generated sequence id using the RX sequence. |
| PracticeID | INTEGER | ? | MANDATORY | FK - Practice |
| StaffID | INTEGER | ? | OPTIONAL | FK - Staff |
| RxSID | INTEGER | ? | OPTIONAL | FK - PatientRx |
| PatientID | INTEGER | ? | OPTIONAL | FK - Patient |
| MsgControlID | CHAR(35) | OPTIONAL | Header ID of Rx Change message from Pharmacy | |
| ChangeRequestType | CHAR(1) | OPTIONAL | Type of Change Request (T- Therapeutic Interchange, G- Generic Substitution, P- Prior Authorization). Supported by LookupType RxChangeRequestType. | |
| XMLMessageData | CLOB | OPTIONAL | Raw XML message data received from pharmacy | |
| 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. |
| PharmacyID | INTEGER | ? | MANDATORY | FK - Pharmacy |
| RequestDate | DATETIME | OPTIONAL | Change Request DateTime. | |
| RequestStatus | CHAR(1) | OPTIONAL | Change Request Status. Acceptable values are: 0 - New, 2 - processed, 3 - queued. | |
| DenialCode | CHAR(2) | OPTIONAL | Change Request Denial Code. | |
| DenialReason | CHAR(40) | OPTIONAL | Change Request Denial Reason. This is used when custom denial reason is chosen. | |
| MessageType | CHAR(10) | OPTIONAL | Electronic Rx Message version. Lookup code of type eRxScriptVersion | |
| MessageRequestSubCodes | CHAR(30) | OPTIONAL | Delimited list of MessageRequestSubCodes sent when ChangeRequestType is U. Each is Lookup code of type RxChangeRequestSubType |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Patient | RxChangeRequest.PracticeID = Patient.PracticeID and RxChangeRequest.PatientID = Patient.PatientID |
RESTRICT if RxChangeRequest exists |
| PatientRx | RxChangeRequest.RxSID = PatientRx.RxSID | RESTRICT if RxChangeRequest exists |
| Staff | RxChangeRequest.PracticeID = Staff.PracticeID and RxChangeRequest.StaffID = Staff.StaffID |
RESTRICT if RxChangeRequest exists |
| Practice | RxChangeRequest.PracticeID = Practice.PracticeID | RESTRICT if RxChangeRequest exists |
| Child Table | Join Phrase | When deleting RxChangeRequest record... |
|---|