Date
To
All Insurance Providers
From
Chris Aulbur, Chief, Actuarial Branch /s/ Chris Aulbur
Subject
Actuarial Release 15-022 - Actuarial Information Available
As of June 11, 2015 the following information is now available on the FTP site:
- 2015 Actuarial Data Master for the 6/30 Filing Date, YTD, and Daily Files.
- 2016 Actuarial Data Master for the 4/30, 6/30 Filing Date, YTD, and Daily Files.
- 2016 Special Provisions for the 6/30 Filing Date.
Users can find this information in the following directories:
- 2015 Actuarial Data Master are in the References/Actuarial_Data_Master/2015 directory.
- 2016 Actuarial Data Master are in the References/Actuarial_Data_Master/2016 directory.
- 2016 Special Provisions are in the Special_Provisions/2016 directory.
Additional notes and details regarding this data release:
2016 Special Provisions, ADM, and related files are now released for the 6/30 filing.
2016 ADM Option Rate and Price updated to allow for Contract Price Addendum to apply to organic transitional practice retroactive to the 4/30 contract change crops of cabbage, CA potatoes, and CA sugar beets.
2015 ADM Quality (A00050) on wheat updated missing discount factor on quality ID 6 sequence 55 to be 0.450 on vomitoxin range of 5.10 to 10.00 ppm
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.
Archived release bulletins are located online at Actuarial Bulletins.
File Name | Contains | Record Count |
|---|---|---|
2015_ADM_Daily_150610.zip | A00050_Quality_Daily.txt | 1 |
2015_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,049 |
A00030_InsuranceOffer_YTD.txt | 1,191,404 | |
A00045_Map_YTD.txt | 1,684,344 | |
A00050_Quality_YTD.txt | 517 | |
A00070_SubsidyPercent_YTD.txt | 464 | |
A00200_Date_YTD.txt | 1,198,043 | |
A00400_AgrCommodity_YTD.txt | 405 | |
A00410_Class_YTD.txt | 27 | |
A00420_Commodity_YTD.txt | 126 | |
A00430_CommodityType_YTD.txt | 359 | |
A00440_County_YTD.txt | 3,190 | |
A00450_CroppingPractice_YTD.txt | 76 | |
A00460_InsurancePlan_YTD.txt | 24 | |
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,043 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 4 | |
A00540_Type_YTD.txt | 542 | |
A00550_DocumentStructure_YTD.txt | 20 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 47 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 83 | |
A00810_Price_YTD.txt | 1,034,458 | |
A01000_AgrRate_YTD.txt | 6,241,608 | |
A01005_AreaRiskRate_YTD.txt | 61,701,500 | |
A01010_BaseRate_YTD.txt | 749,203 | |
A01020_Beta_YTD.txt | 121,500 | |
A01030_ComboRevenueFactor_YTD.txt | 2,827,170 | |
A01040_CoverageLevelDifferential_YTD.txt | 10,312,176 | |
A01050_SubCountyRate_YTD.txt | 177,763 | |
A01060_OptionRate_YTD.txt | 4,040,002 | |
A01070_Proration_YTD.txt | 2,739,732 | |
A01090_UnitDiscount_YTD.txt | 2,669 | |
A01100_YieldAndTyield_YTD.txt | 10,293,875 | |
A01105_YieldExclusion_YTD.txt | 420,588 | |
A01110_HistoricalRevenueCapping_YTD.txt | 156,804 | |
A01200_DocumentBuilder_YTD.txt | 13,962,997 | |
A01210_Statement_YTD.txt | 2,916 | |
2016_ADM_Daily_150611.zip | A00030_InsuranceOffer_Daily.txt | 166,092 |
A00045_Map_Daily.txt | 38,007 | |
A00050_Quality_Daily.txt | 231 | |
A00070_SubsidyPercent_Daily.txt | 170 | |
A00200_Date_Daily.txt | 172,098 | |
A00410_Class_Daily.txt | 7 | |
A00420_Commodity_Daily.txt | 16 | |
A00430_CommodityType_Daily.txt | 44 | |
A00440_County_Daily.txt | 5 | |
A00450_CroppingPractice_Daily.txt | 6 | |
A00460_InsurancePlan_Daily.txt | 10 | |
A00470_IntendedUse_Daily.txt | 2 | |
A00510_Practice_Daily.txt | 126 | |
A00520_State_Daily.txt | 1 | |
A00530_SubClass_Daily.txt | 2 | |
A00540_Type_Daily.txt | 67 | |
A00550_DocumentStructure_Daily.txt | 6 | |
A00570_InsuranceOption_Daily.txt | 16 | |
A00580_RateMethod_Daily.txt | 3 | |
A00590_SpoiGroup_Daily.txt | 18 | |
A00810_Price_Daily.txt | 75 | |
A01005_AreaRiskRate_Daily.txt | 11,215,380 | |
A01010_BaseRate_Daily.txt | 81,123 | |
A01020_Beta_Daily.txt | 37,500 | |
A01030_ComboRevenueFactor_Daily.txt | 819,180 | |
A01040_CoverageLevelDifferential_Daily.txt | 1,428,594 | |
A01050_SubCountyRate_Daily.txt | 23,625 | |
A01060_OptionRate_Daily.txt | 490,844 | |
A01090_UnitDiscount_Daily.txt | 778 | |
A01100_YieldAndTyield_Daily.txt | 1,371,420 | |
A01105_YieldExclusion_Daily.txt | 120,786 | |
A01110_HistoricalRevenueCapping_Daily.txt | 17,742 | |
A01200_DocumentBuilder_Daily.txt | 1,578,932 | |
A01210_Statement_Daily.txt | 4,911 | |
2016_ADM_Filing_0430.zip | A00030_InsuranceOffer_Filing.txt | 14,062 |
A00045_Map_Filing.txt | 89,279 | |
A00200_Date_Filing.txt | 14,062 | |
A00810_Price_Filing.txt | 11,793 | |
A01005_AreaRiskRate_Filing.txt | 392,708 | |
A01010_BaseRate_Filing.txt | 1,800 | |
A01040_CoverageLevelDifferential_Filing.txt | 52,800 | |
A01050_SubCountyRate_Filing.txt | 603 | |
A01060_OptionRate_Filing.txt | 3,252 | |
A01100_YieldAndTyield_Filing.txt | 4,275 | |
A01200_DocumentBuilder_Filing.txt | 95,154 | |
2016_ADM_Filing_0630.zip | A00030_InsuranceOffer_Filing.txt | 166,092 |
A00045_Map_Filing.txt | 38,007 | |
A00200_Date_Filing.txt | 172,098 | |
A01005_AreaRiskRate_Filing.txt | 11,215,380 | |
A01010_BaseRate_Filing.txt | 81,123 | |
A01040_CoverageLevelDifferential_Filing.txt | 1,428,594 | |
A01050_SubCountyRate_Filing.txt | 23,625 | |
A01060_OptionRate_Filing.txt | 490,769 | |
A01100_YieldAndTyield_Filing.txt | 1,371,420 | |
A01105_YieldExclusion_Filing.txt | 120,786 | |
A01110_HistoricalRevenueCapping_Filing.txt | 17,742 | |
A01200_DocumentBuilder_Filing.txt | 1,578,932 | |
2016_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,020 |
A00030_InsuranceOffer_YTD.txt | 180,154 | |
A00045_Map_YTD.txt | 127,286 | |
A00050_Quality_YTD.txt | 231 | |
A00070_SubsidyPercent_YTD.txt | 269 | |
A00200_Date_YTD.txt | 186,160 | |
A00410_Class_YTD.txt | 11 | |
A00420_Commodity_YTD.txt | 33 | |
A00430_CommodityType_YTD.txt | 64 | |
A00440_County_YTD.txt | 3,166 | |
A00450_CroppingPractice_YTD.txt | 29 | |
A00460_InsurancePlan_YTD.txt | 16 | |
A00470_IntendedUse_YTD.txt | 4 | |
A00480_Interval_YTD.txt | 39 | |
A00490_IrrigationPractice_YTD.txt | 3 | |
A00500_OrganicPractice_YTD.txt | 3 | |
A00510_Practice_YTD.txt | 276 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 3 | |
A00540_Type_YTD.txt | 100 | |
A00550_DocumentStructure_YTD.txt | 17 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 25 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 18 | |
A00810_Price_YTD.txt | 11,793 | |
A01005_AreaRiskRate_YTD.txt | 11,608,088 | |
A01010_BaseRate_YTD.txt | 82,923 | |
A01020_Beta_YTD.txt | 37,500 | |
A01030_ComboRevenueFactor_YTD.txt | 819,180 | |
A01040_CoverageLevelDifferential_YTD.txt | 1,481,394 | |
A01050_SubCountyRate_YTD.txt | 24,228 | |
A01060_OptionRate_YTD.txt | 494,021 | |
A01090_UnitDiscount_YTD.txt | 815 | |
A01100_YieldAndTyield_YTD.txt | 1,375,695 | |
A01105_YieldExclusion_YTD.txt | 120,786 | |
A01110_HistoricalRevenueCapping_YTD.txt | 17,742 | |
A01200_DocumentBuilder_YTD.txt | 1,674,086 | |
A01210_Statement_YTD.txt | 5,044 | |
2016_SPOI_0630.zip | 2016 Special Provisions 06/30 Filing Date | 4,432 |