Date
To
All Insurance Providers
From
Zachary White, Chief, Actuarial Branch /s/ Zachary White
Subject
Actuarial Release 16-028 - Actuarial Information Available
As of July 15, 2016 the following information is now available on the FTP site:
- 2015 Actuarial Data Master for the 11/30 Filing Date, YTD, and Daily Files.
- 2016 Actuarial Data Master for the 4/30, 8/31 Filing Date, YTD, and Daily Files.
- 2017 Actuarial Data Master for the 6/30 Filing Date, YTD, and Daily Files.
- 2017 Special Provisions for the 6/30 Filing Date.
Users can find this information in the following directories:
- 2015 Actuarial Data Master are in the References/Actuarial_Data_Master/2015 directory.
- 2016 Actuarial Data Master are in the References/Actuarial_Data_Master/2016 directory.
- 2017 Actuarial Data Master are in the References/Actuarial_Data_Master/2017 directory.
- 2017 Special Provisions are in the Special_Provisions/2017 directory.
Additional notes and details regarding this data release:
2015 ARPI/SCO/STAX final county yields and county revenues on cotton are issued via ADM Area Risk Rate, reference PM-16-039, 11/30 filing.
2016 ADM Area Risk Rate updated final indices on intervals with an ending month of May for PRF/Apiculture and Annual Forage respectively, reference PM-16-038.
2017 new statement #24885 wording revised and Special Provisions reissued on 16 PNW/Spokane barley counties, 6/30 filing.
2017 ARPI forage production sales closing date corrected to be September 30 and Special Provisions are reissued, 6/30 filing.
2017 ADM Option Rate now has option "CP" populated on APH forage production, 6/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 release bulletins are located online at Actuarial Bulletins.
File Name | Contains | Record Count |
|---|---|---|
2015_ADM_Daily_160715.zip | A01005_AreaRiskRate_Daily.txt | 485,664 |
2015_ADM_Filing_1130.zip | A00030_InsuranceOffer_Filing.txt | 745,769 |
A00045_Map_Filing.txt | 232,040 | |
A00200_Date_Filing.txt | 746,420 | |
A00810_Price_Filing.txt | 808,088 | |
A01005_AreaRiskRate_Filing.txt | 50,758,986 | |
A01010_BaseRate_Filing.txt | 415,784 | |
A01040_CoverageLevelDifferential_Filing.txt | 7,110,613 | |
A01050_SubCountyRate_Filing.txt | 144,166 | |
A01060_OptionRate_Filing.txt | 2,972,066 | |
A01100_YieldAndTyield_Filing.txt | 6,593,468 | |
A01105_YieldExclusion_Filing.txt | 420,588 | |
A01110_HistoricalRevenueCapping_Filing.txt | 139,614 | |
A01200_DocumentBuilder_Filing.txt | 6,892,284 | |
2015_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,049 |
A00030_InsuranceOffer_YTD.txt | 1,191,404 | |
A00045_Map_YTD.txt | 1,684,344 | |
A00050_Quality_YTD.txt | 518 | |
A00070_SubsidyPercent_YTD.txt | 464 | |
A00200_Date_YTD.txt | 1,198,043 | |
A00400_AgrCommodity_YTD.txt | 405 | |
A00410_Class_YTD.txt | 27 | |
A00420_Commodity_YTD.txt | 126 | |
A00430_CommodityType_YTD.txt | 359 | |
A00440_County_YTD.txt | 3,190 | |
A00450_CroppingPractice_YTD.txt | 76 | |
A00460_InsurancePlan_YTD.txt | 24 | |
A00470_IntendedUse_YTD.txt | 12 | |
A00480_Interval_YTD.txt | 47 | |
A00490_IrrigationPractice_YTD.txt | 3 | |
A00500_OrganicPractice_YTD.txt | 3 | |
A00510_Practice_YTD.txt | 1,043 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 4 | |
A00540_Type_YTD.txt | 542 | |
A00550_DocumentStructure_YTD.txt | 20 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 47 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 83 | |
A00810_Price_YTD.txt | 1,034,566 | |
A01000_AgrRate_YTD.txt | 6,241,608 | |
A01005_AreaRiskRate_YTD.txt | 61,701,500 | |
A01010_BaseRate_YTD.txt | 749,203 | |
A01020_Beta_YTD.txt | 121,500 | |
A01030_ComboRevenueFactor_YTD.txt | 2,827,170 | |
A01040_CoverageLevelDifferential_YTD.txt | 10,312,176 | |
A01050_SubCountyRate_YTD.txt | 177,763 | |
A01060_OptionRate_YTD.txt | 4,040,002 | |
A01070_Proration_YTD.txt | 2,739,732 | |
A01090_UnitDiscount_YTD.txt | 2,669 | |
A01100_YieldAndTyield_YTD.txt | 10,293,875 | |
A01105_YieldExclusion_YTD.txt | 420,588 | |
A01110_HistoricalRevenueCapping_YTD.txt | 156,804 | |
A01200_DocumentBuilder_YTD.txt | 13,962,997 | |
A01210_Statement_YTD.txt | 2,916 | |
2016_ADM_Daily_160715.zip | A01005_AreaRiskRate_Daily.txt | 712,810 |
2016_ADM_Filing_0430.zip | A00030_InsuranceOffer_Filing.txt | 14,944 |
A00045_Map_Filing.txt | 102,327 | |
A00200_Date_Filing.txt | 14,944 | |
A00810_Price_Filing.txt | 12,675 | |
A01005_AreaRiskRate_Filing.txt | 450,492 | |
A01010_BaseRate_Filing.txt | 1,800 | |
A01040_CoverageLevelDifferential_Filing.txt | 56,706 | |
A01050_SubCountyRate_Filing.txt | 603 | |
A01060_OptionRate_Filing.txt | 3,252 | |
A01100_YieldAndTyield_Filing.txt | 4,275 | |
A01200_DocumentBuilder_Filing.txt | 100,572 | |
2016_ADM_Filing_0831.zip | A00030_InsuranceOffer_Filing.txt | 168,244 |
A00045_Map_Filing.txt | 1,590,039 | |
A00200_Date_Filing.txt | 168,244 | |
A00810_Price_Filing.txt | 341,100 | |
A01000_AgrRate_Filing.txt | 9,263,808 | |
A01005_AreaRiskRate_Filing.txt | 7,142,467 | |
A01010_BaseRate_Filing.txt | 19,247 | |
A01040_CoverageLevelDifferential_Filing.txt | 971,310 | |
A01050_SubCountyRate_Filing.txt | 3,432 | |
A01060_OptionRate_Filing.txt | 85,388 | |
A01070_Proration_Filing.txt | 384 | |
A01100_YieldAndTyield_Filing.txt | 2,252,082 | |
A01105_YieldExclusion_Filing.txt | 11,238 | |
A01200_DocumentBuilder_Filing.txt | 918,792 | |
2016_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,072 |
A00030_InsuranceOffer_YTD.txt | 1,474,169 | |
A00045_Map_YTD.txt | 1,954,672 | |
A00050_Quality_YTD.txt | 538 | |
A00070_SubsidyPercent_YTD.txt | 480 | |
A00200_Date_YTD.txt | 1,480,826 | |
A00400_AgrCommodity_YTD.txt | 400 | |
A00410_Class_YTD.txt | 24 | |
A00420_Commodity_YTD.txt | 131 | |
A00430_CommodityType_YTD.txt | 360 | |
A00440_County_YTD.txt | 3,190 | |
A00450_CroppingPractice_YTD.txt | 77 | |
A00460_InsurancePlan_YTD.txt | 25 | |
A00470_IntendedUse_YTD.txt | 12 | |
A00480_Interval_YTD.txt | 47 | |
A00490_IrrigationPractice_YTD.txt | 3 | |
A00500_OrganicPractice_YTD.txt | 3 | |
A00510_Practice_YTD.txt | 1,072 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 6 | |
A00540_Type_YTD.txt | 547 | |
A00550_DocumentStructure_YTD.txt | 20 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 46 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 92 | |
A00615_Draw_YTD.txt | 74,100 | |
A00810_Price_YTD.txt | 1,511,463 | |
A01000_AgrRate_YTD.txt | 9,263,808 | |
A01005_AreaRiskRate_YTD.txt | 87,253,282 | |
A01010_BaseRate_YTD.txt | 755,783 | |
A01020_Beta_YTD.txt | 121,500 | |
A01030_ComboRevenueFactor_YTD.txt | 2,827,170 | |
A01040_CoverageLevelDifferential_YTD.txt | 12,312,223 | |
A01050_SubCountyRate_YTD.txt | 177,454 | |
A01060_OptionRate_YTD.txt | 4,543,545 | |
A01070_Proration_YTD.txt | 2,739,624 | |
A01090_UnitDiscount_YTD.txt | 2,801 | |
A01100_YieldAndTyield_YTD.txt | 10,558,009 | |
A01105_YieldExclusion_YTD.txt | 599,718 | |
A01110_HistoricalRevenueCapping_YTD.txt | 156,480 | |
A01115_HistoricalYieldTrend_YTD.txt | 23,482 | |
A01200_DocumentBuilder_YTD.txt | 17,395,677 | |
A01210_Statement_YTD.txt | 22,016 | |
2017_ADM_Daily_160715.zip | A00200_Date_Daily.txt | 2,577 |
A01060_OptionRate_Daily.txt | 6,438 | |
A01210_Statement_Daily.txt | 1 | |
2017_ADM_Filing_0630.zip | A00030_InsuranceOffer_Filing.txt | 170,930 |
A00045_Map_Filing.txt | 38,187 | |
A00200_Date_Filing.txt | 176,783 | |
A00810_Price_Filing.txt | 103,529 | |
A01010_BaseRate_Filing.txt | 82,470 | |
A01040_CoverageLevelDifferential_Filing.txt | 1,463,639 | |
A01050_SubCountyRate_Filing.txt | 23,787 | |
A01060_OptionRate_Filing.txt | 585,850 | |
A01100_YieldAndTyield_Filing.txt | 1,483,536 | |
A01105_YieldExclusion_Filing.txt | 127,068 | |
A01110_HistoricalRevenueCapping_Filing.txt | 17,706 | |
A01130_AreaCoverageLevel_Filing.txt | 633,462 | |
A01200_DocumentBuilder_Filing.txt | 1,107,631 | |
2017_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,112 |
A00030_InsuranceOffer_YTD.txt | 185,985 | |
A00045_Map_YTD.txt | 140,514 | |
A00050_Quality_YTD.txt | 232 | |
A00070_SubsidyPercent_YTD.txt | 273 | |
A00200_Date_YTD.txt | 191,838 | |
A00410_Class_YTD.txt | 11 | |
A00420_Commodity_YTD.txt | 36 | |
A00430_CommodityType_YTD.txt | 66 | |
A00440_County_YTD.txt | 3,166 | |
A00450_CroppingPractice_YTD.txt | 32 | |
A00460_InsurancePlan_YTD.txt | 17 | |
A00470_IntendedUse_YTD.txt | 5 | |
A00480_Interval_YTD.txt | 39 | |
A00490_IrrigationPractice_YTD.txt | 3 | |
A00500_OrganicPractice_YTD.txt | 3 | |
A00510_Practice_YTD.txt | 303 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 3 | |
A00540_Type_YTD.txt | 105 | |
A00550_DocumentStructure_YTD.txt | 19 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 25 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 21 | |
A00810_Price_YTD.txt | 116,315 | |
A01010_BaseRate_YTD.txt | 84,381 | |
A01020_Beta_YTD.txt | 37,500 | |
A01030_ComboRevenueFactor_YTD.txt | 889,110 | |
A01040_CoverageLevelDifferential_YTD.txt | 1,521,248 | |
A01050_SubCountyRate_YTD.txt | 24,390 | |
A01060_OptionRate_YTD.txt | 589,389 | |
A01090_UnitDiscount_YTD.txt | 816 | |
A01100_YieldAndTyield_YTD.txt | 1,489,920 | |
A01105_YieldExclusion_YTD.txt | 127,068 | |
A01110_HistoricalRevenueCapping_YTD.txt | 17,706 | |
A01115_HistoricalYieldTrend_YTD.txt | 147,558 | |
A01120_AreaDataSource_YTD.txt | 30 | |
A01125_ProductionArea_YTD.txt | 51,653 | |
A01130_AreaCoverageLevel_YTD.txt | 1,083,954 | |
A01135_AreaRate_YTD.txt | 2,360,458 | |
A01200_DocumentBuilder_YTD.txt | 1,208,856 | |
A01210_Statement_YTD.txt | 402 | |
2017_SPOI_0630.zip | 2017 Special Provisions 06/30 Filing Date | 4,922 |