Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (21) | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | | Key to the Pharmacy_DE table |
 | EnterpriseEntryID | [dbo].[uniqueid] | 9 | NOT NULL | | | Master (enterprise) dictionary surrogate key. Points to Dictionary_Entry.EnterpriseEntryID |
 | DefinitionSetID | [dbo].[dict_id] | 5 | NOT NULL | | | Points to Dict_Definition_Set.DefinitionSetID but is typically zero. |
 | Entry | [dbo].[dict_id] | 5 | NOT NULL | | | Calculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set |
(3) | EntryCode | [dbo].[code] | 10 | NOT NULL | | | Pharmacy code |
(23) | EntryName | [dbo].[name] | 255 | NOT NULL | | | Pharmacy Name |
(3) | EntryMnemonic | [dbo].[code] | 10 | NOT NULL | | | Copy of Entry code |
(4)![Check Constraints CK_Pharmacy_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_Pharmacy_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is not active; N=row is active. (Rows are inactivated rather than deleted for history) |
 ![Check Constraints CK_Pharmacy_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y') Check Constraints CK_Pharmacy_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')](../../../../Images/c-constraint.png) | IsEnforcedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is readonly; N=row is modifiable |
(23)![Check Constraints CK_Pharmacy_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y') Check Constraints CK_Pharmacy_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')](../../../../Images/c-constraint.png) | IsCurrentFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Usually 'Y' but occasionally used to subordinate rows. Not exposed to the end user. |
 | EffectiveDT | datetime | 8 | NULL allowed | | | Time of last modification (not "when this row goes into effect") |
 | AddressLine1 | varchar(40) | 40 | NOT NULL | | (' ') | Address Line 1 of Pharmacy |
 | AddressLine2 | varchar(40) | 40 | NOT NULL | | (' ') | Address Line 2 of Pharmacy |
(2) | City | varchar(35) | 35 | NOT NULL | | (' ') | City of Pharmacy |
(2) | State | varchar(15) | 15 | NOT NULL | | (' ') | State |
(2) | ZipCode | char(10) | 10 | NOT NULL | | (' ') | ZIP Code |
 | PhoneArea | smallint | 2 | NOT NULL | | (0) | Phone Area |
 | PhoneExchange | smallint | 2 | NOT NULL | | (0) | Phone Exchange |
 | PhoneLast4 | smallint | 2 | NOT NULL | | (0) | Phone Last 4 Number |
 | PhoneExtension | varchar(8) | 8 | NULL allowed | | (' ') | Phone Extension |
 | FaxArea | smallint | 2 | NOT NULL | | (0) | Fax Area |
 | FaxExchange | smallint | 2 | NOT NULL | | (0) | Fax Exchange |
 | FaxLast4 | smallint | 2 | NOT NULL | | (0) | Fax Last 4 Number |
 | Contact1 | varchar(255) | 255 | NULL allowed | | (' ') | Contact Number |
 | Contact2 | varchar(35) | 35 | NOT NULL | | (' ') | Contact Number |
 | Contact3 | varchar(35) | 35 | NOT NULL | | (' ') | Contact Number |
 | TransmitAcceptedFlag | [dbo].[XBOOL] | 1 | NOT NULL | | ('N') | Flag to indicate Transmit Accepted by Pharmacy |
 ![Check Constraints CK_Pharmacy_DE_TransmitReqPrintFlag_Yes_Or_No : ([TransmitReqPrintFlag]='N' OR [TransmitReqPrintFlag]='Y') Check Constraints CK_Pharmacy_DE_TransmitReqPrintFlag_Yes_Or_No : ([TransmitReqPrintFlag]='N' OR [TransmitReqPrintFlag]='Y')](../../../../Images/c-constraint.png) | TransmitReqPrintFlag | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Flag to indicate Transmit Request Print Flag |
 ![Check Constraints CK_Pharmacy_DE_TransmitAcceptClass2Flag_Yes_Or_No : ([TransmitAcceptClass2Flag]='N' OR [TransmitAcceptClass2Flag]='Y') Check Constraints CK_Pharmacy_DE_TransmitAcceptClass2Flag_Yes_Or_No : ([TransmitAcceptClass2Flag]='N' OR [TransmitAcceptClass2Flag]='Y')](../../../../Images/c-constraint.png) | TransmitAcceptClass2Flag | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Flag to indicate Transmit Accept Class 2 Medications |
(2) | PharmacyNABP | varchar(35) | 35 | NOT NULL | | (' ') | NABP Number (National Association of Boards of Pharmacy) of Pharmacy |
 ![Check Constraints CK_Pharmacy_DE_AcceptUcodeTransFLAG_Yes_Or_No : ([AcceptUcodeTransFLAG]='N' OR [AcceptUcodeTransFLAG]='Y') Check Constraints CK_Pharmacy_DE_AcceptUcodeTransFLAG_Yes_Or_No : ([AcceptUcodeTransFLAG]='N' OR [AcceptUcodeTransFLAG]='Y')](../../../../Images/c-constraint.png) | AcceptUcodeTransFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Flag to indicate Unicode transmission is allowed |
