/images/  RO Server Bulletin 48
USDA Image
TO:
All Insurance Providers
Jason Albright
/s/ Chris Aulbur for
FROM:
Chief, Actuarial Branch
SUBJECT:
RO Server Release 10-048 - Actuarial Information Available
As of December 16, 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, 1/31 Filing Date, YTD, and Daily Files.
2011 Special Provisions for the 1/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 the 1/31 filing.
2011 Additional Price Election for CA Safflowers updated in ADMPrice, reference PM-10-068, 8/31 filing.
2011 Price Elections are now released in ADMPrice for the 12/31 filing.
2011 LGM Dairy ADMDate is populated for premium billing and end of insurance dates for the sales periods starting with December 17 and later, 4/30 filing.
2011 Fresh Market Beans ADMCoverageLevelDifferential residuals and ADMUnitDiscount for area low and area high quantities updated, 11/30 filing.
2011 ADM Layouts and related records updated for all filings for the removal of map name from InsuranceOffer and removal of high risk flag from SubCountyRates as previously planned when the 1/31 filing was released.
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_101216.zip
A00010_AdmLayout_Daily.txt
12
 
A00030_InsuranceOffer_Daily.txt
736,487
 
A00045_Map_Daily.txt
1,296
 
A00200_Date_Daily.txt
229,296
 
A00410_Class_Daily.txt
2
 
A00420_Commodity_Daily.txt
17
 
A00430_CommodityType_Daily.txt
29
 
A00450_CroppingPractice_Daily.txt
2
 
A00510_Practice_Daily.txt
54
 
A00540_Type_Daily.txt
42
 
A00810_Price_Daily.txt
227,514
 
A01010_BaseRate_Daily.txt
228,720
 
A01040_CoverageLevelDifferential_Daily.txt
1,608,501
 
A01050_SubCountyRate_Daily.txt
149,784
 
A01060_OptionRate_Daily.txt
785,265
 
A01070_Proration_Daily.txt
2,742,228
 
A01090_UnitDiscount_Daily.txt
2
 
A01200_DocumentBuilder_Daily.txt
5,005,755
 
A01210_Statement_Daily.txt
47
     
     
2011_ADM_Filing_0131.zip
A00010_AdmLayout_Filing.txt
938
 
A00030_InsuranceOffer_Filing.txt
228,720
 
A00045_Map_Filing.txt
1,296
 
A00200_Date_Filing.txt
228,720
 
A00410_Class_Filing.txt
5
 
A00420_Commodity_Filing.txt
17
 
A00430_CommodityType_Filing.txt
33
 
A00440_County_Filing.txt
2,802
 
A00450_CroppingPractice_Filing.txt
3
 
A00460_InsurancePlan_Filing.txt
2
 
A00470_IntendedUse_Filing.txt
3
 
A00480_Interval_Filing.txt
1
 
A00490_IrrigationPractice_Filing.txt
1
 
A00500_OrganicPractice_Filing.txt
3
 
A00510_Practice_Filing.txt
54
 
A00520_State_Filing.txt
50
 
A00530_SubClass_Filing.txt
1
 
A00540_Type_Filing.txt
42
 
A00810_Price_Filing.txt
226,962
 
A01010_BaseRate_Filing.txt
228,720
 
A01040_CoverageLevelDifferential_Filing.txt
1,607,619
 
A01050_SubCountyRate_Filing.txt
1,296
 
A01060_OptionRate_Filing.txt
785,265
 
A01070_Proration_Filing.txt
2,742,228
 
A01090_UnitDiscount_Filing.txt
2
 
A01200_DocumentBuilder_Filing.txt
5,005,755
 
A01210_Statement_Filing.txt
56
     
     
2011_ADM_Filing_0430.zip
A00010_AdmLayout_Filing.txt
938
 
A00030_InsuranceOffer_Filing.txt
3,728
 
A00045_Map_Filing.txt
441
 
A00070_SubsidyPercent_Filing.txt
64
 
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
     

File Name
Contains
Record Count
     
2011_ADM_Filing_0430.zip
A01090_UnitDiscount_Filing.txt
1
 
A01100_YieldAndTyield_Filing.txt
2,400
 
A01200_DocumentBuilder_Filing.txt
27,562
 
A01210_Statement_Filing.txt
124
     
     
2011_ADM_Filing_0630.zip
A00010_AdmLayout_Filing.txt
938
 
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
9
 
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
123,601
 
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
938
 
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
     

