Contents Show
The Benefit Report (Output) displays the benefit issuance information for a household. It combines data from the EBT Processor system and the SPIRIT system. The first page contains participant-level details of the EBT benefits that were just issued. The second page contains the issuance total for the household, drawn from the FOODINSTRUMENTITEMDETAIL table, and the existing benefit account balance drawn from the EBT Processor system. The report is generated when the OK button is clicked on the Generate Benefit Report 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.
The title of the report is the text "EBT Benefit Issuance".
Origin of Data Element
The value is a literal value.
Format
The value prints as its literal value.
Origin of Data Element
The value is the HOUSEHOLD.HOUSEHOLDID of the household for which the report is generated.
Format
The value will print as its literal value.
Origin of Data Element
The values displayed in this column are populated from the FIRST, LAST, and MIDDLEINITIAL fields in a call made to the WIC Direct system for GETCARDHOLDERCARDS.
Format
The value will print in {first name}, {last name}, {WIC ID} 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) will print in {first name} {last name} 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) will print in {Month Abbr.} {MM/DD - MM/DD/YY} format.
Origin of Data Element
The values displayed in this column are populated from referencing the CATEGORY and SUB_CAT field in a call made to the WIC Direct system for WIC_BENEFIT_REQUEST then finding it in FOODITEM local references. .
Format
The value prints as its literal value.
Origin of Data Element
The values displayed in this column are populated from the QUANTITY field in a call made to the WIC Direct system for WIC_BENEFIT_REQUEST.
This is based off of the new FOODINSTRUMENTITEMDETAIL. FOODINSTRUMENTITEM FOODINSTRUMENTITEM.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 value(s) is the total new issuance for the household for which the report is generated.
Origin of Data Element
The value(s) is the existing benefits for the household for which the report is generated.
Origin of Data Element
The value(s) is the total available for the household for which the report is generated.
|
Software Version: 2.40.00