(2)![Check Constraints CK_Pharmacy_DE_PharmacyType : ([PharmacyType]='M' OR [PharmacyType]='R') Check Constraints CK_Pharmacy_DE_PharmacyType : ([PharmacyType]='M' OR [PharmacyType]='R')](../../../../Images/c-constraint.png) | PharmacyType | char(1) | 1 | NOT NULL | | ('R') | Pharmacy Type. R- Retail , M-Mail |
 ![Check Constraints CK_Pharmacy_DE_PatientConfirmation : ([PatientConfirmation]='N' OR [PatientConfirmation]='Y') Check Constraints CK_Pharmacy_DE_PatientConfirmation : ([PatientConfirmation]='N' OR [PatientConfirmation]='Y')](../../../../Images/c-constraint.png) | PatientConfirmation | char(1) | 1 | NOT NULL | | ('N') | Flag to indicate Patient Confirmation Required |
 ![Check Constraints CK_Pharmacy_DE_AcceptsDCFLAG_Yes_Or_No : ([AcceptsDCFLAG]='N' OR [AcceptsDCFLAG]='Y') Check Constraints CK_Pharmacy_DE_AcceptsDCFLAG_Yes_Or_No : ([AcceptsDCFLAG]='N' OR [AcceptsDCFLAG]='Y')](../../../../Images/c-constraint.png) | AcceptsDCFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Flag to indicate Accepts Discontinued |
 ![Check Constraints CK_Pharmacy_DE_AcceptsEIEFLAG_Yes_Or_No : ([AcceptsEIEFLAG]='N' OR [AcceptsEIEFLAG]='Y') Check Constraints CK_Pharmacy_DE_AcceptsEIEFLAG_Yes_Or_No : ([AcceptsEIEFLAG]='N' OR [AcceptsEIEFLAG]='Y')](../../../../Images/c-constraint.png) | AcceptsEIEFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Flag to indicate Accepts Entered In Error |
 ![Check Constraints CK_Pharmacy_DE_AcceptsCompletedFLAG_Yes_Or_No : ([AcceptsCompletedFLAG]='N' OR [AcceptsCompletedFLAG]='Y') Check Constraints CK_Pharmacy_DE_AcceptsCompletedFLAG_Yes_Or_No : ([AcceptsCompletedFLAG]='N' OR [AcceptsCompletedFLAG]='Y')](../../../../Images/c-constraint.png) | AcceptsCompletedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Flag to indicate Completed Flag |
| StoreNumber | varchar(35) | 35 | NOT NULL | | ('') | Store Number |
| ServiceLevel | int | 4 | NOT NULL | | ((0)) | Service Level |
![Check Constraints CK_Pharmacy_DE_CancelFaxAcceptanceFlag_Yes_Or_No : ([CancelFaxAcceptanceFlag]='N' OR [CancelFaxAcceptanceFlag]='Y') Check Constraints CK_Pharmacy_DE_CancelFaxAcceptanceFlag_Yes_Or_No : ([CancelFaxAcceptanceFlag]='N' OR [CancelFaxAcceptanceFlag]='Y')](../../../../Images/c-constraint.png) | CancelFaxAcceptanceFlag | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Flag to indicate Cancel by Fax Accepted |
| DisplayName | varchar(255) | 255 | NULL allowed | | ('') | Pharmacy Display Name |
| Landmark | varchar(50) | 50 | NOT NULL | | ('') | Landmark |
![Check Constraints CK_Pharmacy_DE_Pharmacy24HourFLAG_Yes_Or_No : ([Pharmacy24HourFLAG]='N' OR [Pharmacy24HourFLAG]='Y') Check Constraints CK_Pharmacy_DE_Pharmacy24HourFLAG_Yes_Or_No : ([Pharmacy24HourFLAG]='N' OR [Pharmacy24HourFLAG]='Y')](../../../../Images/c-constraint.png) | Pharmacy24HourFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Flag indicating Pharmacy is open 24 Hours a day |
![Check Constraints CK_Pharmacy_DE_SpecialtyPharmacyFLAG_Yes_Or_No : ([SpecialtyPharmacyFLAG]='N' OR [SpecialtyPharmacyFLAG]='Y') Check Constraints CK_Pharmacy_DE_SpecialtyPharmacyFLAG_Yes_Or_No : ([SpecialtyPharmacyFLAG]='N' OR [SpecialtyPharmacyFLAG]='Y')](../../../../Images/c-constraint.png) | SpecialtyPharmacyFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Is Pharmacy is Speciality Pharmacy |
![Check Constraints CK_Pharmacy_DE_LongTermCarePharmacyFLAG_Yes_Or_No : ([LongTermCarePharmacyFLAG]='N' OR [LongTermCarePharmacyFLAG]='Y') Check Constraints CK_Pharmacy_DE_LongTermCarePharmacyFLAG_Yes_Or_No : ([LongTermCarePharmacyFLAG]='N' OR [LongTermCarePharmacyFLAG]='Y')](../../../../Images/c-constraint.png) | LongTermCarePharmacyFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Is pharmacy is Long term care pharmacy |
| PharmacyScriptVersion | varchar(15) | 15 | NOT NULL | | ('') | Surescript version of pharmacy |
| NPI | varchar(10) | 10 | NOT NULL | | ('') | NPI of the pharmacy |
| IsNewScript | bit | 1 | NOT NULL | | ((0)) | Uses the new script standard |