ACTUARIAL RELEASE: Actuarial Release18-041




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

Date

November 27, 2018

To:

All Insurance Providers

From:

Megan Heyns /s/ Megan Heyns    11/27/2018

Subject:

Actuarial Release 18-041 - Actuarial Information Available

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

  • 2019 Actuarial Data Master for the 6/30, 11/30, 12/31 Filing Date, YTD, and Daily Files.
  • 2019 Special Provisions for the 11/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.
  • 2019 Special Provisions are in the Special_Provisions/2019 directory.

Additional notes and details regarding this data release:

2019 Special Provisions and ADM are now issued for the remaining commodities of Corn (01/02/03), Sesame & Sugar Beets (APH), area plans (ARPI/STAX). 2019 ADM for SCO including applicable prices for 11/30 & 12/31 filings and 6/30 dry peas.

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 www.rma.usda.gov/bulletins/actuarial/.

File Name Contains Record Count 
2019_ADM_Daily_181127.zip A00030_InsuranceOffer_Daily.txt
A00045_Map_Daily.txt
A00050_Quality_Daily.txt
A00070_SubsidyPercent_Daily.txt
A00200_Date_Daily.txt
A00420_Commodity_Daily.txt
A00430_CommodityType_Daily.txt
A00460_InsurancePlan_Daily.txt
A00510_Practice_Daily.txt
A00540_Type_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
A01115_HistoricalYieldTrend_Daily.txt
A01120_AreaDataSource_Daily.txt
A01125_ProductionArea_Daily.txt
A01130_AreaCoverageLevel_Daily.txt
A01135_AreaRate_Daily.txt
A01200_DocumentBuilder_Daily.txt
A01210_Statement_Daily.txt
A01220_GuaranteeAdjustment_Daily.txt 
595,233
53,397
37
8
595,233
1
5
2
16
8
50
663,597
107,187
17,000
369,630
5,191,694
45,312
1,311,420
384
2,061,612
140,913
22,608
558,933
73
119,094
4,149,216
7,407,818
2,162,730
54
212,238
2019_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

184,025
38,038
190,244
173,708
86,145
1,582,984
24,501
635,912
1,715,274
136,737
17,688
724,710
1,149,357
122,145

2019_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
929,066
223,927
929,717
661,544
440,882
8,900,216
179,883
3,772,890
8,300,124
512,496
138,426
4,146,804
6,551,723
854,986
2019_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
894
228
894
894
492
6,045
120
3,328
10,098
522
2,412
4,869
816
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,396,101
4,511,554
504
488
1,402,971
406
26
117
340
3,191
88
26
12
51
3
3
1,112
50
6
513
20
1
45
4
106
10,350,300
3,007,642
11,104,800
559,474
121,500
2,867,130
12,048,818
208,482
4,559,113
384
2,998
12,205,131
665,343
156,114
811,692
131
178,920
15,470,777
11,576,252
9,168,613
1,222
979,198
2019_SPOI_1130.zip 2019 Special Provisions 11/30 Filing Date 16,048

Disposal Date

Until Rescinded

USDA is an Equal Opportunity Employer and Provider