USDA Image
TO:
All Insurance Providers
Jason Albright
/s/ Chris Aulbur for
FROM:
Chief, Actuarial Branch
SUBJECT:
RO Server Release 10-042 - Actuarial Information Available
As of November 05, 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, 11/30, 12/31 Filing Date, YTD, and Daily Files.
•
2011 Special Provisions for the 11/30, 12/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, and related files are now released for the majority of commodities/insurance plans, 11/30 and 12/31 filings.
2011 ADM records for Insurance Plan, Statement, and Subsidy Percent are refreshed for prior filings to include the new layout changes.

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
https://www.rma.usda.gov/news/ro-server/.
 
File Name
Contains
Record Count
   
2011_ADM_Daily_101105.zip
A00010_AdmLayout_Daily.txt
3
 
A00030_InsuranceOffer_Daily.txt
275,331
 
A00045_Map_Daily.txt
165,885
 
A00050_Quality_Daily.txt
156
 
A00070_SubsidyPercent_Daily.txt
41
 
A00200_Date_Daily.txt
275,883
 
A00410_Class_Daily.txt
10
 
A00420_Commodity_Daily.txt
30
 
A00430_CommodityType_Daily.txt
79
 
A00450_CroppingPractice_Daily.txt
22
 
A00460_InsurancePlan_Daily.txt
5
 
A00470_IntendedUse_Daily.txt
2
 
A00510_Practice_Daily.txt
399
 
A00540_Type_Daily.txt
131
 
A00810_Price_Daily.txt
5,318
 
A01010_BaseRate_Daily.txt
275,025
 
A01020_Beta_Daily.txt
60,000
 
A01030_ComboRevenueFactor_Daily.txt
1,198,800
 
A01040_CoverageLevelDifferential_Daily.txt
2,193,225
 
A01050_SubCountyRate_Daily.txt
103,032
 
A01060_OptionRate_Daily.txt
1,177,872
 
A01090_UnitDiscount_Daily.txt
70
 
A01100_YieldAndTyield_Daily.txt
3,096,810
 
A01110_HistoricalRevenueCapping_Daily.txt
106,188
 
A01200_DocumentBuilder_Daily.txt
2,456,125
 
A01210_Statement_Daily.txt
374
   
   
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,986
 
A01210_Statement_Filing.txt
124
   
   
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
2,815
 
A00450_CroppingPractice_Filing.txt
12
 
A00460_InsurancePlan_Filing.txt
7
 
A00470_IntendedUse_Filing.txt
2
 
A00480_Interval_Filing.txt
22
 
A00490_IrrigationPractice_Filing.txt
3
 
A00500_OrganicPractice_Filing.txt
3
   
 
File Name
Contains
Record Count
   
2011_ADM_Filing_0630.zip
A00510_Practice_Filing.txt
156
 
A00520_State_Filing.txt
45
 
A00530_SubClass_Filing.txt
2
 
A00540_Type_Filing.txt
61
 
A00810_Price_Filing.txt
123,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
3,063,663
 
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,652
 
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
18,514
 
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,212
 
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
 
A00520_State_Filing.txt
14
 
A00530_SubClass_Filing.txt
1
 
A00540_Type_Filing.txt
16
 
A00810_Price_Filing.txt
1,017
   
 
File Name
Contains
Record Count
   
2011_ADM_Filing_0930.zip
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
 
A00810_Price_Filing.txt
4,497
 
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,635
 
A01210_Statement_Filing.txt
96
   
   
2011_ADM_Filing_1130.zip
A00010_AdmLayout_Filing.txt
937
 
A00030_InsuranceOffer_Filing.txt
274,845
 
A00045_Map_Filing.txt
165,423
 
A00050_Quality_Filing.txt
319
 
A00070_SubsidyPercent_Filing.txt
41
 
A00200_Date_Filing.txt
275,397
 
A00410_Class_Filing.txt
14
 
A00420_Commodity_Filing.txt
43
 
A00430_CommodityType_Filing.txt
112
 
A00440_County_Filing.txt
2,843
 
A00450_CroppingPractice_Filing.txt
31
 
A00460_InsurancePlan_Filing.txt
7
 
A00470_IntendedUse_Filing.txt
6
 
A00480_Interval_Filing.txt
1
 
A00490_IrrigationPractice_Filing.txt
3
 
A00500_OrganicPractice_Filing.txt
3
 
A00510_Practice_Filing.txt
468
 
A00520_State_Filing.txt
49
 
A00530_SubClass_Filing.txt
2
 
A00540_Type_Filing.txt
166
 
A00810_Price_Filing.txt
5,318
 
