USDA Image
TO:
All Insurance Providers
Chris Aulbur
/s/ Chris Aulbur
FROM:
Chief, Actuarial Branch
SUBJECT:
Actuarial Release 12-040 - Actuarial Information Available
As of December 20, 2012 the following information is now available on the FTP site:
•
2013 Actuarial Data Master for the 4/30, 11/30 Filing Date, YTD, and Daily Files.
•
2013 Special Provisions for the 11/30 Filing Date.
Users can find this information in the following directories:
•
2013 Actuarial Data Master are in the References/Actuarial_Data_Master/2013 directory.
•
2013 Special Provisions are in the Special_Provisions/2013 directory.
Additional notes and details regarding this data release:
2013 Downed Rice ADM updates are now released for ADM Layout, ADM Insurance Option, ADM Option Rates, and ADM Price for 11/30 filing.
2013 Specialty Canola (MN, MT, and ND) SPOIs are revised for a word change via revised ADM Statement code 01442.
Adding “CP” option to option rate as well as “CP” price flag & maximum contract price factor to both specialty corn and canola ADM records, 11/30 filing.
2013 Peanuts maximum contract price factor of 1.20 and zero volatility set on blue corn specialty type for Corn insurance plans 02/03, ADM Price, 11/30 filing.
2013 Texas Cotton t-yields updated for Jones, Lubbock, and Scurry counties.
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
     
2013_ADM_Daily_121220.zip
A00010_AdmLayout_Daily.txt
16
 
A00070_SubsidyPercent_Daily.txt
24
 
A00570_InsuranceOption_Daily.txt
1
 
A00810_Price_Daily.txt
20,193
 
A01060_OptionRate_Daily.txt
14,679
 
A01100_YieldAndTyield_Daily.txt
324
 
A01210_Statement_Daily.txt
1
     
     
2013_ADM_Filing_0430.zip
A00010_AdmLayout_Filing.txt
985
 
A00030_InsuranceOffer_Filing.txt
4,922
 
A00045_Map_Filing.txt
603
 
A00070_SubsidyPercent_Filing.txt
81
 
A00200_Date_Filing.txt
4,922
 
A00410_Class_Filing.txt
4
 
A00420_Commodity_Filing.txt
15
 
A00430_CommodityType_Filing.txt
20
 
A00440_County_Filing.txt
224
 
A00450_CroppingPractice_Filing.txt
18
 
A00460_InsurancePlan_Filing.txt
5
 
A00470_IntendedUse_Filing.txt
2
 
A00480_Interval_Filing.txt
25
 
A00490_IrrigationPractice_Filing.txt
2
 
A00500_OrganicPractice_Filing.txt
3
 
A00510_Practice_Filing.txt
124
 
A00520_State_Filing.txt
48
 
A00530_SubClass_Filing.txt
1
 
A00540_Type_Filing.txt
31
 
A00550_DocumentStructure_Filing.txt
11
 
A00560_EndorsementLength_Filing.txt
1
 
A00570_InsuranceOption_Filing.txt
8
 
A00580_RateMethod_Filing.txt
1
 
A00810_Price_Filing.txt
1,740
 
A01010_BaseRate_Filing.txt
1,740
 
A01040_CoverageLevelDifferential_Filing.txt
12,159
 
A01050_SubCountyRate_Filing.txt
603
 
A01060_OptionRate_Filing.txt
2,883
 
A01090_UnitDiscount_Filing.txt
1
 
A01100_YieldAndTyield_Filing.txt
2,628
 
A01200_DocumentBuilder_Filing.txt
35,584
 
A01210_Statement_Filing.txt
128
     
     
2013_ADM_Filing_1130.zip
A00030_InsuranceOffer_Filing.txt
378,722
 
A00045_Map_Filing.txt
217,100
 
A00050_Quality_Filing.txt
444
 
A00070_SubsidyPercent_Filing.txt
24
 
A00200_Date_Filing.txt
379,346
 
A00410_Class_Filing.txt
14
 
A00420_Commodity_Filing.txt
47
 
A00430_CommodityType_Filing.txt
124
 
A00440_County_Filing.txt
2,807
 
