ACTUARIAL RELEASE: Actuarial Release21-027




1400 Independence Avenue, SW
Stop 0801
Washington, DC  20250-0801

Date

August 12, 2021

To:

All Insurance Providers

From:

Megan Heyns, Chief, Filing Branch /s/ Megan Heyns    8/12/2021

Subject:

Actuarial Release 21-027 - Actuarial Information Available

As of August 12, 2021 the following information is now available on the FTP site:

  • 2022 Actuarial Data Master for the 6/30, 8/31, 9/30, 10/31 Filing Date, YTD, and Daily Files.
  • 2022 Special Provisions for the 8/31, 9/30, 10/31 Filing Date.

Users can find this information in the following directories:

  • 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 RY ADM, Special Provisions, and related files are now issued for the August 31, September 30, and October 31 filings except for cherries, grapes, pistachios, APH FL citrus, API/PRF, and WFRP.
2022 RY ADM Date updated to correct TX spring wheat HIP-WI dates to match base policy dates, 6/30 filing.
2022 RY ADM Subsidy Percent updated to delete EP unit structure records.

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 https://www.rma.usda.gov/Policy-and-Procedure/Bulletins-and-Memos/Actuarial-Releases

File Name Contains Record Count
2022_ADM_Daily_210812.zip A00030_InsuranceOffer_Daily.txt
A00045_Map_Daily.txt
A00050_Quality_Daily.txt
A00070_SubsidyPercent_Daily.txt
A00200_Date_Daily.txt
A00410_Class_Daily.txt
A00420_Commodity_Daily.txt
A00430_CommodityType_Daily.txt
A00450_CroppingPractice_Daily.txt
A00460_InsurancePlan_Daily.txt
A00470_IntendedUse_Daily.txt
A00480_Interval_Daily.txt
A00510_Practice_Daily.txt
A00530_SubClass_Daily.txt
A00540_Type_Daily.txt
A00550_DocumentStructure_Daily.txt
A00570_InsuranceOption_Daily.txt
A01010_BaseRate_Daily.txt
A01040_CoverageLevelDifferential_Daily.txt
A01050_SubCountyRate_Daily.txt
A01060_OptionRate_Daily.txt
A01070_Proration_Daily.txt
A01090_UnitDiscount_Daily.txt
A01100_YieldAndTyield_Daily.txt
A01105_YieldExclusion_Daily.txt
A01115_HistoricalYieldTrend_Daily.txt
A01120_AreaDataSource_Daily.txt
A01125_ProductionArea_Daily.txt
A01130_AreaCoverageLevel_Daily.txt
A01135_AreaRate_Daily.txt
A01140_HipRate_Daily.txt
A01200_DocumentBuilder_Daily.txt
A01210_Statement_Daily.txt
A01220_GuaranteeAdjustment_Daily.txt
A01230_ContiguousCounty_Daily.txt
48,163
5,562
21
121
48,487
7
42
176
27
2
3
2
339
2
256
1
4
17,453
297,415
2,490
99,629
384
3
1,929,063
10,995
19,442
21
7,651
137,868
4,670
608
151,070
305
1,290
537
2022_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
280,969
41,883
287,464
232,605
93,393
1,862,335
27,324
992,298
2,165,877
153,405
17,664
863,940
1,309,517
129,672
2022_ADM_Filing_0831.zip A00030_InsuranceOffer_Filing.txt
A00045_Map_Filing.txt
A00200_Date_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
39,970
2,916
39,970
13,676
241,174
2,394
84,181
384
1,860,777
9,153
116,676
115,088
132
2022_ADM_Filing_0930.zip A00030_InsuranceOffer_Filing.txt
A00045_Map_Filing.txt
A00200_Date_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
A01220_GuaranteeAdjustment_Filing.txt
2,547
36
2,547
1,338
14,478
36
6,399
26,838
1,014
1,224
13,452
1,158
2022_ADM_Filing_1031.zip A00030_InsuranceOffer_Filing.txt
A00045_Map_Filing.txt
A00200_Date_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
5,646
2,610
5,646
2,439
41,763
60
9,049
41,448
828
19,968
22,530
2022_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
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
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,307
387,881
476,966
272
573
394,376
19
83
259
3,191
68
29
9
73
3
3
757
50
5
394
21
1
37
4
45
500,345
129,865
38,000
1,128,870
2,418,381
33,987
1,164,125
5,484
870
4,108,611
164,400
17,664
139,419
42
82,431
1,936,058
3,318,342
1,525
1,959,589
787
131,085
14,144
2022_SPOI_0831.zip 2022 Special Provisions 08/31 Filing Date 997
2022_SPOI_0930.zip 2022 Special Provisions 09/30 Filing Date 95
2022_SPOI_1031.zip 2022 Special Provisions 10/31 Filing Date 314
     
USDA is an Equal Opportunity Employer and Provider