Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
RxEligPBM
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| RxEligPBMSID | INTEGER | ? | MANDATORY | System generated unique ID from RxEligibility sequence. |
| Clearinghouse | CHAR(15) | OPTIONAL | ||
| ClearinghousePBMID | CHAR(20) | OPTIONAL | ID used by the clearinghouse to identify the PBM | |
| PBMName | CHAR(60) | OPTIONAL | As reported by NM1 segment of 271 | |
| 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. |
| RxBenefitsAllowed | LOGICAL | Logical_False | OPTIONAL | This flag indicates whether PBM can support real time prescription benefits. |
| RecordStatus | CHARACTER(1) | Record_Status_Active | OPTIONAL | RecordStatus is defined in the LookupCode table for the lookup type 'RecordStatus.' Codes for lookup type 'RecordStatus' are not user definable. Valid codes are (A)ctive and (I)nactive. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|
| Child Table | Join Phrase | When deleting RxEligPBM record... |
|---|---|---|
| RxEligPBMResponse | RxEligPBMResponse.RxEligPBMSID = RxEligPBM.RxEligPBMSID | CASCADE if RxEligPBMResponse exists |