COVID-19 Instructions for CFAP Reporting

REPORTING INSTRUCTIONS FOR RETRIEVAL OF DATA FOR Coronavirus Aid, Relief, and Economic Stability Act (CARES), Coronavirus Food Assistance Program (CFAP) COVID-19 PROGRAM

TABLE OF CONTENTS:

1 Background Information:
2 Summary Approach Using AGRIS:
3 Recommended steps:

Background Information:

The ruling on this topic from the USDA can be found at https://www.farmers.gov/sites/default/files/documents/CFAP Final Rule.pdf. That document includes:

SUMMARY: “The Secretary of Agriculture is issuing this rule to implement the Coronavirus Food Assistance Program (CFAP). CFAP provides assistance to agricultural producers impacted by the effects of the COVID-19 outbreak. This rule establishes provisions for direct payments to producers of eligible commodities. This rule specifies the eligibility requirements, payment calculations, and application procedures for CFAP."
"For producers of non-specialty crops,...Eligible inventory for the purpose of non-specialty crops is the lower of self-certified unpriced inventory that an eligible producer has vested ownership in as of January 15, 2020, or 50 percent of the eligible producer’s 2019 production of that commodity." (page 6)
“§ 9.2 Definitions. "Unpriced inventory means any production that is not subject to an agreed-upon price in the future through a forward contract, agreement, or similar binding document." (page 28)

Summary Approach Using AGRIS:

With AGRIS, calculating all customers' unpriced balances as of 1/15/20 will involve processing two Delivery Sheet reports.

The first will show all deliveries on or before Jan 15^th that are still unpriced today.
The second will show everything that was delivered on or before Jan 15^th but has been priced after that date.
The total of the two reports provides the customer's unpriced balance on January 15^th. These reports require all tickets to be on Delivery Sheets.

Cultura Technologies Support will email you the reports that you need to run. The reports are setup as summary level reports. You will want to download the files on to your AGRIS server. A separate Word document will be included on how to get these reports into AGRIS.

Recommended steps:

Download the Delivery Sheet report files to your AGRIS server, per the instructions on the Word document called How to Transfer a Report/Form into AGRIS.
Copy your Live dataset, so that you can work in an environment that is not constantly changing.
Run Automatic Delivery Sheets for all Commodities, all Purchases, all Locations, all Customer Name Id's, all Shipment Dates, all Application Types, as this print screen shows:
Run the User Defined Delivery Sheet Report called "Covid 19 Current Unpriced Balances". This will give you all Unpriced quantities as of today, stating we don't want any tickets that have been unloaded after 1/15/20. Double-check to make sure the Range Selection Criteria to look like this:
Run the User Defined Delivery Sheet report called "Covid 19 Priced Sheets Since 1/15/20". This will give you everything that has been priced since 1/15/20, again it does not include any new ticket activity since 1/15/20. Double-check to make sure the Range Selection Criteria to look like this:
Add the totals together from the 2 reports & that will be what their Unpriced Balance as of 1/15/20.

For Directions to Bring Reports into AGRIS click https://culturatech.atlassian.net/wiki/spaces/ACD/pages/1272217676 .