Date
To
All Insurance Providers
From
Zachary White, Chief, Actuarial Branch /s/ Zachary White
Subject
Actuarial Release 17-025 - Actuarial Information Available
As of August 11, 2017 the following information is now available on the FTP site:
- 2017 Actuarial Data Master for the 4/30, 8/31, 11/30 Filing Date, YTD, and Daily Files.
- 2018 Actuarial Data Master for the 8/31, 9/30, 10/31 Filing Date, YTD, and Daily Files.
- 2018 Special Provisions for the 8/31, 9/30, 10/31 Filing Date.
Users can find this information in the following directories:
- 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.
- 2018 Special Provisions are in the Special_Provisions/2018 directory.
Additional notes and details regarding this data release:
2017 Annual Forage, Apiculture, and PRF final index values and payment factors are issued on intervals 629 and 648 (ending month of June), reference PM-17-047, 4/30 and 8/31 filings.
2017 ADM Area Rate & Area Coverage Level updated on cotton STAX (plans 35 and 36) to move Area Loss Trigger = 0.90 from Price Volatility 0.00 to all available price volatilities to correct for errors on processing, 11/30 filing.
2018 Special Provisions and ADM are now issued for the 8/31, 9/30, and 10/31 filings except for PRF/API, almonds, apples, olives, and Whole Farm Revenue Protection (WFRP). SCO (plan 31) ADM will be issued later (August 22-25) for applicable commodities.
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 |
|---|---|---|
2017_ADM_Daily_170810.zip | A00810_Price_Daily.txt | 148,381 |
A01130_AreaCoverageLevel_Daily.txt | 769,865 | |
A01135_AreaRate_Daily.txt | 32 | |
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_Filing_1130.zip | A00030_InsuranceOffer_Filing.txt | 882,721 |
A00045_Map_Filing.txt | 223,049 | |
A00200_Date_Filing.txt | 883,372 | |
A00810_Price_Filing.txt | 959,170 | |
A01010_BaseRate_Filing.txt | 417,171 | |
A01040_CoverageLevelDifferential_Filing.txt | 8,396,664 | |
A01050_SubCountyRate_Filing.txt | 164,404 | |
A01060_OptionRate_Filing.txt | 3,221,238 | |
A01100_YieldAndTyield_Filing.txt | 7,157,968 | |
A01105_YieldExclusion_Filing.txt | 473,925 | |
A01110_HistoricalRevenueCapping_Filing.txt | 138,588 | |
A01130_AreaCoverageLevel_Filing.txt | 3,984,890 | |
A01200_DocumentBuilder_Filing.txt | 6,552,308 | |
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_170810.zip | A00030_InsuranceOffer_Daily.txt | 20,717 |
A00045_Map_Daily.txt | 6,336 | |
A00050_Quality_Daily.txt | 21 | |
A00070_SubsidyPercent_Daily.txt | 38 | |
A00200_Date_Daily.txt | 20,717 | |
A00410_Class_Daily.txt | 3 | |
A00420_Commodity_Daily.txt | 37 | |
A00430_CommodityType_Daily.txt | 175 | |
A00450_CroppingPractice_Daily.txt | 19 | |
A00460_InsurancePlan_Daily.txt | 2 | |
A00470_IntendedUse_Daily.txt | 1 | |
A00510_Practice_Daily.txt | 219 | |
A00530_SubClass_Daily.txt | 2 | |
A00540_Type_Daily.txt | 229 | |
A00550_DocumentStructure_Daily.txt | 1 | |
A00570_InsuranceOption_Daily.txt | 3 | |
A01010_BaseRate_Daily.txt | 20,717 | |
A01040_CoverageLevelDifferential_Daily.txt | 184,364 | |
A01050_SubCountyRate_Daily.txt | 2,448 | |
A01060_OptionRate_Daily.txt | 64,126 | |
A01070_Proration_Daily.txt | 384 | |
A01090_UnitDiscount_Daily.txt | 1 | |
A01100_YieldAndTyield_Daily.txt | 1,168,917 | |
A01105_YieldExclusion_Daily.txt | 9,180 | |
A01200_DocumentBuilder_Daily.txt | 155,261 | |
A01210_Statement_Daily.txt | 289 | |
A01220_GuaranteeAdjustment_Daily.txt | 1,692 | |
2018_ADM_Filing_0831.zip | A00030_InsuranceOffer_Filing.txt | 15,443 |
A00045_Map_Filing.txt | 3,495 | |
A00200_Date_Filing.txt | 15,443 | |
A01010_BaseRate_Filing.txt | 15,443 | |
A01040_CoverageLevelDifferential_Filing.txt | 141,824 | |
A01050_SubCountyRate_Filing.txt | 2,430 | |
A01060_OptionRate_Filing.txt | 47,640 | |
A01070_Proration_Filing.txt | 384 | |
A01100_YieldAndTyield_Filing.txt | 1,087,344 | |
A01105_YieldExclusion_Filing.txt | 7,665 | |
A01200_DocumentBuilder_Filing.txt | 113,864 | |
A01220_GuaranteeAdjustment_Filing.txt | 198 | |
2018_ADM_Filing_0930.zip | A00030_InsuranceOffer_Filing.txt | 1,239 |
A00045_Map_Filing.txt | 18 | |
A00200_Date_Filing.txt | 1,239 | |
A01010_BaseRate_Filing.txt | 1,239 | |
A01040_CoverageLevelDifferential_Filing.txt | 10,047 | |
A01050_SubCountyRate_Filing.txt | 18 | |
A01060_OptionRate_Filing.txt | 4,884 | |
A01100_YieldAndTyield_Filing.txt | 20,043 | |
A01105_YieldExclusion_Filing.txt | 438 | |
A01200_DocumentBuilder_Filing.txt | 12,171 | |
A01220_GuaranteeAdjustment_Filing.txt | 1,494 | |
2018_ADM_Filing_1031.zip | A00030_InsuranceOffer_Filing.txt | 4,035 |
A00045_Map_Filing.txt | 2,823 | |
A00200_Date_Filing.txt | 4,035 | |
A01010_BaseRate_Filing.txt | 4,035 | |
A01040_CoverageLevelDifferential_Filing.txt | 32,493 | |
A01060_OptionRate_Filing.txt | 11,602 | |
A01100_YieldAndTyield_Filing.txt | 61,530 | |
A01105_YieldExclusion_Filing.txt | 1,077 | |
A01200_DocumentBuilder_Filing.txt | 29,226 | |
2018_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,140 |
A00030_InsuranceOffer_YTD.txt | 227,631 | |
A00045_Map_YTD.txt | 487,980 | |
A00050_Quality_YTD.txt | 258 | |
A00070_SubsidyPercent_YTD.txt | 319 | |
A00200_Date_YTD.txt | 233,814 | |
A00410_Class_YTD.txt | 14 | |
A00420_Commodity_YTD.txt | 74 | |
A00430_CommodityType_YTD.txt | 241 | |
A00440_County_YTD.txt | 3,166 | |
A00450_CroppingPractice_YTD.txt | 57 | |
A00460_InsurancePlan_YTD.txt | 20 | |
A00470_IntendedUse_YTD.txt | 7 | |
A00480_Interval_YTD.txt | 41 | |
A00490_IrrigationPractice_YTD.txt | 3 | |
A00500_OrganicPractice_YTD.txt | 3 | |
A00510_Practice_YTD.txt | 554 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 5 | |
A00540_Type_YTD.txt | 339 | |
A00550_DocumentStructure_YTD.txt | 20 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 29 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 27 | |
A00810_Price_YTD.txt | 312,189 | |
A01010_BaseRate_YTD.txt | 108,035 | |
A01020_Beta_YTD.txt | 37,500 | |
A01030_ComboRevenueFactor_YTD.txt | 1,108,890 | |
A01040_CoverageLevelDifferential_YTD.txt | 1,838,819 | |
A01050_SubCountyRate_YTD.txt | 28,440 | |
A01060_OptionRate_YTD.txt | 683,636 | |
A01070_Proration_YTD.txt | 384 | |
A01090_UnitDiscount_YTD.txt | 817 | |
A01100_YieldAndTyield_YTD.txt | 2,803,926 | |
A01105_YieldExclusion_YTD.txt | 140,619 | |
A01110_HistoricalRevenueCapping_YTD.txt | 17,688 | |
A01115_HistoricalYieldTrend_YTD.txt | 153,345 | |
A01120_AreaDataSource_YTD.txt | 31 | |
A01125_ProductionArea_YTD.txt | 51,790 | |
A01130_AreaCoverageLevel_YTD.txt | 1,551,856 | |
A01135_AreaRate_YTD.txt | 2,627,804 | |
A01200_DocumentBuilder_YTD.txt | 1,544,246 | |
A01210_Statement_YTD.txt | 705 | |
A01220_GuaranteeAdjustment_YTD.txt | 183,822 | |
2018_SPOI_0831.zip | 2018 Special Provisions 08/31 Filing Date | 729 |
2018_SPOI_0930.zip | 2018 Special Provisions 09/30 Filing Date | 84 |
2018_SPOI_1031.zip | 2018 Special Provisions 10/31 Filing Date | 319 |