Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
PharmacyOID | int | NOT NULL | ObjectID of Pharmacy Table |
PharmacyNCPDPID | varchar(7) | NOT NULL | NCPDP ID of Pharmacy returned from HDX. Unique for all US pharmacies. |
PharmacyType | smallint | NOT NULL | Type of Pharmacy "MailOrder" or "Retail".Allowable values 0 and 1(1:MailOrder and 0:Retail) |
PharmacyName | varchar(70) | NOT NULL | Pharmacy Name |
PharmacyAddress | varchar(80) | NOT NULL | Pharmacy Street Address(deprecated: this is a concatenation of PharmacyAddress1 and PharmacyAddress2 separated by a vertical bar.) |
PharmacyZipCode | varchar(10) | NOT NULL | Pharmacy ZipCode |
PharmacyCity | varchar(64) | NOT NULL | Pharmacy City |
PharmacyState | varchar(2) | NOT NULL | Pharmacy State |
PharmacyFaxNumber | varchar(30) | NULL | Pharmacy Fax Number |
PharmacyPhoneNumber | varchar(30) | NULL | Pharmacy Phone Number |
PharmacyNPINumber | varchar(10) | NULL | Pharmacy NPI Number |
PharmacyCrossStreet | varchar(35) | NULL | Pharmacy Cross Street Name |
Pharmacy24HoursIndicator | smallint | NULL | Pharmacy 24 hours open indicator. Allowable values 0 and 1(1:Yes and 0:No ). Null indicates unknown |
PharmacyEmail | varchar(50) | NULL | Pharmacy Email |
CreateDTime | datetime | NOT NULL | Created Date Time(wall clock) |
SupportControlSubstance | smallint | NULL | Indicates if the Pharmacy supports ePrescribing control substance or not(1: support control substance, 0: not support, null: don't know) |
IsCancelSupported | tinyint | NULL | Indicates if the Pharmacy supports canceling the ePrescription or not(1: support cancel, 0: not support, null: don't know) |
PharmacyVersion | varchar(10) | NULL | ePrescribing version used by the provider.(Valid values include: 10.6, 2017.) |
PharmacyAddress1 | varchar(40) | NOT NULL | Pharmacy Street Address 1 |
PharmacyAddress2 | varchar(40) | NULL | Pharmacy Street Address 2 |