Date
To
All Insurance Providers
From
Zachary White, Chief, Actuarial Branch /s/ Zachary White
Subject
Actuarial Release 17-028 - Actuarial Information Available
As of August 29, 2017 the following information is now available on the FTP site:
- 2018 Actuarial Data Master for the 8/31 Filing Date, YTD, and Daily Files.
- 2018 Special Provisions for the 8/31 Filing Date.
Users can find this information in the following directories:
- 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:
2018 Special Provisions and ADM are now issued for Whole Farm Revenue Protection (WFRP), reference PM-17-050, 8/31 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 |
|---|---|---|
2018_ADM_Daily_170829.zip | A00030_InsuranceOffer_Daily.txt | 9,420 |
A00070_SubsidyPercent_Daily.txt | 20 | |
A00200_Date_Daily.txt | 9,420 | |
A00400_AgrCommodity_Daily.txt | 435 | |
A00420_Commodity_Daily.txt | 1 | |
A00430_CommodityType_Daily.txt | 3 | |
A00440_County_Daily.txt | 24 | |
A00460_InsurancePlan_Daily.txt | 1 | |
A00510_Practice_Daily.txt | 1 | |
A00540_Type_Daily.txt | 3 | |
A01000_AgrRate_Daily.txt | 10,747,343 | |
A01040_CoverageLevelDifferential_Daily.txt | 75,312 | |
A01200_DocumentBuilder_Daily.txt | 122,721 | |
A01210_Statement_Daily.txt | 12 | |
2018_ADM_Filing_0831.zip | A00030_InsuranceOffer_Filing.txt | 247,208 |
A00045_Map_Filing.txt | 3,819,012 | |
A00200_Date_Filing.txt | 247,208 | |
A00810_Price_Filing.txt | 1,946,024 | |
A01000_AgrRate_Filing.txt | 10,747,343 | |
A01010_BaseRate_Filing.txt | 23,426 | |
A01040_CoverageLevelDifferential_Filing.txt | 1,379,312 | |
A01050_SubCountyRate_Filing.txt | 3,294 | |
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,101 | |
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,711 | |
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 | |
A00810_Price_YTD.txt | 2,260,814 | |
A01000_AgrRate_YTD.txt | 10,747,343 | |
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,364 | |
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 | 174,504 | |
A01120_AreaDataSource_YTD.txt | 52 | |
A01125_ProductionArea_YTD.txt | 58,704 | |
A01130_AreaCoverageLevel_YTD.txt | 11,213,635 | |
A01135_AreaRate_YTD.txt | 4,083,074 | |
A01200_DocumentBuilder_YTD.txt | 2,336,342 | |
A01210_Statement_YTD.txt | 762 | |
A01220_GuaranteeAdjustment_YTD.txt | 183,822 | |
2018_SPOI_0831.zip | 2018 Special Provisions 08/31 Filing Date | 10,329 |