A00450_CroppingPractice_Filing.txt
31
 
A00460_InsurancePlan_Filing.txt
10
 
A00470_IntendedUse_Filing.txt
7
 
A00480_Interval_Filing.txt
1
 
A00490_IrrigationPractice_Filing.txt
3
 
A00500_OrganicPractice_Filing.txt
3
 
A00510_Practice_Filing.txt
482
 
A00520_State_Filing.txt
49
 
A00530_SubClass_Filing.txt
2
 
A00540_Type_Filing.txt
182
 
A00550_DocumentStructure_Filing.txt
17
 
A00560_EndorsementLength_Filing.txt
1
 
A00570_InsuranceOption_Filing.txt
1
 
A00580_RateMethod_Filing.txt
2
 
A00590_SpoiGroup_Filing.txt
46
 
A00810_Price_Filing.txt
196,214
 
A01005_AreaRiskRate_Filing.txt
1,007,724
 
A01010_BaseRate_Filing.txt
369,155
 
A01020_Beta_Filing.txt
90,500
 
A01030_ComboRevenueFactor_Filing.txt
2,007,990
 
A01040_CoverageLevelDifferential_Filing.txt
3,919,387
 
A01050_SubCountyRate_Filing.txt
133,390
 
A01060_OptionRate_Filing.txt
1,769,273
 
A01090_UnitDiscount_Filing.txt
1,274
 
A01100_YieldAndTyield_Filing.txt
5,058,192
 
A01110_HistoricalRevenueCapping_Filing.txt
139,848
 
A01200_DocumentBuilder_Filing.txt
4,858,164
 
A01210_Statement_Filing.txt
1
     
     
2013_ADM_YTD.zip
A00010_AdmLayout_YTD.txt
985
 
A00030_InsuranceOffer_YTD.txt
552,635
 
A00045_Map_YTD.txt
1,580,728
 
A00050_Quality_YTD.txt
514
 
A00070_SubsidyPercent_YTD.txt
337
 
A00200_Date_YTD.txt
559,313
 
A00400_AgrCommodity_YTD.txt
399
 
A00410_Class_YTD.txt
25
 
A00420_Commodity_YTD.txt
117
 
A00430_CommodityType_YTD.txt
319
 
A00440_County_YTD.txt
3,187
 
A00450_CroppingPractice_YTD.txt
67
 
A00460_InsurancePlan_YTD.txt
20
 
A00470_IntendedUse_YTD.txt
12
 
A00480_Interval_YTD.txt
44
 
A00490_IrrigationPractice_YTD.txt
3
 
A00500_OrganicPractice_YTD.txt
3
 
A00510_Practice_YTD.txt
952
 
A00520_State_YTD.txt
50
 
A00530_SubClass_YTD.txt
4
 
A00540_Type_YTD.txt
474
 
A00550_DocumentStructure_YTD.txt
19
 
A00560_EndorsementLength_YTD.txt
1
 
A00570_InsuranceOption_YTD.txt
1
 
A00580_RateMethod_YTD.txt
4
 
A00590_SpoiGroup_YTD.txt
46
 
A00810_Price_YTD.txt
355,839
 
A01000_AgrRate_YTD.txt
1,136,742
 
A01005_AreaRiskRate_YTD.txt
7,788,057
 
A01010_BaseRate_YTD.txt
477,910
 
A01020_Beta_YTD.txt
121,500
 
A01030_ComboRevenueFactor_YTD.txt
2,637,360
 
A01040_CoverageLevelDifferential_YTD.txt
5,214,839
 
A01050_SubCountyRate_YTD.txt
166,807
 
A01060_OptionRate_YTD.txt
2,131,403
 
A01070_Proration_YTD.txt
600
 
A01090_UnitDiscount_YTD.txt
4,971
 
A01100_YieldAndTyield_YTD.txt
8,040,987
 
A01110_HistoricalRevenueCapping_YTD.txt
157,020
 
A01200_DocumentBuilder_YTD.txt
6,067,118
 
A01210_Statement_YTD.txt
1
     
     
2013_SPOI_1130.zip
2013 Special Provisions 11/30 Filing Date
15,861
     
 
RMA Image