FNS-798 - Page 3 - Actual Outlays Worksheet (Output)

• FNS-798 - Page 1 - Statement Spreadsheet (Output)

• FNS-798 - Page 2 - Statement Spreadsheet (Output)

• FNS-798 - Page 4 - Formula Rebate Worksheet (Output)

• FNS-798 - Page 5 - Milk Rebate Worksheet (Output)

• FNS-798 - Page 6 - Infant Fruit and Vegetable Worksheet (Output)

• FNS-798 - Page 7 - Infant Meat Rebate Worksheet (Output)

• FNS-798 - Page 8 - Juice Rebate Worksheet (Output)

• FNS-798 - Page 9 - Cereal Rebate Worksheet (Output)

The report is generated when the OK button is clicked on the Generate FNS-798 Statement Spreadsheet screen.

Month Ending

Origin of Data Element

This value is the month and federal fiscal year selected when the report is generated.

Format

This is a fifty-character value formatted with Month Name and Year.

Food Obligations - Issuance Months

Origin of Data Element

This value is the months of the federal fiscal year. The columns represent months of issuance. The column headings are static.

Format

This is a ten-character value.

Food Obligations - Redemption Months

Origin of Data Element

This value is the month of redemption. These values vary and are the row headings. There will be a row for each month of redemption during the selected reporting period.

Format

This is a ten-character value.

Food Obligations - Dollars

Origin of Data Element

This value is the sum of the PaidAmount column of the FoodInstrument table plus the sum of the PaidAmount column of the FoodInstrumentItemRedeemd table for food instruments with one of the following selection criteria. The values are summarized by issuance month and redemption month and placed in the appropriate spreadsheet cell.

• The ParticipationDate is between the start of the federal fiscal year and the through accounting period, inclusive, and the PaidDate is greater than zero.

• The ParticipationDate is equal zero and the PaidDate is between the start of the federal fiscal year and the through accounting period, inclusive.

Format

This is a nine-digit value.

Filter Criteria

Base of Data

The spreadsheet is based on the following selection criteria.

• The food instrument issuance date must be within the start of the selected federal fiscal year and the through accounting period.

• The food instrument must be redeemed.

Sort Order

Redemption Month

Rows on this spreadsheet will be sorted by redemption month.

Grand Total

Each column and row will be summarized.