Contents Show
This file will have all the newly issued food instruments. This is the file the Bank will read to validate that a food instrument (negotiable item) can be paid. Multiple Issuance files can be sent for WIC, Farmers Market and Senior Farmers Market or one file with the ProgramCode in the file layout indicating which system the data came from. This is an ASCII flat file and is sent using the FTP or Dial-up Process. This process executes during the End of Day Process if the value of the EOD_BANKINGISSUANCEFILEEXPORT business rule equals "Y" in the STATEBUSINESSRULES table.
The issuance file name syntax will be one of the following depending on who has the banking contract.
Covansys - STISmmdd.txt ST - State Code
IS - Banking Issuance file prefix
mmdd - Current month and day
Example - MNIS1202.txt
File Layout Exception for Missouri Issuance File:
Covansys - ISSTmmdd.txt IS - Banking Issuance file prefix
ST - State Code
mmdd - Current month and day
Example - ISMO1202.txt
FSMC - ISstmmdd.001 IS - Banking Issuance file prefix
st - State Code
mmdd - Current month and day
Example - ISMG1202.001
|
Field |
From |
To |
Length |
Type |
Decimal |
|
RecordId |
1 |
3 |
3 |
Char |
"IAA" |
|
FromMachine |
4 |
9 |
6 |
Char |
"st8888" |
|
ToMachine |
10 |
15 |
6 |
Char |
"??????" |
|
FileDate |
16 |
23 |
8 |
Date |
"yyyymmdd" |
|
FileName |
24 |
33 |
10 |
Char |
"ISst####" or "stIS####" |
|
VersionID |
34 |
41 |
8 |
Char |
"########" |
|
Field |
From |
To |
Length |
Type |
Decimal |
|
RecordID |
1 |
3 |
3 |
Char |
"IBA" |
|
SerialNumber |
4 |
11 |
8 |
Char |
· |
|
FirstDateToUse |
12 |
19 |
8 |
Date |
"yyyymmdd" |
|
LastDateToUse |
20 |
27 |
8 |
Date |
"yyyymmdd" |
|
ProgramCode |
28 |
28 |
1 |
Char |
· |
|
PharmacyInd |
29 |
29 |
1 |
Char |
· |
|
ComplianceBuy |
30 |
30 |
1 |
Char |
· |
|
FoodInstrumentType |
31 |
35 |
5 |
Char |
· |
|
AgencyID |
36 |
40 |
5 |
Char |
· |
|
StateWICID |
41 |
48 |
8 |
Char |
· |
|
Field |
From |
To |
Length |
Type |
Decimal |
|
RecordID |
1 |
3 |
3 |
Char |
"IA9" |
|
IBARecordCount |
4 |
8 |
5 |
Number |
0 |
Record ID
This is the header identifier telling the bank that this is a header record.
Characteristics
This element will be an alphanumeric field and have a value of 'IAA'. It will start in the position 1 and have a length of 3.
Edits
This is a required field.
From Machine ID
This is the identifier of the machine that sent the file to the bank.
Characteristics
This element will be an alphanumeric field and have a value of 'st####". It will start in the position 4 and have a length of 6. st is the state identifier.
Edits
This is a required field.
To Machine ID
This is the identifier of the machine that the file is supposed to reach.
Characteristics
This element will be an alphanumeric field and have a value of <??????>. It will start in the position 10 and have a length of 6.
Edits
This is a required field.
File Date
This is the date the file was sent to the bank.
Characteristics
This element will be an alphanumeric field and have a format of CCYYMMDD. It will start in the position 16 and have a length of 8. This value will be the current system date.
Edits
This is a required field.
File Name
This is the file name was sent to the bank.
Characteristics
This element will be an alphanumeric field and have a format of "BInnnnnn' where nnnnnn is a sequential number with two trailing blanks. It will start in the position 24 and have a length of 10.
Edits
This is a required field.
Version ID
This is the version of the file
Characteristics
This element will be an alphanumeric field that will have the version number of the file. It is not used at this time and will default to spaces. It will start in the position 34 and have a length of 8.
Edits
This is a required field.
Record ID
This is the header identifier telling the WIC system that this is a header record.
Characteristics
This element will be an alphanumeric field and have a value of 'IBA'. It will start in the position 1 and have a length of 3.
Edits
This is a required field.
Check (Serial) Number
This is the check (serial) number for the Food Instrument
Characteristics
This element will be a numeric field. It will start in the position 4 and have a length of 8. This value is taken from the SearialNumber column of the FoodInstrument table.
Edits
This is a required field.
First Date To Use
This is the first date the Food Instrument can be used.
Characteristics
This element will be a date field with a format of CCYYMMDD. It will start in the position 12 and have a length of 8. This value will be taken from the FirstUseDate column of the FoodInstrumentSet table.
Edits
This is a required field.
Last Date To Use
This is the last day the Food Instrument can be used.
Characteristics
This element will be a date field with a format of CCYYMMDD. It will start in the position 20 and have a length of 8. This value will be taken from the LastUseDate column of the FoodInstrumentSet table.
Edits
This is a required field.
Program Code
This is the program code indicating which program the food instrument is issued.
Characteristics
This element will be an alphanumeric field. It will start in the position 28 and have a length of 1. This value will be taken from the ProgramCode column of the FoodInstrument table.
Edits
This is a required field.
Pharmacy Indicator
This is a code indicating if the food instrument can be redeemed at a pharmacy.
Characteristics
This element will be an alphanumeric field. It will start in the position 29 and have a length of 1. This value will be taken from the PharmacyAllowed column of the FoodInstrument table.
Edits
This is a required field.
Compliance Buy
This is a code indicating if the food instrument is a compliance buy check.
Characteristics
This element will be an alphanumeric field. It will start in the position 30 and have a length of 1. This value will be taken from the ComplianceBuy column of the FoodInstrumentSet table.
Edits
This is a required field.
Food Instrument Type
This is a Food Instrument Type code for the Food Instrument
Characteristics
This element will be an alphanumeric field. It will start in the position 31 and have a length of 5. This value will be taken from the FoodInstrumentType column of the FoodInstrument table.
Edits
This is a required field.
Agency ID and Service Site ID
This is the Agency ID and the Clinic ID from where the Food Instrument was printed.
Characteristics
This element will be an alphanumeric field. It will start in the position 36 and have a length of 5. This value will be taken from the AgencyID and ServiceSiteID columns of the FoodInstrumentSet table.
Edits
This is a required field.
State WIC ID
This is the participant State WIC ID for the Food Instrument.
Characteristics
This element will be an alphanumeric field. It will start in the position 41 and have a length of 8. This value will be taken from the StateWICID column of the FoodInstrumentSet table.
Edits
This is a required field.
Record ID
This is the header identifier telling the bank that this is a trailer record.
Characteristics
This element will be an alphanumeric field and have a value of 'IA9'. It will start in the position 1 and have a length of 3.
Edits
This is a required field.
IBA Record Count
This is the count of Issuance detail records in this file.
Characteristics
This element will be a numeric field of the count of the number of Food Instrument Issuance detail ('IBA') records sent in this file. It will start in the position 4 and have a length of 5, right-justified, zero-filled, and no commas.
Edits
This is a required field.
|
Software Version: 2.40.00