USDA Image
TO:
All Insurance Providers
Chris Aulbur
/s/ Chris Aulbur
FROM:
Chief, Actuarial Branch
SUBJECT:
Actuarial Release 13-019 - Actuarial Information Available
As of May 29, 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 4/30 Filing Date, YTD, and Daily Files.
•
2014 Special Provisions for the 4/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.
•
2014 Actuarial Data Master are in the References/Actuarial_Data_Master/2014 directory.
•
2014 Special Provisions are in the Special_Provisions/2014 directory.
Additional notes and details regarding this data release:
2013 Apiculture and PRF final grid indices and payment calculation factors released on interval 626 (rainfall index/plan 13) via ADM Area Risk Rates, reference PM-13-026, 6/30 filing.
2013 ADM Price updated on Barley to null out the contract price code on plans 02/03; plan 01 in the states of AK, NE, and WY removing contract price code, max contract price, and max contract price factor; 6/30 & 11/30 filings. Special provisions do not authorize contract pricing in these instances.
2014 Fresh Market Sweet Corn in Florida counties of Palm Beach, Miami-Dade, and Suwannee counties Special Provisions and ADM are updated to remove minimum value and allowable cost statements (01300, 01301, 01302, and 01308), 4/30 filing. Resolves conflict with generic MV/AC statements referring to prices tab containing the appropriate values and makes these counties consistent with other counties.
2014 ADM Subsidy (A00070) row added for CAT on plan 13 as Annual Forage is allowed to have catastrophic coverage in selected instances, 4/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
mailto: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_130529.zip
A00810_Price_Daily.txt
21,003
 
A01005_AreaRiskRate_Daily.txt
255,900
     
     
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_130529.zip
A00070_SubsidyPercent_Daily.txt
1
 
A01200_DocumentBuilder_Daily.txt
30
 
A01210_Statement_Daily.txt
4
     
     
2014_ADM_Filing_0430.zip
A00030_InsuranceOffer_Filing.txt
14,050
 
A00045_Map_Filing.txt
89,279
 
A00200_Date_Filing.txt
14,050
 
A00810_Price_Filing.txt
11,760
 
A01005_AreaRiskRate_Filing.txt
392,708
 
A01010_BaseRate_Filing.txt
1,788
 
A01040_CoverageLevelDifferential_Filing.txt
52,671
 
A01050_SubCountyRate_Filing.txt
603
 
A01060_OptionRate_Filing.txt
3,075
 
A01100_YieldAndTyield_Filing.txt
3,471
 
A01200_DocumentBuilder_Filing.txt
81,636
     
     
2014_ADM_YTD.zip
A00010_AdmLayout_YTD.txt
986
 
A00030_InsuranceOffer_YTD.txt
14,050
 
A00045_Map_YTD.txt
89,279
 
A00070_SubsidyPercent_YTD.txt
87
 
A00200_Date_YTD.txt
14,050
 
A00410_Class_YTD.txt
4
 
A00420_Commodity_YTD.txt
16
 
A00430_CommodityType_YTD.txt
20
 
A00440_County_YTD.txt
3,161
 
A00450_CroppingPractice_YTD.txt
23
 
A00460_InsurancePlan_YTD.txt
6
 
A00470_IntendedUse_YTD.txt
2
 
A00480_Interval_YTD.txt
39
 
A00490_IrrigationPractice_YTD.txt
2
 
A00500_OrganicPractice_YTD.txt
3
 
A00510_Practice_YTD.txt
147
 
A00520_State_YTD.txt
49
 
A00530_SubClass_YTD.txt
1
 
A00540_Type_YTD.txt
32
 
A00550_DocumentStructure_YTD.txt
11
 
A00560_EndorsementLength_YTD.txt
1
 
A00570_InsuranceOption_YTD.txt
8
 
A00580_RateMethod_YTD.txt
1
 
A00810_Price_YTD.txt
11,760
 
A01005_AreaRiskRate_YTD.txt
392,708
 
A01010_BaseRate_YTD.txt
1,788
 
A01040_CoverageLevelDifferential_YTD.txt
52,671
 
A01050_SubCountyRate_YTD.txt
603
 
A01060_OptionRate_YTD.txt
3,075
 
A01090_UnitDiscount_YTD.txt
1
 
A01100_YieldAndTyield_YTD.txt
3,471
 
A01200_DocumentBuilder_YTD.txt
81,636
 
A01210_Statement_YTD.txt
126
     
     
2014_SPOI_0430.zip
2014 Special Provisions 04/30 Filing Date
1,106
     
RMA Image