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. |
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. |