RO Server Bulletin 45

TO:

All Insurance Providers

Jason Albright

/s/ Jason Albright

FROM:

Chief, Actuarial Branch

SUBJECT:

RO Server Release 10-045 - Actuarial Information Available

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


•	2011 Actuarial Data Master for the 11/30 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 SPOIs and ADM are now released for Silage Sorghum as well as for 3 GRP/GRIP counties (27-051, 29-113, 29-201),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

mailto: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_SPOI_1130.zip	2011 Special Provisions 11/30 Filing Date	16,222


2011_ADM_Daily_101130.zip	A00030_InsuranceOffer_Daily.txt	504
	A00045_Map_Daily.txt	132
	A00200_Date_Daily.txt	504
	A00420_Commodity_Daily.txt	1
	A00430_CommodityType_Daily.txt	2
	A00510_Practice_Daily.txt	6
	A00540_Type_Daily.txt	2
	A00810_Price_Daily.txt	12
	A01005_AreaRiskRate_Daily.txt	3,792
	A01010_BaseRate_Daily.txt	468
	A01040_CoverageLevelDifferential_Daily.txt	3,468
	A01050_SubCountyRate_Daily.txt	66
	A01060_OptionRate_Daily.txt	1,872
	A01100_YieldAndTyield_Daily.txt	5,160
	A01200_DocumentBuilder_Daily.txt	4,057
	A01210_Statement_Daily.txt	5


2011_ADM_Filing_1130.zip	A00010_AdmLayout_Filing.txt	937
	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
	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,353
	A01020_Beta_Filing.txt	120,500
	A01030_ComboRevenueFactor_Filing.txt	1,668,330
	A01040_CoverageLevelDifferential_Filing.txt	2,703,451
	A01050_SubCountyRate_Filing.txt	116,523
	A01060_OptionRate_Filing.txt	1,464,519
	A01090_UnitDiscount_Filing.txt	203
	A01100_YieldAndTyield_Filing.txt	3,726,570
	A01110_HistoricalRevenueCapping_Filing.txt	124,170
	A01200_DocumentBuilder_Filing.txt	2,878,228
	A01210_Statement_Filing.txt	486


2011_ADM_YTD.zip	A00010_AdmLayout_YTD.txt	937
	A00030_InsuranceOffer_YTD.txt	507,767
	A00045_Map_YTD.txt	1,536,443
	A00050_Quality_YTD.txt	450
	A00070_SubsidyPercent_YTD.txt	257
	A00200_Date_YTD.txt	513,185
	A00400_AgrCommodity_YTD.txt	399
	A00410_Class_YTD.txt	28
	A00420_Commodity_YTD.txt	114
	A00430_CommodityType_YTD.txt	298
	A00440_County_YTD.txt	3,190
	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	960
	A00520_State_YTD.txt	50


File Name	Contains	Record Count

2011_ADM_YTD.zip	A00530_SubClass_YTD.txt	4
	A00540_Type_YTD.txt	446
	A00810_Price_YTD.txt	244,443
	A01000_AgrRate_YTD.txt	1,136,526
	A01005_AreaRiskRate_YTD.txt	7,790,344
	A01010_BaseRate_YTD.txt	442,835
	A01020_Beta_YTD.txt	120,500
	A01030_ComboRevenueFactor_YTD.txt	2,407,590
	A01040_CoverageLevelDifferential_YTD.txt	5,965,467
	A01050_SubCountyRate_YTD.txt	148,368
	A01060_OptionRate_YTD.txt	1,812,123
	A01070_Proration_YTD.txt	600
	A01090_UnitDiscount_YTD.txt	244
	A01100_YieldAndTyield_YTD.txt	6,323,283
	A01110_HistoricalRevenueCapping_YTD.txt	141,168
	A01200_DocumentBuilder_YTD.txt	3,970,358
	A01210_Statement_YTD.txt	1,062