Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
RxEligMedHistRequest
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| RxEligMedHistRequestSID | INTEGER | ? | MANDATORY | System defined value based on sequence RxEligibility |
| RxEligPBMResponseSID | INTEGER | ? | OPTIONAL | FK - From RxEligPBMResponse |
| PracticeID | INTEGER | ? | MANDATORY | PracticeID at the time the RxEligRequest was created. |
| PatientID | INTEGER | ? | MANDATORY | PatientID at the time the RxEligRequest was created. |
| ProviderID | INTEGER | ? | MANDATORY | FK - From Provider |
| StartDate | DATE | OPTIONAL | Begin date range for desired results | |
| EndDate | DATE | OPTIONAL | End range for desired results | |
| TransmitStamp | CHARACTER(14) | OPTIONAL | Timestamp of the request transmission | |
| ResponseStamp | CHARACTER(14) | OPTIONAL | Timestamp of the response reception | |
| ResponseType | CHARACTER(1) | OPTIONAL | (A)ccepted or (D)enied, from response | |
| MoreHistoryAvailable | LOGICAL | OPTIONAL | Whether the PBM has more history available, from the response | |
| ResponseNote | CHAR(70) | OPTIONAL | free text, from the response | |
| 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. |
| MessageID | CHAR(35) | Set_To_Empty_String | OPTIONAL | Message ID on history check. |
| RxExtMessageSID | INTEGER | ? | OPTIONAL | PK. Uses sequence for RxExtMessage. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| RxExtMessage | RxEligMedHistRequest.RxExtMessageSID = RxExtMessage.RxExtMessageSID | CASCADE if RxEligMedHistRequest exists |
| Provider | RxEligMedHistRequest.ProviderID = Provider.ProviderID | RESTRICT if RxEligMedHistRequest exists |
| RxEligPBMResponse | RxEligMedHistRequest.RxEligPBMResponseSID = RxEligPBMResponse.RxEligPBMResponseSID | CASCADE if RxEligMedHistRequest exists |
| Child Table | Join Phrase | When deleting RxEligMedHistRequest record... |
|---|