Contents Show
The WIC Activity File is used for inbound communication to the SPIRIT WIC system from the EBT Processor system and contains daily redemption data from the EBT Processor, including sales data relating to all WIC transactions that were processed by the EBT Processor system. WIC transactions processed by the EBT Processor system include not only cardholder and vendor transaction data, but also adjustment data.
The WIC Activity File is sent from the EBT Processor system to the SPIRIT WIC system during End of Day Processing. For more information, see the EBT to SPIRIT Files section of the EBT Processor Import/Export Files topic.
For more information, see the WIC Activity File Processing within the BatchProcessor topic for more information about WIC Activity File processes that occur during BatchProcessor Processing.
The WIC Activity File is applicable to your state when the Electronic Benefit Transfer (EBT) food delivery system is enabled for any site within your state.
|
|
NOTE: For more information about enabling the Electronic Benefit Transfer (EBT) food delivery system (or any other food delivery system, such as check, voucher, or direct distribution), see the Clinic screen in the Reference Utility application module. |
The WIC Activity File is generated during BatchProcessor Processing and sent to the folder names specified in the VALUE column of the FileSendPath and FileArchivePath rows within the EBTCONNECTIONINFO table of the SPIRIT database.
The name of the WIC Activity File is the value specified in the VALUE column of the WICActivityFileName row within the EBTCONNECTIONINFO table of the SPIRIT database.
The naming syntax for the WIC Activity File sent to the FileSendPath specified in the EBTCONNECTIONINFO table of the SPIRIT database is based on the file type as follows:
When the file type is JPM, where the value of the FILETYPE column is equal to "0" in the EBTCONNECTIONINFO table of the SPIRIT database, the naming syntax is set to:
[File Name Variable][yyMMdd][Sequence Number]
For example, a WIC Activity File sent to the FileSendPath specified in the EBTCONNECTIONINFO table of the SPIRIT database might be named "C4WACT22092400".
The [File Name Variable] represents a combination of the [State Identifier Code] and WACT.
"C4" in the example above is a [State Identifier Code] which signifies a Chickasaw Nation's WIC Activity File as designated by the Food and Nutrition Service (FNS) division of the United States Department of Agriculture (USDA). It is a 2-character alphanumeric value.
"WACT" in the example above is a file naming convention which signifies an WIC Activity File. It is a 4-character value.
In the values above, "C4" and "WACT" comprise a six-character WIC Activity File name example, but the exact name of the WIC Activity File in your state's environment will equal the value specified in the VALUE column of the WICActivityFileName row within the EBTCONNECTIONINFO table of the SPIRIT database.
"220924" in the example above is a dating convention that signifies the date on which the WIC Activity File was processed. It is a 6-digit numeric value in "yyMMdd" format.
"00" in the example above is a file naming convention signifying a [Sequence Number] that begins with "00" and increments anytime a(n) WIC Activity File is created and one already exists in the specified path for the same day.
When the file type is WUMEI, where the value of the FILETYPE column is equal to "1" or "2" in the EBTCONNECTIONINFO table of the SPIRIT database, the naming syntax is set to:
[yyMMdd][HHMMSS][File Name Variable]
For example, a WIC Activity File sent to the FileSendPath specified in the EBTCONNECTIONINFO table of the SPIRIT database might be named "220924231445.bxml-2014".
"220924" in the example above is a dating convention that signifies the date on which the WIC Activity File was processed. It is a 6-digit numeric value in "yyMMdd" format.
"231445" in the example above is a dating convention that signifies the time in 24-hour military time (or 24-hour clock time) on which the WIC Activity File was processed. It is a 6-digit numeric value in "HHMMSS" format, as follows:
"HH" = Hours
"MM" = Minutes
"SS" = Seconds
".bxml-2014" in the example above is a [File Name Variable] which signifies the file type extension. This variable is an 10-character value with alphanumeric and special characters.
The exact name of the File Name Variable in your state's environment will equal the value specified in the VALUE column of the WicActivityFileTypeExtension row within the EBTCONNECTIONINFO table of the SPIRIT database.
AND
The naming syntax for the WIC Activity File sent to the FileArchivePath specified in the EBTCONNECTIONINFO table of the SPIRIT database (to include a date and time stamp) is based on the file type as follows:
When the file type is JPM, where the value of the FILETYPE column is equal to "0" in the EBTCONNECTIONINFO table of the SPIRIT database, the naming syntax is set to:
[File Name Variable][yyMMdd][Sequence Number].[yyyyMMdd][HHMMSS]
For example, an WIC Activity File sent to the FileArchivePath specified in the EBTCONNECTIONINFO table of the SPIRIT database might be named "C4WACT22092400.20220924231512". In this example, the file processed on September 24, 2022, at twelve (12) seconds past 11:15 PM.
The [File Name Variable] represents a combination of the [State Identifier Code] and WACT.
"C4" in the example above is a [State Identifier Code] which signifies a Chickasaw Nation's WIC Activity File as designated by the Food and Nutrition Service (FNS) division of the United States Department of Agriculture (USDA). It is a 2-character alphanumeric value.
"WACT" in the example above is a file naming convention which signifies a WIC Activity File. It is a 4-character value.
In the values above, "C4" and "WACT" comprise a six-character WIC Activity File name example, but the exact name of the WIC Activity File in your state's environment will equal the value specified in the VALUE column of the WICActivityFileName row within the EBTCONNECTIONINFO table of the SPIRIT database.
"220924" in the example above is a dating convention that signifies the date on which the WIC Activity File was processed. It is a 6-digit numeric value in "yyMMdd" format.
"00" in the example above is a file naming convention signifying a [Sequence Number] that begins with "00" and increments anytime a(n) WIC Activity File is created and one already exists in the specified path for the same day.
"20220924" in the example above is a dating convention that signifies the date on which the WIC Activity File was processed. It is an 8-digit numeric value in "yyyyMMdd" format.
"231512" in the example above is a dating convention that signifies the time in 24-hour military time (or 24-hour clock time) on which the WIC Activity File was processed. It is a 6-digit numeric value in "HHMMSS" format, as follows:
"HH" = Hours
"MM" = Minutes
"SS" = Seconds
When the file type is WUMEI, where the value of the FILETYPE column is equal to "1" or "2" in the EBTCONNECTIONINFO table of the SPIRIT database, the naming syntax is set to:
[yyMMdd][HHMMSS][File Name Variable][YYMMDD][HHMMSS][Sequence Number]
For example, an WIC Activity File sent to the FileArchivePath specified in the EBTCONNECTIONINFO table of the SPIRIT database might be named "220924231445.bxml-2014.22092423151200". In this example, the file processed on September 24, 2022, at twelve (12) seconds past 11:15 PM.
"220924" in the example above is a dating convention that signifies the date on which the WIC Activity File was processed. It is a 6-digit numeric value in "yyMMdd" format.
"231445" in the example above is a dating convention that signifies the time in 24-hour military time (or 24-hour clock time) on which the WIC Activity File was processed. It is a 6-digit numeric value in "HHMMSS" format, as follows:
"HH" = Hours
"MM" = Minutes
"SS" = Seconds
".bxml-2014" in the example above is a [File Name Variable] which signifies the file type extension. This variable is an 10-character value with alphanumeric and special characters.
The exact name of the File Name Variable in your state's environment will equal the value specified in the VALUE column of the WicActivityFileTypeExtension row within the EBTCONNECTIONINFO table of the SPIRIT database.
"220924" in the example above is a dating convention that signifies the date on which the WIC Activity File was processed. It is a 6-digit numeric value in "yyMMdd" format.
"231512" in the example above is a dating convention that signifies the time in 24-hour military time (or 24-hour clock time) on which the WIC Activity File was processed. It is a 6-digit numeric value in "HHMMSS" format, as follows:
"HH" = Hours
"MM" = Minutes
"SS" = Seconds
"00" in the example above is a file naming convention signifying a [Sequence Number] that begins with "00" and increments anytime a(n) WIC Activity File is created and one already exists in the specified path for the same day.
The WIC Activity File is also referred by the following names in software solutions outside of the SPIRIT WIC system:
EBT Processor: "WIC Daily Interface Reconciliation File"
WIC Direct: "WIC Daily Interface Reconciliation File"
WIC EBT Middleware (WEM): "Benefit Activity File"
The tables below describe the data elements that comprise the WIC Activity File.
|
|
NOTE: The Header Record position, Details Record position, and Trailer Record data elements do not apply to WUMEI file types. |
Header Record
|
SPIRIT Element |
WUMEI Name |
Position |
Length |
+Type |
*Notes |
|
Record Type |
Unmapped |
1-2 |
2 |
X |
Coded Value - 'HD'. |
|
Transaction Type |
File Name |
3-10 |
8 |
X |
"[State Identifier Code]WACT". The [State Identifier Code] value as designated by the Food and Nutrition Service (FNS) division of the United States Department of Agriculture (USDA). For example, 'C4' is the [State Identifier Code] value for the Chickasaw Nation's WIC program as designated by FNS. The value is from the EBTCONNECTIONINFO table in the SPIRIT database. |
|
Date |
Date and time, transmission |
11-18 |
8 |
9 |
Date Field - "yyyyMMdd" format. |
|
Time |
Date and time, transmission |
19-26 |
8 |
9 |
Date Field - "HHMMSSFF" format. 'FF' signifies fractional seconds. |
|
Control Number |
File sequence number |
27-32 |
6 |
9 |
6-digit number incremented by 1 on each submission. |
|
WIC Program ID |
Unmapped |
33-34 |
2 |
X |
ยท |
|
Filler |
Unmapped |
35-250 |
216 |
X |
Empty space filled record. |
+ For more information, see Field Data Types.
* For more information, see Annotations.
Detail Record
|
SPIRIT Element |
WUMEI Name |
Position |
Length |
+Type |
File Mapping to SPIRIT Database (Table. Column) |
*Notes |
|
~Record Type |
Unmapped |
1-2 |
2 |
X |
Unmapped |
Coded Value - 'DT'. |
|
~Household ID |
WIC MIS account ID |
3-17 |
15 |
X |
EBTWICACTIVITY. HOUSEHOLDID |
"Recipient Number" in the EBT Processor system. Left aligned. Space filled. Unique number. |
|
~Filler |
Unmapped |
18-28 |
11 |
X |
Unmapped |
Space filled. |
|
~WIC Clinic Code |
Clinic Id |
29-33 |
5 |
X |
EBTWICACTIVITY. CLINICID |
Left aligned. Space filled. |
|
~Primary/Alternate Indicator |
Unmapped |
34-35 |
2 |
9 |
Unmapped |
Coded Value.
|
|
~Filler |
Unmapped |
36-39 |
4 |
X |
Unmapped |
Space filled. |
|
~Transaction Code |
Type Code |
40-42 |
3 |
9 |
EBTWICACTIVITY. TRANSACTIONCD |
The SPIRIT WIC system's transaction code.
|
|
~Transaction Log Date |
Date and time, host |
43-50 |
8 |
9 |
EBTWICACTIVITY. ACTIVITYDATETIME |
The EBT Processor's transaction log date or POS date. Date Field - "yyyyMMdd" format. It is combination of Transaction Log Date and Transaction Log Time. |
|
~Transaction Log Time |
Date and time, host |
51-58 |
8 |
9 |
EBTWICACTIVITY. ACTIVITYDATETIME |
The EBT Processor's transaction log time or POS time. Date Field - "HHMMSSFF" format. 'FF' signifies fractional seconds. If no fractional seconds exist in the file imported from the EBT Processor, '00' is right padded with zeroes when mapped to the SPIRIT WIC database. It is combination of Transaction Log Date and Transaction Log Time. |
|
~Transaction Response Code |
Unmapped |
59-60 |
2 |
9 |
EBTWICACTIVITY. RESPONSECD |
The SPIRIT WIC system's transaction response code. |
|
~Benefit Type |
Unmapped |
61-66 |
6 |
X |
Unmapped |
Coded Value - 'WIC'. Left aligned. Space filled. |
|
~Credit Debit Indicator |
Unmapped |
67-68 |
2 |
X |
EBTWICACTIVITY. CREDITDEBITINDICATOR |
Coded Value.
|
|
~Requested Amount |
Unmapped |
69-75 |
7 |
99999v99 |
EBTWICACTIVITY. CLAIMAMOUNT |
The aggregate requested amount for the unique benefit issuance number, applied category, and applied sub-category combination. Zero filled for subsequent benefit grand records within the same transaction. |
|
~Settled Amount |
Unmapped |
76-82 |
7 |
99999v99 |
EBTWICACTIVITY. PAIDAMOUNT |
The aggregate settled amount for the unique benefit issuance number, applied category, and applied sub-category combination. Zero filled for subsequent benefit grand records within the same transaction. |
|
~Origination Date |
Unmapped |
83-90 |
8 |
9 |
Unmapped |
The Origination Date is the same value as the Transaction Log Date. Date Field - "yyyyMMdd" format. |
|
~Business Date |
Date, business |
91-98 |
8 |
9 |
EBTWICACTIVITY. PAIDDATE |
The EBT Processor system's Settlement Date on the State Issuer Totals Screen/Report. Date Field - "yyyyMMdd" format. |
|
~WIC Vendor Number |
Unmapped |
99-105 |
7 |
9 |
EBTWICACTIVITY. VENDORID |
The WIC Vendor Number as supplied within transaction activity. |
|
~Peer Group Id |
Unmapped |
106-107 |
2 |
9 |
EBTWICACTIVITY. PEERGROUPID |
The WIC Vendor Peer Group ID from the WIC program. Left aligned. Space filled. For exception items, the field will be all spaces. |
|
~POS ID |
Unmapped |
108-122 |
15 |
X |
EBTWICACTIVITY. POSID |
The POS ID as supplied within transaction activity Space filled. |
|
~Vendor Name |
Unmapped |
123-137 |
15 |
X |
Unmapped |
The WIC Vendor Name as supplied within transaction activity. Space filled. |
|
~Vendor Location |
Unmapped |
138-177 |
40 |
X |
Unmapped |
The WIC Vendor Location as supplied within transaction activity. Space filled. |
|
~Card Entry |
Unmapped |
178-178 |
1 |
X |
EBTWICACTIVITY. CARDENTRY |
The method of card entry to facilitate the transaction at the vendor location. Coded Value.
Space filled. |
|
~Authorization Number |
Unmapped |
179-186 |
8 |
X |
EBTWICACTIVITY. AUTHORIZATIONCD |
The authorization number for the transaction. Left aligned. Space filled. |
|
~Unique Benefit Issuance Number |
Benefit Issuance Id |
187-206 |
20 |
X |
EBTWICACTIVITY. UNIQUEISSUANCENR |
The benefit authorization number in the EBT Processor system. Left aligned. Space filled. Positions 1-15 will contain the WIC Authorization Number in SPIRIT. Positions 16-20 will contain spaces only, as these positions are reserved for EBT Processor suffixes. |
|
~Applied Category |
Category Code |
207-208 |
2 |
9 |
EBTWICACTIVITY. CATEGORY |
The category that was reduced from the household benefit grant. Right aligned. Zero filled. |
|
~Applied Sub-category |
Sub-category code |
209-211 |
3 |
9 |
EBTWICACTIVITY. SUBCATEGORY |
The sub-category that was reduced from the household benefit grant. Right aligned. Zero filled. |
|
~Applied Qty |
Benefit Quantity |
212-216 |
5 |
999v99 |
EBTWICACTIVITY. QUANTITY |
The quantity in standard units reduced from the applied category/sub-category. Right aligned. Zero filled. |
|
~UPC Category |
Unmapped |
217-218 |
2 |
9 |
Unmapped |
The category assigned to the UPC/PLU by the WIC program, which can differentiate from the Applied Category. Right aligned. Zero filled. |
|
~UPC Sub-category |
Unmapped |
219-221 |
3 |
9 |
Unmapped |
The sub-category assigned to the UPC/PLU by the WIC program, which can differentiate from the Applied Sub-category. Right aligned. Zero filled. |
|
~Exception Indicator |
Unmapped |
222-222 |
1 |
X |
Unmapped |
Indicates that the detail record created an exception item. Coded Value.
|
|
Unmapped |
223-231 |
9 |
9 |
Unmapped |
The State Agency's unique profile number identifier. Coded Value. Zero filled. For example, '500030011' is an example of a unique profile number identifier where the last 3 digits are '011' and represent the WIC Authority ID value or the WIC program identifier for the Chickasaw Nation's WIC program as designated by the Food and Nutrition Service (FNS) division of the United States Department of Agriculture (USDA). This field does not exist in the WUMEI, therefore, it is not used for EBT to SPIRIT Files. |
|
|
~Original Unique Benefit Issuance Number |
Unmapped |
232-251 |
20 |
X |
EBTWICACTIVITY. ORIGINALISSUANCENR |
The unique benefit issuance number identified as a result of the EBT Processor investigation relating to an exception condition for adjustment transactions. Space filled if unknown. |
|
~NIT |
Unmapped |
252-257 |
6 |
X |
Unmapped |
The WIC Authority ID value as designated by the Food and Nutrition Service (FNS) division of the United States Department of Agriculture (USDA). Coded Value. Space filled. For example, '011' is the WIC Authority ID value for the Chickasaw Nation's WIC program as designated by FNS. |
|
~Card Number |
Unmapped |
258-276 |
19 |
X |
EBTWICACTIVITY. PAN |
The card used during the transaction. Space filled |
|
~Filler |
Unmapped |
277-290 |
14 |
X |
Unmapped |
Space filled. |
~ Denotes a required SPIRIT Element.
+ For more information, see Field Data Types.
* For more information, see Annotations.
Trailer Record
|
SPIRIT Element |
WUMEI Name |
Position |
Length |
+Type |
*Notes |
|
Record Type |
Unmapped |
1-2 |
2 |
X |
Coded Value - 'TR'. |
|
Transaction Type |
File Name |
3-10 |
8 |
X |
"[State Identifier Code]WACT". The [State Identifier Code] value as designated by the Food and Nutrition Service (FNS) division of the United States Department of Agriculture (USDA). For example, 'C4' is the [State Identifier Code] value for the Chickasaw Nation's WIC program as designated by FNS. The value is from the EBTCONNECTIONINFO table in the SPIRIT database. |
|
Date |
Date and time, transmission |
11-18 |
8 |
9 |
Date Field - "yyyyMMdd" format. |
|
Time |
Date and time, transmission |
19-26 |
8 |
9 |
Date Field - "HHMMSSFF" format. 'FF' signifies fractional seconds. |
|
Control Number |
File sequence number |
27-32 |
6 |
9 |
6-digit number incremented by 1 on each submission. |
|
Total Detail Records |
Unmapped |
33-38 |
6 |
9 |
Count of the number of detail records. Zero padded. |
|
Filler |
Unmapped |
39-250 |
212 |
X |
Space filled. |
+ For more information, see Field Data Types.
* For more information, see Annotations.
|
Software Version: 2.40.00
