Date
To
All Insurance Providers
From
Megan Heyns, Chief, Filing Branch
Subject
Actuarial Release 21-016 - Actuarial Information Available
As of April 29, 2021 the following information is now available on the FTP site:
- 2019 Actuarial Data Master for the 8/31 Filing Date, YTD, and Daily Files.
- 2020 Actuarial Data Master for the 8/31, 10/31 Filing Date, YTD, and Daily Files.
- 2021 Actuarial Data Master for the 6/30, 11/30 Filing Date, YTD, and Daily Files.
- 2022 Actuarial Data Master for the 4/30 Filing Date, YTD, and Daily Files.
- 2022 Special Provisions for the 4/30 Filing Date.
Users can find this information in the following directories:
- 2019 Actuarial Data Master are in the References/Actuarial_Data_Master/2019 directory.
- 2020 Actuarial Data Master are in the References/Actuarial_Data_Master/2020 directory.
- 2021 Actuarial Data Master are in the References/Actuarial_Data_Master/2021 directory.
- 2022 Actuarial Data Master are in the References/Actuarial_Data_Master/2022 directory.
- 2022 Special Provisions are in the Special_Provisions/2022 directory.
Additional notes and details regarding this data release:
2022 ADM Layout updated to add Sales Effective Date as a key field to LGM Gross Margin, 4/30 filing. 2022 RY ADM and Special Provisions issued for Livestock Gross Margin and Dairy Revenue Protection, 4/30 filing. 2021 RY ADM Price are reissued for corrections being made after reviewing issuance of contract prices and their corresponding max contract price factors and max contract prices, 6/30 and 11/30 filings. 2020 RY ADM Area Coverage Level and ADM Price updated to issue final county yields and payment factors for SCO commodities, reference PM-21-024, 8/31 and 10/31 filings. 2019 RY ADM Area Coverage Level and ADM Price updated to issue final county yields and payment factors for SCO commodities, reference PM-21-024, 8/31 filing.
Please notify your data processing representative that this information is available for downloading. For questions regarding the actuarial information, please contact Megan Heyns by phone at (816) 926-5636, or via email to megan.heyns@rma.usda.gov
Archived release bulletins are located online at www.rma.usda.gov/Policy-and-Procedure/Bulletins-and-Memos/Actuarial-Releases
| File Name | Contains | Record Count |
| 2019_ADM_Daily_210429.zip | A00810_Price_Daily.txt A01130_AreaCoverageLevel_Daily.txt | 303 1,818 |
| 2019_ADM_Filing_0831.zip | A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01000_AgrRate_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01070_Proration_Filing.txt A01100_YieldAndTyield_Filing.txt A01105_YieldExclusion_Filing.txt A01130_AreaCoverageLevel_Filing.txt A01200_DocumentBuilder_Filing.txt A01220_GuaranteeAdjustment_Filing.txt | 248,096 3,817,989 248,096 1,947,248 11,104,800 24,197 1,386,077 3,327 120,759 384 2,074,962 13,533 9,641,781 1,233,868 132 |
| 2019_ADM_YTD.zip | A00010_AdmLayout_YTD.txt A00030_InsuranceOffer_YTD.txt A00045_Map_YTD.txt A00050_Quality_YTD.txt A00070_SubsidyPercent_YTD.txt A00200_Date_YTD.txt A00400_AgrCommodity_YTD.txt A00410_Class_YTD.txt A00420_Commodity_YTD.txt A00430_CommodityType_YTD.txt A00440_County_YTD.txt A00450_CroppingPractice_YTD.txt A00460_InsurancePlan_YTD.txt A00470_IntendedUse_YTD.txt A00480_Interval_YTD.txt A00490_IrrigationPractice_YTD.txt A00500_OrganicPractice_YTD.txt A00510_Practice_YTD.txt A00520_State_YTD.txt A00530_SubClass_YTD.txt A00540_Type_YTD.txt A00550_DocumentStructure_YTD.txt A00560_EndorsementLength_YTD.txt A00570_InsuranceOption_YTD.txt A00580_RateMethod_YTD.txt A00590_SpoiGroup_YTD.txt A00615_Draw_YTD.txt A00810_Price_YTD.txt A01000_AgrRate_YTD.txt A01010_BaseRate_YTD.txt A01020_Beta_YTD.txt A01030_ComboRevenueFactor_YTD.txt A01040_CoverageLevelDifferential_YTD.txt A01050_SubCountyRate_YTD.txt A01060_OptionRate_YTD.txt A01070_Proration_YTD.txt A01090_UnitDiscount_YTD.txt A01100_YieldAndTyield_YTD.txt A01105_YieldExclusion_YTD.txt A01110_HistoricalRevenueCapping_YTD.txt A01115_HistoricalYieldTrend_YTD.txt A01120_AreaDataSource_YTD.txt A01125_ProductionArea_YTD.txt A01130_AreaCoverageLevel_YTD.txt A01135_AreaRate_YTD.txt A01200_DocumentBuilder_YTD.txt A01210_Statement_YTD.txt A01220_GuaranteeAdjustment_YTD.txt | 1,274 1,631,124 4,512,876 531 507 1,637,994 406 26 130 365 3,191 90 26 12 51 3 3 1,170 50 6 559 21 1 49 4 106 10,471,900 3,547,693 11,104,800 794,488 121,500 2,867,130 13,739,639 209,778 5,373,067 2,738,868 3,000 12,206,787 665,343 156,114 816,738 133 179,280 15,474,071 11,580,750 13,537,198 1,308 979,198 |
| 2020_ADM_Daily_210429.zip | A00810_Price_Daily.txt A01130_AreaCoverageLevel_Daily.txt | 18,447 125,706 |
| 2020_ADM_Filing_0831.zip | A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01000_AgrRate_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01070_Proration_Filing.txt A01100_YieldAndTyield_Filing.txt A01105_YieldExclusion_Filing.txt A01130_AreaCoverageLevel_Filing.txt A01200_DocumentBuilder_Filing.txt A01220_GuaranteeAdjustment_Filing.txt | 255,616 3,817,935 259,270 1,947,818 11,331,024 24,770 1,400,326 3,273 158,270 384 2,216,220 14,169 9,641,763 1,209,788 132 |
| 2020_ADM_Filing_1031.zip | A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01100_YieldAndTyield_Filing.txt A01105_YieldExclusion_Filing.txt A01130_AreaCoverageLevel_Filing.txt A01200_DocumentBuilder_Filing.txt | 7,806 5,433 7,806 7,149 4,602 57,108 60 17,268 80,949 1,425 19,668 37,632 |
| 2020_ADM_YTD.zip | A00010_AdmLayout_YTD.txt A00030_InsuranceOffer_YTD.txt A00045_Map_YTD.txt A00050_Quality_YTD.txt A00070_SubsidyPercent_YTD.txt A00200_Date_YTD.txt A00400_AgrCommodity_YTD.txt A00410_Class_YTD.txt A00420_Commodity_YTD.txt A00430_CommodityType_YTD.txt A00440_County_YTD.txt A00450_CroppingPractice_YTD.txt A00460_InsurancePlan_YTD.txt A00470_IntendedUse_YTD.txt A00480_Interval_YTD.txt A00490_IrrigationPractice_YTD.txt A00500_OrganicPractice_YTD.txt A00510_Practice_YTD.txt A00520_State_YTD.txt A00530_SubClass_YTD.txt A00540_Type_YTD.txt A00550_DocumentStructure_YTD.txt A00560_EndorsementLength_YTD.txt A00570_InsuranceOption_YTD.txt A00580_RateMethod_YTD.txt A00590_SpoiGroup_YTD.txt A00615_Draw_YTD.txt A00810_Price_YTD.txt A01000_AgrRate_YTD.txt A01010_BaseRate_YTD.txt A01020_Beta_YTD.txt A01030_ComboRevenueFactor_YTD.txt A01040_CoverageLevelDifferential_YTD.txt A01050_SubCountyRate_YTD.txt A01060_OptionRate_YTD.txt A01070_Proration_YTD.txt A01090_UnitDiscount_YTD.txt A01100_YieldAndTyield_YTD.txt A01105_YieldExclusion_YTD.txt A01110_HistoricalRevenueCapping_YTD.txt A01115_HistoricalYieldTrend_YTD.txt A01120_AreaDataSource_YTD.txt A01125_ProductionArea_YTD.txt A01130_AreaCoverageLevel_YTD.txt A01135_AreaRate_YTD.txt A01140_HipRate_YTD.txt A01200_DocumentBuilder_YTD.txt A01210_Statement_YTD.txt A01220_GuaranteeAdjustment_YTD.txt A01230_ContiguousCounty_YTD.txt | 1,311 1,825,334 4,524,603 555 906 1,835,894 412 28 135 376 3,191 94 27 14 54 3 3 1,212 50 6 583 21 1 57 4 106 4,481,700 3,693,114 11,331,024 862,976 121,500 2,867,130 14,515,000 217,929 5,725,732 2,747,436 4,181 13,335,105 693,135 154,860 636,463 96 179,727 15,545,369 11,959,714 5,645 14,197,790 1,368 1,000,756 15,958 |
| 2021_ADM_Daily_210429.zip | A00810_Price_Daily.txt | 780 |
| 2021_ADM_Filing_0630.zip | A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01100_YieldAndTyield_Filing.txt A01105_YieldExclusion_Filing.txt A01110_HistoricalRevenueCapping_Filing.txt A01130_AreaCoverageLevel_Filing.txt A01200_DocumentBuilder_Filing.txt A01220_GuaranteeAdjustment_Filing.txt | 198,279 40,413 204,642 196,152 91,290 1,671,079 26,397 886,087 2,013,300 146,712 17,604 811,338 1,255,684 125,439 |
| 2021_ADM_Filing_1130.zip | A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01100_YieldAndTyield_Filing.txt A01105_YieldExclusion_Filing.txt A01110_HistoricalRevenueCapping_Filing.txt A01130_AreaCoverageLevel_Filing.txt A01200_DocumentBuilder_Filing.txt A01220_GuaranteeAdjustment_Filing.txt | 1,458,518 232,822 1,458,629 1,523,489 500,180 10,345,301 186,209 5,301,476 9,744,050 553,923 137,226 5,145,030 7,297,385 878,440 |
| 2021_ADM_YTD.zip | A00010_AdmLayout_YTD.txt A00030_InsuranceOffer_YTD.txt A00045_Map_YTD.txt A00050_Quality_YTD.txt A00070_SubsidyPercent_YTD.txt A00200_Date_YTD.txt A00400_AgrCommodity_YTD.txt A00410_Class_YTD.txt A00420_Commodity_YTD.txt A00430_CommodityType_YTD.txt A00440_County_YTD.txt A00450_CroppingPractice_YTD.txt A00460_InsurancePlan_YTD.txt A00470_IntendedUse_YTD.txt A00480_Interval_YTD.txt A00490_IrrigationPractice_YTD.txt A00500_OrganicPractice_YTD.txt A00510_Practice_YTD.txt A00520_State_YTD.txt A00530_SubClass_YTD.txt A00540_Type_YTD.txt A00550_DocumentStructure_YTD.txt A00560_EndorsementLength_YTD.txt A00570_InsuranceOption_YTD.txt A00580_RateMethod_YTD.txt A00590_SpoiGroup_YTD.txt A00615_Draw_YTD.txt A00810_Price_YTD.txt A01000_AgrRate_YTD.txt A01010_BaseRate_YTD.txt A01020_Beta_YTD.txt A01030_ComboRevenueFactor_YTD.txt A01040_CoverageLevelDifferential_YTD.txt A01050_SubCountyRate_YTD.txt A01060_OptionRate_YTD.txt A01070_Proration_YTD.txt A01090_UnitDiscount_YTD.txt A01100_YieldAndTyield_YTD.txt A01105_YieldExclusion_YTD.txt A01110_HistoricalRevenueCapping_YTD.txt A01115_HistoricalYieldTrend_YTD.txt A01120_AreaDataSource_YTD.txt A01125_ProductionArea_YTD.txt A01130_AreaCoverageLevel_YTD.txt A01135_AreaRate_YTD.txt A01140_HipRate_YTD.txt A01200_DocumentBuilder_YTD.txt A01210_Statement_YTD.txt A01220_GuaranteeAdjustment_YTD.txt A01230_ContiguousCounty_YTD.txt | 1,337 2,304,740 4,532,865 563 1,041 2,311,214 416 29 139 383 3,191 93 33 14 77 3 3 1,345 50 6 599 22 1 60 4 148 1,086,600 4,159,266 11,365,296 891,159 121,500 2,927,070 15,768,062 226,778 7,292,666 2,752,536 3,226 14,805,527 722,973 154,830 678,844 96 180,843 16,563,749 15,336,416 5,906 15,038,185 1,423 1,006,108 15,958 |
| 2022_ADM_Daily_210429.zip | A00010_AdmLayout_Daily.txt A00030_InsuranceOffer_Daily.txt A00070_SubsidyPercent_Daily.txt A00200_Date_Daily.txt A00420_Commodity_Daily.txt A00430_CommodityType_Daily.txt A00460_InsurancePlan_Daily.txt A00480_Interval_Daily.txt A00510_Practice_Daily.txt A00540_Type_Daily.txt A01040_CoverageLevelDifferential_Daily.txt A01200_DocumentBuilder_Daily.txt A01210_Statement_Daily.txt | 1 3,584 52 3,584 3 7 2 32 44 8 3,200 15,296 11 |
| 2022_ADM_Filing_0430.zip | A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01070_Proration_Filing.txt A01100_YieldAndTyield_Filing.txt A01130_AreaCoverageLevel_Filing.txt A01200_DocumentBuilder_Filing.txt A01220_GuaranteeAdjustment_Filing.txt | 58,749 429,521 58,749 267,584 19,019 258,631 4,173 72,198 5,100 13,671 934,250 499,002 123 |
| 022_ADM_YTD.zip | A00010_AdmLayout_YTD.txt A00030_InsuranceOffer_YTD.txt A00045_Map_YTD.txt A00070_SubsidyPercent_YTD.txt A00200_Date_YTD.txt A00410_Class_YTD.txt A00420_Commodity_YTD.txt A00430_CommodityType_YTD.txt A00440_County_YTD.txt A00450_CroppingPractice_YTD.txt A00460_InsurancePlan_YTD.txt A00470_IntendedUse_YTD.txt A00480_Interval_YTD.txt A00490_IrrigationPractice_YTD.txt A00500_OrganicPractice_YTD.txt A00510_Practice_YTD.txt A00520_State_YTD.txt A00530_SubClass_YTD.txt A00540_Type_YTD.txt A00550_DocumentStructure_YTD.txt A00560_EndorsementLength_YTD.txt A00570_InsuranceOption_YTD.txt A00580_RateMethod_YTD.txt A00590_SpoiGroup_YTD.txt A00810_Price_YTD.txt A01010_BaseRate_YTD.txt A01020_Beta_YTD.txt A01030_ComboRevenueFactor_YTD.txt A01040_CoverageLevelDifferential_YTD.txt A01050_SubCountyRate_YTD.txt A01060_OptionRate_YTD.txt A01070_Proration_YTD.txt A01090_UnitDiscount_YTD.txt A01100_YieldAndTyield_YTD.txt A01130_AreaCoverageLevel_YTD.txt A01135_AreaRate_YTD.txt A01140_HipRate_YTD.txt A01200_DocumentBuilder_YTD.txt A01210_Statement_YTD.txt A01220_GuaranteeAdjustment_YTD.txt A01230_ContiguousCounty_YTD.txt | 1,302 58,749 429,521 201 58,749 7 20 38 3,191 30 12 2 71 3 3 258 50 1 55 12 1 14 2 3 267,584 19,019 1,000 19,980 258,631 4,173 72,198 5,100 39 13,671 934,250 443,952 193 499,002 190 123 7,224 |
| 2022_SPOI_0430.zip | 2022 Special Provisions 04/30 Filing Date | 1,975 |