RO Server Bulletin 11-007

TO:

All Insurance Providers

Jason Albright

/s/ Chris Aulbur for

FROM:

Chief, Actuarial Branch

SUBJECT:

RO Server Release 11-007 - Actuarial Information Available

As of February 28, 2011 the following information is now available on the Reporting Organization (RO) Server:


•	2011 Actuarial Data Master for the 4/30, 6/30, 11/30, 12/31 Filing Date, YTD, and Daily Files.

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.

Additional notes and details regarding this data release:

2011 Additional price elections are now updated in ADM price record A00810, reference PM-11-010; 4/30, 11/30, and 12/31 filings.

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_110228.zip	A00045_Map_Daily.txt	108
	A00810_Price_Daily.txt	14,415


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
	A01090_UnitDiscount_Filing.txt	1
	A01100_YieldAndTyield_Filing.txt	2,400
	A01200_DocumentBuilder_Filing.txt	27,562
	A01210_Statement_Filing.txt	121


2011_ADM_Filing_0630.zip	A00010_AdmLayout_Filing.txt	938
	A00030_InsuranceOffer_Filing.txt	134,188
	A00045_Map_Filing.txt	1,338,176
	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,311
	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_1130.zip	A00010_AdmLayout_Filing.txt	938
	A00030_InsuranceOffer_Filing.txt	344,544
	A00045_Map_Filing.txt	183,279
	A00050_Quality_Filing.txt	364
	A00070_SubsidyPercent_Filing.txt	55
	A00200_Date_Filing.txt	345,096


File Name	Contains	Record Count

2011_ADM_Filing_1130.zip	A00410_Class_Filing.txt	14
	A00420_Commodity_Filing.txt	46
	A00430_CommodityType_Filing.txt	118
	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
	A00490_IrrigationPractice_Filing.txt	3
	A00500_OrganicPractice_Filing.txt	3
	A00510_Practice_Filing.txt	486
	A00520_State_Filing.txt	49
	A00530_SubClass_Filing.txt	2
	A00540_Type_Filing.txt	177
	A00810_Price_Filing.txt	122,314
	A01005_AreaRiskRate_Filing.txt	1,022,518
	A01010_BaseRate_Filing.txt	334,875
	A01020_Beta_Filing.txt	90,000
	A01030_ComboRevenueFactor_Filing.txt	1,678,320
	A01040_CoverageLevelDifferential_Filing.txt	2,706,901
	A01050_SubCountyRate_Filing.txt	116,523
	A01060_OptionRate_Filing.txt	1,466,175
	A01090_UnitDiscount_Filing.txt	204
	A01100_YieldAndTyield_Filing.txt	3,731,790
	A01110_HistoricalRevenueCapping_Filing.txt	124,170
	A01200_DocumentBuilder_Filing.txt	2,880,316
	A01210_Statement_Filing.txt	493


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,703
	A00045_Map_YTD.txt	1,537,895
	A00050_Quality_YTD.txt	450
	A00070_SubsidyPercent_YTD.txt	292
	A00200_Date_YTD.txt	742,121
	A00400_AgrCommodity_YTD.txt	399
	A00410_Class_YTD.txt	30
	A00420_Commodity_YTD.txt	132
	A00430_CommodityType_YTD.txt	329
	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


File Name	Contains	Record Count

2011_ADM_YTD.zip	A00490_IrrigationPractice_YTD.txt	3
	A00500_OrganicPractice_YTD.txt	3
	A00510_Practice_YTD.txt	1,020
	A00520_State_YTD.txt	50
	A00530_SubClass_YTD.txt	4
	A00540_Type_YTD.txt	492
	A00810_Price_YTD.txt	505,737
	A01000_AgrRate_YTD.txt	1,136,526
	A01005_AreaRiskRate_YTD.txt	7,794,394
	A01010_BaseRate_YTD.txt	672,077
	A01020_Beta_YTD.txt	121,000
	A01030_ComboRevenueFactor_YTD.txt	2,417,580
	A01040_CoverageLevelDifferential_YTD.txt	7,576,536
	A01050_SubCountyRate_YTD.txt	149,820
	A01060_OptionRate_YTD.txt	2,599,044
	A01070_Proration_YTD.txt	2,742,828
	A01090_UnitDiscount_YTD.txt	246
	A01100_YieldAndTyield_YTD.txt	6,328,503
	A01110_HistoricalRevenueCapping_YTD.txt	141,168
	A01200_DocumentBuilder_YTD.txt	8,978,777
	A01210_Statement_YTD.txt	1,112