USDA Image
TO:
All Insurance Providers
Zachary White
/s/ Zachary White
FROM:
Chief, Actuarial Branch
SUBJECT:
Actuarial Release 16-049 - Actuarial Information Available
As of December 22, 2016 the following information is now available on the FTP site:
•
2016 Actuarial Data Master for the 8/31 Filing Date, YTD, and Daily Files.
•
2017 Actuarial Data Master for the 4/30, 8/31, 11/30 Filing Date, YTD, and Daily Files.
Users can find this information in the following directories:
•
2016 Actuarial Data Master are in the References/Actuarial_Data_Master/2016 directory.
•
2017 Actuarial Data Master are in the References/Actuarial_Data_Master/2017 directory.
Additional notes and details regarding this data release:
2016 ADM Area Risk Rate updated final indices on intervals with an ending month of October for PRF/Apiculture; and 2017 Annual Forage [ADM Price & Area Coverage Level] respectively, reference PM-16-065.
2017 ADM Price records updated to repopulate the Expected Index Values (1.00) at the sub county/grid level as previously done at the county level on Annual Forage, PRF, and Apiculture, 4/30 & 8/31 filings.
2017 ADM updates completed on the 11/30 filing for SCO on Silage Sorghum, Hybrid Corn Seed, Hybrid Seed Rice, Hybrid Sorghum Seed, SCO/ARPI Popcorn and SCO/ARPI Corn for silage conversion factors applied, SCO added to expansion counties for Dry Peas, Potatoes, MI (26-041) SCO Dry Beans populated rate where price volatility is zero and county yield added for Hybrid Corn Seed expansion counties (Plan 55).
2017 ADM Layout (A00010) revised for the Price record to make CrushDistrictNumber part of the business key as well as 2 changes for the upcoming filings (1/31 & 2/28).
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
https://www.rma.usda.gov/bulletins/actuarial/.
 
File Name
Contains
Record Count
   
2016_ADM_Daily_161222.zip
A01005_AreaRiskRate_Daily.txt
707,295
   
   
2016_ADM_Filing_0831.zip
A00030_InsuranceOffer_Filing.txt
168,244
 
A00045_Map_Filing.txt
1,590,039
 
A00200_Date_Filing.txt
168,244
 
A00810_Price_Filing.txt
341,100
 
A01000_AgrRate_Filing.txt
9,263,808
 
A01005_AreaRiskRate_Filing.txt
7,142,467
 
A01010_BaseRate_Filing.txt
19,247
 
A01040_CoverageLevelDifferential_Filing.txt
971,310
 
A01050_SubCountyRate_Filing.txt
3,432
 
A01060_OptionRate_Filing.txt
85,388
 
A01070_Proration_Filing.txt
384
 
A01100_YieldAndTyield_Filing.txt
2,252,082
 
A01105_YieldExclusion_Filing.txt
11,238
 
A01200_DocumentBuilder_Filing.txt
918,792
   
   
2016_ADM_YTD.zip
A00010_AdmLayout_YTD.txt
1,072
 
A00030_InsuranceOffer_YTD.txt
1,474,169
 
A00045_Map_YTD.txt
1,954,672
 
A00050_Quality_YTD.txt
538
 
A00070_SubsidyPercent_YTD.txt
480
 
A00200_Date_YTD.txt
1,480,826
 
A00400_AgrCommodity_YTD.txt
400
 
A00410_Class_YTD.txt
24
 
A00420_Commodity_YTD.txt
131
 
A00430_CommodityType_YTD.txt
360
 
A00440_County_YTD.txt
3,190
 
A00450_CroppingPractice_YTD.txt
77
 
A00460_InsurancePlan_YTD.txt
25
 
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,072
 
A00520_State_YTD.txt
50
 
A00530_SubClass_YTD.txt
6
 
A00540_Type_YTD.txt
547
 
A00550_DocumentStructure_YTD.txt
20
 
A00560_EndorsementLength_YTD.txt
1
 
A00570_InsuranceOption_YTD.txt
46
 
A00580_RateMethod_YTD.txt
4
 
A00590_SpoiGroup_YTD.txt
92
 
A00615_Draw_YTD.txt
74,100
 
A00810_Price_YTD.txt
1,511,463
 
A01000_AgrRate_YTD.txt
9,263,808
 
A01005_AreaRiskRate_YTD.txt
87,253,282
 
A01010_BaseRate_YTD.txt
755,783
 
A01020_Beta_YTD.txt
121,500
 
A01030_ComboRevenueFactor_YTD.txt
2,827,170
 
A01040_CoverageLevelDifferential_YTD.txt
12,312,223
 
A01050_SubCountyRate_YTD.txt
177,454
 
A01060_OptionRate_YTD.txt
4,543,545
 
A01070_Proration_YTD.txt
2,739,624
 
A01090_UnitDiscount_YTD.txt
2,801
 
A01100_YieldAndTyield_YTD.txt
10,558,009
 
A01105_YieldExclusion_YTD.txt
599,718
 
A01110_HistoricalRevenueCapping_YTD.txt
156,480
 
A01115_HistoricalYieldTrend_YTD.txt
23,482
 
A01200_DocumentBuilder_YTD.txt
17,395,677
 
A01210_Statement_YTD.txt
22,016
   
   
2017_ADM_Daily_161222.zip
A00010_AdmLayout_Daily.txt
11
 
A00030_InsuranceOffer_Daily.txt
14,995
 
A00810_Price_Daily.txt
1,650,090
 
