Food Obligations and Expenditures - Closeout Month Report FIN002 (Output)

The Food Obligations and Expenditures - Closeout Month Report FIN002 (Output) report consists of individual clinic summaries, agency summaries, and the state summary. The report is generated when the OK button is clicked on the Generate Food Obligations and Expenditures Report screen and the selected month is in the closeout status. If the selected month is in the 30 day status, the Food Obligations and Expenditures - 30 Day Status Report FIN003 (Output) will print. If the selected month is the current month, the Food Obligations and Expenditures - Issue Month Report FIN004 (Output) will print.

This report will also be generated as part of the month-end process using the selection criteria of "All". During the month-end process, individual clinic summaries, agency summaries and the state summary will be printed for following reports.

• Food Obligations and Expenditures - Closeout Month Report FIN002 (Output)

• Food Obligations and Expenditures - 30 Day Status Report FIN003 (Output)

• Food Obligations and Expenditures - Issue Month Report FIN004 (Output)

Data is grouped on the report based on selection criteria- agency, clinic, state or all. Within this, the data is grouped by WIC category.

The Food Obligations and Expenditures - Closeout Month Report FIN002 (Output) includes the following summaries.

• Issued counts

• Issued count values will match corresponding count values on Obligation Value for O/S FIs Issued report.

• Redeemed count

• Redeemed counts do not include early or late payments.

• Redeemed amount

• Redeemed amounts do not include early or late payments.

• De-obligated counts

• De-obligated amount

The redemption values on the following month-end reports are totaled and used to balance to the total expenditure for the associated month.

• Food Instruments Redeemed Early

• Food Obligation and Expenditures - Closeout Month (previous month-end cumulative dollars minus the current month-end cumulative dollars for the same calendar month.)

• Food Instruments Redeemed Late

Issue Month

Origin of Data Element

The user records this value when the report is submitted. During the month-end process this is the CCYYMM value from the CloseMonthEndDt column of the ProcessControl table.

Format

This is an accounting month and year formatted as Month Name CCYY.

Clinic / Agency / State Total

Origin of Data Element

The selection criteria and information being reported determine this value.

• When reporting clinic data, the agency code, agency description, clinic code and clinic description will be printed.

• When reporting agency data, the agency code and description will be printed.

• When reporting state data, the text description of "State Total" will be printed.

Format

This is a fifty-character text field. The format is determined by the information being reported.

Category

Origin of Data Element

This value is the category of the participant that is issued the food instrument. The value comes from the WICStatus column of the FoodInstrumentSet table.

Paid without issuance records from the BankExceptions table do not have associated values for WIC Category, FI Type, Agency or Clinic. The totals for these records are listed as an "Unknown" category total on the state report.

Format

This is a one-character value.

FI Issued Number

Origin of Data Element

The cumulative value is the count of the total number of food instrument records selected. The cumulative value for paid without issuance (unknown) is the count of the total number of bank exception records selected.

Format

This is a six-digit number.

FI Redeemed Number

Origin of Data Element

The cumulative value is the count of the total number of food instrument records selected where the PaidDate column of the FoodInstrument table is during the selected month, the month after the selected month or two months after the selected month. The cumulative value for paid without issuance (unknown) is the count of the total number of bank exception records selected.

Format

This is a six-digit number.

FI Redeemed Amount

Origin of Data Element

The cumulative value is the sum of the PaidAmt column on the FoodInstrument table for the selected food instrument records where the PaidDate column of the FoodInstrument table is during the selected month, the month after the selected month or two months after the selected month. The cumulative value for paid without issuance (unknown) is the sum of the PaidAmt column on the BankExceptions table for the selected bank exception records.

Format

This is an eight-digit number plus two decimal places.

FI Deobligated Number

Origin of Data Element

The cumulative value is the count of the total number of food instrument records selected where the PaidDate column of the FoodInstrument table is during the selected month, the month after the selected month or two months after the selected month plus the count of the total number of food instrument records selected where the VoidDate column of the FoodInstrument is less than the selected month or during the selected month, the month after the selected month or two months after the selected month. The cumulative value for paid without issuance (unknown) is the count of the total number of bank exception records selected.

Format

This is a six-digit number.

FI Deobligated Amount

Origin of Data Element

The cumulative value is the sum of the ObligationAmt column on the FoodInstrument table for the selected food instrument records where the PaidDate column of the FoodInstrument table is during the selected month, the month after the selected month or two months after the selected month plus the sum of the ObligationAmt column on the FoodInstrument table for the selected food instrument records where the VoidDate column of the FoodInstrument table is less than the selected month or during the selected month, the month after the selected month or two months after the selected month. The cumulative value for paid without issuance (unknown) is zero.

Format

This is an eight-digit number plus two decimal places.

Filter Criteria

Base of Data

The report is based on food instruments that meet either of the following selection criteria.

Issued for the closeout month

Food instruments where the ParticipationDate column of the FoodInstrumentSet table is the same as the closeout month and the ProgramCode column of the FoodInstrument table equals the WIC value are included in the report totals.

Paid without issuance

Payment without issuance occurs when payment information is recorded before the issuance information. This can happen in a data sync environment if the food instrument is redeemed before the data sync process completes for the clinic that issued the food instrument. The paid without issuance data is recorded in the BankExceptions table. During the End of Day process, the payment records in the BankExceptions table are reprocessed to determine if the issuance information has been recorded yet. If it has, the payment information is updated and the record is removed from the BankExceptions table.

The remaining paid without issuance records that meet the following selection criteria are included in the state report totals as an Unknown WIC Category.

• • The PaidDate column of the BankExceptions table is within the closeout month

• The PaidAmt column of the BankExceptions table is greater than zero

• The PaidInd column of the BankExceptions table is equal to "Y"

• The ReApplyInd column of the BankExceptions table is equal to "Y"

Clinic, Agency, State, All

If an individual clinic is selected, only data for that clinic will be included. If an individual agency is selected, summary data for that agency will be included. If the state is selected, summary data for the state level will be included. During the month-end process when all is selected, data for all clinics, agencies and state will be selected in the following sequence. Data for hidden agencies will not be included.

• Agency 01, clinic 01

• Agency 01, clinic 02

• Agency 01 summary

• Agency 02, clinic 21

• Agency 02, clinic 22

• Agency 02 summary

• State summary

Sort Order

Clinic / Agency / State Total

This report will be sorted by clinic code, agency code and state totals, depending on selection criteria of the report.

• If the clinic total is selected, this part of the sort order does not apply.

• If the agency total is selected, this part of the sort order does not apply.

• If the state total is selected, this part of the sort order does not apply.

• If all is selected, the report will be sorted by agency code then clinic code. The state summary will print at the end.

Category

This report will be sorted by category within clinic/agency/state. Category data will be displayed in the following sequence.

• Unknown

• Pregnant Women

• Breastfeeding Women

• Non-Breastfeeding Women

• Infants

• Children

Control Breaks

Clinic / Agency

A page break will occur on change in clinic/agency. Totals will be calculated for FI Issued, FI Redeemed and FI Deobligated for each clinic/agency.

Grand Total

State totals will be calculated for FI Issued, FI Redeemed and FI Deobligated when the state or all option is selected.