Date
To
All Insurance Providers
From
Zachary White, Chief, Actuarial Branch /s/ Zachary White
Subject
Actuarial Release 16-024 - Actuarial Information Available
As of June 13, 2016 the following information is now available on the FTP site:
- 2016 Actuarial Data Master for the 4/30, 8/31 Filing Date, YTD, and Daily Files.
- 2017 Actuarial Data Master for the 4/30 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 Area Risk Rate updated final indices on intervals with an ending month of April for PRF/Apiculture and Annual Forage respectively, reference PM-16-033.
2017 ADM Layout (A00010) updated to show the business key is added to 5 additional fields (field #'s 14-18) on the new Area Data Source (A01120) yet to be issued until the 6/30 filing. The revised PDF Layout was posted May 19, see change log on page 69 of the document.
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_160609.zip | A01005_AreaRiskRate_Daily.txt | 621,500 |
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_160609.zip | A00010_AdmLayout_Daily.txt | 5 |
2017_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,112 |
A00030_InsuranceOffer_YTD.txt | 15,055 | |
A00045_Map_YTD.txt | 102,327 | |
A00070_SubsidyPercent_YTD.txt | 98 | |
A00200_Date_YTD.txt | 15,055 | |
A00410_Class_YTD.txt | 4 | |
A00420_Commodity_YTD.txt | 17 | |
A00430_CommodityType_YTD.txt | 20 | |
A00440_County_YTD.txt | 3,161 | |
A00450_CroppingPractice_YTD.txt | 23 | |
A00460_InsurancePlan_YTD.txt | 6 | |
A00470_IntendedUse_YTD.txt | 2 | |
A00480_Interval_YTD.txt | 39 | |
A00490_IrrigationPractice_YTD.txt | 3 | |
A00500_OrganicPractice_YTD.txt | 3 | |
A00510_Practice_YTD.txt | 165 | |
A00520_State_YTD.txt | 49 | |
A00530_SubClass_YTD.txt | 1 | |
A00540_Type_YTD.txt | 33 | |
A00550_DocumentStructure_YTD.txt | 11 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 9 | |
A00580_RateMethod_YTD.txt | 1 | |
A00810_Price_YTD.txt | 12,786 | |
A01010_BaseRate_YTD.txt | 1,911 | |
A01040_CoverageLevelDifferential_YTD.txt | 57,609 | |
A01050_SubCountyRate_YTD.txt | 603 | |
A01060_OptionRate_YTD.txt | 3,539 | |
A01090_UnitDiscount_YTD.txt | 37 | |
A01100_YieldAndTyield_YTD.txt | 6,384 | |
A01130_AreaCoverageLevel_YTD.txt | 450,492 | |
A01135_AreaRate_YTD.txt | 208,568 | |
A01200_DocumentBuilder_YTD.txt | 101,225 | |
A01210_Statement_YTD.txt | 131 |