STANDARD DATA DICTIONARY #58.42 -- SPMP EXPORT BATCH FILE 9/29/25 PAGE 1
STORED IN ^PS(58.42, *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 7.0)
DATA NAME GLOBAL DATA
ELEMENT TITLE LOCATION TYPE
-----------------------------------------------------------------------------------------------------------------------------------
This file is used to maintain information on all controlled substance prescriptions transmitted to the State Prescription
Monitoring Program (SPMP). The file is also used for manually re-transmitting the data to the SPMP.
The data in this file is automatically populated and is not editable by the end-user.
DD ACCESS:
RD ACCESS:
WR ACCESS:
DEL ACCESS:
LAYGO ACCESS:
AUDIT ACCESS:
APPLICATION GROUP(S): PSO
IDENTIFIED BY: EXPORT TYPE (#2), DATE/TIME BATCH CREATED (#8)
CROSS
REFERENCED BY: DATE/TIME BATCH CREATED(AD), BATCH NUMBER(B)
INDEXED BY: PRESCRIPTION & FILL (ARX)
LAST MODIFIED: APR 5,2021@09:44:33
58.42,.01 BATCH NUMBER 0;1 NUMBER (Required)
INPUT TRANSFORM: K:+X'=X!(X>999999999999)!(X<1)!(X?.E1"."1.N) X
LAST EDITED: DEC 13, 2012
HELP-PROMPT: Type a number between 1 and 999999999999, 0 decimal digits.
DESCRIPTION:
This is the internal batch number used to identify the batch transmitted to the state.
CROSS-REFERENCE: 58.42^B
1)= S ^PS(58.42,"B",$E(X,1,30),DA)=""
2)= K ^PS(58.42,"B",$E(X,1,30),DA)
58.42,1 STATE 0;2 POINTER TO STATE FILE (#5)
LAST EDITED: FEB 08, 2013
HELP-PROMPT: Select the state to which the batch was transmitted.
DESCRIPTION:
This is the state the batch was transmitted to.
58.42,2 EXPORT TYPE 0;3 SET
'SC' FOR SCHEDULED;
'MA' FOR MANUAL;
'RX' FOR SINGLE RX;
'VD' FOR VOID ONLY;
'ZR' FOR ZERO RPT;
LAST EDITED: SEP 21, 2020
HELP-PROMPT: Choose how the batch was created.
DESCRIPTION: This indicates if the batch was created by a scheduled process, manually entered date range or by
transmitting a single Rx to the state.
58.42,3 BATCH STATUS 0;4 SET
'N' FOR NEW;
'X' FOR EXPORTED;
'E' FOR ERROR(S) FOUND;
'C' FOR CANCELLED;
LAST EDITED: SEP 07, 2012
58.42,4 BEGIN RELEASE DATE/TIME 0;5 DATE
INPUT TRANSFORM: S %DT="ESTX" D ^%DT S X=Y K:X<1 X
LAST EDITED: JAN 16, 2013
HELP-PROMPT: Enter the first prescription release date/time included in the batch.
DESCRIPTION:
This is the first prescription release date/time included in the batch.
58.42,5 END RELEASE DATE/TIME 0;6 DATE
INPUT TRANSFORM: S %DT="EST" D ^%DT S X=Y K:X<1 X
LAST EDITED: FEB 08, 2013
HELP-PROMPT: Enter the last prescription release date/time included in the batch.
DESCRIPTION:
This is the last prescription release/date time included in the batch.
58.42,6 EXPORT FILE NAME 0;7 FREE TEXT
INPUT TRANSFORM: K:$L(X)>100!($L(X)<5) X
LAST EDITED: DEC 13, 2012
HELP-PROMPT: Answer must be 5-100 characters in length.
DESCRIPTION:
This is the name of the file exported to the state.
58.42,7 EXPORTED BY 0;8 POINTER TO NEW PERSON FILE (#200)
LAST EDITED: JAN 16, 2013
HELP-PROMPT: Select the user who ran the batch transmission to the state.
DESCRIPTION:
This is the user who ran the transmission to the state.
58.42,8 DATE/TIME BATCH CREATED 0;9 DATE
INPUT TRANSFORM: S %DT="ESTXR" D ^%DT S X=Y K:X<1 X
LAST EDITED: JAN 16, 2013
HELP-PROMPT: Enter the date/time the batch was created.
DESCRIPTION:
This is the date/time the batch was created.
CROSS-REFERENCE: 58.42^AD
1)= S ^PS(58.42,"AD",$E(X,1,30),DA)=""
2)= K ^PS(58.42,"AD",$E(X,1,30),DA)
58.42,9 DATE/TIME BATCH EXPORTED 0;10 DATE
INPUT TRANSFORM: S %DT="ESTXR" D ^%DT S X=Y K:X<1 X
LAST EDITED: JAN 16, 2013
HELP-PROMPT: Enter the date/time the batch was transmitted to the state.
DESCRIPTION:
This is the date/time the batch was transmitted to the state.
58.42,10 CREATED BY 0;11 POINTER TO NEW PERSON FILE (#200)
LAST EDITED: OCT 21, 2020
HELP-PROMPT: Select the user who created the batch.
DESCRIPTION:
This is the user who created the batch.
58.42,100 PRESCRIPTIONS RX;0 POINTER Multiple #58.42001
DESCRIPTION:
This contains information about the prescriptions included in the batch.
58.42001,.01 PRESCRIPTION 0;1 POINTER TO PRESCRIPTION FILE (#52)
LAST EDITED: FEB 20, 2013
HELP-PROMPT: Select the prescription included in the transmission batch.
DESCRIPTION:
This is the prescription included in the transmission batch.
CROSS-REFERENCE: 58.42001^B
1)= S ^PS(58.42,DA(1),"RX","B",$E(X,1,30),DA)=""
2)= K ^PS(58.42,DA(1),"RX","B",$E(X,1,30),DA)
RECORD INDEXES: ARX (#759) (WHOLE FILE #58.42)
58.42001,1 FILL 0;2 FREE TEXT
INPUT TRANSFORM: K:$L(X)>3!($L(X)<1) X
LAST EDITED: JAN 16, 2013
HELP-PROMPT: Answer must be 1-3 characters in length.
DESCRIPTION: This is the prescription fill included in the transmission batch. The original fill is
represented by "0" (zero). A numeric value other than zero indicates the refill #. A numeric
value preceded by "P" (e.g., "P1", "P2", etc.) indicates a partial fill.
RECORD INDEXES: ARX (#759) (WHOLE FILE #58.42)
58.42001,2 RECORD TYPE 0;3 SET
'N' FOR NEW;
'R' FOR REVISE;
'V' FOR VOID;
LAST EDITED: FEB 20, 2013
HELP-PROMPT: Choose the type of record that was transmitted to the state for the prescription fill.
DESCRIPTION: This indicates if the prescription fill was transmitted as a new record, a revised record or a
void record.
58.42001,3 NDC SENT 0;4 FREE TEXT
INPUT TRANSFORM: K:$L(X)>20!($L(X)<1) X
LAST EDITED: NOV 16, 2015
HELP-PROMPT: Answer must be 1-20 characters in length.
DESCRIPTION:
This is the NDC that was sent to the state for this prescription fill.
58.42,102 DEBUG REASON DR;0 Multiple #58.42102 (Add New Entry without Asking)
DESCRIPTION:
This information is related to running batch export in debug mode.
58.42102,.01 DEBUG REASON 0;1 FREE TEXT (Multiply asked)
INPUT TRANSFORM: K:$L(X)>40!($L(X)<1) X
MAXIMUM LENGTH: 40
LAST EDITED: OCT 09, 2020
HELP-PROMPT: Your answer must be 1 to 40 characters in length.
DESCRIPTION: This is the reason for running the batch export in debug mode such as 'retransmitting failed
batch'.
58.42102,1 RUN BY 0;2 POINTER TO NEW PERSON FILE (#200)
LAST EDITED: NOV 04, 2020
HELP-PROMPT: The user who ran the batch transmission in debug mode
DESCRIPTION:
This is the user who ran the transmission to the state in debug mode.
58.42102,3 DEBUG EXPORT DATE/TIME 0;3 DATE
INPUT TRANSFORM: S %DT="ESTXR" D ^%DT S X=Y K:X<1 X
LAST EDITED: JAN 07, 2021
HELP-PROMPT: Enter the date/time the batch was exported in debug mode.
DESCRIPTION:
This is the date/time the batch was exported is debug mode.
58.42,200 ZERO REPORT SITES ZRS;0 POINTER Multiple #58.42201
DESCRIPTION:
This contains information about the zero report batch.
TECHNICAL DESCR:
This field is created by the PSO SPMP Scheduled Export process.
58.42201,.01 OUTPATIENT SITE 0;1 POINTER TO OUTPATIENT SITE FILE (#59)
LAST EDITED: NOV 23, 2020
HELP-PROMPT: Enter the Outpatient Pharmacy Site.
DESCRIPTION:
This is the Outpatient Pharmacy Site for the Zero Report Batch.
TECHNICAL DESCR:
This field is created by the PSO SPMP Scheduled Export process.
CROSS-REFERENCE: 58.42201^B
1)= S ^PS(58.42,DA(1),"ZRS","B",$E(X,1,30),DA)=""
2)= K ^PS(58.42,DA(1),"ZRS","B",$E(X,1,30),DA)
58.42201,1 SITE DEA NUMBER 0;2 FREE TEXT
INPUT TRANSFORM: K:$L(X)>9!($L(X)<9)!'(X?2U7N) X
MAXIMUM LENGTH: 9
LAST EDITED: NOV 23, 2020
HELP-PROMPT: Answer must be 9 characters in length. Two alpha characters followed by 7 digits.
DESCRIPTION:
This field will be used to indicate the Drug Enforcement Agency ID number for this site.
TECHNICAL DESCR:
This field is created by the PSO SPMP Scheduled Export process.
FILES POINTED TO FIELDS
NEW PERSON (#200) EXPORTED BY (#7)
CREATED BY (#10)
DEBUG REASON:RUN BY (#1)
OUTPATIENT SITE (#59) ZERO REPORT SITES:OUTPATIENT SITE (#.01)
PRESCRIPTION (#52) PRESCRIPTIONS:PRESCRIPTION (#.01)
STATE (#5) STATE (#1)
Subfile #58.42001
Record Indexes:
ARX (#759) RECORD REGULAR IR SORTING ONLY WHOLE FILE (#58.42)
Short Descr: Prescription cross-reference
Description: This is a cross-reference on the prescription pointer and fill number.
Set Logic: S ^PS(58.42,"ARX",X(1),X(2),DA(1),DA)=""
Kill Logic: K ^PS(58.42,"ARX",X(1),X(2),DA(1),DA)
Whole Kill: K ^PS(58.42,"ARX")
X(1): PRESCRIPTION (58.42001,.01) (Subscr 1) (forwards)
X(2): FILL (58.42001,1) (Subscr 2) (forwards)
INPUT TEMPLATE(S):
PRINT TEMPLATE(S):
SORT TEMPLATE(S):
FORM(S)/BLOCK(S):