RO Server Bulletin 11-041

TO:

All Insurance Providers

Chris Aulbur

/s/ Chris Aulbur

FROM:

Chief, Actuarial Branch

SUBJECT:

RO Server Release 11-041 - Actuarial Information Available

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


•	2012 Actuarial Data Master for the 11/30 Filing Date, YTD, and Daily Files.

Users can find this information on the RO Server in the following directories:


•	2012 Actuarial Data Master are in the References/Actuarial_Data_Master/2012 directory.

Additional notes and details regarding this data release:

2012 ADM Price is now released for all plan 90 (silage sorghum will be based on corn so issued late January), 50, 51, and 55 commodities as well as combo cotton for cottonseed, 11/30 filing.
2012 ADMInsuranceOffer updated to populate BetaIDs for expansion counties of rice and barley along with adding ADMComboRevenueFactor information for IL rice, 11/30 filing.
2012 ADMOptionRate updated to remove "TA" option code from South Dakota specialty soybean types.
2012 Towner County, North Dakota corn now populated with proper prior year information as a new expansion county on ADMBaseRate.

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

2012_ADM_Daily_111129.zip	A00030_InsuranceOffer_Daily.txt	792
	A00810_Price_Daily.txt	69,936
	A01010_BaseRate_Daily.txt	36
	A01030_ComboRevenueFactor_Daily.txt	9,990
	A01060_OptionRate_Daily.txt	37,239


2012_ADM_Filing_1130.zip	A00010_AdmLayout_Filing.txt	991
	A00030_InsuranceOffer_Filing.txt	358,980
	A00045_Map_Filing.txt	193,641
	A00050_Quality_Filing.txt	453
	A00070_SubsidyPercent_Filing.txt	202
	A00200_Date_Filing.txt	359,400
	A00410_Class_Filing.txt	14
	A00420_Commodity_Filing.txt	46
	A00430_CommodityType_Filing.txt	121
	A00440_County_Filing.txt	2,810
	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	492
	A00520_State_Filing.txt	49
	A00530_SubClass_Filing.txt	2
	A00540_Type_Filing.txt	179
	A00810_Price_Filing.txt	84,409
	A01005_AreaRiskRate_Filing.txt	1,018,468
	A01010_BaseRate_Filing.txt	349,311
	A01020_Beta_Filing.txt	90,000
	A01030_ComboRevenueFactor_Filing.txt	1,948,050
	A01040_CoverageLevelDifferential_Filing.txt	2,884,159
	A01050_SubCountyRate_Filing.txt	123,723
	A01060_OptionRate_Filing.txt	1,576,089
	A01090_UnitDiscount_Filing.txt	2,522
	A01100_YieldAndTyield_Filing.txt	4,310,262
	A01110_HistoricalRevenueCapping_Filing.txt	130,704
	A01200_DocumentBuilder_Filing.txt	4,211,345
	A01210_Statement_Filing.txt	505


2012_ADM_YTD.zip	A00010_AdmLayout_YTD.txt	991
	A00030_InsuranceOffer_YTD.txt	529,087
	A00045_Map_YTD.txt	1,696,451
	A00050_Quality_YTD.txt	523
	A00070_SubsidyPercent_YTD.txt	296
	A00200_Date_YTD.txt	534,877
	A00400_AgrCommodity_YTD.txt	399
	A00410_Class_YTD.txt	23
	A00420_Commodity_YTD.txt	115
	A00430_CommodityType_YTD.txt	312
	A00440_County_YTD.txt	3,188
	A00450_CroppingPractice_YTD.txt	70
	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	969
	A00520_State_YTD.txt	50
	A00530_SubClass_YTD.txt	4
	A00540_Type_YTD.txt	462
	A00810_Price_YTD.txt	239,420
	A01000_AgrRate_YTD.txt	1,136,526
	A01005_AreaRiskRate_YTD.txt	8,546,599
	A01010_BaseRate_YTD.txt	456,800
	A01020_Beta_YTD.txt	121,000
	A01030_ComboRevenueFactor_YTD.txt	2,567,430
	A01040_CoverageLevelDifferential_YTD.txt	3,970,694
	A01050_SubCountyRate_YTD.txt	154,197
	A01060_OptionRate_YTD.txt	1,921,941
	A01070_Proration_YTD.txt	600
	A01090_UnitDiscount_YTD.txt	5,115