File Name
Contains
Record Count
     
2011_ADM_Filing_0930.zip
A00010_AdmLayout_Filing.txt
938
 
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
 
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
938
 
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
938
 
A00030_InsuranceOffer_Filing.txt
344,328
 
A00045_Map_Filing.txt
183,279
 
A00050_Quality_Filing.txt
364
 
A00070_SubsidyPercent_Filing.txt
41
 
A00200_Date_Filing.txt
344,880
 
A00410_Class_Filing.txt
14
 
A00420_Commodity_Filing.txt
45
 
A00430_CommodityType_Filing.txt
116
 
A00440_County_Filing.txt
2,843
 
A00450_CroppingPractice_Filing.txt
31
 
A00460_InsurancePlan_Filing.txt
10
 
A00470_IntendedUse_Filing.txt
7
 
A00480_Interval_Filing.txt
1
     

File Name
Contains
Record Count
     
2011_ADM_Filing_1130.zip
A00490_IrrigationPractice_Filing.txt
3
 
A00500_OrganicPractice_Filing.txt
3
 
A00510_Practice_Filing.txt
480
 
A00520_State_Filing.txt
49
 
A00530_SubClass_Filing.txt
2
 
A00540_Type_Filing.txt
173
 
A00810_Price_Filing.txt
95,260
 
A01005_AreaRiskRate_Filing.txt
1,018,468
 
A01010_BaseRate_Filing.txt
334,659
 
A01020_Beta_Filing.txt
90,000
 
A01030_ComboRevenueFactor_Filing.txt
1,678,320
 
A01040_CoverageLevelDifferential_Filing.txt
2,705,389
 
A01050_SubCountyRate_Filing.txt
116,523
 
A01060_OptionRate_Filing.txt
1,465,743
 
A01090_UnitDiscount_Filing.txt
203
 
A01100_YieldAndTyield_Filing.txt
3,729,630
 
A01110_HistoricalRevenueCapping_Filing.txt
124,170
 
A01200_DocumentBuilder_Filing.txt
2,878,228
 
A01210_Statement_Filing.txt
486
     
     
2011_ADM_Filing_1231.zip
A00010_AdmLayout_Filing.txt
938
 
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
 
A00810_Price_Filing.txt
486
 
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
938
 
A00030_InsuranceOffer_YTD.txt
736,487
 
A00045_Map_YTD.txt
1,537,859
 
A00050_Quality_YTD.txt
450
 
A00070_SubsidyPercent_YTD.txt
278
 
A00200_Date_YTD.txt
741,905
 
A00400_AgrCommodity_YTD.txt
399
 
A00410_Class_YTD.txt
30
 
A00420_Commodity_YTD.txt
131
 
A00430_CommodityType_YTD.txt
327
 
A00440_County_YTD.txt
3,190
 
A00450_CroppingPractice_YTD.txt
72
 
A00460_InsurancePlan_YTD.txt
20
 
A00470_IntendedUse_YTD.txt
8
 
A00480_Interval_YTD.txt
46
 
A00490_IrrigationPractice_YTD.txt
3
 
A00500_OrganicPractice_YTD.txt
3
 
A00510_Practice_YTD.txt
1,014
 
A00520_State_YTD.txt
50
 
A00530_SubClass_YTD.txt
4
 
A00540_Type_YTD.txt
488
 
A00810_Price_YTD.txt
471,891
 
A01000_AgrRate_YTD.txt
1,136,526
     

File Name
Contains
Record Count
     
2011_ADM_YTD.zip
A01005_AreaRiskRate_YTD.txt
7,790,344
 
A01010_BaseRate_YTD.txt
671,861
 
A01020_Beta_YTD.txt
121,000
 
A01030_ComboRevenueFactor_YTD.txt
2,417,580
 
A01040_CoverageLevelDifferential_YTD.txt
7,575,024
 
A01050_SubCountyRate_YTD.txt
149,784
 
A01060_OptionRate_YTD.txt
2,598,612
 
A01070_Proration_YTD.txt
2,742,828
 
A01090_UnitDiscount_YTD.txt
245
 
A01100_YieldAndTyield_YTD.txt
6,326,343
 
A01110_HistoricalRevenueCapping_YTD.txt
141,168
 
A01200_DocumentBuilder_YTD.txt
8,976,689
 
A01210_Statement_YTD.txt
1,109
     
     
2011_SPOI_0131.zip
2011 Special Provisions 01/31 Filing Date
3,104
     
RMA Image