USDA Image
TO:
All Insurance Providers
Jason Albright
/s/ Chris Aulbur for
FROM:
Chief, Actuarial Branch
SUBJECT:
RO Server Release 10-029 - Actuarial Information Available
As of August 20, 2010 the following information is now available on the Reporting Organization (RO) Server:
2011 Actuarial Data Master for the 4/30, 6/30, 8/31, 9/30, 10/31 Filing Date, YTD, and Daily Files.
2011 Special Provisions for the 8/31, 9/30, 10/31 Filing Date.
Users can find this information on the RO Server in the following directories:
2011 Actuarial Data Master are in the References/Actuarial_Data_Master/2011 directory.
2011 Special Provisions are in the Special_Provisions/2011 directory.
Additional notes and details regarding this data release:
2011 SPOIs, ADM, Map Shape and related files are now released for 8/31, 9/30, and 10/31 filings.
ADM (A01040) Coverage Level Differential record updated to expand 80/85 coverage for Wheat and Canola plans 01/02/03 in states and counties having RA in 2010, 6/30 filing.
ADM Coverage Level Differential records are completely replaced for PRF (0088) plans 13/14 to correct the association of coverage level to county versus Grid ID, 6/30 filing.
ADM (A00045) Map records are now completely refreshed for the 4/30 and 6/30 filings and the layout of this new record type posted.
ADM (A00200) Dates record updated to populate cancellation and termination dates to match the Dry Peas Crop Provisions on the WO option, 6/30 filing.
ADM Dates record updated for Spokane region Barley plans 01/02/03 populate Contract Change Date for WO option to match the Winter Coverage Endorsement, 6/30 filing.
ADM (A00050) Quality record updated so the data now matches the quality statements on the SPOIs, 6/30 filing.
ADM (A00030) Insurance Offer record updated to show pilot status of a "P" for PRF (0088), 6/30 filing.
ADM (A00440) County record populated to have all county codes for livestock states, 4/30 filing.
Please notify your data processing representative that this information is available for downloading. For questions regarding the actuarial information, please contact Ron Tilly by phone at (816) 926-1337, or via email to
ronald.tilly@rma.usda.gov.
Archived RO Server Release memos are located online at
http://www.rma.usda.gov/news/ro-server/.

 
File Name
Contains
Record Count
   
2011_ADM_Daily_100820.zip
A00010_AdmLayout_Daily.txt
28
 
A00030_InsuranceOffer_Daily.txt
60,917
 
A00045_Map_Daily.txt
1,352,750
 
A00050_Quality_Daily.txt
135
 
A00070_SubsidyPercent_Daily.txt
58
 
A00200_Date_Daily.txt
26,723
 
A00400_AgrCommodity_Daily.txt
399
 
A00410_Class_Daily.txt
7
 
A00420_Commodity_Daily.txt
53
 
A00430_CommodityType_Daily.txt
161
 
A00440_County_Daily.txt
326
 
A00450_CroppingPractice_Daily.txt
18
 
A00460_InsurancePlan_Daily.txt
6
 
A00470_IntendedUse_Daily.txt
2
 
A00510_Practice_Daily.txt
260
 
A00520_State_Daily.txt
1
 
A00530_SubClass_Daily.txt
2
 
A00540_Type_Daily.txt
222
 
A00810_Price_Daily.txt
131
 
A01000_AgrRate_Daily.txt
1,136,526
 
A01005_AreaRiskRate_Daily.txt
786
 
A01010_BaseRate_Daily.txt
29,474
 
A01040_CoverageLevelDifferential_Daily.txt
669,609
 
A01050_SubCountyRate_Daily.txt
9,036
 
A01060_OptionRate_Daily.txt
52,665
 
A01070_Proration_Daily.txt
600
 
A01090_UnitDiscount_Daily.txt
1
 
A01100_YieldAndTyield_Daily.txt
1,723,983
 
A01200_DocumentBuilder_Daily.txt
156,730
 
A01210_Statement_Daily.txt
296
   
   
2011_ADM_Filing_0430.zip
A00010_AdmLayout_Filing.txt
934
 
A00030_InsuranceOffer_Filing.txt
3,728
 
A00045_Map_Filing.txt
441
 
A00070_SubsidyPercent_Filing.txt
43
 
A00200_Date_Filing.txt
3,728
 
A00410_Class_Filing.txt
3
 
A00420_Commodity_Filing.txt
14
 
A00430_CommodityType_Filing.txt
16
 
A00440_County_Filing.txt
3,161
 
A00450_CroppingPractice_Filing.txt
24
 
A00460_InsurancePlan_Filing.txt
4
 
A00470_IntendedUse_Filing.txt
2
 
A00480_Interval_Filing.txt
25
 
A00490_IrrigationPractice_Filing.txt
2
 
A00500_OrganicPractice_Filing.txt
3
 
A00510_Practice_Filing.txt
136
 
A00520_State_Filing.txt
48
 
A00530_SubClass_Filing.txt
1
 
A00540_Type_Filing.txt
27
 
