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):