Category/Sub-category File

Contents ShowHide

The EBT Processor system's format for the Category/Sub-category File is used for outbound communication from the SPIRIT system to the EBT Processor system.

The Category/Sub-category File is sent from the SPIRIT WIC system to the EBT Processor system during End of Day Processing. For more information, see the SPIRIT to EBT Files section of the EBT Processor Import/Export Files topic.

The Category/Sub-category 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 Category/Sub-category 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.

NOTE: File names must match your state's EBT Processor's file name format requirements. The EBT Processor may also impose maximum length, date format, special character, or other restrictions.

The naming syntax for the Category/Sub-category 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:

• "C4" in the example above is a [State Identifier Code] which signifies a Chickasaw Nation's Category/Sub-category 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.

In the values above, "C4" and "WCSB" comprise a six-character Category/Sub-category File name example, but the exact name of the Category/Sub-category File in your state's environment will equal the value specified in the VALUE column of the CatSubcatFileName row within the EBTCONNECTIONINFO table of the SPIRIT database.

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

• "{0:[Date Time Format Variable]}" is a date/time format and contains the following components:

• "{0:" signifies the beginning of the date/time format.

• The [Date Time Format Variable] signifies a standard date time format accepted by your state's EBT Processor. The format used in the example above is yyyyMMdd.HHMMSS.

• "}" signifies the end of the date/time format.

During End of Day Command Line Batch Processing, the format is replaced by the actual date and time the Category/Sub-category File is processed. The example above includes the following date and time:

• "220924" in the example above is a dating convention that signifies the date on which the Category/Sub-category File was generated. It is a 6-digit numeric value in "YYMMDD" format.

• A period separates the date and time in this 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 Category/Sub-category File was processed. It is a 6-digit numeric value in "HHMMSS" format.

• ".csxml-2014" in the example above is a [File Extension Variable] which signifies the WIC Universal MIS EBT Interface (WUMEI) version supported. It is an 11-character value with alphanumeric and special characters.

The exact name of the File Extension Variable in your state's environment will equal the value specified in the VALUE column of the CatSubcatFileTypeExtension row within the EBTCONNECTIONINFO table of the SPIRIT database.

The naming syntax for the Category/Sub-category 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:

• "220924" in the example above is a dating convention that signifies the date on which the Category/Sub-category 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 Category/Sub-category 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:

• "220924" in the example above is a dating convention that signifies the date on which the Category/Sub-category 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 Category/Sub-category 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) Category/Sub-category File is created and one already exists in the specified path for the same day.

NOTE: The Header Record position, Details Record position, and Trailer Record data elements do not apply to WUMEI file types.

+ For more information, see Field Data Types.

* For more information, see Annotations.

~ Denotes a required SPIRIT Element.

+ For more information, see Field Data Types.

* For more information, see Annotations.

+ For more information, see Field Data Types.

* For more information, see Annotations.

|

Software Version: 2.40.00