RO Server Bulletin 48

TO:

All Insurance Providers

Jason Albright

/s/ Chris Aulbur for

FROM:

Chief, Actuarial Branch

SUBJECT:

RO Server Release 10-048 - Actuarial Information Available

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


•	2011 Actuarial Data Master for the 4/30, 6/30, 8/31, 9/30, 10/31, 11/30, 12/31, 1/31 Filing Date, YTD, and Daily Files.
•	2011 Special Provisions for the 1/31 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, ADM, Map Shape and related files are now released for the 1/31 filing.
2011 Additional Price Election for CA Safflowers updated in ADMPrice, reference PM-10-068, 8/31 filing.
2011 Price Elections are now released in ADMPrice for the 12/31 filing.
2011 LGM Dairy ADMDate is populated for premium billing and end of insurance dates for the sales periods starting with December 17 and later, 4/30 filing.
2011 Fresh Market Beans ADMCoverageLevelDifferential residuals and ADMUnitDiscount for area low and area high quantities updated, 11/30 filing.
2011 ADM Layouts and related records updated for all filings for the removal of map name from InsuranceOffer and removal of high risk flag from SubCountyRates as previously planned when the 1/31 filing was released.

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_101216.zip	A00010_AdmLayout_Daily.txt	12
	A00030_InsuranceOffer_Daily.txt	736,487
	A00045_Map_Daily.txt	1,296
	A00200_Date_Daily.txt	229,296
	A00410_Class_Daily.txt	2
	A00420_Commodity_Daily.txt	17
	A00430_CommodityType_Daily.txt	29
	A00450_CroppingPractice_Daily.txt	2
	A00510_Practice_Daily.txt	54
	A00540_Type_Daily.txt	42
	A00810_Price_Daily.txt	227,514
	A01010_BaseRate_Daily.txt	228,720
	A01040_CoverageLevelDifferential_Daily.txt	1,608,501
	A01050_SubCountyRate_Daily.txt	149,784
	A01060_OptionRate_Daily.txt	785,265
	A01070_Proration_Daily.txt	2,742,228
	A01090_UnitDiscount_Daily.txt	2
	A01200_DocumentBuilder_Daily.txt	5,005,755
	A01210_Statement_Daily.txt	47


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	226,962
	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


File Name	Contains	Record Count

2011_ADM_Filing_0430.zip	A01090_UnitDiscount_Filing.txt	1
	A01100_YieldAndTyield_Filing.txt	2,400
	A01200_DocumentBuilder_Filing.txt	27,562
	A01210_Statement_Filing.txt	124


2011_ADM_Filing_0630.zip	A00010_AdmLayout_Filing.txt	938
	A00030_InsuranceOffer_Filing.txt	134,188
	A00045_Map_Filing.txt	1,338,140
	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,275
	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_0831.zip	A00010_AdmLayout_Filing.txt	938
	A00030_InsuranceOffer_Filing.txt	20,081
	A00045_Map_Filing.txt	8,652
	A00050_Quality_Filing.txt	21
	A00070_SubsidyPercent_Filing.txt	32
	A00200_Date_Filing.txt	20,081
	A00400_AgrCommodity_Filing.txt	399
	A00410_Class_Filing.txt	8
	A00420_Commodity_Filing.txt	40
	A00430_CommodityType_Filing.txt	102
	A00440_County_Filing.txt	1,909
	A00450_CroppingPractice_Filing.txt	8
	A00460_InsurancePlan_Filing.txt	7
	A00470_IntendedUse_Filing.txt	4
	A00480_Interval_Filing.txt	1
	A00490_IrrigationPractice_Filing.txt	3
	A00500_OrganicPractice_Filing.txt	3
	A00510_Practice_Filing.txt	165
	A00520_State_Filing.txt	46
	A00530_SubClass_Filing.txt	3
	A00540_Type_Filing.txt	139
	A00810_Price_Filing.txt	18,514
	A01000_AgrRate_Filing.txt	1,136,526
	A01005_AreaRiskRate_Filing.txt	786
	A01010_BaseRate_Filing.txt	18,014
	A01040_CoverageLevelDifferential_Filing.txt	145,400
	A01050_SubCountyRate_Filing.txt	7,212
	A01060_OptionRate_Filing.txt	42,261
	A01070_Proration_Filing.txt	600
	A01090_UnitDiscount_Filing.txt	1
	A01100_YieldAndTyield_Filing.txt	1,678,863
	A01200_DocumentBuilder_Filing.txt	120,100
	A01210_Statement_Filing.txt	202


File Name	Contains	Record Count

