Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
RxEligPBMResponse
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| RxEligPBMResponseSID | INTEGER | ? | MANDATORY | System generated value from sequence RxEligibility. |
| RxEligRequestSID | INTEGER | ? | MANDATORY | FK - RxEligRequest |
| RxEligPBMSID | INTEGER | ? | MANDATORY | FK - RxEligPBM |
| ApptSID | INTEGER | 0 | OPTIONAL | Denorm from RxEligRequest |
| PracticeID | INTEGER | ? | MANDATORY | PracticeID at the time the RxEligRequest was created. |
| PatientID | INTEGER | ? | MANDATORY | PatientID at the time the RxEligRequest was created. |
| ExpireStamp | CHARACTER(14) | MANDATORY | Timestamp to indicate when the response is no longer valid | |
| PlanName | CHAR(60) | OPTIONAL | name of plan, from subscriber REF segment of response | |
| ResponseChangedData | LOGICAL | MANDATORY | Whether the response indicates an important change, from INS segment of response | |
| PatientNameLast | CHAR(40) | OPTIONAL | Patient last name, from response | |
| PatientNameFirst | CHAR(35) | OPTIONAL | Patient first name, from response | |
| PatientNameMiddle | CHAR(35) | OPTIONAL | Patient middle name, from response | |
| PatientNameSuffix | CHAR(20) | OPTIONAL | Patient middle suffix, from response | |
| PatientAddressLine1 | CHAR(55) | OPTIONAL | Patient address line 1, from response | |
| PatientAddressLine2 | CHAR(55) | OPTIONAL | Patient address line 2, from response | |
| PatientCity | CHAR(20) | OPTIONAL | Patient address city, from response | |
| PatientState | CHAR(2) | OPTIONAL | Patient address state code, from response | |
| PatientZip | CHAR(15) | OPTIONAL | Patient address zip code, from response | |
| PatientCountry | CHAR(3) | OPTIONAL | Patient address country code, from response | |
| PatientDOB | DATE | OPTIONAL | Patient date of birth, from response | |
| PatientSex | CHARACTER(1) | OPTIONAL | Patient gender code (M/F), from response | |
| UniqueMemberID | CHAR(80) | OPTIONAL | Number used by plan to identify patient, from response | |
| RelationToCardholder | CHAR(2) | OPTIONAL | Patient relation to cardholder, from response | |
| CardholderID | CHARACTER(30) | OPTIONAL | Number to identify the cardholder, from response | |
| CardholderName | CHAR(80) | OPTIONAL | LastName, FirstName, from response | |
| GroupID | CHARACTER(30) | OPTIONAL | Number used by plan to identify insurance group, from 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. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| RxEligPBM | RxEligPBMResponse.RxEligPBMSID = RxEligPBM.RxEligPBMSID | CASCADE if RxEligPBMResponse exists |
| RxEligRequest | RxEligPBMResponse.RxEligRequestSID = RxEligRequest.RxEligRequestSID | CASCADE if RxEligPBMResponse exists |
| Child Table | Join Phrase | When deleting RxEligPBMResponse record... |
|---|---|---|
| RxEligMedHistRequest | RxEligMedHistRequest.RxEligPBMResponseSID = RxEligPBMResponse.RxEligPBMResponseSID | CASCADE if RxEligMedHistRequest exists |
| RxEligPBMRespEB | RxEligPBMRespEB.RxEligPBMResponseSID = RxEligPBMResponse.RxEligPBMResponseSID | CASCADE if RxEligPBMRespEB exists |
| RxEligPBMRespPatID | RxEligPBMRespPatID.RxEligPBMResponseSID = RxEligPBMResponse.RxEligPBMResponseSID | CASCADE if RxEligPBMRespPatID exists |