Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
Pharmacy This Table is used by ePrescribing workflow for saving pharmacy information retrieved from HDX (Healthcare Data Exchange).
Column Name Column Datatype Column Null Option Column Comment
PharmacyOIDintNOT NULL ObjectID of Pharmacy Table
PharmacyNCPDPIDvarchar(7)NOT NULL NCPDP ID of Pharmacy returned from HDX. Unique for all US pharmacies.
PharmacyTypesmallintNOT NULL Type of Pharmacy "MailOrder" or "Retail".Allowable values 0 and 1(1:MailOrder and 0:Retail)
PharmacyNamevarchar(70)NOT NULL Pharmacy Name
PharmacyAddressvarchar(80)NOT NULL Pharmacy Street Address(deprecated: this is a concatenation of PharmacyAddress1 and PharmacyAddress2 separated by a vertical bar.)
PharmacyZipCodevarchar(10)NOT NULL Pharmacy ZipCode
PharmacyCityvarchar(64)NOT NULL Pharmacy City
PharmacyStatevarchar(2)NOT NULL Pharmacy State
PharmacyFaxNumbervarchar(30)NULL Pharmacy Fax Number
PharmacyPhoneNumbervarchar(30)NULL Pharmacy Phone Number
PharmacyNPINumbervarchar(10)NULL Pharmacy NPI Number
PharmacyCrossStreetvarchar(35)NULL Pharmacy Cross Street Name
Pharmacy24HoursIndicatorsmallintNULL Pharmacy 24 hours open indicator. Allowable values 0 and 1(1:Yes and 0:No ). Null indicates unknown
PharmacyEmailvarchar(50)NULL Pharmacy Email
CreateDTimedatetimeNOT NULL Created Date Time(wall clock)
SupportControlSubstancesmallintNULL Indicates if the Pharmacy supports ePrescribing control substance or not(1: support control substance, 0: not support, null: don't know)
IsCancelSupportedtinyintNULL Indicates if the Pharmacy supports canceling the ePrescription or not(1: support cancel, 0: not support, null: don't know)
PharmacyVersionvarchar(10)NULL ePrescribing version used by the provider.(Valid values include: 10.6, 2017.)
PharmacyAddress1varchar(40)NOT NULL Pharmacy Street Address 1
PharmacyAddress2varchar(40)NULL Pharmacy Street Address 2

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates