1.  

ACTUARIAL RELEASE: Actuarial Release–19-041

United States Department of Agriculture


Farm and Foreign Agricultural Services


Risk Management Agency


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

Date

November 27, 2019

To:

All Insurance Providers

From:

Sarah Thomas, Chief, Actuarial Branch /s/ Sarah Thomas    11/27/2019

Subject:

Actuarial Release 19-041 - Actuarial Information Available

As of November 27, 2019 the following information is now available on the FTP site:

  • 2020 Actuarial Data Master for the 6/30, 11/30, 12/31 Filing Date, YTD, and Daily Files.
  • 2020 Special Provisions for the 11/30 Filing Date.

Users can find this information in the following directories:

  • 2020 Actuarial Data Master are in the References/Actuarial_Data_Master/2020 directory.
  • 2020 Special Provisions are in the Special_Provisions/2020 directory.

Additional notes and details regarding this data release:

  • 2020 RY ADM and Special Provisions are now issued for the remaining commodities of grain sorghum (1/2/3) and soybeans (1/2/3), 11/30 filing.
  • 2020 RY ADM Price are now issued for the 11/30 and 12/31 filings as well as 6/30 dry peas.
  • 2020 RY ADM Statement, ADM Document Builder and Special Provisions are reissued for burley tobacco (90) and flue cured tobacco (90) to delete quality statements 25246 and
  • 25247 and replace with new statements 25738 and 25739 to revise section 3.i.B, 11/30 filing.
  • 2020 RY ADM Statement, ADM Document Builder, and Special Provisions are reissued for rice (1/2/3) to correct statement 25704 to reference the Rice Crop Provisions instead of
  • Basic Provisions and to replace breached levee statement 01212 with statement 25727 in East Carroll, LA (22-035) and Dyer, TN (47-045), 11/30 filing.
  • 2020 RY ADM Statement, ADM Document Builder, and Special Provisions are reissued for corn (1/2/3) in Franklin, MO to delete breached levee statement 01212, and corn (1/2/3) and cotton (1/2/3) in East Carroll, LA (22-035) and Dyer, TN (47-045) to replace breached levee statement 01212 with statement 25727, 11/30 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 https://www.rma.usda.gov/Policy-and-Procedure/Bulletins-and-Memos/Actuarial-Releases

File Name Contains Record Count
2020_ADM_Daily_191126.zip
 A00030_InsuranceOffer_Daily.txt
A00045_Map_Daily.txt
A00050_Quality_Daily.txt
A00070_SubsidyPercent_Daily.txt
A00200_Date_Daily.txt
A00590_SpoiGroup_Daily.txt
A00810_Price_Daily.txt
A01010_BaseRate_Daily.txt
A01020_Beta_Daily.txt
A01030_ComboRevenueFactor_Daily.txt
A01040_CoverageLevelDifferential_Daily.txt
A01050_SubCountyRate_Daily.txt
A01060_OptionRate_Daily.txt
A01090_UnitDiscount_Daily.txt
A01100_YieldAndTyield_Daily.txt
A01105_YieldExclusion_Daily.txt
A01110_HistoricalRevenueCapping_Daily.txt
A01200_DocumentBuilder_Daily.txt
A01210_Statement_Daily.txt
A01220_GuaranteeAdjustment_Daily.txt		 177,810
106,092
95
274
177,810
6
702,007
177,810
32,000
29,970
2,210,525
94,473
1,389,330
388
3,560,334
173,004
78,444
2,181,198
24
355,620
2020_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		 185,522
38,613
191,777
174,308
87,582
1,599,619
25,059
715,363
1,837,851
139,539
17,604
725,130
1,219,151
124,863
2020_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
 947,480
222,313
947,861
700,870
450,329
9,038,345
178,020
3,875,655
8,954,016
536,646
137,256
4,217,628
6,449,941
873,664
2020_ADM_Filing_1231.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
A01220_GuaranteeAdjustment_Filing.txt		 912
213
912
730
510
6,171
117
3,394
11,058
534
2,412
5,064
816
22020_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
A01230_ContiguousCounty_YTD.txt
 1,293
1,416,963
4,510,464
555
760
1,423,599
412
26
119
342
3,191
88
26
12
51
3
3
1,101
50
6
519
20
1
48
4
106
4,448,100
3,083,769
11,331,024
571,181
121,500
1,918,080
12,207,773
207,138
4,808,205
384
3,998
13,131,957
693,135
154,860
633,265
96
179,727
15,542,075
11,940,768
9,150,215
1,245
1,000,756
15,958
 2020_SPOI_1130.zip  2020 Special Provisions 11/30 Filing Date 16,120
USDA is an Equal Opportunity Employer and Provider