Date
To
All Insurance Providers
From
Zachary White, Chief, Actuarial Branch /s/ Zachary White
Subject
Actuarial Release 16-048 - Actuarial Information Available
As of December 15, 2016 the following information is now available on the FTP site:
- 2016 Actuarial Data Master for the 6/30, 11/30 Filing Date, YTD, and Daily Files.
- 2017 Actuarial Data Master for the 12/31 Filing Date, YTD, and Daily Files.
Users can find this information in the following directories:
- 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.
Additional notes and details regarding this data release:
2016 ADM Price updated for dry pea and dry bean revenue endorsement harvest prices, reference PM-16-064, 6/30 and 11/30 filings.
In addition on the above update, 2016 CY organic practice Austrian dry peas (Type Code 098, Practice Codes 702, 713) in ND (38) and MT (30) incorrectly received a harvest price that differed from the projected price. Austrian peas do not receive revenue coverage (Insurance Plans 2, 3, 32, and 33). Thus RMA has set the harvest price to be equal to the projected price for these occurrences.
2017 ADM Price now issued for the December 31 contract change commodities of fresh market tomatoes and safflower.
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 |
|---|---|---|
2016_ADM_Daily_161215.zip | A00810_Price_Daily.txt | 19,378 |
2016_ADM_Filing_0630.zip | A00030_InsuranceOffer_Filing.txt | 166,919 |
A00045_Map_Filing.txt | 38,297 | |
A00200_Date_Filing.txt | 172,925 | |
A00810_Price_Filing.txt | 168,737 | |
A01005_AreaRiskRate_Filing.txt | 11,310,055 | |
A01010_BaseRate_Filing.txt | 81,159 | |
A01040_CoverageLevelDifferential_Filing.txt | 1,469,809 | |
A01050_SubCountyRate_Filing.txt | 23,625 | |
A01060_OptionRate_Filing.txt | 570,178 | |
A01100_YieldAndTyield_Filing.txt | 1,372,480 | |
A01105_YieldExclusion_Filing.txt | 120,786 | |
A01110_HistoricalRevenueCapping_Filing.txt | 17,742 | |
A01200_DocumentBuilder_Filing.txt | 1,587,211 | |
2016_ADM_Filing_1130.zip | A00030_InsuranceOffer_Filing.txt | 886,327 |
A00045_Map_Filing.txt | 214,856 | |
A00200_Date_Filing.txt | 886,978 | |
A00810_Price_Filing.txt | 962,662 | |
A01005_AreaRiskRate_Filing.txt | 68,327,558 | |
A01010_BaseRate_Filing.txt | 418,887 | |
A01040_CoverageLevelDifferential_Filing.txt | 8,123,808 | |
A01050_SubCountyRate_Filing.txt | 146,647 | |
A01060_OptionRate_Filing.txt | 3,205,652 | |
A01100_YieldAndTyield_Filing.txt | 6,836,241 | |
A01105_YieldExclusion_Filing.txt | 466,461 | |
A01110_HistoricalRevenueCapping_Filing.txt | 138,738 | |
A01200_DocumentBuilder_Filing.txt | 8,887,029 | |
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_161215.zip | A00810_Price_Daily.txt | 894 |
2017_ADM_Filing_1231.zip | A00030_InsuranceOffer_Filing.txt | 894 |
A00045_Map_Filing.txt | 393 | |
A00200_Date_Filing.txt | 894 | |
A00810_Price_Filing.txt | 894 | |
A01010_BaseRate_Filing.txt | 492 | |
A01040_CoverageLevelDifferential_Filing.txt | 6,192 | |
A01050_SubCountyRate_Filing.txt | 144 | |
A01060_OptionRate_Filing.txt | 3,244 | |
A01100_YieldAndTyield_Filing.txt | 10,368 | |
A01105_YieldExclusion_Filing.txt | 483 | |
A01130_AreaCoverageLevel_Filing.txt | 2,412 | |
A01200_DocumentBuilder_Filing.txt | 5,835 | |
2017_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,112 |
A00030_InsuranceOffer_YTD.txt | 1,243,991 | |
A00045_Map_YTD.txt | 1,967,889 | |
A00050_Quality_YTD.txt | 510 | |
A00070_SubsidyPercent_YTD.txt | 479 | |
A00200_Date_YTD.txt | 1,250,495 | |
A00400_AgrCommodity_YTD.txt | 431 | |
A00410_Class_YTD.txt | 24 | |
A00420_Commodity_YTD.txt | 114 | |
A00430_CommodityType_YTD.txt | 339 | |
A00440_County_YTD.txt | 3,190 | |
A00450_CroppingPractice_YTD.txt | 75 | |
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,014 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 6 | |
A00540_Type_YTD.txt | 504 | |
A00550_DocumentStructure_YTD.txt | 20 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 43 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 95 | |
A00615_Draw_YTD.txt | 29,500 | |
A00810_Price_YTD.txt | 1,268,129 | |
A01000_AgrRate_YTD.txt | 9,898,224 | |
A01010_BaseRate_YTD.txt | 527,087 | |
A01020_Beta_YTD.txt | 121,500 | |
A01030_ComboRevenueFactor_YTD.txt | 2,857,140 | |
A01040_CoverageLevelDifferential_YTD.txt | 10,959,539 | |
A01050_SubCountyRate_YTD.txt | 194,071 | |
A01060_OptionRate_YTD.txt | 3,923,276 | |
A01070_Proration_YTD.txt | 384 | |
A01090_UnitDiscount_YTD.txt | 2,897 | |
A01100_YieldAndTyield_YTD.txt | 11,127,004 | |
A01105_YieldExclusion_YTD.txt | 615,027 | |
A01110_HistoricalRevenueCapping_YTD.txt | 156,294 | |
A01115_HistoricalYieldTrend_YTD.txt | 707,750 | |
A01120_AreaDataSource_YTD.txt | 124 | |
A01125_ProductionArea_YTD.txt | 175,798 | |
A01130_AreaCoverageLevel_YTD.txt | 12,182,684 | |
A01135_AreaRate_YTD.txt | 13,669,455 | |
A01200_DocumentBuilder_YTD.txt | 8,466,300 | |
A01210_Statement_YTD.txt | 1,209 |