STANDARD DATA DICTIONARY #344.5 -- AR EDI LOCKBOX MESSAGES FILE 6/27/25 PAGE 1 STORED IN ^RCY(344.5, *** NO DATA STORED YET *** SITE: WWW.BMIRWIN.COM UCI: VISTA,VISTA (VERSION 4.5) DATA NAME GLOBAL DATA ELEMENT TITLE LOCATION TYPE ----------------------------------------------------------------------------------------------------------------------------------- This file receives the raw data from electronic ERAs and EOBs. Once filed here, the records are verified and sent to the permanent file where the summaries are kept (#344.4) and the detail is stored in Integrated Billing's file #361.1. Once permanently filed, the raw data is deleted from this file. CROSS REFERENCED BY: MULTI SEQUENCE NUMBER(AMSEQ), MESSAGE ID(B) INDEXED BY: EXCEPTION STATUS (AEXC), DATE RECORDED & TRANSFERRED EOB RECEIVED FROM (ATIN) LAST MODIFIED: OCT 23,2020@09:12:24 344.5,.01 MESSAGE ID 0;1 FREE TEXT (Required) INPUT TRANSFORM: K:$L(X)>20!($L(X)<1)!'(X'?1P.E) X LAST EDITED: JUN 03, 2002 HELP-PROMPT: Answer must be 1-20 characters in length. DESCRIPTION: This is the id to identify the message uniquely to the system. It is calculated from the mail message number that delivers it to the system. CROSS-REFERENCE: 344.5^B 1)= S ^RCY(344.5,"B",$E(X,1,30),DA)="" 2)= K ^RCY(344.5,"B",$E(X,1,30),DA) 344.5,.02 MESSAGE TYPE 0;2 SET '835ERA' FOR ERA RECORD; '835XFR' FOR EOB TRANSFER; LAST EDITED: JUN 06, 2002 HELP-PROMPT: Enter the code to specify which type of information the message will contain. DESCRIPTION: This is the type of information contained in the transmission record. 344.5,.03 DATE RECORDED 0;3 DATE INPUT TRANSFORM: S %DT="ETX" D ^%DT S X=Y K:Y<1 X LAST EDITED: JAN 13, 2003 HELP-PROMPT: Enter the time the record was recorded at the site. DESCRIPTION: This is the actual time the record was added to the file at the site. RECORD INDEXES: ATIN (#295) 344.5,.04 UPDATE STATUS 0;4 SET '0' FOR NOT UPDATING; '1' FOR UPDATING; LAST EDITED: JUN 04, 2002 HELP-PROMPT: Enter a 1 if VistA is currently being updated with the information in this record. DESCRIPTION: This is the indicator of whether or not the VistA database is being updated with the data contained in the electronic transmission record. 344.5,.05 UPDATE TASK 0;5 FREE TEXT INPUT TRANSFORM: K:$L(X)>20!($L(X)<1) X LAST EDITED: JUN 03, 2002 HELP-PROMPT: Answer must be 1-20 characters in length. DESCRIPTION: This is the # of the background task that is updating the VistA data with the information in this electronic transmission record. 344.5,.06 ALLOW AUTO-UPDATE 0;6 SET '0' FOR NO; '1' FOR YES; LAST EDITED: JUN 03, 2002 HELP-PROMPT: Enter YES (1) to allow this record to auto update VistA DESCRIPTION: This field controls whether the data in the record can be automatically updated into the VistA database or if it must be manually reviewed and updated. 344.5,.07 ERA TOTALS RECORD 0;7 POINTER TO ELECTRONIC REMITTANCE ADVICE FILE (#344.4) LAST EDITED: DEC 06, 2002 HELP-PROMPT: Enter the ERA record created by this message DESCRIPTION: This is the ERA totals batch entry that was created by this message. 344.5,.08 EXCEPTION STATUS 0;8 SET '0' FOR NO EXCEPTION; '1' FOR EXCEPTION EXISTS; LAST EDITED: OCT 10, 2002 HELP-PROMPT: Enter a 1 if this message should appear on the exception processing list. DESCRIPTION: This is the indicator used to inlcude/exclude the record from the exception processing list. FIELD INDEX: AEXC (#294) REGULAR IR SORTING ONLY Short Descr: Cross reference by records with exception condition Set Logic: S ^RCY(344.5,"AEXC",X,DA)="" Set Cond: I X=1 Kill Logic: K ^RCY(344.5,"AEXC",X,DA) Whole Kill: K ^RCY(344.5,"AEXC") X(1): EXCEPTION STATUS (344.5,.08) (Subscr 1) (forwards) 344.5,.09 MULTI SEQUENCE NUMBER 0;9 NUMBER INPUT TRANSFORM: K:+X'=X!(X>9999999999)!(X<1)!(X?.E1"."1N.N) X LAST EDITED: AUG 19, 2002 HELP-PROMPT: Type a Number between 1 and 9999999999, 0 Decimal Digits DESCRIPTION: This number is used to associate ERA messages that must be broken up and sent in pieces from the FSC due to size constraints on the DMI Queues. CROSS-REFERENCE: 344.5^AMSEQ 1)= S ^RCY(344.5,"AMSEQ",$E(X,1,30),DA)="" 2)= K ^RCY(344.5,"AMSEQ",$E(X,1,30),DA) 3)= Do not delete This cross reference is needed to associate all 'pieces' of an ERA 344.5,.1 EXCEPTION CATEGORY 0;10 SET '1' FOR SUMMARY RECORD STORE ERROR; '2' FOR PARTIAL MESSAGE RECEIVED; '3' FOR EOB TRANSFERRED IN; '4' FOR TRANSMISSION STORE ERROR; '5' FOR ERROR STORING EOB TRANSFER IN; '6' FOR NO VALID CLAIMS; '99' FOR OTHER; LAST EDITED: JAN 02, 2004 HELP-PROMPT: Enter the code that corresponds to the exception condition of the ERA/EEOB record DESCRIPTION: This is the specific exception that occurred to cause the ERA/EEOB record to be placed in an exception status. 344.5,.11 MAIL MESSAGE 0;11 FREE TEXT INPUT TRANSFORM: K:$L(X)>60!($L(X)<1) X LAST EDITED: JAN 14, 2003 HELP-PROMPT: Answer must be 1-60 characters in length. DESCRIPTION: This is the list of message #s the ERA/EOB record was delivered in, separated by commas. 344.5,.12 TRANSFERRED EOB RECEIVED FROM 0;12 FREE TEXT INPUT TRANSFORM: K:$L(X)>64!($L(X)<1) X LAST EDITED: APR 25, 2003 HELP-PROMPT: Answer must be 1-64 characters in length. DESCRIPTION: This is the name of the domain from which the transfer was received RECORD INDEXES: ATIN (#295) 344.5,.13 REFERENCE AT OTHER SITE 0;13 FREE TEXT INPUT TRANSFORM: K:$L(X)>30!($L(X)<3)!'(X?1N.N1";"1N.N) X LAST EDITED: JAN 15, 2003 HELP-PROMPT: Answer must be 3-30 characters in length. DESCRIPTION: This is the field that holds the reference to the entry in file 344.4 that correspond to this EOB message if it is a transfer EOB type. The format is ien of file 344 followed by a semicolon (;) followed by the ien of the entry in file 344.41. 344.5,.14 EOB ACCEPTANCE SENT 0;14 SET '0' FOR NO; '1' FOR YES; LAST EDITED: JAN 17, 2003 HELP-PROMPT: Enter 1 if this EOB has been confirmed as accepted to the sending site. DESCRIPTION: This is a flag that indicates whether or not an EOB has been confirmed as being accepted by the sending site. This is used so multiple attempts at filing do not send multiple confirmation records. 344.5,.15 DUPLICATE INDICATOR 0;15 SET '0' FOR NO; '1' FOR YES; LAST EDITED: OCT 17, 2018 HELP-PROMPT: Enter '1' if the message is a duplicate transmission. DESCRIPTION: This field indicates the incoming 835 message is a duplicate transmission. TECHNICAL DESCR: This field is used in the filing routines for EFT 835 messages to override the checks for duplicates. The field will be automatically set by the system. 344.5,1 DISPLAY DATA 1;0 WORD-PROCESSING #344.51 (NOWRAP) LAST EDITED: JUN 04, 2002 DESCRIPTION: This is the formatted data, extracted from the raw text of the message that will be used to update VistA. LAST EDITED: JUN 04, 2002 HELP-PROMPT: Enter the data in the format appropriate to the message type. DESCRIPTION: This is the formatted data, extracted from the raw text of the message that will be used to update VistA. 344.5,2 RAW MESSAGE DATA 2;0 WORD-PROCESSING #344.52 (NOWRAP) DESCRIPTION: This is the actual text that was received at the site in the electronic transmission. LAST EDITED: JUN 03, 2002 HELP-PROMPT: Enter the raw data that was received at the site DESCRIPTION: This is the actual text that was received at the site in the electronic transmission. 344.5,3 SEQUENCE RECEIVED S;0 Multiple #344.53 (Add New Entry without Asking) DESCRIPTION: This multiple field stores all the sequences received for an ERA that was trasnmitted in 'pieces' due to the DMI queue's limit on the size of messages that can be transmitted. 344.53,.01 SEQUENCE RECEIVED 0;1 NUMBER (Multiply asked) INPUT TRANSFORM: K:+X'=X!(X>999)!(X<1)!(X?.E1"."1.N) X LAST EDITED: NOV 14, 2019 HELP-PROMPT: Type a number between 1 and 999, 0 decimal digits. DESCRIPTION: This is the sequence # of the message 'piece' for the ERA received. CROSS-REFERENCE: 344.53^B 1)= S ^RCY(344.5,DA(1),"S","B",$E(X,1,30),DA)="" 2)= K ^RCY(344.5,DA(1),"S","B",$E(X,1,30),DA) 344.53,.02 LAST SEQUENCE 0;2 SET '0' FOR NO; '1' FOR YES; LAST EDITED: AUG 20, 2002 HELP-PROMPT: Enter 1 if this is the last sequence # expected DESCRIPTION: This is the flag that indicates the last sequence # for a message transmitted in parts was received. 344.53,.03 DATE/TIME RECEIVED 0;3 DATE INPUT TRANSFORM: S %DT="ESTX" D ^%DT S X=Y K:Y<1 X LAST EDITED: AUG 20, 2002 HELP-PROMPT: Enter the date/time this record was entered DESCRIPTION: This is the date/time the sequence 'piece' of the ERA was received and stored at the site. 344.53,.04 MAIL MESSAGE 0;4 NUMBER INPUT TRANSFORM: K:+X'=X!(X>999999999999999)!(X<1)!(X?.E1"."1N.N) X LAST EDITED: JAN 14, 2003 HELP-PROMPT: Type a Number between 1 and 999999999999999, 0 Decimal Digits DESCRIPTION: This is the number of the mail message the sequence was received in. 344.5,3.01 ERA PAYER NAME 3;1 FREE TEXT INPUT TRANSFORM: K:$L(X)>30!($L(X)<1) X LAST EDITED: APR 25, 2003 HELP-PROMPT: Answer must be 1-30 characters in length. DESCRIPTION: This is the name of the payer as provided on the ERA transmission record. 344.5,4 BILL REFERENCE B;0 Multiple #344.54 (Add New Entry without Asking) LAST EDITED: SEP 24, 2002 DESCRIPTION: This is a list of the bills included in the ERA record. INDEXED BY: FOUND IN AR BILL FILE (AV) 344.54,.01 BILL REFERENCE 0;1 FREE TEXT (Multiply asked) INPUT TRANSFORM: K:$L(X)>20!($L(X)<1) X LAST EDITED: SEP 24, 2002 HELP-PROMPT: Answer must be 1-20 characters in length. DESCRIPTION: This is a bill included in this ERA record. CROSS-REFERENCE: 344.54^B 1)= S ^RCY(344.5,DA(1),"B","B",$E(X,1,30),DA)="" 2)= K ^RCY(344.5,DA(1),"B","B",$E(X,1,30),DA) 344.54,.02 FOUND IN AR BILL FILE 0;2 SET '0' FOR NO; '1' FOR YES; LAST EDITED: SEP 23, 2002 HELP-PROMPT: Enter a 1 if this bill can be found in the VistA AR bill file. DESCRIPTION: This indicates whether or not the referenced bill exists at the VistA site. FIELD INDEX: AV (#296) REGULAR IR SORTING ONLY Short Descr: Cross reference on valid bills in the ERA Set Logic: S ^RCY(344.5,DA(1),"B","AV",X,DA)="" Set Cond: I X=1 Kill Logic: K ^RCY(344.5,DA(1),"B","AV",X,DA) Whole Kill: K ^RCY(344.5,DA(1),"B","AV") X(1): FOUND IN AR BILL FILE (344.54,.02) (Subscr 1) (forwards) 344.5,5 EXCEPTION MESSAGES EX;0 WORD-PROCESSING #344.55 (NOWRAP) DESCRIPTION: This is where the text of the error or exception condition is stored. LAST EDITED: OCT 17, 2002 HELP-PROMPT: Enter a description of the exception existing for this ERA record. DESCRIPTION: This is the free text explanation of any exceptions found for this record. FILES POINTED TO FIELDS ELECTRONIC REMITTANCE ADVICE (#344.4) ERA TOTALS RECORD (#.07) File #344.5 Record Indexes: ATIN (#295) RECORD REGULAR IR SORTING ONLY Short Descr: Xref by file date and transferred from for message type = '835XFR' Set Logic: S ^RCY(344.5,"ATIN",X(1),$E(X(2),1,30),DA)="" Set Cond: I $P($G(^RCY(344.5,DA,0)),U)["XFR" Kill Logic: K ^RCY(344.5,"ATIN",X(1),$E(X(2),1,30),DA) Kill Cond: I $P($G(^RCY(344.5,DA,0)),U)["XFR" Whole Kill: K ^RCY(344.5,"ATIN") X(1): DATE RECORDED (344.5,.03) (Subscr 1) (forwards) X(2): TRANSFERRED EOB RECEIVED FROM (344.5,.12) (Subscr 2) (Len 30) (forwards) INPUT TEMPLATE(S): PRINT TEMPLATE(S): SORT TEMPLATE(S): FORM(S)/BLOCK(S):