STANDARD DATA DICTIONARY #52.47 -- ERX EXTERNAL PHARMACY FILE 3/24/25 PAGE 1 STORED IN ^PS(52.47, *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 7.0) DATA NAME GLOBAL DATA ELEMENT TITLE LOCATION TYPE ----------------------------------------------------------------------------------------------------------------------------------- This file holds the eRx pharmacy information. DD ACCESS: @ RD ACCESS: Pp WR ACCESS: @ DEL ACCESS: @ LAYGO ACCESS: @ AUDIT ACCESS: @ POINTED TO BY: ASSOCIATED ERX PHARMACY field (#1.3) of the ERX EXTERNAL PERSON File (#52.48) ERX EXTERNAL PHARMACY field (#2.5) of the ERX HOLDING QUEUE File (#52.49) EXTERNAL PHARMACY field (#17.1) of the ERX HOLDING QUEUE File (#52.49) XFER TO EXTERNAL PHARMACY field (#17.4) of the ERX HOLDING QUEUE File (#52.49) INDEXED BY: NAME (B) LAST MODIFIED: DEC 18,2020@15:20:58 52.47,.01 NAME 0;1 FREE TEXT (Required) INPUT TRANSFORM: K:$L(X)>70!($L(X)<3)!'(X'?1P.E) X MAXIMUM LENGTH: 70 LAST EDITED: OCT 07, 2019 HELP-PROMPT: Answer must be 3-70 characters in length. DESCRIPTION: This is the name of the eRx external pharmacy. FIELD INDEX: B (#1491) REGULAR IR LOOKUP & SORTING Short Descr: Index on full external pharmacy name. Description: Since the external pharmacy can be 70 characters, this cross reference is created to index the full name. Set Logic: S ^PS(52.47,"B",$E(X,1,70),DA)="" Kill Logic: K ^PS(52.47,"B",$E(X,1,70),DA) Whole Kill: K ^PS(52.47,"B") X(1): NAME (52.47,.01) (Subscr 1) (Len 70) (forwards) 52.47,.02 NCPDP ID 0;2 FREE TEXT INPUT TRANSFORM: K:$L(X)>35!($L(X)<1) X LAST EDITED: AUG 31, 2016 HELP-PROMPT: Enter the NCPDP identifier. Answer must be 1-35 characters in length. DESCRIPTION: This is the NCPDP identifier for this pharmacy. 52.47,.03 NPI 0;3 FREE TEXT INPUT TRANSFORM: K:$L(X)>35!($L(X)<3) X LAST EDITED: AUG 31, 2016 HELP-PROMPT: Enter the NPI for this external pharmacy. Answer must be 3-35 characters in length. DESCRIPTION: This is the NPI for the external pharmacy. 52.47,.04 DEA NUMBER 0;4 FREE TEXT INPUT TRANSFORM: K:$L(X)>35!($L(X)<3) X LAST EDITED: AUG 31, 2016 HELP-PROMPT: Enter the DEA number for this external pharmacy. Answer must be 3-35 characters in length. DESCRIPTION: The DEA Number for the external pharmacy. 52.47,.05 STORE NAME 0;5 FREE TEXT INPUT TRANSFORM: K:$L(X)>70!($L(X)<3) X MAXIMUM LENGTH: 70 LAST EDITED: SEP 23, 2019 HELP-PROMPT: Answer must be 3-70 characters in length. DESCRIPTION: This is the name of the pharmacy/store, such as CSV, WALGREENS, etc. 52.47,1.1 ADDRESS LINE 1 1;1 FREE TEXT INPUT TRANSFORM: K:$L(X)>40!($L(X)<3) X MAXIMUM LENGTH: 40 LAST EDITED: SEP 23, 2019 HELP-PROMPT: Answer must be 3-40 characters in length. DESCRIPTION: Address line 1 for the external pharmacy/store. 52.47,1.2 ADDRESS LINE 2 1;2 FREE TEXT INPUT TRANSFORM: K:$L(X)>40!($L(X)<3) X MAXIMUM LENGTH: 40 LAST EDITED: SEP 23, 2019 HELP-PROMPT: Answer must be 3-40 characters in length. DESCRIPTION: Address line 2 for the external pharmacy/store. 52.47,1.3 CITY 1;3 FREE TEXT INPUT TRANSFORM: K:$L(X)>35!($L(X)<3) X LAST EDITED: AUG 31, 2016 HELP-PROMPT: Enter the City where this external pharmacy resides. Answer must be 3-35 characters in length. DESCRIPTION: This is the city associated with the external pharmacy/store. 52.47,1.4 STATE/PROVINCE 1;4 POINTER TO STATE FILE (#5) LAST EDITED: SEP 27, 2019 HELP-PROMPT: Enter the state/province associated with the external pharmacy/store. DESCRIPTION: This is the state/province in which the external pharmacy/store resides. 52.47,1.5 POSTAL CODE 1;5 FREE TEXT INPUT TRANSFORM: K:$L(X)>9!($L(X)<5) X MAXIMUM LENGTH: 9 LAST EDITED: SEP 27, 2019 HELP-PROMPT: Enter the postal code for this pharmacy/store. Answer must be 5-9 characters in length. DESCRIPTION: The postal code for the pharmacy/store. 52.47,1.6 TYPE 1;6 SET 'VA' FOR VA FACILITY; 'EF' FOR EXTERNAL FACILITY; 'EP' FOR EXTERNAL PHARMACY; 'OP' FOR OTHER FACILITY; LAST EDITED: OCT 20, 2016 HELP-PROMPT: Enter the type for this pharmacy/store. DESCRIPTION: This is the type of the pharmacy/store. 52.47,1.7 COUNTRY CODE 1;7 FREE TEXT INPUT TRANSFORM: K:$L(X)>3!($L(X)<1) X MAXIMUM LENGTH: 3 LAST EDITED: SEP 27, 2019 HELP-PROMPT: Enter the country code for this pharmacy/store. Answer must be 1-3 characters in length. DESCRIPTION: Enter the country code for this pharmacy/store. 52.47,1.8 SPECIALTY 1;8 FREE TEXT INPUT TRANSFORM: K:$L(X)>10!($L(X)<1) X LAST EDITED: NOV 07, 2016 HELP-PROMPT: Enter the specialty for the eRx Pharmacy. Answer must be 1-10 characters in length. DESCRIPTION: This is the pharmacy specialty for the incoming eRx Pharmacy. 52.47,2 IDENTIFICATION 2;0 Multiple #52.472 (Add New Entry without Asking) DESCRIPTION: This sub-file holds the identification elements passed in with the incoming eRx. 52.472,.01 ID TYPE 0;1 FREE TEXT INPUT TRANSFORM: K:$L(X)>50!($L(X)<3) X LAST EDITED: MAR 07, 2017 HELP-PROMPT: Enter the identification type. Answer must be 3-50 characters in length. DESCRIPTION: This is the identification type, such as NCPDP ID, NPI, or DEA #. CROSS-REFERENCE: 52.472^B 1)= S ^PS(52.47,DA(1),2,"B",$E(X,1,30),DA)="" 2)= K ^PS(52.47,DA(1),2,"B",$E(X,1,30),DA) 52.472,.02 ID VALUE 0;2 FREE TEXT INPUT TRANSFORM: K:$L(X)>35!($L(X)<1) X LAST EDITED: MAR 07, 2017 HELP-PROMPT: Enter the identification value. Answer must be 1-35 characters in length. DESCRIPTION: This is the value associated with the identification type. 52.47,3 COMMUNICATION 3;0 Multiple #52.473 (Add New Entry without Asking) DESCRIPTION: This sub-file holds the communication values and types for an eRx external pharmacy. 52.473,.01 COMMUNICATION 0;1 FREE TEXT INPUT TRANSFORM: K:$L(X)>80!($L(X)<1) X LAST EDITED: OCT 12, 2016 HELP-PROMPT: Enter the value for the communication method. Answer must be 1-80 characters in length. DESCRIPTION: This field contains the communication value for an eRx external pharmacy. CROSS-REFERENCE: 52.473^B 1)= S ^PS(52.47,DA(1),3,"B",$E(X,1,30),DA)="" 2)= K ^PS(52.47,DA(1),3,"B",$E(X,1,30),DA) 52.473,.02 TYPE 0;2 SET 'BN' FOR BEEPER; 'CP' FOR CELLULAR; 'EM' FOR ELECTRONIC MAIL; 'FX' FOR FAX; 'HP' FOR HOME PHONE; 'NP' FOR NIGHT-TIME PHONE; 'TE' FOR TELEPHONE; 'WP' FOR WORK PHONE; LAST EDITED: OCT 12, 2016 HELP-PROMPT: Enter the type associated with the supplied communication value. DESCRIPTION: This is the type associated with the communication value supplied. 52.47,4 ASSOCIATED ERX PERSON 4;1 POINTER TO ERX EXTERNAL PERSON FILE (#52.48) LAST EDITED: AUG 31, 2016 HELP-PROMPT: Enter the person from the eRx external person file that is associated with this eRx external pharmacy. DESCRIPTION: This holds the person(s) associated with the eRx external pharmacy. 52.47,5.1 FORMER LAST NAME 5;1 FREE TEXT INPUT TRANSFORM: K:$L(X)>35!($L(X)<1) X MAXIMUM LENGTH: 35 LAST EDITED: SEP 27, 2019 HELP-PROMPT: Enter the former last name. Answer must be 1-35 characters in length. DESCRIPTION: This is the former last name associated with the eRx external pharmacy. 52.47,5.2 FORMER FIRST NAME 5;2 FREE TEXT INPUT TRANSFORM: K:$L(X)>35!($L(X)<1) X MAXIMUM LENGTH: 35 LAST EDITED: SEP 27, 2019 HELP-PROMPT: Enter the former first name. Answer must be 1-35 characters in length. DESCRIPTION: This is the former first name associated with the eRx external pharmacy. 52.47,5.3 FORMER MIDDLE NAME 5;3 FREE TEXT INPUT TRANSFORM: K:$L(X)>35!($L(X)<1) X MAXIMUM LENGTH: 35 LAST EDITED: SEP 27, 2019 HELP-PROMPT: Enter the former middle name. Answer must be 1-35 characters in length. DESCRIPTION: This is the former middle name associated with the eRx external pharmacy. 52.47,5.4 FORMER SUFFIX 5;4 FREE TEXT INPUT TRANSFORM: K:$L(X)>10!($L(X)<1) X MAXIMUM LENGTH: 10 LAST EDITED: SEP 27, 2019 HELP-PROMPT: Enter the former suffix. Answer must be 1-10 characters in length. DESCRIPTION: This is the former suffix associated with the eRx external pharmacy. 52.47,5.5 FORMER PREFIX 5;5 FREE TEXT INPUT TRANSFORM: K:$L(X)>10!($L(X)<1) X MAXIMUM LENGTH: 10 LAST EDITED: SEP 27, 2019 HELP-PROMPT: Enter the former prefix. Answer must be 1-10 characters in length. DESCRIPTION: This is the former prefix associated with the eRx external pharmacy. 52.47,7 2017 COMMUNICATION 7;0 Multiple #52.477 LAST EDITED: NOV 04, 2019 DESCRIPTION: This subfile contains the communication information associated with the eRx external pharmacy. This subfile was created to support the 2017 script standard. 52.477,.01 SEQUENCE 0;1 NUMBER (Multiply asked) INPUT TRANSFORM: K:+X'=X!(X>999)!(X<1)!(X?.E1"."1N.N) X LAST EDITED: OCT 07, 2019 HELP-PROMPT: Enter the sequence number. Type a number between 1 and 999, 0 decimal digits. DESCRIPTION: This is the sequence number associated with the incoming communication information. CROSS-REFERENCE: 52.477^B 1)= S ^PS(52.47,DA(1),7,"B",$E(X,1,30),DA)="" 2)= K ^PS(52.47,DA(1),7,"B",$E(X,1,30),DA) 52.477,.02 TYPE 0;2 SET 'PT' FOR PrimaryTelephone; 'B' FOR Beeper; 'EM' FOR ElectronicMail; 'F' FOR Fax; 'HT' FOR HomeTelephone; 'WT' FOR WorkTelephone; 'OT' FOR OtherTelephone; LAST EDITED: NOV 04, 2019 HELP-PROMPT: Enter the type of communication. DESCRIPTION: This field determines the type associated with the incoming communcation information. 52.477,.03 NUMBER 0;3 NUMBER INPUT TRANSFORM: K:+X'=X!(X>9999999999)!(X<1)!(X?.E1"."1N.N) X LAST EDITED: NOV 04, 2019 HELP-PROMPT: Enter the number. Type a number between 1 and 9999999999, 0 decimal digits. DESCRIPTION: This is the number associated with the incoming communication. 52.477,.04 EXTENSION 0;4 NUMBER INPUT TRANSFORM: K:+X'=X!(X>99999999)!(X<1)!(X?.E1"."1N.N) X LAST EDITED: NOV 04, 2019 HELP-PROMPT: Enter the extension. Type a number between 1 and 99999999, 0 decimal digits. DESCRIPTION: This is the extension associated with the incoming communication. 52.477,.05 SUPPORTS SMS 0;5 SET 'Y' FOR YES; 'N' FOR NO; LAST EDITED: NOV 04, 2019 HELP-PROMPT: Enter if the communication supports SMS messages. DESCRIPTION: This field determines if the communication supports SMS messages. 52.477,1 EMAIL ADDRESS 1;1 FREE TEXT INPUT TRANSFORM: K:$L(X)>80!($L(X)<1) X MAXIMUM LENGTH: 80 LAST EDITED: NOV 04, 2019 HELP-PROMPT: Enter the email address. Answer must be 1-80 characters in length. DESCRIPTION: This is the email address associated with the incoming communication. 52.47,8 2017 DIRECT ADDRESS 8;1 FREE TEXT INPUT TRANSFORM: K:$L(X)>254!($L(X)<1) X MAXIMUM LENGTH: 254 LAST EDITED: NOV 04, 2019 HELP-PROMPT: Enter the direct address. Answer must be 1-254 characters in length. DESCRIPTION: This is the direct address associated with the incoming communication. 52.47,9.1 2017 STATE LICENSE NUMBER 9;1 FREE TEXT INPUT TRANSFORM: K:$L(X)>35!($L(X)<1) X MAXIMUM LENGTH: 35 LAST EDITED: NOV 08, 2019 HELP-PROMPT: Enter the State License Number for the eRx pharmacy. Answer must be 1-35 characters in length. DESCRIPTION: This is the state license number for the eRx pharmacy. 52.47,9.2 2017 MEDICARE NUMBER 9;2 FREE TEXT INPUT TRANSFORM: K:$L(X)>35!($L(X)<1) X MAXIMUM LENGTH: 35 LAST EDITED: NOV 08, 2019 HELP-PROMPT: Enter the Medicare Number. Answer must be 1-35 characters in length. DESCRIPTION: This is the Medicare Number of the pharmacy. 52.47,9.3 2017 MEDICAID NUMBER 9;3 FREE TEXT INPUT TRANSFORM: K:$L(X)>35!($L(X)<1) X MAXIMUM LENGTH: 35 LAST EDITED: NOV 08, 2019 HELP-PROMPT: Enter the Medicaid Number for the pharmacy. Answer must be 1-35 characters in length. DESCRIPTION: This is the Medicaid Number for the eRx pharmacy. 52.47,9.4 2017 UPIN 9;4 FREE TEXT INPUT TRANSFORM: K:$L(X)>35!($L(X)<1) X MAXIMUM LENGTH: 35 LAST EDITED: NOV 05, 2019 HELP-PROMPT: Enter the UPIN number for the eRx pharmacy. Answer must be 1-35 characters in length. DESCRIPTION: This is the UPIN number associated with the eRx pharmacy. 52.47,9.5 2017 HIN 9;5 FREE TEXT INPUT TRANSFORM: K:$L(X)>35!($L(X)<1) X MAXIMUM LENGTH: 35 LAST EDITED: NOV 12, 2019 HELP-PROMPT: Enter the HIN for this eRx pharmacy. Answer must be 1-35 characters in length. DESCRIPTION: This is the HIN number associated with the eRx Pharmacy. 52.47,9.6 2017 MUTUALLY DEFINED 9;6 FREE TEXT INPUT TRANSFORM: K:$L(X)>35!($L(X)<1) X MAXIMUM LENGTH: 35 LAST EDITED: NOV 08, 2019 HELP-PROMPT: Enter the mutually defined identification value for the eRx pharmacy. Answer must be 1-35 characters in length. DESCRIPTION: This is the mutually defined identification value for the eRx pharamcy. 52.47,10.1 2017 NCPDP ID 10;1 FREE TEXT INPUT TRANSFORM: K:$L(X)>35!($L(X)<1) X MAXIMUM LENGTH: 35 LAST EDITED: NOV 05, 2019 HELP-PROMPT: Enter the NCPDP ID for this eRx Pharmacy. Answer must be 1-35 characters in length. DESCRIPTION: This the 2017071 NCPDP ID for the eRx Pharmacy. 52.47,10.2 2017 NPI 10;2 FREE TEXT INPUT TRANSFORM: K:$L(X)>35!($L(X)<1) X MAXIMUM LENGTH: 35 LAST EDITED: NOV 08, 2019 HELP-PROMPT: Enter the 2017071 script standard NPI for this eRx Pharmacy. Answer must be 1-35 characters in length. DESCRIPTION: This is the 2017071 script standard NPI for the eRx pharmacy. 52.47,10.3 2017 DEA NUMBER 10;3 FREE TEXT INPUT TRANSFORM: K:$L(X)>35!($L(X)<1) X MAXIMUM LENGTH: 35 LAST EDITED: NOV 08, 2019 HELP-PROMPT: Enter the 2017071 script standard DEA Number for this eRx Pharmacy. Answer must be 1-35 characters in length. DESCRIPTION: This is the 2017071 script standard DEA Number for the eRx Pharmacy. FILES POINTED TO FIELDS ERX EXTERNAL PERSON (#52.48) ASSOCIATED ERX PERSON (#4) STATE (#5) STATE/PROVINCE (#1.4) INPUT TEMPLATE(S): PRINT TEMPLATE(S): SORT TEMPLATE(S): FORM(S)/BLOCK(S):