RO Server Bulletin 50

TO:

All Insurance Providers

Jason Albright

/s/ Chris Aulbur for

FROM:

Chief, Actuarial Branch

SUBJECT:

RO Server Release 10-050 - Actuarial Information Available

As of December 20, 2010 the following information is now available on the Reporting Organization (RO) Server:


•	2011 Actuarial Data Master for the 4/30, 11/30, 1/31 Filing Date, YTD, and Daily Files.
•	2011 Special Provisions for the 11/30 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 Sweet Potato SPOIs and ADM are now released, 11/30 filing.
2011 ADMPrice is populated for 2012 C.Y. Florida Citrus and Florida Fruit Trees, 1/31 filing.
2011 ADMCoverageLevelDifferential residuals are updated for Fresh Market Beans and Sesame, 11/30 filing.

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_101220.zip	A00030_InsuranceOffer_Daily.txt	216
	A00200_Date_Daily.txt	216
	A00420_Commodity_Daily.txt	1
	A00430_CommodityType_Daily.txt	2
	A00510_Practice_Daily.txt	6
	A00540_Type_Daily.txt	4
	A00810_Price_Daily.txt	7,008
	A01010_BaseRate_Daily.txt	216
	A01040_CoverageLevelDifferential_Daily.txt	4,830
	A01060_OptionRate_Daily.txt	432
	A01090_UnitDiscount_Daily.txt	1
	A01100_YieldAndTyield_Daily.txt	2,160
	A01200_DocumentBuilder_Daily.txt	2,088
	A01210_Statement_Daily.txt	8


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


File Name	Contains	Record Count

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	41
	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	95,476
	A01005_AreaRiskRate_Filing.txt	1,018,468
	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_YTD.zip	A00010_AdmLayout_YTD.txt	938
	A00030_InsuranceOffer_YTD.txt	736,703
	A00045_Map_YTD.txt	1,537,859
	A00050_Quality_YTD.txt	450
	A00070_SubsidyPercent_YTD.txt	278
	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	478,899
	A01000_AgrRate_YTD.txt	1,136,526
	A01005_AreaRiskRate_YTD.txt	7,790,344
	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,784
	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