USDA Image
TO:
All Insurance Providers
Chris Aulbur
/s/ Chris Aulbur
FROM:
Chief, Actuarial Branch
SUBJECT:
Actuarial Release 13-028 - Actuarial Information Available
As of August 15, 2013 the following information is now available on the FTP site:
2013 Actuarial Data Master for the 6/30 Filing Date, YTD, and Daily Files.
2014 Actuarial Data Master for the 4/30, 6/30 Filing Date, YTD, and Daily Files.
Users can find this information in the following directories:
2013 Actuarial Data Master are in the References/Actuarial_Data_Master/2013 directory.
2014 Actuarial Data Master are in the References/Actuarial_Data_Master/2014 directory.
Additional notes and details regarding this data release:
2013 Apiculture and PRF final grid indices and payment calculation factors are released on interval 629 (rainfall index/plan 13) and interval 648 (vegetation index/plan 14) via ADM Area Risk Rates (A01005), reference PM-13-039, 6/30 filing.
2014 ADM Price is updated for canola with projected price for plans 01 (includes CAT price), 02, 03 and price volatility for plans 02 and 03, reference PM-13-038, 6/30 filing.
2014 ADM Layout updated for field name on Land Description (A00040) as previously issued in PDF document on 6/28/2013 (see change history, page 63).
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
http://www.rma.usda.gov/bulletins/actuarial/.

 
File Name
Contains
Record Count
     
2013_ADM_Daily_130815.zip
A01005_AreaRiskRate_Daily.txt
798,195
     
     
2013_ADM_Filing_0630.zip
A00030_InsuranceOffer_Filing.txt
143,634
 
A00045_Map_Filing.txt
1,349,210
 
A00050_Quality_Filing.txt
207
 
A00070_SubsidyPercent_Filing.txt
157
 
A00200_Date_Filing.txt
149,688
 
A00410_Class_Filing.txt
9
 
A00420_Commodity_Filing.txt
19
 
A00430_CommodityType_Filing.txt
49
 
A00440_County_Filing.txt
2,803
 
A00450_CroppingPractice_Filing.txt
12
 
A00460_InsurancePlan_Filing.txt
10
 
A00470_IntendedUse_Filing.txt
5
 
A00480_Interval_Filing.txt
20
 
A00490_IrrigationPractice_Filing.txt
3
 
A00500_OrganicPractice_Filing.txt
3
 
A00510_Practice_Filing.txt
161
 
A00520_State_Filing.txt
45
 
A00530_SubClass_Filing.txt
2
 
A00540_Type_Filing.txt
72
 
A00550_DocumentStructure_Filing.txt
16
 
A00560_EndorsementLength_Filing.txt
1
 
A00570_InsuranceOption_Filing.txt
19
 
A00580_RateMethod_Filing.txt
4
 
A00590_SpoiGroup_Filing.txt
14
 
A00810_Price_Filing.txt
145,095
 
A01005_AreaRiskRate_Filing.txt
6,779,583
 
A01010_BaseRate_Filing.txt
77,241
 
A01020_Beta_Filing.txt
37,500
 
A01030_ComboRevenueFactor_Filing.txt
769,230
 
A01040_CoverageLevelDifferential_Filing.txt
1,038,569
 
A01050_SubCountyRate_Filing.txt
24,459
 
A01060_OptionRate_Filing.txt
305,280
 
A01090_UnitDiscount_Filing.txt
3,707
 
A01100_YieldAndTyield_Filing.txt
1,054,980
 
A01110_HistoricalRevenueCapping_Filing.txt
17,172
 
A01200_DocumentBuilder_Filing.txt
962,406
 
A01210_Statement_Filing.txt
259
     
     
2013_ADM_YTD.zip
A00010_AdmLayout_YTD.txt
985
 
A00030_InsuranceOffer_YTD.txt
781,124
 
A00045_Map_YTD.txt
1,582,024
 
A00050_Quality_YTD.txt
514
 
A00070_SubsidyPercent_YTD.txt
361
 
A00200_Date_YTD.txt
787,802
 
A00400_AgrCommodity_YTD.txt
399
 
A00410_Class_YTD.txt
25
 
A00420_Commodity_YTD.txt
132
 
A00430_CommodityType_YTD.txt
340
 
A00440_County_YTD.txt
3,187
 
A00450_CroppingPractice_YTD.txt
69
 
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
1,004
 
A00520_State_YTD.txt
50
 
A00530_SubClass_YTD.txt
4
 
A00540_Type_YTD.txt
517
 
A00550_DocumentStructure_YTD.txt
19
 
A00560_EndorsementLength_YTD.txt
1
 
A00570_InsuranceOption_YTD.txt
45
 
A00580_RateMethod_YTD.txt
4
 
A00590_SpoiGroup_YTD.txt
46
 
A00810_Price_YTD.txt
605,838
 
A01000_AgrRate_YTD.txt
1,136,742
 
A01005_AreaRiskRate_YTD.txt
7,788,111
 
A01010_BaseRate_YTD.txt
706,390
 
A01020_Beta_YTD.txt
121,500
 
A01030_ComboRevenueFactor_YTD.txt
2,637,360
 
A01040_CoverageLevelDifferential_YTD.txt
6,820,832
 
A01050_SubCountyRate_YTD.txt
168,103
 
A01060_OptionRate_YTD.txt
2,789,987
 
A01070_Proration_YTD.txt
2,739,948
 
A01090_UnitDiscount_YTD.txt
4,972
 
A01100_YieldAndTyield_YTD.txt
8,040,987
 
A01110_HistoricalRevenueCapping_YTD.txt
157,020
 
A01200_DocumentBuilder_YTD.txt
11,200,568
 
A01210_Statement_YTD.txt
1,192
     
     
2014_ADM_Daily_130815.zip
A00010_AdmLayout_Daily.txt
3
 
A00810_Price_Daily.txt
1,611
     
     
2014_ADM_Filing_0630.zip
A00030_InsuranceOffer_Filing.txt
86,037
 
A00045_Map_Filing.txt
37,542
 
A00200_Date_Filing.txt
91,971
 
A00810_Price_Filing.txt
16,290
 
A01005_AreaRiskRate_Filing.txt
965,064
 
A01010_BaseRate_Filing.txt
76,875
 
A01040_CoverageLevelDifferential_Filing.txt
751,968
 
A01050_SubCountyRate_Filing.txt
23,475
 
A01060_OptionRate_Filing.txt
326,164
 
A01100_YieldAndTyield_Filing.txt
1,130,064
 
A01110_HistoricalRevenueCapping_Filing.txt
17,046
 
A01200_DocumentBuilder_Filing.txt
959,599
     
     
2014_ADM_YTD.zip
A00010_AdmLayout_YTD.txt
987
 
A00030_InsuranceOffer_YTD.txt
180,146
 
A00045_Map_YTD.txt
1,448,200
 
A00050_Quality_YTD.txt
210
 
A00070_SubsidyPercent_YTD.txt
233
 
A00200_Date_YTD.txt
186,080
 
A00400_AgrCommodity_YTD.txt
399
 
A00410_Class_YTD.txt
15
 
A00420_Commodity_YTD.txt
69
 
A00430_CommodityType_YTD.txt
231
 
A00440_County_YTD.txt
3,188
 
A00450_CroppingPractice_YTD.txt
40
 
A00460_InsurancePlan_YTD.txt
16
 
A00470_IntendedUse_YTD.txt
9
 
A00480_Interval_YTD.txt
47
 
A00490_IrrigationPractice_YTD.txt
3
 
A00500_OrganicPractice_YTD.txt
3
 
A00510_Practice_YTD.txt
469
 
A00520_State_YTD.txt
50
 
A00530_SubClass_YTD.txt
4
 
A00540_Type_YTD.txt
320
 
A00550_DocumentStructure_YTD.txt
18
 
A00560_EndorsementLength_YTD.txt
1
 
A00570_InsuranceOption_YTD.txt
26
 
A00580_RateMethod_YTD.txt
4
 
A00590_SpoiGroup_YTD.txt
15
 
A00810_Price_YTD.txt
92,259
 
A01000_AgrRate_YTD.txt
1,135,674
 
A01005_AreaRiskRate_YTD.txt
7,907,202
 
A01010_BaseRate_YTD.txt
92,598
 
A01020_Beta_YTD.txt
37,500
 
A01030_ComboRevenueFactor_YTD.txt
779,220
 
A01040_CoverageLevelDifferential_YTD.txt
1,293,927
 
A01050_SubCountyRate_YTD.txt
30,516
 
A01060_OptionRate_YTD.txt
364,980
 
A01090_UnitDiscount_YTD.txt
396
 
A01100_YieldAndTyield_YTD.txt
2,154,048
 
A01110_HistoricalRevenueCapping_YTD.txt
17,046
 
A01200_DocumentBuilder_YTD.txt
1,369,940
 
A01210_Statement_YTD.txt
533
     

 
RMA Image