Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
RxRequest
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| RxRequestSID | INTEGER | ? | MANDATORY | System generated sequence id using the RX sequence. |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| StaffID | INTEGER | ? | OPTIONAL | FK |
| DrugCode | CHARACTER(6) | OPTIONAL | FK | |
| RxSIDToBeRenewed | INTEGER | ? | OPTIONAL | FK |
| PatientID | INTEGER | ? | OPTIONAL | FK |
| ReqStatus | CHARACTER(1) | OPTIONAL | Request status. Acceptable values are: 0 - New, 1 - scanned, 2 - processed, 3 - queued, 4 - Hold. | |
| Priority | CHARACTER(1) | OPTIONAL | Transaction priority. Acceptable values are: 1 - Stat, 2 - Routine, 3 - Overnight. | |
| ReqDate | DATE | OPTIONAL | Request date. | |
| ReqType | CHARACTER(1) | OPTIONAL | Request type. Acceptable values are: 0 - Extend request, 1 - Brand change, 2 - Generic change, 3 - Therapeutic change, 4 - Compound change, 5 - New EDI Rx, 6 - Manual Extend request, 7 - New Manual Rx request | |
| DrugName | CHARACTER(60) | OPTIONAL | Prescribed drug name. | |
| Quantity | DECIMAL(10,3) | OPTIONAL | Prescribed quantity. | |
| Refills | INTEGER | 0 | OPTIONAL | Number of allowable refills. |
| RxDirections | CHARACTER(200) | OPTIONAL | Prescription directions. | |
| 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 | System generated unique id using the Entity sequence. |
| PRNFlag | CHARACTER(1) | OPTIONAL | User-entered indicator to specify if the prescription has refills or is only prescribed on as as needed basis. Supported by lookup type Confirmation. | |
| PatientName | CHAR(200) | MANDATORY | Patient name as supplied by the outside electronic request or as specified manually via Rx submit. This denormalization of name is allowed since the records in the table are deleted once adjudicated by the doctor. | |
| ResponseCode | CHARACTER(20) | OPTIONAL | A code used to identify a prescription denial code. | |
| DenialReason | CHARACTER(40) | OPTIONAL | Description of the denial reason for the prescription. | |
| LockConnectionSID | INTEGER | OPTIONAL | Presence of a value in this field indicates that someone may be working the request. Use this value to look up the corresponding MainWindowConnection record and verify that the STConnectUsr and STConnectTime are valid. | |
| MsgControlID | CHARACTER(35) | OPTIONAL | ||
| RxSIDToBeIssued | INTEGER | ? | OPTIONAL | FK to PatientRx. Indicates which PatientRx will be issued when the Rx request is cosigned. This field is only used for the Rx cosignature workflow. |
| PharmacyNotes | CHAR(210) | OPTIONAL | Prescription Notes to Pharmacy. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| PatientRx | RxRequest.RxSIDToBeIssued = PatientRx.RxSID | SET NULL if RxRequest exists |
| Staff | RxRequest.PracticeID = Staff.PracticeID and RxRequest.StaffID = Staff.StaffID |
NONE if RxRequest exists |
| Patient | RxRequest.PracticeID = Patient.PracticeID and RxRequest.PatientID = Patient.PatientID |
RESTRICT if RxRequest exists |
| PatientRx | RxRequest.RxSIDToBeRenewed = PatientRx.RxSID | SET NULL if RxRequest exists |
| Child Table | Join Phrase | When deleting RxRequest record... |
|---|