Date
To
All Insurance Providers
From
Zachary White, Chief, Actuarial Branch /s/ Zachary White
Subject
Actuarial Release 17-041 - Actuarial Information Available
As of December 11, 2017 the following information is now available on the FTP site:
- 2017 Actuarial Data Master for the 11/30 Filing Date, YTD, and Daily Files.
- 2018 Actuarial Data Master for the 11/30 Filing Date, YTD, and Daily Files.
Users can find this information in the following directories:
- 2017 Actuarial Data Master are in the References/Actuarial_Data_Master/2017 directory.
- 2018 Actuarial Data Master are in the References/Actuarial_Data_Master/2018 directory.
Additional notes and details regarding this data release:
2017 & 2018 ADM Insurance Offer for Hybrid Sorghum Seed (0050/55) updated 'Program Type Code' to be 'R' as this commodity/plan is regulatory, 11/30 filing.
2018 ADM Base Rate county yield updated for private product (Section 508(h)) Hybrid Seed Rice (0080/55) as determined by the ADM Female only factor (1.34) established in the Insurance Standards Handbook.
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 Actuarial Bulletins.
File Name | Contains | Record Count |
|---|---|---|
2017_ADM_Daily_171211.zip | A00030_InsuranceOffer_Daily.txt | 360 |
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 | 959,170 | |
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,984,890 | |
A01200_DocumentBuilder_Filing.txt | 6,552,308 | |
2017_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,117 |
A00030_InsuranceOffer_YTD.txt | 1,478,981 | |
A00045_Map_YTD.txt | 3,298,356 | |
A00050_Quality_YTD.txt | 510 | |
A00070_SubsidyPercent_YTD.txt | 498 | |
A00200_Date_YTD.txt | 1,485,485 | |
A00400_AgrCommodity_YTD.txt | 431 | |
A00410_Class_YTD.txt | 24 | |
A00420_Commodity_YTD.txt | 127 | |
A00430_CommodityType_YTD.txt | 364 | |
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 | 550 | |
A00550_DocumentStructure_YTD.txt | 21 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 46 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 95 | |
A00615_Draw_YTD.txt | 76,700 | |
A00810_Price_YTD.txt | 2,998,996 | |
A01000_AgrRate_YTD.txt | 9,898,224 | |
A01010_BaseRate_YTD.txt | 762,068 | |
A01020_Beta_YTD.txt | 121,500 | |
A01030_ComboRevenueFactor_YTD.txt | 2,857,140 | |
A01040_CoverageLevelDifferential_YTD.txt | 12,650,747 | |
A01050_SubCountyRate_YTD.txt | 195,367 | |
A01060_OptionRate_YTD.txt | 4,607,891 | |
A01070_Proration_YTD.txt | 2,738,688 | |
A01090_UnitDiscount_YTD.txt | 2,899 | |
A01100_YieldAndTyield_YTD.txt | 11,127,004 | |
A01105_YieldExclusion_YTD.txt | 615,027 | |
A01110_HistoricalRevenueCapping_YTD.txt | 156,294 | |
A01115_HistoricalYieldTrend_YTD.txt | 724,426 | |
A01120_AreaDataSource_YTD.txt | 130 | |
A01125_ProductionArea_YTD.txt | 177,728 | |
A01130_AreaCoverageLevel_YTD.txt | 12,269,758 | |
A01135_AreaRate_YTD.txt | 13,886,372 | |
A01200_DocumentBuilder_YTD.txt | 13,723,962 | |
A01210_Statement_YTD.txt | 1,298 | |
2018_ADM_Daily_171211.zip | A00030_InsuranceOffer_Daily.txt | 360 |
A01010_BaseRate_Daily.txt | 21 | |
2018_ADM_Filing_1130.zip | A00030_InsuranceOffer_Filing.txt | 887,120 |
A00045_Map_Filing.txt | 213,653 | |
A00200_Date_Filing.txt | 887,771 | |
A00810_Price_Filing.txt | 675,511 | |
A01010_BaseRate_Filing.txt | 419,549 | |
A01040_CoverageLevelDifferential_Filing.txt | 8,412,792 | |
A01050_SubCountyRate_Filing.txt | 160,795 | |
A01060_OptionRate_Filing.txt | 3,243,686 | |
A01100_YieldAndTyield_Filing.txt | 7,581,422 | |
A01105_YieldExclusion_Filing.txt | 478,074 | |
A01110_HistoricalRevenueCapping_Filing.txt | 138,498 | |
A01130_AreaCoverageLevel_Filing.txt | 3,981,792 | |
A01200_DocumentBuilder_Filing.txt | 5,878,873 | |
A01220_GuaranteeAdjustment_Filing.txt | 813,187 | |
2018_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,140 |
A00030_InsuranceOffer_YTD.txt | 1,350,683 | |
A00045_Map_YTD.txt | 4,522,763 | |
A00050_Quality_YTD.txt | 530 | |
A00070_SubsidyPercent_YTD.txt | 482 | |
A00200_Date_YTD.txt | 1,357,517 | |
A00400_AgrCommodity_YTD.txt | 435 | |
A00410_Class_YTD.txt | 24 | |
A00420_Commodity_YTD.txt | 115 | |
A00430_CommodityType_YTD.txt | 339 | |
A00440_County_YTD.txt | 3,190 | |
A00450_CroppingPractice_YTD.txt | 80 | |
A00460_InsurancePlan_YTD.txt | 25 | |
A00470_IntendedUse_YTD.txt | 12 | |
A00480_Interval_YTD.txt | 41 | |
A00490_IrrigationPractice_YTD.txt | 3 | |
A00500_OrganicPractice_YTD.txt | 3 | |
A00510_Practice_YTD.txt | 1,056 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 6 | |
A00540_Type_YTD.txt | 506 | |
A00550_DocumentStructure_YTD.txt | 20 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 45 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 103 | |
A00615_Draw_YTD.txt | 23,912,500 | |
A00810_Price_YTD.txt | 3,010,495 | |
A01000_AgrRate_YTD.txt | 10,747,415 | |
A01010_BaseRate_YTD.txt | 536,626 | |
A01020_Beta_YTD.txt | 121,500 | |
A01030_ComboRevenueFactor_YTD.txt | 2,857,140 | |
A01040_CoverageLevelDifferential_YTD.txt | 11,520,416 | |
A01050_SubCountyRate_YTD.txt | 190,309 | |
A01060_OptionRate_YTD.txt | 3,978,913 | |
A01070_Proration_YTD.txt | 384 | |
A01090_UnitDiscount_YTD.txt | 2,849 | |
A01100_YieldAndTyield_YTD.txt | 11,391,425 | |
A01105_YieldExclusion_YTD.txt | 624,090 | |
A01110_HistoricalRevenueCapping_YTD.txt | 156,186 | |
A01115_HistoricalYieldTrend_YTD.txt | 795,825 | |
A01120_AreaDataSource_YTD.txt | 126 | |
A01125_ProductionArea_YTD.txt | 177,586 | |
A01130_AreaCoverageLevel_YTD.txt | 15,254,383 | |
A01135_AreaRate_YTD.txt | 11,502,856 | |
A01200_DocumentBuilder_YTD.txt | 8,234,503 | |
A01210_Statement_YTD.txt | 1,201 | |
A01220_GuaranteeAdjustment_YTD.txt | 997,825 |