A01010_BaseRate_Filing.txt
274,539
 
A01020_Beta_Filing.txt
66,000
 
A01030_ComboRevenueFactor_Filing.txt
1,198,800
 
A01040_CoverageLevelDifferential_Filing.txt
2,189,823
 
A01050_SubCountyRate_Filing.txt
102,891
 
A01060_OptionRate_Filing.txt
1,175,946
 
A01090_UnitDiscount_Filing.txt
171
 
A01100_YieldAndTyield_Filing.txt
3,089,970
 
A01110_HistoricalRevenueCapping_Filing.txt
106,188
 
A01200_DocumentBuilder_Filing.txt
2,453,323
 
A01210_Statement_Filing.txt
454
   
 
File Name
Contains
Record Count
   
2011_ADM_Filing_1231.zip
A00010_AdmLayout_Filing.txt
937
 
A00030_InsuranceOffer_Filing.txt
486
 
A00045_Map_Filing.txt
462
 
A00050_Quality_Filing.txt
21
 
A00200_Date_Filing.txt
486
 
A00410_Class_Filing.txt
1
 
A00420_Commodity_Filing.txt
2
 
A00430_CommodityType_Filing.txt
1
 
A00440_County_Filing.txt
93
 
A00450_CroppingPractice_Filing.txt
4
 
A00460_InsurancePlan_Filing.txt
1
 
A00470_IntendedUse_Filing.txt
2
 
A00480_Interval_Filing.txt
1
 
A00490_IrrigationPractice_Filing.txt
3
 
A00500_OrganicPractice_Filing.txt
3
 
A00510_Practice_Filing.txt
18
 
A00520_State_Filing.txt
11
 
A00530_SubClass_Filing.txt
1
 
A00540_Type_Filing.txt
2
 
A01010_BaseRate_Filing.txt
486
 
A01040_CoverageLevelDifferential_Filing.txt
3,402
 
A01050_SubCountyRate_Filing.txt
141
 
A01060_OptionRate_Filing.txt
1,926
 
A01090_UnitDiscount_Filing.txt
1
 
A01100_YieldAndTyield_Filing.txt
6,840
 
A01200_DocumentBuilder_Filing.txt
2,802
 
A01210_Statement_Filing.txt
27
   
   
2011_ADM_YTD.zip
A00010_AdmLayout_YTD.txt
937
 
A00030_InsuranceOffer_YTD.txt
438,284
 
A00045_Map_YTD.txt
1,518,707
 
A00050_Quality_YTD.txt
405
 
A00070_SubsidyPercent_YTD.txt
257
 
A00200_Date_YTD.txt
443,702
 
A00400_AgrCommodity_YTD.txt
399
 
A00410_Class_YTD.txt
28
 
A00420_Commodity_YTD.txt
112
 
A00430_CommodityType_YTD.txt
294
 
A00440_County_YTD.txt
3,190
 
A00450_CroppingPractice_YTD.txt
70
 
A00460_InsurancePlan_YTD.txt
18
 
A00470_IntendedUse_YTD.txt
7
 
A00480_Interval_YTD.txt
46
 
A00490_IrrigationPractice_YTD.txt
3
 
A00500_OrganicPractice_YTD.txt
3
 
A00510_Practice_YTD.txt
948
 
A00520_State_YTD.txt
50
 
A00530_SubClass_YTD.txt
4
 
A00540_Type_YTD.txt
439
 
A00810_Price_YTD.txt
154,282
 
A01000_AgrRate_YTD.txt
1,136,526
 
A01005_AreaRiskRate_YTD.txt
6,771,876
 
A01010_BaseRate_YTD.txt
383,021
 
A01020_Beta_YTD.txt
97,000
 
A01030_ComboRevenueFactor_YTD.txt
1,938,060
 
A01040_CoverageLevelDifferential_YTD.txt
5,451,839
 
A01050_SubCountyRate_YTD.txt
134,856
 
A01060_OptionRate_YTD.txt
1,523,550
 
A01070_Proration_YTD.txt
600
 
A01090_UnitDiscount_YTD.txt
212
 
A01100_YieldAndTyield_YTD.txt
5,686,683
 
A01110_HistoricalRevenueCapping_YTD.txt
123,186
 
A01200_DocumentBuilder_YTD.txt
3,545,453
 
A01210_Statement_YTD.txt
1,034
   
   
2011_SPOI_1130.zip
2011 Special Provisions 11/30 Filing Date
10,530
   
   
2011_SPOI_1231.zip
2011 Special Provisions 12/31 Filing Date
93
   
RMA Image