Tables [dbo].[Pharmacy_DE]
Pharmacy Dictionary
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Pharmacy_DE_ID: IDIndexes XAK4PharmacyDE, TWstat_Pharmacy_DE_AddressLine1_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_AddressLine2_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_City_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_Contact1_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_EffectiveDT_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_FaxArea_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_FaxExchange_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_FaxLast4_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_IsCurrentFLAG_EntryName_ID, TWstat_Pharmacy_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_PharmacyNABP_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_PharmacyType_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_PhoneArea_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_PhoneExchange_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_PhoneLast4_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_State_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_TransmitAcceptedFlag_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_ZipCode_EntryName_IsCurrentFLAG_ID(21)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the Pharmacy_DE table
Indexes TWstat_Pharmacy_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_IDEnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
Indexes TWstat_Pharmacy_DE_DefinitionSetID_EntryName_IsCurrentFLAG_IDDefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Indexes TWstat_Pharmacy_DE_EntryEntry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes NIX_Pharmacy_DE_EntryCode_WithIncludeColumns, NIX_Pharmacy_DE_EntryMnemonic_WithIncludeColumns, NIX_Pharmacy_DE_EntryName_WithIncludeColumns(3)EntryCode[dbo].[code]10NOT NULLPharmacy code
Indexes NIX_Pharmacy_DE_EntryCode_WithIncludeColumns, NIX_Pharmacy_DE_EntryMnemonic_WithIncludeColumns, NIX_Pharmacy_DE_EntryName_WithIncludeColumns, TWstat_Pharmacy_DE_AddressLine1_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_AddressLine2_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_City_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_Contact1_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_EffectiveDT_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_FaxArea_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_FaxExchange_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_FaxLast4_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_IsCurrentFLAG_EntryName_ID, TWstat_Pharmacy_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_PharmacyNABP_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_PharmacyType_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_PhoneArea_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_PhoneExchange_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_PhoneLast4_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_State_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_TransmitAcceptedFlag_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_ZipCode_EntryName_IsCurrentFLAG_ID(23)EntryName[dbo].[name]255NOT NULLPharmacy Name
Indexes NIX_Pharmacy_DE_EntryCode_WithIncludeColumns, NIX_Pharmacy_DE_EntryMnemonic_WithIncludeColumns, NIX_Pharmacy_DE_EntryName_WithIncludeColumns(3)EntryMnemonic[dbo].[code]10NOT NULLCopy of Entry code
Indexes NIX_Pharmacy_DE_EntryCode_WithIncludeColumns, NIX_Pharmacy_DE_EntryMnemonic_WithIncludeColumns, NIX_Pharmacy_DE_EntryName_WithIncludeColumns, TWstat_Pharmacy_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(4)Check Constraints CK_Pharmacy_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLY=row is not active; N=row is active.  (Rows are inactivated rather than deleted for history)
Indexes TWstat_Pharmacy_DE_IsEnforcedFLAGCheck Constraints CK_Pharmacy_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Indexes NIX_Pharmacy_DE_EntryCode_WithIncludeColumns, NIX_Pharmacy_DE_EntryMnemonic_WithIncludeColumns, NIX_Pharmacy_DE_EntryName_WithIncludeColumns, TWstat_Pharmacy_DE_AddressLine1_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_AddressLine2_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_City_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_Contact1_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_EffectiveDT_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_EnterpriseEntryID_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_FaxArea_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_FaxExchange_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_FaxLast4_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_IsCurrentFLAG_EntryName_ID, TWstat_Pharmacy_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_PharmacyNABP_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_PharmacyType_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_PhoneArea_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_PhoneExchange_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_PhoneLast4_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_State_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_TransmitAcceptedFlag_EntryName_IsCurrentFLAG_ID, TWstat_Pharmacy_DE_ZipCode_EntryName_IsCurrentFLAG_ID(23)Check Constraints CK_Pharmacy_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLUsually 'Y' but occasionally used to subordinate rows.  Not exposed to the end user.
Indexes TWstat_Pharmacy_DE_EffectiveDT_EntryName_IsCurrentFLAG_IDEffectiveDTdatetime8NULL allowedTime of last modification  (not "when this row goes into effect")
Indexes TWstat_Pharmacy_DE_AddressLine1_EntryName_IsCurrentFLAG_IDAddressLine1varchar(40)40NOT NULL(' ')Address Line 1 of Pharmacy
Indexes TWstat_Pharmacy_DE_AddressLine2_EntryName_IsCurrentFLAG_IDAddressLine2varchar(40)40NOT NULL(' ')Address Line 2 of Pharmacy
Indexes nix_Pharmacy_DE_PharmacyType_City_State_ZipCode, TWstat_Pharmacy_DE_City_EntryName_IsCurrentFLAG_ID(2)Cityvarchar(35)35NOT NULL(' ')City of Pharmacy
Indexes nix_Pharmacy_DE_PharmacyType_City_State_ZipCode, TWstat_Pharmacy_DE_State_EntryName_IsCurrentFLAG_ID(2)Statevarchar(15)15NOT NULL(' ')State
Indexes nix_Pharmacy_DE_PharmacyType_City_State_ZipCode, TWstat_Pharmacy_DE_ZipCode_EntryName_IsCurrentFLAG_ID(2)ZipCodechar(10)10NOT NULL(' ')ZIP Code
Indexes TWstat_Pharmacy_DE_PhoneArea_EntryName_IsCurrentFLAG_IDPhoneAreasmallint2NOT NULL(0)Phone Area
Indexes TWstat_Pharmacy_DE_PhoneExchange_EntryName_IsCurrentFLAG_IDPhoneExchangesmallint2NOT NULL(0)Phone Exchange
Indexes TWstat_Pharmacy_DE_PhoneLast4_EntryName_IsCurrentFLAG_IDPhoneLast4smallint2NOT NULL(0)Phone Last 4 Number
Indexes TWstat_Pharmacy_DE_PhoneExtensionPhoneExtensionvarchar(8)8NULL allowed(' ')Phone Extension
Indexes TWstat_Pharmacy_DE_FaxArea_EntryName_IsCurrentFLAG_IDFaxAreasmallint2NOT NULL(0)Fax Area
Indexes TWstat_Pharmacy_DE_FaxExchange_EntryName_IsCurrentFLAG_IDFaxExchangesmallint2NOT NULL(0)Fax Exchange
Indexes TWstat_Pharmacy_DE_FaxLast4_EntryName_IsCurrentFLAG_IDFaxLast4smallint2NOT NULL(0)Fax Last 4 Number
Indexes TWstat_Pharmacy_DE_Contact1_EntryName_IsCurrentFLAG_IDContact1varchar(255)255NULL allowed(' ')Contact Number
Indexes TWstat_Pharmacy_DE_Contact2Contact2varchar(35)35NOT NULL(' ')Contact Number
Indexes TWstat_Pharmacy_DE_Contact3Contact3varchar(35)35NOT NULL(' ')Contact Number
Indexes TWstat_Pharmacy_DE_TransmitAcceptedFlag_EntryName_IsCurrentFLAG_IDTransmitAcceptedFlag[dbo].[XBOOL]1NOT NULL('N')Flag to indicate Transmit Accepted by Pharmacy
Indexes TWstat_Pharmacy_DE_TransmitReqPrintFlagCheck Constraints CK_Pharmacy_DE_TransmitReqPrintFlag_Yes_Or_No : ([TransmitReqPrintFlag]='N' OR [TransmitReqPrintFlag]='Y')TransmitReqPrintFlag[dbo].[BOOL]1NOT NULL('N')Flag to indicate Transmit Request Print Flag
Indexes TWstat_Pharmacy_DE_TransmitAcceptClass2FlagCheck Constraints CK_Pharmacy_DE_TransmitAcceptClass2Flag_Yes_Or_No : ([TransmitAcceptClass2Flag]='N' OR [TransmitAcceptClass2Flag]='Y')TransmitAcceptClass2Flag[dbo].[BOOL]1NOT NULL('N')Flag to indicate Transmit Accept Class 2 Medications
Indexes XAK4PharmacyDE, TWstat_Pharmacy_DE_PharmacyNABP_EntryName_IsCurrentFLAG_ID(2)PharmacyNABPvarchar(35)35NOT NULL(' ')NABP Number (National Association of Boards of Pharmacy) of Pharmacy
Indexes TWstat_Pharmacy_DE_AcceptUcodeTransFLAGCheck Constraints CK_Pharmacy_DE_AcceptUcodeTransFLAG_Yes_Or_No : ([AcceptUcodeTransFLAG]='N' OR [AcceptUcodeTransFLAG]='Y')AcceptUcodeTransFLAG[dbo].[BOOL]1NOT NULL('N')Flag to indicate Unicode transmission is allowed
Indexes nix_Pharmacy_DE_PharmacyType_City_State_ZipCode, TWstat_Pharmacy_DE_PharmacyType_EntryName_IsCurrentFLAG_ID(2)Check Constraints CK_Pharmacy_DE_PharmacyType : ([PharmacyType]='M' OR [PharmacyType]='R')PharmacyTypechar(1)1NOT NULL('R')Pharmacy Type. R- Retail , M-Mail
Indexes TWstat_Pharmacy_DE_PatientConfirmationCheck Constraints CK_Pharmacy_DE_PatientConfirmation : ([PatientConfirmation]='N' OR [PatientConfirmation]='Y')PatientConfirmationchar(1)1NOT NULL('N')Flag to indicate Patient Confirmation Required
Indexes TWstat_Pharmacy_DE_AcceptsDCFLAGCheck Constraints CK_Pharmacy_DE_AcceptsDCFLAG_Yes_Or_No : ([AcceptsDCFLAG]='N' OR [AcceptsDCFLAG]='Y')AcceptsDCFLAG[dbo].[BOOL]1NOT NULL('N')Flag to indicate Accepts Discontinued
Indexes TWstat_Pharmacy_DE_AcceptsEIEFLAGCheck Constraints CK_Pharmacy_DE_AcceptsEIEFLAG_Yes_Or_No : ([AcceptsEIEFLAG]='N' OR [AcceptsEIEFLAG]='Y')AcceptsEIEFLAG[dbo].[BOOL]1NOT NULL('N')Flag to indicate Accepts Entered In Error
Indexes TWstat_Pharmacy_DE_AcceptsCompletedFLAGCheck Constraints CK_Pharmacy_DE_AcceptsCompletedFLAG_Yes_Or_No : ([AcceptsCompletedFLAG]='N' OR [AcceptsCompletedFLAG]='Y')AcceptsCompletedFLAG[dbo].[BOOL]1NOT NULL('N')Flag to indicate Completed Flag
StoreNumbervarchar(35)35NOT NULL('')Store Number
ServiceLevelint4NOT NULL((0))Service Level
Check Constraints CK_Pharmacy_DE_CancelFaxAcceptanceFlag_Yes_Or_No : ([CancelFaxAcceptanceFlag]='N' OR [CancelFaxAcceptanceFlag]='Y')CancelFaxAcceptanceFlag[dbo].[BOOL]1NOT NULL('N')Flag to indicate Cancel by Fax Accepted
DisplayNamevarchar(255)255NULL allowed('')Pharmacy Display Name
Landmarkvarchar(50)50NOT NULL('')Landmark
Check Constraints CK_Pharmacy_DE_Pharmacy24HourFLAG_Yes_Or_No : ([Pharmacy24HourFLAG]='N' OR [Pharmacy24HourFLAG]='Y')Pharmacy24HourFLAG[dbo].[BOOL]1NOT 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')SpecialtyPharmacyFLAG[dbo].[BOOL]1NOT NULL('N')Is Pharmacy is Speciality Pharmacy
Check Constraints CK_Pharmacy_DE_LongTermCarePharmacyFLAG_Yes_Or_No : ([LongTermCarePharmacyFLAG]='N' OR [LongTermCarePharmacyFLAG]='Y')LongTermCarePharmacyFLAG[dbo].[BOOL]1NOT NULL('N')Is pharmacy is Long term care pharmacy
PharmacyScriptVersionvarchar(15)15NOT NULL('')Surescript version of pharmacy
NPIvarchar(10)10NOT NULL('')NPI of the pharmacy
IsNewScriptbit1NOT NULL((0))Uses the new script standard