A00810_Price_Filing.txt
1,554
 
A01010_BaseRate_Filing.txt
1,554
 
A01040_CoverageLevelDifferential_Filing.txt
10,878
 
A01050_SubCountyRate_Filing.txt
441
 
A01060_OptionRate_Filing.txt
2,751
 
A01090_UnitDiscount_Filing.txt
1
 
A01100_YieldAndTyield_Filing.txt
2,400
 
A01200_DocumentBuilder_Filing.txt
26,410
 
A01210_Statement_Filing.txt
120
   
   
2011_ADM_Filing_0630.zip
A00010_AdmLayout_Filing.txt
934
 
A00030_InsuranceOffer_Filing.txt
134,188
 
A00045_Map_Filing.txt
1,338,140
 
A00050_Quality_Filing.txt
228
 
A00070_SubsidyPercent_Filing.txt
115
 
A00200_Date_Filing.txt
139,054
 
A00410_Class_Filing.txt
9
 
A00420_Commodity_Filing.txt
16
 
A00430_CommodityType_Filing.txt
41
 
A00440_County_Filing.txt
3,161
 
A00450_CroppingPractice_Filing.txt
12
 
A00460_InsurancePlan_Filing.txt
9
   

 
File Name
Contains
Record Count
   
2011_ADM_Filing_0630.zip
A00470_IntendedUse_Filing.txt
2
 
A00480_Interval_Filing.txt
22
 
A00490_IrrigationPractice_Filing.txt
3
 
A00500_OrganicPractice_Filing.txt
3
 
A00510_Practice_Filing.txt
156
 
A00520_State_Filing.txt
45
 
A00530_SubClass_Filing.txt
2
 
A00540_Type_Filing.txt
61
 
A00810_Price_Filing.txt
71,382
 
A01005_AreaRiskRate_Filing.txt
6,771,090
 
A01010_BaseRate_Filing.txt
76,968
 
A01020_Beta_Filing.txt
37,000
 
A01030_ComboRevenueFactor_Filing.txt
739,260
 
A01040_CoverageLevelDifferential_Filing.txt
2,984,725
 
A01050_SubCountyRate_Filing.txt
22,275
 
A01060_OptionRate_Filing.txt
290,262
 
A01090_UnitDiscount_Filing.txt
141
 
A01100_YieldAndTyield_Filing.txt
863,490
 
A01110_HistoricalRevenueCapping_Filing.txt
16,998
 
A01200_DocumentBuilder_Filing.txt
905,285
 
A01210_Statement_Filing.txt
247
   
   
2011_ADM_Filing_0831.zip
A00010_AdmLayout_Filing.txt
934
 
A00030_InsuranceOffer_Filing.txt
20,081
 
A00045_Map_Filing.txt
8,580
 
A00050_Quality_Filing.txt
21
 
A00070_SubsidyPercent_Filing.txt
32
 
A00200_Date_Filing.txt
20,081
 
A00400_AgrCommodity_Filing.txt
399
 
A00410_Class_Filing.txt
8
 
A00420_Commodity_Filing.txt
40
 
A00430_CommodityType_Filing.txt
102
 
A00440_County_Filing.txt
1,909
 
A00450_CroppingPractice_Filing.txt
8
 
A00460_InsurancePlan_Filing.txt
7
 
A00470_IntendedUse_Filing.txt
4
 
A00480_Interval_Filing.txt
1
 
A00490_IrrigationPractice_Filing.txt
3
 
A00500_OrganicPractice_Filing.txt
3
 
A00510_Practice_Filing.txt
165
 
A00520_State_Filing.txt
46
 
A00530_SubClass_Filing.txt
3
 
A00540_Type_Filing.txt
139
 
A00810_Price_Filing.txt
131
 
A01000_AgrRate_Filing.txt
1,136,526
 
A01005_AreaRiskRate_Filing.txt
786
 
A01010_BaseRate_Filing.txt
18,014
 
A01040_CoverageLevelDifferential_Filing.txt
145,400
 
A01050_SubCountyRate_Filing.txt
7,140
 
A01060_OptionRate_Filing.txt
42,261
 
A01070_Proration_Filing.txt
600
 
A01090_UnitDiscount_Filing.txt
1
 
A01100_YieldAndTyield_Filing.txt
1,678,863
 
A01200_DocumentBuilder_Filing.txt
120,100
 
A01210_Statement_Filing.txt
202
   
   
2011_ADM_Filing_0930.zip
A00010_AdmLayout_Filing.txt
934
 
A00030_InsuranceOffer_Filing.txt
879
 
A00045_Map_Filing.txt
45
 
A00070_SubsidyPercent_Filing.txt
13
 
A00200_Date_Filing.txt
879
 
A00410_Class_Filing.txt
1
 
A00420_Commodity_Filing.txt
8
 
A00430_CommodityType_Filing.txt
10
 
A00440_County_Filing.txt
64
 
A00450_CroppingPractice_Filing.txt
13
 
A00460_InsurancePlan_Filing.txt
2
 
