Last Updated: 9/24/2025 12:09:38 PM
Intergy Version: 22.00.00.00
PatientRxFill
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PatientRxFillSID | INTEGER | ? | MANDATORY | System generated sequence id using the RX sequence. |
| PracticeID | INTEGER | ? | MANDATORY | FK from Practice |
| StaffID | INTEGER | ? | OPTIONAL | FK from Staff |
| MsgControlID | CHAR(35) | OPTIONAL | The Header ID of the Rx Fill message received from pharmacy. | |
| RxSID | INTEGER | ? | OPTIONAL | FK from PatientRx table. |
| FillStatus | CHAR(2) | OPTIONAL | Fill status of prescription. Supported by lookup type RxFillStatus. | |
| FillStatusNote | CHAR(70) | OPTIONAL | Pharmacy supplied note related to the fill status. | |
| FillReasonCode | CHAR(2) | OPTIONAL | Pharmacy supplied reason code when fill status is not filled. Supported by RxFillReasonCode lookup type. | |
| FillStatusDateTime | DATETIME | OPTIONAL | The date and time the fill status was sent by the pharmacy. | |
| XMLMessageData | CLOB | OPTIONAL | Raw message data in format 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. |
| MessageType | CHAR(10) | OPTIONAL | Electronic Rx Message version. Lookup code of type eRxScriptVersion |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| PatientRx | PatientRxFill.RxSID = PatientRx.RxSID | CASCADE if PatientRxFill exists |
| Staff | PatientRxFill.PracticeID = Staff.PracticeID and PatientRxFill.StaffID = Staff.StaffID |
CASCADE if PatientRxFill exists |
| Practice | PatientRxFill.PracticeID = Practice.PracticeID | CASCADE if PatientRxFill exists |
| Child Table | Join Phrase | When deleting PatientRxFill record... |
|---|---|---|
| PatientRxFillAttribute | PatientRxFillAttribute.PatientRxFillSID = PatientRxFill.PatientRxFillSID | CASCADE if PatientRxFillAttribute exists |