VistaCARE BATCH CHARGE INTERFACE - File Specification - Page 1 The attached VistaCARE Batch Charge Import File layout will show you what is contained in a file that can be imported into our accounts receivable system. Your program should write this file in the following specific ways: The file name should be "TARBARff.TXT" where the "ff" is the facility code of the company importing this file into the VistaCARE Accounts Receivable System. The computer operator should be able to supply this to you. The file should be in fixed field ASCII text format. It uses the typical hexadecimal 0D0A (CR/LF) combination as a record delimiter. It should use the common hexadecimal 1A (^Z) as an end of file indicator. A PC-DOS DIRectory command performed on this file should show the actual number of bytes in the file up to and including the hexadecimal 1A. It should not include any bytes after the 1A end of file indicator. The header record should be built as follows: Field TBRHSTAT, the Batch Status, is initially created set to 0 and is changed to 1 when the "extract" is completed. Field TBRHBTCH, the Bar Code Batch Number, can be assigned by your system. This allows the operator to "re-send" a previously extracted batch of charges from certain systems that will only allow the extract to occur once. In case the originally created extraction file was lost or damaged, they could resend a given batch number. Field TBRHPOST is used by our program. You should create it with a value of blank. The detail record should be built as follows: Field TBRSTAT is used by our program. You should create it with a value of 1. Field TBRPTNO, the Patient Number, is numeric and zero filled. This must be a valid patient number in the VistaCARE system. Field TBRDATE, the Used Date, is used in the conversion process by our program to decide who should be billed for the product on the the product was used. The facility must therefore make sure they enter the actual date the product was used to ensure correct billing. Field TBRARCD, the A/R Code, is numeric. This must be a valid Accounts Receivable Code in the VistaCARE system. Every item in the Bar Code System's inventory file that will be extracted must have an A/R Code. These codes can either be specific (e.g. 12345 for Kleenix Tissue Reg 160/bx) or generic (e.g. 12345 for Personal Items). That choice is up to the facility or corporate office. Field TBRDESC, the Product Description, will appear on the patient's bill if the facility chooses to itemize their charges. Field TBRQTY, the Quantity Used, is a whole number that is the number of items used to be multiplied by the price. Field TBRAMT, the Sell Price Each, is multiplied by the Quantity Used to come up with the total charge. If no Sell Price Each is used, then the price will be looked up from the VistaCARE System. VistaCARE BATCH CHARGE INTERFACE - File Specification - Page 2 File Layout for TARBARff.TXT This file will contain 2 record types with a fixed length of 53 characters. HEADER RECORD LAYOUT -------------------- Type Size Position Comment ---------------------------------------------- TBRHSTAT DIM 1 01-01 .Batch status, 1 = Create completed TBRHBTCH DIM 5 02-06 .Batch number TBRHPOST DIM 1 07-07 .1 = Post to batch ancill. in progress FILLER DIM 44 08-53 .Unused space DETAIL RECORD LAYOUT -------------------- Type Size Position Comment ---------------------------------------------- TBRSTAT DIM 1 01-01 .Status flag, '*' = Posted to 'TARANCxx' TBRPTNO DIM 5 02-06 .Patient number TBRDATE DIM 6 07-12 .Used-date (YYMMDD) TBRARCD DIM 5 13-17 .A/R Code TBRDESC DIM 25 18-42 .Product description TBRQTY FORM 4 43-46 .Quantity used TBRAMT FORM 4.2 47-53 .Sell price each Note: It would be helpful to your clients who have VistaCARE systems and use the Batch Charge Interface Module if you created this file in the directory specified by the DBC_PREP environment variable. If you don't, they will have to make sure their system can find the TARBARff.TXT file you create.