SiteID 
Definition  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 

Build 
Definition  Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. 

TouchedBy 
Definition  Information about the user that last updated the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 

TouchedWhen 
Definition  The date and time that the row was last updated and will be based on the Enterprise time zone. 

CreatedBy 
Definition  Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 

CreatedWhen 
Definition  The date and time that the row was created and will be based on the Enterprise time zone. 

Active 
Definition  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 

eRxTransDetailID 
Definition  Auto generated unique primary key value. 

ClientGUID 
Definition  PHI: References GUID for table CV3Client 

ClientVisitGUID 
Definition  PHI: References GUID for table CV3ClientVisit 

TransactionNumber 
Definition  PHI: Unique RxHub transaction ID from BHT03 for the request/response 

TransactionSetNumber 
Definition  PHI: When multiple transactions/benefit coverage are returned for patient, this will be used to identify the sequence number when making one among them active. Value in ST02 usually 01 to N number of transactions returned 

RequestedWhen 
Definition  PHI: Enterprise TimeZone - Datetime when the 270 was requested 

ResponseStatusType 
Definition  An enumerated type with the following list of possible values: 0 = [COMMUNICATION_ERROR],1 = [SUCCESS],2 = [AAA_ERROR],3 = [TA1_ERROR],4 = [NAK_ERROR],5 = [AK_ERROR], 

ResponseMessage 
Definition  PHI: Response message from RXHUB when ResponseStatus is FALSE 

PBMPayerName 
Definition  PHI: Name of PBM/Payer supplying the benefit information; from 271 loop 2100A, NM103 

PBMParticipantNumber 
Definition  PHI: Internal use – required for drug history and new Rx requests; from 271 loop 2100A, NM109 

HealthPlanNumber 
Definition  PHI: ID for the Health Plan; from 271, loop 2100C/D REF02 value, where REF01=”18” 

HealthPlanName 
Definition  PHI: User-recognizable name for the Health Plan; from 271, loop 2100C/D REF03 value, where REF01=”18” 

CardholderNumber 
Definition  PHI: Internal use – required for drug history and new Rx requests; from 271 loop 2100C/D REF02, where REF01=”1W”. 

CardholderName 
Definition  PHI: Internal use – required for drug history and new Rx requests; from 271 loop 2100C/D REF03, where REF01=”1W”. 

PersonCode 
Definition  PHI: An identification number assigned to the siblings within the same family; from 271 loop 2100C/D REF02, where REF01=”49”. 

GroupNumber 
Definition  PHI: Internal use – required for drug history and new Rx requests; from 271 loop 2100C/D REF02, where REF01=”6P” 

GroupName 
Definition  PHI: Internal use – required for drug history and new Rx requests; from 271 loop 2100C/D REF03, where REF01=”6P” 

FormularyListNumber 
Definition  PHI: Internal use – required for drug history and new Rx requests; from 271 loop 2100C/D REF02, where REF01=”IF” 

AlternativeListNumber 
Definition  PHI: Internal use – required for drug history and new Rx requests; from 271 loop 2100C/D REF03, where REF01=”IF” 

CoverageNumber 
Definition  PHI: Use this only when GroupID or CopayID are not there; from 271 loop 2100C/D REF03, where REF01=”1L” 

PayerBIN 
Definition  PHI: Plan Network Identification Number; from 271 loop 2100C/D REF02, where REF01=”N6” 

CopayNumber 
Definition  PHI: Insurance Policy Number, from 271 loop 2100C/D REF03, where REF01=”IG” 

IsMailOrderRxElig 
Definition  PHI: Is patient eligible for mail order benefits under this plan (Y/N/U) – from 271 loop 2110C1/2110D1 where EB03 = “88” and EB01=”1” 

IsRetailRxElig 
Definition  PHI: Is patient eligible forretail benefits under this plan (Y/N/U) – from 271 loop 2110C2/2110D2 where EB03 = “90” and EB01=”1” 

IsSubscriber 
Definition  PHI: Whether patient is a subscriber or a dependent;271 loop 2100C/D INS01=”Y” indicates insured is a subscriber. 

DependentRelationshipCode 
Definition  PHI: From 271 loop 2100D INS02 value when INS01=”N” 01 Spouse 19 Child 21 Unknown 34 Other Adult 

DemogDiffsFlag 
Definition  PHI: Indicator of demographic differences between what was sent in 270 and what PBM/Payer has on file. If there is a difference, user must be notified. True if values in 271, loop 2100C/D, if INS03=”001” and INS04=”25”.
The differences could be in NM1, N3, N4, or DMG 

SubscriberName 
Definition  PHI: Last Name, First name, Middle Name, Suffix – NM103, NM104, NM105, NM107 from 271 loop 2100C 

DependentName 
Definition  PHI: Last Name, First name, Middle Name, Suffix – NM103, NM104, NM105, NM107 from 271 loop 2100D 

PatientAddress 
Definition  PHI: Concatenate for display the values from 271, loop 2100C/D, fields N301, N302, N401, N402, N403. Either dependent or subscriber 

PatientDOB 
Definition  PHI: DMG02 from 271 2100C/D Either dependent or subscriber Date in the format of CCYYMMDD 

PatientGender 
Definition  PHI: DMG03 from 271 2100C/D Either dependent or subscriber F/M/U Female/Male/Unknown 

MemberNumber 
Definition  PHI: Member Identification Number from 271, loop 2100C, NM109 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

MiscellaneousInfoXML 
Definition  PHI: Miscellaneous patient benefit coverage information that may have to be shown. The X12 271 message specification has many optional elements that can occur multiple times. 

IsGeneralCoverageElig 
Definition  PHI: Is General Coverage Eligible 

IsLongTermCareElig 
Definition  PHI: Is Long Term Care Eligible 

IsSpecialtyPharmacyElig 
Definition  PHI: Is Specialty Pharmacy Eligible 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

CardholderLastName 
Definition  PHI: Last Name of the Card holder 

CardholderFirstName 
Definition  PHI: First Name of the Card holder 

CardholderMiddleName 
Definition  PHI: Middle Name of the Card holder 

CardholderSuffix 
Definition  PHI: Prefix Name of the Card holder 

CardholderPrefix 
Definition  PHI: Sufix Name of the Card holder 

CardHolderProcessorID 
Definition  PHI: Processor Identification Number of the Card holder 

RxHubUniqueID 
Definition  PHI: Unique identifier in Rx HUB for eligibility respose 

PartnerMsgID 
Definition  PHI: Partner Message Identifier 

LastRequestSentDtm 
Definition  PHI: Holds date and time of last request sent.