Presented by:Shanita Hines

Agricultural Program SpecialistPrice Support Division, Automation Branch

202-720-9888Washington, DC

7/24-7/26

Overview of CMA/LSA

Automated Eligibility

Process

CMA Process Overview

• Purpose• General

Information/Rules• File Submission (input

file)• File Download (output

file)• Analyzing Output Data• Resolving Eligibility

Problems• CY 06 Status

PURPOSE 1-CMA (Rev.1), Par 215

The CMA Process is an automated process used by CCC to provide loan and LDP eligibility and PLM to and CMA/LSA’s

The CMA Process involves 6 phases:- Submitting ID’s- Processing ID’s- Returning Data- Summary/Status Reports- Collectively correcting problems

General Information (Scheduling and Location) 1-CMA (Rev.1), Par 216

Submission Schedule:The deadline for CMA/LSA’s to submit an input file is Sunday and Wednesday by 6 p.m. CT

Release of Data:The output file is available for download after 2 p.m. CT each Tuesday and Friday in the applicable folder at the secure FTP site

Where to FTP and receive LSA files:IP Address: 165.221.200.44 Starting folder is /CMA (each LSA will be assigned a folder)

General Information(Processing Methods)

E lig ib ility P L M

C ou n ty O ffices(A S /4 0 0 )

C oop C ou n ty O fficesF or G ra in C M A

(A S /4 0 0 )

N ITC(K C M O -M ain fram e)

sFTP Server

GENERAL INFORMATION(8 Files Used) 1-CMA (Rev.1), Par 224

These COF Files are Used by CMA Process:

Compliance Share File

County Table Maintenance

Eligibility File

Multi-county File

Name and Address File

Permitted Entity File

Payment Limitation File

FSA-578 Compliance Summary File

General Information (Processing Rules]

General CMA Process Rules:

– Submit ID numbers for all producers expected to receive benefits

– Submit ID numbers for joint operations (partnership)

– Submit ID numbers for entities (corporations).

1-CMA (Rev.1), Par 225

1-CMA (Rev.1), Par 236 FILE SUBMISSION

There are 5 basic stages for CMA’s/LSA’s in

transmitting input files:

• Obtain appropriate producer data

• Create input file

• Create control record file

• Zip files created

• Submit to sFTP host by Sunday or Wednesday 6:00 p.m.

FILE SUBMISSIONCreate Input File (MB1) 1-CMA (Rev.1), Par 237

• Create the input file using any ASCII text editor, ex. NOTEPAD• the input file is named “CMAXXYYY.mb1”, where XXYYY is the

State and county code of CMA/LSA• Create the input file with a record length of always 43 characters.

• 480270021480291234567890700000000000000000 • C480270021480291234567890700000000000000000

Field No. Contents Begin Length Data Type

1 Record Status (leave blank unless canceling or deleting a record) 1 1 Char

2 State code of CMA, DMA, or LSA 2 2 Char

3 County code of CMA, DMA, or LSA 4 3 Char

4 Crop code 7 4 Char

5 State code of producer's administrative County 11 2 Char

6 County code of producer's administrative County 13 3 Char

7 producer ID number 16 9 Char

8 Crop year 25 2 Char

9 Farm number (for “D” transactions only) 27 7 Char

10 Filler (leave blank) 34 10

FILE SUBMISSIONCreate Control Record File (MB4) 1-CMA (Rev.1), Par 239

• The Control Record File provides KC and LSAs the number of records being submitted to and from the FTP host.

• control record file is named “CMAXXYYY.mb4”, where XXYYY is the State and county code of CMA/LSA

• 4802700000502005/04/26

Field No. Contents Begin Length Data Type

1 State code of CMA, DMA, or LSA 1 2 Char

2 County code of CMA, DMA, or LSA 3 3 Char

3 Filler 6 1

4 Number of records in input file 7 7 Char

5 Filler 14 1

6 Date input file was preparedExample: yyyy/mm/dd

15 10 Char

FILE SUBMISSION(Zipping Files)

Access WINZIP or similar software such asPKWARE from PC.

1-CMA (Rev.1), Par 240

Zip the 2 files together which will later be transmitted to KC

FILE SUBMISSION(Transmitting to KC) 1-CMA (Rev.1), Par 204

