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

The Food Obligations and Expenditures - Issue Month Report FIN004 (Output) 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 the current month. If the selected month has been closed, the Food Obligations and Expenditures - Closeout Month Report FIN002 (Output) will print. If the selected month is the 30-day status, the Food Obligations and Expenditures - 30 Day Status Report FIN003 (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,a nd the state summary will be printed for the 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 - clinic, agency, state, or all. Within this, WIC status and food instrument type group the data.

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

• Issued counts

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

• Issued amount

• 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

• Outstanding count

• Outstanding count values will NOT necessarily match corresponding values on Obligation Value for O/S FIs Issued report. This report looks at paid/void dates within given ranges. The Obligation Value for O/S FIs Issued reports look at paid/void dates with values greater that zero.

• Outstanding amount

• Outstanding amount values will NOT necessarily match corresponding values on Obligation Value for O/S FIs Issued report. This report looks at paid/void dates within given ranges. The Obligation Value for O/S FIs Issued reports look at paid/void dates with values greater that zero.

• Total estimated expenditures

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 CurrentMonthEndDt 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 WICCategory, FIType, 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 Type

Origin of Data Element

This value is the code associated with the combination of distribution items and quantities on the food instrument. The value comes from the FoodInstrumentType column of the FoodInstrument table.

Format

This is a five-character value.

FI Issued Number

Origin of Data Element

This value is the count of the total number of food instrument records selected. The 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 Issued Amount

Origin of Data Element

This value is the sum of the ObligationAmt column on the FoodInstrument table for the selected food instrument records. The value for paid without issuance (unknown) is zero.

Format

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

FI Redeemed Number

Origin of Data Element

This value is the count of the total number of food instrument records selected where the PaidDate column of the FoodInstrument table is during the current month. The 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

This value is the sum of the PaidAmount column on the FoodInstrument table for the selected food instrument records wehre the PaidDate column of the FoodInstrument table is during the current month. The 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

This value is the count of the total number of food instrument records selected where either the PaidDate column or VoidDate column of the FoodInstrument table is during the current month. The 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

This value is the sum of the ObligationAmt column on the FoodInstrument table for the selected food instrument records where either the PaidDate column or VoidDate column of the FoodInstrument table is during the current month. The value for paid without issuance (unknonw) is zero.

Format

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

FI Outstanding Number

Origin of Data Element

This value is calculated by subtracting the FI Deobligated Number from the FI Issued Number for the row.

Format

This is a six-digit number.

FI Outstanding Amount

Origin of Data Element

This value is calculated by subtracting the FI Deobligated Amount from the FI Issued Amount for the row.

Format

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

Total Est. Expenditures

Origin of Data Element

This value is calculated by totaling the FI Outstanding Amount and the FI Redeemed Amount for the row.

Format

This is a nine-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 Current Month

Food instruments where the ParticipationDate column of the FoodInstrumentSet table is the same as the current month and the ProgramCode column of the FoodInstrument table equals the WIC value are included in the reported 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 re-processed 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 current 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 states 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, FI Deobligated, FI Outstanding and Total Expenditures for each clinic/agency.

Grand Total

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