|
|
NOTE: The format of the generated account balance and shopping list reports can be customized in the Reference Utility application module. For more information, see the Modify EBT Shopping List Reports screen. |
Contents Show
The EBT Benefit Issuance (Output) displays the benefit issuance information for a household. It combines data from the EBT Processor system and the SPIRIT system. It displays participant-level details for the EBT benefits that were just issued, and also displays the issuance total for the household. The data is retrieved from the FOODINSTRUMENTITEMDETAIL table and the existing benefit account balance from the EBT Processor system. The report is generated when the OK button is clicked on the Print Shopping List screen.
The ShoppingList.doc template is the basis for this report output and is initially installed in the following folder during the SPIRIT WIC Client installation:
{drive letter}:\Users\Public\CSC\WIC\TemplatesBase\
By default, the ShoppingList.doc template contains the following fields and is formatted as follows:
SPIRITLogoImage.jpg
EBT Benefit Issuance
Household ID: «HouseholdID»
Primary Card Holder: «PrimaryCardHolder»
«ShoppingList»
«EndingCerts»
Milk Conversion:
.75 = 1 quart and 1 half-gallon or 3 quarts
.5 = 1 half-gallon or 2 quarts
.25 = 1 quart
Printed on: «PrintDate»
{page number}
|
|
NOTE: The format of the generated account balance and shopping list reports can be customized in the Reference Utility application module. For more information, see the Modify EBT Shopping List Reports screen. |
This section describes the data elements that print on the document. The data elements are generated based on the data passed into the form; they do not map to specific database fields.
A standard SPIRIT logo image is available within the generated output. However, this can be modified for your state in the ShoppingList.doc template.
Origin of Data Element
The image displayed is sourced from the ShoppingList.doc template.
Format
The image prints as a picture.
The default title of the report is the text "EBT Benefit Issuance". However, this can be modified for your state in the ShoppingList.doc template.
Origin of Data Element
The value is a literal value.
Format
The value prints as its literal value.
|
|
NOTE: For more information about customizing templates used in the SPIRIT WIC system, refer to the Customizing Templates section of the SPIRIT WIC Templates topic in the SPIRIT WIC Detailed Functional Design Document (DFDD). |
Origin of Data Element
The value is the HOUSEHOLD.HOUSEHOLDID of the household for which the report is generated.
Format
The value prints in "Household ID: HOUSEHOLD.HOUSEHOLDID}" format.
Origin of Data Element
The values displayed in this column are dependent upon the value in HOUSEHOLD.EBTPRIMARYCARDHOLDERID and one of the following:
MEMBER.FIRSTNAME, MEMBER.MIDDLEINITIAL, MEMBER.LASTNAME
HOUSEHOLD.AUTHREPFIRSTNAME, HOUSEHOLD.AUTHREPMIDDLEINITIAL, HOUSEHOLD.AUTHREPLASTNAME
HOUSEHOLD.ALTREP1FIRSTNAME, HOUSEHOLD.ALTREP1MIDDLEINITIAL, HOUSEHOLD.ALTREP1LASTNAME
HOUSEHOLD.ALTREP2FIRSTNAME, HOUSEHOLD.ALTREP2MIDDLEINITIAL, HOUSEHOLD.ALTREP2LASTNAME
Format
The values print in "Primary Card Holder: {FIRSTNAME} {MIDDLEINITIAL}. {LASTNAME} , {STATEWICID}" format.
Origin of Data Element
The value is the participant name(s) of the household for which the report is generated.
Format
The value(s) print in "{MEMBER.FIRSTNAME} {MEMBER.LASTNAME} {MEMBER.STATEWICID}" format.
Origin of Data Element
The values displayed in this column are populated from the START_DATE thru EXPIRE_DATE field in a call made to the EBT Processor system for WIC_BENEFIT_REQUEST.
Format
The value(s) print in "{MM/DD/CCYY} - {MM/DD/CCYY}" format.
Origin of Data Element
The values displayed in this column are populated from the QUANTITY field in a call made to the EBT Processor system for WIC_BENEFIT_REQUEST.
This is based off of the new FOODINSTRUMENTITEMDETAIL.FOODINSTRUMENTITEM FOODINSTRUMENTITEMDETAIL.FOODITEMID FOODINSTRUMENTITEMDETAIL.ITEMQUANTITY records created.
This is what was returned in WIC_BENEFIT_REQUEST returned for current benefit period.
This is the aggregated total from the Item Quantities above.
Format
This is a numeric value.
Origin of Data Element
The values displayed in this column are based off of the value of the CatSubcatListDescription business rule and may contain a combination of the following fields from the from EBTFOODCATSUBCATEGORY table:
FOODCATEGORYCD
FOODCATEGORYCDFOODSUBCATEGORYCD
FOODSUBCATDESCRIPTION
UNITOFMEASURECD
SUBCATSHORTDESCRIPTION
Format
The values print as literal values.
Origin of Data Element
The value(s) is the total available for the household for which the report is generated.
Origin of Data Element
This value is the end date after which the participant is no longer certified and cannot utilize WIC benefits. It is printed for all members of the household that are within an active certification.
Format
The value(s) will print in "{MEMBER.FIRSTNAME} {MEMBER.MIDDLEINITIAL}. {MEMBER.LASTNAME} -- This Participant's certification ends on {CERTCONTACT.CERTENDDATE}" format.
Origin of Data Element
This value is the current date at time the report is generated.
Format
The values print in "Printed On: {PrintDate}" format.
A page number displays at the bottom of the report if multiple pages are generated.
Origin of Data Element
The value is a literal value.
Format
The page number is centered at the bottom of the page.
|
Software Version: 2.40.00