2011_ADM_Filing_0930.zip	A00010_AdmLayout_Filing.txt	938
	A00030_InsuranceOffer_Filing.txt	879
	A00045_Map_Filing.txt	45
	A00070_SubsidyPercent_Filing.txt	13
	A00200_Date_Filing.txt	879
	A00410_Class_Filing.txt	1
	A00420_Commodity_Filing.txt	8
	A00430_CommodityType_Filing.txt	10
	A00440_County_Filing.txt	64
	A00450_CroppingPractice_Filing.txt	13
	A00460_InsurancePlan_Filing.txt	2
	A00470_IntendedUse_Filing.txt	2
	A00480_Interval_Filing.txt	1
	A00490_IrrigationPractice_Filing.txt	3
	A00500_OrganicPractice_Filing.txt	3
	A00510_Practice_Filing.txt	69
	A00520_State_Filing.txt	14
	A00530_SubClass_Filing.txt	1
	A00540_Type_Filing.txt	16
	A00810_Price_Filing.txt	1,017
	A01010_BaseRate_Filing.txt	879
	A01040_CoverageLevelDifferential_Filing.txt	6,369
	A01050_SubCountyRate_Filing.txt	45
	A01060_OptionRate_Filing.txt	2,826
	A01090_UnitDiscount_Filing.txt	1
	A01100_YieldAndTyield_Filing.txt	8,190
	A01200_DocumentBuilder_Filing.txt	5,322
	A01210_Statement_Filing.txt	62


2011_ADM_Filing_1031.zip	A00010_AdmLayout_Filing.txt	938
	A00030_InsuranceOffer_Filing.txt	4,077
	A00045_Map_Filing.txt	5,544
	A00070_SubsidyPercent_Filing.txt	13
	A00200_Date_Filing.txt	4,077
	A00410_Class_Filing.txt	1
	A00420_Commodity_Filing.txt	16
	A00430_CommodityType_Filing.txt	86
	A00440_County_Filing.txt	185
	A00450_CroppingPractice_Filing.txt	3
	A00460_InsurancePlan_Filing.txt	3
	A00470_IntendedUse_Filing.txt	3
	A00480_Interval_Filing.txt	1
	A00490_IrrigationPractice_Filing.txt	3
	A00500_OrganicPractice_Filing.txt	3
	A00510_Practice_Filing.txt	66
	A00520_State_Filing.txt	9
	A00530_SubClass_Filing.txt	1
	A00540_Type_Filing.txt	101
	A00810_Price_Filing.txt	4,497
	A01010_BaseRate_Filing.txt	10,581
	A01040_CoverageLevelDifferential_Filing.txt	32,304
	A01050_SubCountyRate_Filing.txt	1,851
	A01060_OptionRate_Filing.txt	7,578
	A01090_UnitDiscount_Filing.txt	2
	A01100_YieldAndTyield_Filing.txt	36,930
	A01200_DocumentBuilder_Filing.txt	31,635
	A01210_Statement_Filing.txt	96


2011_ADM_Filing_1130.zip	A00010_AdmLayout_Filing.txt	938
	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


File Name	Contains	Record Count

2011_ADM_Filing_1130.zip	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,659
	A01020_Beta_Filing.txt	90,000
	A01030_ComboRevenueFactor_Filing.txt	1,678,320
	A01040_CoverageLevelDifferential_Filing.txt	2,705,389
	A01050_SubCountyRate_Filing.txt	116,523
	A01060_OptionRate_Filing.txt	1,465,743
	A01090_UnitDiscount_Filing.txt	203
	A01100_YieldAndTyield_Filing.txt	3,729,630
	A01110_HistoricalRevenueCapping_Filing.txt	124,170
	A01200_DocumentBuilder_Filing.txt	2,878,228
	A01210_Statement_Filing.txt	486


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,487
	A00045_Map_YTD.txt	1,537,859
	A00050_Quality_YTD.txt	450
	A00070_SubsidyPercent_YTD.txt	278
	A00200_Date_YTD.txt	741,905
	A00400_AgrCommodity_YTD.txt	399
	A00410_Class_YTD.txt	30
	A00420_Commodity_YTD.txt	131
	A00430_CommodityType_YTD.txt	327
	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,014
	A00520_State_YTD.txt	50
	A00530_SubClass_YTD.txt	4
	A00540_Type_YTD.txt	488
	A00810_Price_YTD.txt	471,891
	A01000_AgrRate_YTD.txt	1,136,526


File Name	Contains	Record Count

2011_ADM_YTD.zip	A01005_AreaRiskRate_YTD.txt	7,790,344
	A01010_BaseRate_YTD.txt	671,861
	A01020_Beta_YTD.txt	121,000
	A01030_ComboRevenueFactor_YTD.txt	2,417,580
	A01040_CoverageLevelDifferential_YTD.txt	7,575,024
	A01050_SubCountyRate_YTD.txt	149,784
	A01060_OptionRate_YTD.txt	2,598,612
	A01070_Proration_YTD.txt	2,742,828
	A01090_UnitDiscount_YTD.txt	245
	A01100_YieldAndTyield_YTD.txt	6,326,343
	A01110_HistoricalRevenueCapping_YTD.txt	141,168
	A01200_DocumentBuilder_YTD.txt	8,976,689
	A01210_Statement_YTD.txt	1,109


2011_SPOI_0131.zip	2011 Special Provisions 01/31 Filing Date	3,104