USDA Image
TO:
All Insurance Providers
Chris Aulbur
/s/ Chris Aulbur
FROM:
Chief, Actuarial Branch
SUBJECT:
Actuarial Release 13-024 - Actuarial Information Available
As of July 02, 2013 the following information is now available on the FTP site:
•
2013 Actuarial Data Master for the 6/30, 11/30 Filing Date, YTD, and Daily Files.
•
2014 Actuarial Data Master for the 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 ADM Price updated for the harvest price announcement, PM-13-033, 6/30 and 11/30 filings.
2014 ADM Option Rate (A01060) CP option code added for alfalfa seed (for consistent processing of contract pricing where both contract price and RMA price election is available), certified organic barley in county 35-037 (previously missing), and certified organic oats in 48-031 (previously missing); 6/30 filing.
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_130702.zip
A00810_Price_Daily.txt
19,480
     
     
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_Filing_1130.zip
A00030_InsuranceOffer_Filing.txt
378,722
 
A00045_Map_Filing.txt
217,100
 
A00050_Quality_Filing.txt
444
 
A00070_SubsidyPercent_Filing.txt
72
 
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
418,124
 
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
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_130702.zip
A01060_OptionRate_Daily.txt
211
     
     
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
15,135
 
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
986
 
A00030_InsuranceOffer_YTD.txt
100,087
 
A00045_Map_YTD.txt
126,821
 
A00050_Quality_YTD.txt
210
 
A00070_SubsidyPercent_YTD.txt
209
 
A00200_Date_YTD.txt
106,021
 
A00410_Class_YTD.txt
12
 
A00420_Commodity_YTD.txt
32
 
A00430_CommodityType_YTD.txt
66
 
A00440_County_YTD.txt
3,166
 
A00450_CroppingPractice_YTD.txt
29
 
A00460_InsurancePlan_YTD.txt
13
 
A00470_IntendedUse_YTD.txt
4
 
A00480_Interval_YTD.txt
39
 
A00490_IrrigationPractice_YTD.txt
3
 
A00500_OrganicPractice_YTD.txt
3
 
A00510_Practice_YTD.txt
273
 
A00520_State_YTD.txt
50
 
A00530_SubClass_YTD.txt
2
 
A00540_Type_YTD.txt
101
 
A00550_DocumentStructure_YTD.txt
17
 
A00560_EndorsementLength_YTD.txt
1
 
A00570_InsuranceOption_YTD.txt
24
 
A00580_RateMethod_YTD.txt
4
 
A00590_SpoiGroup_YTD.txt
15
 
A00810_Price_YTD.txt
26,916
 
A01005_AreaRiskRate_YTD.txt
1,357,772
 
A01010_BaseRate_YTD.txt
78,663
 
A01020_Beta_YTD.txt
37,500
 
A01030_ComboRevenueFactor_YTD.txt
769,230
 
A01040_CoverageLevelDifferential_YTD.txt
804,639
 
A01050_SubCountyRate_YTD.txt
24,078
 
A01060_OptionRate_YTD.txt
329,239
 
A01090_UnitDiscount_YTD.txt
395
 
A01100_YieldAndTyield_YTD.txt
1,133,535
 
A01110_HistoricalRevenueCapping_YTD.txt
17,046
 
A01200_DocumentBuilder_YTD.txt
1,041,235
 
A01210_Statement_YTD.txt
355
     
 
RMA Image