Contents Show
This file will have the pricing of the food instruments for each of the peer groups. This is the file that the Bank will read in order to set max prices. 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_BANKINGPRICEFILEEXPORT business rule equals "Y" in the STATEBUSINESSRULES table.
The price file name syntax will be one of the following depending on who has the banking contract.
Covansys - stBP######.txt st - State Code
BP - Banking Price file prefix
###### - sequential number
Example - MOBP000001.txt
FSMC - BP######.txt BP - Banking Price file prefix
###### - sequential number
Example - BP000001.txt
|
Field |
From |
To |
Length |
Type |
Decimal |
|
RecordId |
1 |
3 |
3 |
Char |
"PAA" |
|
FromMachine |
4 |
9 |
6 |
Char |
"st8888" |
|
ToMachine |
10 |
15 |
6 |
Char |
"??????" |
|
FileDate |
16 |
23 |
8 |
Date |
"yyyymmdd" |
|
FileName |
24 |
33 |
10 |
Char |
"BP######" or "stBP######" |
|
VersionID |
34 |
41 |
8 |
Char |
"########" |
|
Field |
From |
To |
Length |
Type |
Decimal |
|
RecordID |
1 |
3 |
3 |
Char |
"PBA" |
|
PeerGroup |
4 |
5 |
2 |
Char |
· |
|
FoodInstrumentType |
6 |
10 |
5 |
Char |
· |
|
AvgPrice |
11 |
16 |
6 |
Number |
2 |
|
Price |
17 |
22 |
6 |
Number |
2 |
|
Field |
From |
To |
Length |
Type |
Decimal |
|
RecordID |
1 |
3 |
3 |
Char |
"PA9" |
|
PBARecordCount |
4 |
8 |
5 |
Decimal |
0 |
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 'PAA'. 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 '?????? '. It will start in the position 4 and have a length of 6 (with following space filler).
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 a date 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 "stBPnnnnnn" where st is the state code and nnnnnn is a sequential number. 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 'PBA'. It will start in the position 1 and have a length of 3.
Edits
This is a required field.
Peer Group
This is the peer group code. This is the code for the group of vendors that will use the same pricing information.
Characteristics
This element will be a numeric field. It will start in the position 4 and have a length of 2. This value is taken from the PeerGroup column of the PeerGroupFoodInstTypePrice table.
Edits
This is a required field.
Food Instrument Type
This is the food instrument type code from the Covansys system. The food instrument type is the code for all food items that are printed on the food instrument.
Characteristics
This element will be a numeric field. It will start in the position 6 and have a length of 5. This value is taken from the FoodInstrumentType column of the PeerGroupFoodInstTypePrice table.
Edits
This is a required field.
Average Price
This is the Average Price for each of the food instrument types for each of the vendor peer groups.
Characteristics
This element will be a numeric field and has a format of DDDDCC. It will start in the position 11 and have a length of 6. If a 3 month rolling average has been calculated for the FoodInstrumentType for the selected peer group (For Paper Food Instruments - PEERGROUPFOODINSTTYPEPRICE and For EBT - EERGROUPFOODITEM).
Edits
This is a required field.
Max Price
This is the Max Price for each of the food instrument types for each of the vendor peer groups.
Characteristics
This element will be a numeric field and has a format of DDDDCC. It will start in the position 17 and have a length of 6. If a 3 month rolling average has been calculated for the FoodInstrumentType for the selected peer group (For Paper Food Instruments - PEERGROUPFOODINSTTYPEPRICE and For EBT - EERGROUPFOODITEM).
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 'PA9'. It will start in the position 1 and have a length of 3.
Edits
This is a required field.
PBA Record Count
This is the count of Vendor Stamp detail records in this file.
Characteristics
This element will be a numeric field of the count of the number of Food Instrument Price detail ('PBA') 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