A01010_BaseRate_Daily.txt
24
 
A01040_CoverageLevelDifferential_Daily.txt
654
 
A01115_HistoricalYieldTrend_Daily.txt
58,136
 
A01120_AreaDataSource_Daily.txt
10
 
A01125_ProductionArea_Daily.txt
1,662
 
A01130_AreaCoverageLevel_Daily.txt
106,670
 
A01135_AreaRate_Daily.txt
217,962
   
   
2017_ADM_Filing_0430.zip
A00030_InsuranceOffer_Filing.txt
15,286
 
A00045_Map_Filing.txt
107,955
 
A00200_Date_Filing.txt
15,286
 
A00810_Price_Filing.txt
120,369
 
A01010_BaseRate_Filing.txt
1,911
 
A01040_CoverageLevelDifferential_Filing.txt
58,632
 
A01050_SubCountyRate_Filing.txt
603
 
A01060_OptionRate_Filing.txt
3,539
 
A01100_YieldAndTyield_Filing.txt
6,384
 
A01130_AreaCoverageLevel_Filing.txt
475,416
 
A01200_DocumentBuilder_Filing.txt
102,644
   
   
2017_ADM_Filing_0831.zip
A00030_InsuranceOffer_Filing.txt
165,814
 
A00045_Map_Filing.txt
1,590,961
 
A00200_Date_Filing.txt
165,814
 
A00810_Price_Filing.txt
1,547,281
 
A01000_AgrRate_Filing.txt
9,898,224
 
A01010_BaseRate_Filing.txt
19,322
 
A01040_CoverageLevelDifferential_Filing.txt
956,778
 
A01050_SubCountyRate_Filing.txt
3,432
 
A01060_OptionRate_Filing.txt
85,864
 
A01070_Proration_Filing.txt
384
 
A01100_YieldAndTyield_Filing.txt
2,380,332
 
A01105_YieldExclusion_Filing.txt
11,685
 
A01130_AreaCoverageLevel_Filing.txt
7,127,437
 
A01200_DocumentBuilder_Filing.txt
648,214
   
   
2017_ADM_Filing_1130.zip
A00030_InsuranceOffer_Filing.txt
882,721
 
A00045_Map_Filing.txt
223,049
 
A00200_Date_Filing.txt
883,372
 
A00810_Price_Filing.txt
755,697
 
A01010_BaseRate_Filing.txt
417,171
 
A01040_CoverageLevelDifferential_Filing.txt
8,396,664
 
A01050_SubCountyRate_Filing.txt
164,404
 
A01060_OptionRate_Filing.txt
3,221,238
 
A01100_YieldAndTyield_Filing.txt
7,157,968
 
A01105_YieldExclusion_Filing.txt
473,925
 
A01110_HistoricalRevenueCapping_Filing.txt
138,588
 
A01130_AreaCoverageLevel_Filing.txt
3,968,210
 
A01200_DocumentBuilder_Filing.txt
6,552,227
   
   
2017_ADM_YTD.zip
A00010_AdmLayout_YTD.txt
1,117
 
A00030_InsuranceOffer_YTD.txt
1,243,991
 
A00045_Map_YTD.txt
1,967,889
 
A00050_Quality_YTD.txt
510
 
A00070_SubsidyPercent_YTD.txt
479
 
A00200_Date_YTD.txt
1,250,495
 
A00400_AgrCommodity_YTD.txt
431
 
A00410_Class_YTD.txt
24
 
A00420_Commodity_YTD.txt
114
 
A00430_CommodityType_YTD.txt
339
 
A00440_County_YTD.txt
3,190
 
A00450_CroppingPractice_YTD.txt
75
 
A00460_InsurancePlan_YTD.txt
25
 
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,014
 
A00520_State_YTD.txt
50
 
A00530_SubClass_YTD.txt
6
 
A00540_Type_YTD.txt
504
 
A00550_DocumentStructure_YTD.txt
20
 
A00560_EndorsementLength_YTD.txt
1
 
A00570_InsuranceOption_YTD.txt
43
 
A00580_RateMethod_YTD.txt
4
 
A00590_SpoiGroup_YTD.txt
95
 
A00615_Draw_YTD.txt
29,500
 
A00810_Price_YTD.txt
2,598,159
 
A01000_AgrRate_YTD.txt
9,898,224
 
A01010_BaseRate_YTD.txt
527,087
 
A01020_Beta_YTD.txt
121,500
 
A01030_ComboRevenueFactor_YTD.txt
2,857,140
 
A01040_CoverageLevelDifferential_YTD.txt
10,960,193
 
A01050_SubCountyRate_YTD.txt
194,071
 
A01060_OptionRate_YTD.txt
3,923,276
 
A01070_Proration_YTD.txt
384
 
A01090_UnitDiscount_YTD.txt
2,897
 
A01100_YieldAndTyield_YTD.txt
11,127,004
 
A01105_YieldExclusion_YTD.txt
615,027
 
A01110_HistoricalRevenueCapping_YTD.txt
156,294
 
A01115_HistoricalYieldTrend_YTD.txt
719,702
 
A01120_AreaDataSource_YTD.txt
128
 
A01125_ProductionArea_YTD.txt
177,460
 
A01130_AreaCoverageLevel_YTD.txt
12,253,024
 
A01135_AreaRate_YTD.txt
13,887,417
 
A01200_DocumentBuilder_YTD.txt
8,466,300
 
A01210_Statement_YTD.txt
1,209
   
 
RMA Image