A00470_IntendedUse_Filing.txt
2
 
A00480_Interval_Filing.txt
1
 
A00490_IrrigationPractice_Filing.txt
3
 
A00500_OrganicPractice_Filing.txt
3
 
A00510_Practice_Filing.txt
69
   

 
File Name
Contains
Record Count
   
2011_ADM_Filing_0930.zip
A00520_State_Filing.txt
14
 
A00530_SubClass_Filing.txt
1
 
A00540_Type_Filing.txt
16
 
A01010_BaseRate_Filing.txt
879
 
A01040_CoverageLevelDifferential_Filing.txt
6,369
 
A01050_SubCountyRate_Filing.txt
45
 
A01060_OptionRate_Filing.txt
2,826
 
A01090_UnitDiscount_Filing.txt
1
 
A01100_YieldAndTyield_Filing.txt
8,190
 
A01200_DocumentBuilder_Filing.txt
5,322
 
A01210_Statement_Filing.txt
62
   
   
2011_ADM_Filing_1031.zip
A00010_AdmLayout_Filing.txt
934
 
A00030_InsuranceOffer_Filing.txt
4,077
 
A00045_Map_Filing.txt
5,544
 
A00070_SubsidyPercent_Filing.txt
13
 
A00200_Date_Filing.txt
4,077
 
A00410_Class_Filing.txt
1
 
A00420_Commodity_Filing.txt
16
 
A00430_CommodityType_Filing.txt
86
 
A00440_County_Filing.txt
185
 
A00450_CroppingPractice_Filing.txt
3
 
A00460_InsurancePlan_Filing.txt
3
 
A00470_IntendedUse_Filing.txt
3
 
A00480_Interval_Filing.txt
1
 
A00490_IrrigationPractice_Filing.txt
3
 
A00500_OrganicPractice_Filing.txt
3
 
A00510_Practice_Filing.txt
66
 
A00520_State_Filing.txt
9
 
A00530_SubClass_Filing.txt
1
 
A00540_Type_Filing.txt
101
 
A01010_BaseRate_Filing.txt
10,581
 
A01040_CoverageLevelDifferential_Filing.txt
32,304
 
A01050_SubCountyRate_Filing.txt
1,851
 
A01060_OptionRate_Filing.txt
7,578
 
A01090_UnitDiscount_Filing.txt
2
 
A01100_YieldAndTyield_Filing.txt
36,930
 
A01200_DocumentBuilder_Filing.txt
31,308
 
A01210_Statement_Filing.txt
89
   
   
2011_ADM_YTD.zip
A00010_AdmLayout_YTD.txt
934
 
A00030_InsuranceOffer_YTD.txt
162,953
 
A00045_Map_YTD.txt
1,352,750
 
A00050_Quality_YTD.txt
249
 
A00070_SubsidyPercent_YTD.txt
216
 
A00200_Date_YTD.txt
167,819
 
A00400_AgrCommodity_YTD.txt
399
 
A00410_Class_YTD.txt
18
 
A00420_Commodity_YTD.txt
82
 
A00430_CommodityType_YTD.txt
215
 
A00440_County_YTD.txt
3,190
 
A00450_CroppingPractice_YTD.txt
48
 
A00460_InsurancePlan_YTD.txt
18
 
A00470_IntendedUse_YTD.txt
5
 
A00480_Interval_YTD.txt
46
 
A00490_IrrigationPractice_YTD.txt
3
 
A00500_OrganicPractice_YTD.txt
3
 
A00510_Practice_YTD.txt
549
 
A00520_State_YTD.txt
50
 
A00530_SubClass_YTD.txt
4
 
A00540_Type_YTD.txt
308
 
A00810_Price_YTD.txt
73,067
 
A01000_AgrRate_YTD.txt
1,136,526
 
A01005_AreaRiskRate_YTD.txt
6,771,876
 
A01010_BaseRate_YTD.txt
107,996
 
A01020_Beta_YTD.txt
37,000
 
A01030_ComboRevenueFactor_YTD.txt
739,260
 
A01040_CoverageLevelDifferential_YTD.txt
3,179,676
 
A01050_SubCountyRate_YTD.txt
31,752
 
A01060_OptionRate_YTD.txt
345,678
 
A01070_Proration_YTD.txt
600
 
A01090_UnitDiscount_YTD.txt
142
   

 
File Name
Contains
Record Count
   
2011_ADM_YTD.zip
A01100_YieldAndTyield_YTD.txt
2,589,873
 
A01110_HistoricalRevenueCapping_YTD.txt
16,998
 
A01200_DocumentBuilder_YTD.txt
1,088,425
 
A01210_Statement_YTD.txt
650
   
   
2011_SPOI_0831.zip
2011 Special Provisions 08/31 Filing Date
3,159
   
   
2011_SPOI_0930.zip
2011 Special Provisions 09/30 Filing Date
86
   
   
2011_SPOI_1031.zip
2011 Special Provisions 10/31 Filing Date
341
   
RMA Image