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. 

PharmacyID 
Definition  Auto generated unique primary key value. 

PharmacyName 
Definition  Name of the pharmacy 

Address1 
Definition  Line 1 of the pharmacy's address. 

Address2 
Definition  Line 2 of the pharmacy's address. 

City 
Definition  City of the pharmacy's address. 

CountryDvsnCode 
Definition  State/Province of the pharmacy's address. 

PostalCode 
Definition  Postal Code of the pharmacy's address 

PhoneAreaCode 
Definition  Area code of the pharmacy's phone number. 

PhoneNumber 
Definition  Phone number for the pharmacy. 

FaxAreaCode 
Definition  Area code of the pharmacy's fax number. 

FaxNumber 
Definition  Fax number for the pharmacy. 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

NCPDPID 
Definition  Sure Scripts defined Pharmacy ID 

StoreNumber 
Definition  Store number information for the pharmacy. 

Email 
Definition  Email address for the pharmacy. 

PhoneAlt1 
Definition  Alternate phone number 1 

PhoneAlt1Qualifier 
Definition  Alternate phone number 1 qualifier 

PhoneAlt2 
Definition  Alternate phone number 2 

PhoneAlt2Qualifier 
Definition  Alternate phone number 2 qualifier 

PhoneAlt3 
Definition  Alternate phone number 3 

PhoneAlt3Qualifier 
Definition  Alternate phone number 3 qualifier 

PhoneAlt4 
Definition  Alternate phone number 4 

PhoneAlt4Qualifier 
Definition  Alternate phone number 4 qualifier 

PhoneAlt5 
Definition  Alternate phone number 5 

PhoneAlt5Qualifier 
Definition  Alternate phone number 5 qualifier 

ActiveStartTime 
Definition  Enterprise TimeZone - Pharmacy start time. 

ActiveEndTime 
Definition  Enterprise TimeZone - Pharmacy close time. 

ServiceLevel 
Definition  Service level code used to determine messaging capabilities. 

PartnerAccount 
Definition  Pharmacy trading partner account. 

LastModifiedDate 
Definition  Enterprise TimeZone - Date of last pharmacy modification. 

CrossStreet 
Definition  Nearest crossing street. 

RecordChange 
Definition  N = New, U = Updated, D = Deactivated 

OldServiceLevel 
Definition  Previous service level. 

TextServiceLevel 
Definition  Text formatted service level. 

TextServiceLevelChange 
Definition  Text formatted service level change. 

Version 
Definition  Current SMS version number of pharmacy. 

PharmacyType 
Definition  An enumerated type with the following list of possible values: 0 = [Retail],1 = [Mail Order], 

NPI 
Definition  Pharmacy Identifier from Surescripts Pharmacy Flat File. NPI (National Provider Identifier) assigned to the Pharmacy. 

SpecialtyType1 
Definition  Pharmacy Specialty Type from Surescripts Pharmacy Flat File. Indicates Mail Order, Retail, Fax, 24 hour, etc. 1 of 4 optional Specialty Types allowed per pharmacy. 

SpecialtyType2 
Definition  Pharmacy Specialty Type from Surescripts Pharmacy Flat File. Indicates Mail Order, Retail, Fax, 24 hour, etc. 2 of 4 optional Specialty Types allowed per pharmacy. 

SpecialtyType3 
Definition  Pharmacy Specialty Type from Surescripts Pharmacy Flat File. Indicates Mail Order, Retail, Fax, 24 hour, etc. 3 of 4 optional Specialty Types allowed per pharmacy. 

SpecialtyType4 
Definition  Pharmacy Specialty Type from Surescripts Pharmacy Flat File. Indicates Mail Order, Retail, Fax, 24 hour, etc. 4 of 4 optional Specialty Types allowed per pharmacy. 

FileID 
Definition  Pharmacy Identifier from Surescripts Pharmacy Flat File. The Surescripts internal FileID is seldom used but retained for backward compatibility. 

StateLicenseNumber 
Definition  Pharmacy Identifier from Surescripts Pharmacy Flat File. State License Number assigned to the Pharmacy. 

MedicareNumber 
Definition  Pharmacy Identifier from Surescripts Pharmacy Flat File. Medicare Identifier assigned to the Pharmacy. 

MedicaidNumber 
Definition  Pharmacy Identifier from Surescripts Pharmacy Flat File. Medicaid Identifier assigned to the Pharmacy. 

PPONumber 
Definition  Pharmacy Identifier from Surescripts Pharmacy Flat File. PPO Number assigned to the Pharmacy. 

PayerID 
Definition  Pharmacy Identifier from Surescripts Pharmacy Flat File. Payer ID assigned to the Pharmacy. 

BINLocationNumber 
Definition  Pharmacy Identifier from Surescripts Pharmacy Flat File. BIN Identifier assigned to the Pharmacy. 

DEANumber 
Definition  Pharmacy Identifier from Surescripts Pharmacy Flat File. DEA Number assigned to the Pharmacy. 

HIN 
Definition  Pharmacy Identifier from Surescripts Pharmacy Flat File. HIN Identifier assigned to the Pharmacy. 

SecondaryCoverage 
Definition  Pharmacy Identifier from Surescripts Pharmacy Flat File. Secondary Coverage ID assigned to the Pharmacy. 

NAICCode 
Definition  Pharmacy Identifier from Surescripts Pharmacy Flat File. NAIC Code assigned to the Pharmacy. 

PromotionNumber 
Definition  Pharmacy Identifier from Surescripts Pharmacy Flat File. Promotion Code assigned to the Pharmacy. 

SocialSecurity 
Definition  Pharmacy Identifier from Surescripts Pharmacy Flat File. Tax ID assigned to the Pharmacy. 

PriorAuthorization 
Definition  PriorAuth Identifier from Surescripts Pharmacy Flat File. Provided by Pharmacies to Surescripts. 

MutuallyDefined 
Definition  MutuallyDefined Identifier from Surescripts Pharmacy Flat File. Provided by Pharmacies to Surescripts. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

IsContracted 
Definition  Determine pharmacy as being a contracted/340B pharmacy 

AddressGUID 
Definition  A foreign key to the GUID column in the CV3Address table. 

FriendlyName 
Definition  Pharmacy "nick name" or Synonym defined by the customer 

StdAddressGUID 
Definition  A foreign key to the GUID column in the CV3Address table.