Date
To
All Insurance Providers
From
Zachary White, Chief, Actuarial Branch /s/ Zachary White
Subject
Actuarial Release 17-034 - Actuarial Information Available
As of October 16, 2017 the following information is now available on the FTP site:
- 2016 Actuarial Data Master for the 2/28 Filing Date, YTD, and Daily Files.
- 2017 Actuarial Data Master for the 4/30, 8/31 Filing Date, YTD, and Daily Files.
- 2018 Actuarial Data Master for the 6/30, 8/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.
- 2018 Actuarial Data Master are in the References/Actuarial_Data_Master/2018 directory.
Additional notes and details regarding this data release:
2018 ADM Price updated for barley and wheat price announcement, PM-17-059, 6/30 filing.
2018 California safflower map files updated for labeling issues(San Joaquin & Yolo) with Yolo county re-added URA to the map which impacted ADM Map, ADM Sub County Rate, and ADM Document Builder for AIB map tab, 8/31 filing.
2017 Annual Forage, Apiculture, and PRF final index values and payment factors are issued on intervals 631 and 650 (ending month of August), reference PM-17-058, 4/30 and 8/31 filings.
2016 ADM Area Risk Rate (A01005) updated for payment landings for crop year 2017 Oysters, reference PM-17-060, 2/28 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 |
|---|---|---|
2016_ADM_Daily_171016.zip | A01005_AreaRiskRate_Daily.txt | 54 |
2016_ADM_Filing_0228.zip | A00030_InsuranceOffer_Filing.txt | 9 |
A00200_Date_Filing.txt | 9 | |
A00810_Price_Filing.txt | 9 | |
A01005_AreaRiskRate_Filing.txt | 54 | |
A01040_CoverageLevelDifferential_Filing.txt | 54 | |
A01200_DocumentBuilder_Filing.txt | 27 | |
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,267,262 | |
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_171016.zip | A00810_Price_Daily.txt | 147,402 |
A01130_AreaCoverageLevel_Daily.txt | 737,010 | |
2017_ADM_Filing_0430.zip | A00030_InsuranceOffer_Filing.txt | 15,286 |
A00045_Map_Filing.txt | 215,307 | |
A00200_Date_Filing.txt | 15,286 | |
A00810_Price_Filing.txt | 120,369 | |
A01010_BaseRate_Filing.txt | 1,911 | |
A01040_CoverageLevelDifferential_Filing.txt | 58,632 | |
A01050_SubCountyRate_Filing.txt | 603 | |
A01060_OptionRate_Filing.txt | 3,539 | |
A01100_YieldAndTyield_Filing.txt | 6,384 | |
A01130_AreaCoverageLevel_Filing.txt | 475,416 | |
A01200_DocumentBuilder_Filing.txt | 102,644 | |
2017_ADM_Filing_0831.zip | A00030_InsuranceOffer_Filing.txt | 165,814 |
A00045_Map_Filing.txt | 2,812,780 | |
A00200_Date_Filing.txt | 165,814 | |
A00810_Price_Filing.txt | 1,547,281 | |
A01000_AgrRate_Filing.txt | 9,898,224 | |
A01010_BaseRate_Filing.txt | 19,322 | |
A01040_CoverageLevelDifferential_Filing.txt | 956,778 | |
A01050_SubCountyRate_Filing.txt | 3,432 | |
A01060_OptionRate_Filing.txt | 85,864 | |
A01070_Proration_Filing.txt | 384 | |
A01100_YieldAndTyield_Filing.txt | 2,380,332 | |
A01105_YieldExclusion_Filing.txt | 11,685 | |
A01130_AreaCoverageLevel_Filing.txt | 7,127,437 | |
A01200_DocumentBuilder_Filing.txt | 648,214 | |
2017_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,117 |
A00030_InsuranceOffer_YTD.txt | 1,478,981 | |
A00045_Map_YTD.txt | 3,298,356 | |
A00050_Quality_YTD.txt | 510 | |
A00070_SubsidyPercent_YTD.txt | 498 | |
A00200_Date_YTD.txt | 1,485,485 | |
A00400_AgrCommodity_YTD.txt | 431 | |
A00410_Class_YTD.txt | 24 | |
A00420_Commodity_YTD.txt | 127 | |
A00430_CommodityType_YTD.txt | 364 | |
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 | 550 | |
A00550_DocumentStructure_YTD.txt | 21 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 46 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 95 | |
A00615_Draw_YTD.txt | 76,700 | |
A00810_Price_YTD.txt | 2,998,996 | |
A01000_AgrRate_YTD.txt | 9,898,224 | |
A01010_BaseRate_YTD.txt | 762,068 | |
A01020_Beta_YTD.txt | 121,500 | |
A01030_ComboRevenueFactor_YTD.txt | 2,857,140 | |
A01040_CoverageLevelDifferential_YTD.txt | 12,650,747 | |
A01050_SubCountyRate_YTD.txt | 195,367 | |
A01060_OptionRate_YTD.txt | 4,607,891 | |
A01070_Proration_YTD.txt | 2,738,688 | |
A01090_UnitDiscount_YTD.txt | 2,899 | |
A01100_YieldAndTyield_YTD.txt | 11,127,004 | |
A01105_YieldExclusion_YTD.txt | 615,027 | |
A01110_HistoricalRevenueCapping_YTD.txt | 156,294 | |
A01115_HistoricalYieldTrend_YTD.txt | 724,426 | |
A01120_AreaDataSource_YTD.txt | 130 | |
A01125_ProductionArea_YTD.txt | 177,728 | |
A01130_AreaCoverageLevel_YTD.txt | 12,269,758 | |
A01135_AreaRate_YTD.txt | 13,886,372 | |
A01200_DocumentBuilder_YTD.txt | 13,723,962 | |
A01210_Statement_YTD.txt | 1,298 | |
2018_ADM_Daily_171016.zip | A00045_Map_Daily.txt | 6 |
A00810_Price_Daily.txt | 2,898 | |
A01050_SubCountyRate_Daily.txt | 6 | |
A01200_DocumentBuilder_Daily.txt | 17 | |
2018_ADM_Filing_0630.zip | A00030_InsuranceOffer_Filing.txt | 182,975 |
A00045_Map_Filing.txt | 40,221 | |
A00200_Date_Filing.txt | 189,158 | |
A00810_Price_Filing.txt | 171,608 | |
A01010_BaseRate_Filing.txt | 85,407 | |
A01040_CoverageLevelDifferential_Filing.txt | 1,558,642 | |
A01050_SubCountyRate_Filing.txt | 25,389 | |
A01060_OptionRate_Filing.txt | 615,971 | |
A01100_YieldAndTyield_Filing.txt | 1,628,226 | |
A01105_YieldExclusion_Filing.txt | 131,439 | |
A01110_HistoricalRevenueCapping_Filing.txt | 17,688 | |
A01130_AreaCoverageLevel_Filing.txt | 713,790 | |
A01200_DocumentBuilder_Filing.txt | 1,248,466 | |
A01220_GuaranteeAdjustment_Filing.txt | 181,947 | |
2018_ADM_Filing_0831.zip | A00030_InsuranceOffer_Filing.txt | 247,208 |
A00045_Map_Filing.txt | 3,819,018 | |
A00200_Date_Filing.txt | 247,208 | |
A00810_Price_Filing.txt | 1,946,024 | |
A01000_AgrRate_Filing.txt | 10,747,415 | |
A01010_BaseRate_Filing.txt | 23,426 | |
A01040_CoverageLevelDifferential_Filing.txt | 1,379,312 | |
A01050_SubCountyRate_Filing.txt | 3,300 | |
A01060_OptionRate_Filing.txt | 94,395 | |
A01070_Proration_Filing.txt | 384 | |
A01100_YieldAndTyield_Filing.txt | 2,072,562 | |
A01105_YieldExclusion_Filing.txt | 12,228 | |
A01130_AreaCoverageLevel_Filing.txt | 9,640,959 | |
A01200_DocumentBuilder_Filing.txt | 897,107 | |
A01220_GuaranteeAdjustment_Filing.txt | 198 | |
2018_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,140 |
A00030_InsuranceOffer_YTD.txt | 462,669 | |
A00045_Map_YTD.txt | 4,308,717 | |
A00050_Quality_YTD.txt | 258 | |
A00070_SubsidyPercent_YTD.txt | 358 | |
A00200_Date_YTD.txt | 468,852 | |
A00400_AgrCommodity_YTD.txt | 435 | |
A00410_Class_YTD.txt | 14 | |
A00420_Commodity_YTD.txt | 80 | |
A00430_CommodityType_YTD.txt | 248 | |
A00440_County_YTD.txt | 3,190 | |
A00450_CroppingPractice_YTD.txt | 58 | |
A00460_InsurancePlan_YTD.txt | 21 | |
A00470_IntendedUse_YTD.txt | 11 | |
A00480_Interval_YTD.txt | 41 | |
A00490_IrrigationPractice_YTD.txt | 3 | |
A00500_OrganicPractice_YTD.txt | 3 | |
A00510_Practice_YTD.txt | 642 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 5 | |
A00540_Type_YTD.txt | 354 | |
A00550_DocumentStructure_YTD.txt | 20 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 30 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 27 | |
A00615_Draw_YTD.txt | 23,912,500 | |
A00810_Price_YTD.txt | 2,326,797 | |
A01000_AgrRate_YTD.txt | 10,747,415 | |
A01010_BaseRate_YTD.txt | 116,585 | |
A01020_Beta_YTD.txt | 37,500 | |
A01030_ComboRevenueFactor_YTD.txt | 1,108,890 | |
A01040_CoverageLevelDifferential_YTD.txt | 3,101,432 | |
A01050_SubCountyRate_YTD.txt | 29,370 | |
A01060_OptionRate_YTD.txt | 731,899 | |
A01070_Proration_YTD.txt | 384 | |
A01090_UnitDiscount_YTD.txt | 818 | |
A01100_YieldAndTyield_YTD.txt | 3,798,987 | |
A01105_YieldExclusion_YTD.txt | 145,518 | |
A01110_HistoricalRevenueCapping_YTD.txt | 17,688 | |
A01115_HistoricalYieldTrend_YTD.txt | 263,761 | |
A01120_AreaDataSource_YTD.txt | 57 | |
A01125_ProductionArea_YTD.txt | 59,325 | |
A01130_AreaCoverageLevel_YTD.txt | 11,270,179 | |
A01135_AreaRate_YTD.txt | 4,122,638 | |
A01200_DocumentBuilder_YTD.txt | 2,350,629 | |
A01210_Statement_YTD.txt | 765 | |
A01220_GuaranteeAdjustment_YTD.txt | 183,822 |