• Obtain a user ID and password from PSD

• Access the free downloadable secure FTP site at: http://www.glub.com/products/secureftp/download.shtml

• Follow prompts to successfully download a one-time install “Secure FTP (v2.5.X)”.

FILE SUBMISSION(Transmitting to KC) 1-CMA (Rev.1), Par 204

• Access the specified host name or sFTP Client

• Choose “Add Bookmark”

• “Profile” will be what the user chooses to name the connection

• “Host Name” is always “165.221.200.44”

• Enter the assigned user name and password received from PSD. “User Name” will always begin with tds\

Note: Do not save or cancel

1-CMA (Rev.1), Par 204 FILE SUBMISSION

(Transmitting to KC)•click on the “Options” tab

• under the “Options” tab, change “Security Mode” to “Implicit SSL” by using the drop-down list

• choose “Save”.Note: This will close the window.

FILE SUBMISSION(Transmitting to KC) 1-CMA (Rev.1), Par 204

Click on “Bookmarks” and click on the specified “Profile Name” that was created earlier from the drop-down list, the software will be launched.

Choose “Grant Always” in the next pop-up box to close the window and connect to the secure FTP

FILE SUBMISSION(Transmitting to KC) 1-CMA (Rev.1), Par 204

• access the zipped files that you saved in the left

tree

• Users may upload and download the files by the “drag and drop”

method or simply right click on the files and choose “upload” or

“download”.

FILE SUBMISSIONThings to REMEMBER!!

• Only ineligible producers may be deleted.

• eligible and ineligible producers records may be canceled when erroneous or incorrect

producer ID

• If you re-submit a producer ID

NO RESPONSE UNLESS A CHANGE .

The Output File 1-CMA (Rev.1), Par 251

There are 7 basic stages For CMA’s/LSA’s intransmitting output files:

• Download CMA files after 2 p.m. Tuesday and Fridays

• Unzip compressed file• Compare number of records in output file

w/number reported in control record.• Print and Review CMA/LSA

Summary/Transmission Status Report • Analyze output file.

The Output File 1-CMA (Rev.1), Par 251

The CMA Process

Returns:

• Producer Eligibility

• Farm & Crop Eligibility

• Component member Payment Limitation

The CMA Processgenerates a record for each:

tax-ID

FSN

crop code

component member

Reports

There are several files and reports that will be returned in the weekly download:

1. Transmission Status Report (MB0)

2. Output File (MB2)

3. CMA/LSA Summary Report (MB3)

4. Full-File Download (MB5)

5. Name and Address Status Report (MB6)

6. Producer Loan and LDP Volume Report (LV1)

1-CMA (Rev.1), Par 251-256

The Output File (Downloading) 1-CMA (Rev.1), Par 251

Follow the same steps that you did when

you submitted your file:

The Output File(Unzipping file) 1-CMA (Rev.1), Par 251

Click on a specific report to print or import needed files.

The Output File Output File Record (MB2)

Raw Data:

I9953802111111111E04N5304353043 000001000010000

9312345670037500 00001250011 00064000000000 06667 53043SMITH FARMS INC NNNNNNY NNNNYNN NNNNNN NNNNNNNNNN NN 19990728

Detailed explanation of each Data Field1-CMA (Rev.1), Par 268-371

Analyzing Data

•strongly advisable to import download file (MB2/MB5) into a program such as Microsoft Access that will allow you to add column headings for clarity.

ReportsSummary Report (MB3)

Using Winzip, click on the MB3 file and print.

Analyzing Data

• Analyze Weekly File Download for:

1. All ineligible records

2. Missing information

3. Information that may have changed

• Our Specialists Review Weekly Summaries and Identify Problems

Resolving Problems

Communication is essential for any program to work to its full potential. Any questions or concerns should be addressed to the CMA staff in WDC. These will be coordinated with the staff at KCMO.

Information Needed:

• State and County Code

• Farm Number

• Producer(s) Name and ID number

• Full Description of Problem

CMA Process Status Report

• Changes in 06 CY– Processing schedule– Field changes– Reading correct files– State Office Status Report Disabled

• Frequent problems of 06 CY– Submitting CY 05 instead 06– File naming convention– Component member payment limit

COMMENTS orQUESTIONS

Thank You