RO Server Bulletin 11-021

TO:

All Insurance Providers

Chris Aulbur

/s/ Chris Aulbur

FROM:

Chief, Actuarial Branch

SUBJECT:

RO Server Release 11-021 - Actuarial Information Available

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


•	2011 Actuarial Data Master for the 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 ADMPrice (A00810) updated for the harvest price announcement, PM-11-032, 6/30 and 11/30 filings.
2011 ADMDate (A00200) updated modified acreage reporting date for 6 states spring seeded crops from June 30 to July 15, reference MGR-11-009, 6/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_110703.zip	A00200_Date_Daily.txt	112,566
	A00810_Price_Daily.txt	22,042


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	134,728
	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,339
	A01210_Statement_Filing.txt	248


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	56
	A00200_Date_Filing.txt	345,096
	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	384,546
	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


File Name	Contains	Record Count

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	293
	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
	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	780,614
	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,831
	A01210_Statement_YTD.txt	1,109