Release Notes 8.080.0

These release notes provide brief descriptions of changes included in AgWorks 8.080.0.

System Updates

Forms & Reports

DESCRIPTION ID #

A request was made to add RLU data to the Acreage Report CLU form. The Acreage Report CLU form's Detail Line section was updated to print RLU data in the Legal Description field after the Legal Description.

106744

Production Report / Acreage Report: Some enhancements were made to the Skip Row page. These changes will apply to all Crop Years:

1. The pre-print functionality was updated for the Skip Row page to print with Acres, Plant Pattern, Row Width, and Skip Row Factor data from the current year's Premium Line.
2. The pre-fill functionality was updated for the Skip Row page to print Plant Pattern, Row Width, and Skip Row Factor with acres when the agents are printing the form to gather Production data from the Insured.
3. The Yield Total was updated on the Skip Row page to not double the Yield Total amount.

92899

The Potential Loss Estimator form (available for Plan Codes RP [02] and RPHPE [03] only) has been updated in the following ways for all years:

Detail Line Share: The space between the Share amount and the percentage sign has been removed.
AOI: The format of the data was updated to have a dash instead of a forward slash. Also, if there is no AOI, then "NONE" will now print. (For example, AOI Name (County - Crop 1, Crop 2)).
Spouse: If no there is no Spouse, then "NONE" will now print.

110625

Peanuts: The Federal Crop Insurance Corporation (FCIC) revised the Peanuts Crop Provisions to allow separate coverage levels by type (planting period) and to make other policy clarifications for the 2020 Crop Year. The provisions print with the MPCI Policy Declaration page when the print option to print provisions with the form is selected. The MPCI Policy Declaration page is available to print from the MPCI Print tab in an individual MPCI policy and from the Batch Printing menu. These changes are applicable for the 2020 Crop Year.

111506

Hybrid Sweet Corn: The Federal Crop Insurance Corporation (FCIC) updated the Hybrid Sweet Corn Seed Crop Provisions. These provisions print with the MPCI Policy Declaration page when the print option to print provisions with the form is selected. The MPCI Policy Declaration page is available to print from the MPCI Print tab in an individual MPCI policy and from the Batch Printing menu. These changes are applicable for the 2020 Crop Year.

111538

STAX: The Federal Crop Insurance Corporation (FCIC) updated the Stacked Income Protection Plan Cotton Crop Provisions. These provisions print with the MPCI Policy Declaration page when the print option to print provisions with the form is selected. The MPCI Policy Declaration page is available to print from the MPCI Print tab in an individual MPCI policy and from the Batch Printing menu. These changes are applicable for the 2020 Crop Year.

111542

Updated 2020 Special Provisions were made available by the RMA on Nov 25 and 27 and have been implemented in the System:

Wheat (0011) - Plan YP (01), Plan AYP (04): Several states & counties
Onions (0013) - Plan APH (90): Several states & counties
Canola (0015) - Plan YP (01): Several states & counties
Oats (0016) - Plan APH (90): Several states & counties
Millets (0017) - Plan APH (90): Several states & counties
Rice (0018) - Plan YP (01), Plan AYP (04), Plan MP (16): Several states & counties
Cotton (0021) - Plan YP (01), Plan AYP (04), Plan STAX-RP (35): Several states & counties
Cotton Ex Long Staple (0022) - Plan APH (90): Several states & counties
Flax (0031) - Plan APH (90): Several states & counties
Forage Seeding (0032) - Plan DO (50): Several states & counties
Sugar Beets (0039) - Plan APH (90): Several states & counties
Corn (0041) - Plan YP (01), Plan AYP (04): Several states & counties
Sweet Corn (0042) - Plan APH (90): Several states & counties
Popcorn (0043) - Plan YP (01), Plan AYP (04): Several states & counties
Fresh Market Corn (0044) - Plan DO (50): Several states & counties
Processing Beans (0046) - Plan APH (90): Several states & counties
Dry Beans (0047) - Plan YP (01), Plan AYP (04): Several states & counties
Safflower (0049) - Plan APH (90): Several states & counties
Hybrid Sorghum Seed (0050) - Plan YDO (55): Several states & counties
Grain Sorghum (0051) - Plan YP (01), Plan AYP (04): Several states & counties
Cultivated Wild Rice (0055) - Plan APH (90): CA in 2 counties (Sutter (101) & Yolo (113))
Silage Sorghum (0059) - Plan APH (90): Several states & counties
Hybrid Corn Seed (0062) - Plan YDO (55): Several states & counties
Green Peas (0064) - Plan APH (90): Several states & counties
Dry Beans (0067) - Plan YP (01), Plan AYP (04), Plan APH (90): Several states & counties
Mustard (0069) - Plan APH (90): Several states & counties
Cabbage (0072) - Plan APH (90): Several states & counties
Sunflowers (0078) - Plan YP (01): Several states & counties
Hybrid Seed Rice (0080) - Plan YDO (55): Several states & counties
Soybeans (0081) - Plan YP (01), Plan AYP (04): Several states & counties
Potatoes (0084) - Plan APH (90): Several states & counties
Fresh Market Tomatoes (0086) - Plan APH (90): Several states & counties
Tomatoes (0087) - Plan APH (90): Several states & counties
Barley (0091) - Plan YP (01): Several states & counties
Hybrid Sweet Corn Seed (0093) - Plan YDO (55): Several states & counties
Fresh Market Beans (0105) - Plan APH (90): Several states & counties
Buckwheat (0114) - Plan APH (90): Several states & counties
Cucumbers (0132) - Plan APH (90): Several states & counties
Pumpkins (0147) - Plan APH (90): IL (17) Several counties
Sweet Potatoes (0156) - Plan APH (90): LA (22) several counties
Flue Cured Tobacco (0229) - Plan APH (90): Several states & counties
Fired Cured Tobacco (0230) - Plan APH (90): Several states & counties
Burley Tobacco (0231) - Plan APH (90): Several states & counties
Maryland Tobacco (0232) - Plan APH (90): MD (24) with several counties & PA (42) in Lancaster County (071)
Dark Air Tobacco (0233) - Plan APH (90): Several states & counties
Cigar Filled Tobacco (0234) - Plan APH (90): PA in Chester (029), Lancaster (071) & Lebanon (075) counties
Cigar Binder Tobacco (0235) - Plan APH (90): CT (09) in Hartford (003) & Tolland (013) counties; and MA (25) in Franklin (011), Hampden (013) & Hampshire (015) counties
Maryland Tobacco (0232) - Plan APH (90): CT (09) in Tolland (013) county; and MA (25) in Franklin (011), Hampden (013) & Hampshire (015) counties
Camelina (0333) - Plan APH (90): MT (30) in several counties; and ND (38) in several counties
Sesame (0396) - Plan APH (90): Several states & counties

111567

New 2020 Special Provisions were made available by the RMA on Dec 20 and have been implemented in the System. The following have been updated for the 2020 RY / 2021 CY:

Grapefruit (0201) - Plan DO (50)
Lemons (0202) - Plan DO (50)
Tangelos (0203) - Plan DO (50)
Orange Trees (0207) - Plan TDO (40)
Grapefruit Trees (0208) - Plan TDO (40)
Lemon Trees (0209) - Plan TDO (40)
All Other Citrus Trees (0211) - Plan TDO (40)
Oranges (0227) - Plan DO (50)
Mandarins / Tangerines (0309) - Plan DO (50)
Tangors (1302) - Plan DO (50) FL (12) in several counties
Lime Trees (0210) - Plan TDO (40)
Carambola Trees (0213) - Plan TDO (40)
Limes (9936) - Plan DO (50) FL (12) in Lee (071) & Miami-Dade (086) counties
Avocado Trees (0212) - Plan TDO (40)
Mango Trees (0214) - Plan TDO (40) in FL (12) in Miami-Dade (086) county
Nursery (0073) - Plan DO (50): Several states & counties

112327

Sweet Potato: The RMA updated the Sweet Potato Crop Provisions for the 2020 and succeeding Crop Years. These provisions print with the MPCI Policy Declaration page when the print option to print provisions with the form is selected. The MPCI Policy Declaration page is available to print from the MPCI Print tab in an individual MPCI policy and from the Batch Printing menu.

111062

Rice: The RMA updated the Rice Crop Provisions for the 2020 and succeeding Crop Years. With this ticket, these updated Rice Crop Provisions were implemented. Provisions print with the MPCI Policy Declaration page when the print option to print provisions with the form is selected. The MPCI Policy Declaration page is available to print from the MPCI Print tab in an individual MPCI policy and from the Batch Printing menu.

111438

The RMA updated the Basic Crop Provisions for 2020 and succeeding years for crops with CCD on or after 6/30/19 and 2021 and succeeding years for crops with CCD prior 6/30/19. Provisions print with the MPCI Policy Declaration page when the print option to print provisions with the form is selected. The MPCI Policy Declaration page is available to print from the MPCI Print tab in an individual MPCI policy and from the Batch Printing menu. The updated Basic Crop Provisions implemented will be effective for 2020 and succeeding years for crops with CCD on or after 6/30/19 and 2021 and succeeding years for crops with CCD prior 6/30/19.

111442

Sugar Beets: The Federal Crop Insurance Corporation (FCIC) updated the Sugar Beets Crop Provisions. This ticket implemented the Sugar Beets Crop Provisions for the 2020 Crop Year. Provisions print with the MPCI Policy Declaration page when the print option to print provisions with the form is selected. The MPCI Policy Declaration page is available to print from the MPCI Print tab in an individual MPCI policy and from the Batch Printing menu.

112204

Rice: The Commodity Exchange Price Provisions (CEPP) are used in conjunction with either the Common Crop Insurance Policy Basic Provisions or the Area Risk Protection Insurance Basic Provisions along with the Crop Provisions for the following crops: Barley, Canola (including Rapeseed), Corn, Cotton, Grain Sorghum, Rice, Soybeans, Sunflowers, and Wheat. In accordance with Section 1 of either the Common Crop Insurance Policy Basic Provisions or the Area Risk Protection Insurance Basic Provisions, the CEPP specifies how and when the projected and harvest price components will be determined by crop. There are two sections contained in the CEPP:

Section I: General Information. This section contains information relevant for all applicable crops, including definitions and common policy material.
Section II: Price Definitions. This section contains crop-specific projected and harvest price definitions and specifications, including commodity exchanges, contracts, and discovery periods.

The RMA updated the Section II: Rice CEPP document for the 2020 and succeeding Crop Years. This ticket implemented revised CEPP Rice Crop Provisions that will be effective for the 2020 Crop Year. Provisions print with the MPCI Policy Declaration page when the print option to print provisions with the form is selected. The MPCI Policy Declaration page is available to print from the MPCI Print tab in an individual MPCI policy and from the Batch Printing menu.

112211

Livestock: An issue was found where the Livestock Risk Protection (LRP) Application was only printing one application page (page one) for the policy instead of one application for each policy county. The LRP Application has been updated for all years to print an application page (page one) for each policy county on the policy.

113303

Livestock: An Initial Accepted Date field has been added to the Livestock Policy Register (Reports > MPCI Reporting > Livestock Register) Excel export following the Error Status Flag. It will be populated with the initial date the endorsement was accepted.

106858

An enhancement request was received to add sorting and filtering functionality to the Maintain Documents page to improve the findability of existing forms (Forms & Docs Menu > Maintain Documents). This ticket added sorting and filtering functionality to the Form Number and Form Name columns on the Maintain Documents page. In addition, a new column was added to display the Category of the form. The new Column category also has the sorting and filtering functionality.

111492

Sugar Beets: On the Schedule of Insurance (SOI), it was found that the Price for Sugar Beets was printing with two decimals instead of three decimals. This was found to be the same with the SOI / Production Report for Sugar Beets. This was a display-only issue. The Price for Sugar Beets premium line(s) was updated to print three decimal places instead of rounding to two decimal places; no changes were done to the SOI formats for Annual Forage, API, PRF and WFRP.

NOTE: TFS #112272 will be updating the Price on the System pages for premium lines to display the Price as three decimals.

111987

Private Product Application: During internal research, it was noticed that the Private Product Application did not include the Tax, Fees, and Surcharge fields when totaling premium. This ticket was created to update the form when those fields are applicable. The logic was updated on the Private Product Application to add the Tax, Fees, and Surcharge fields to the Totals field on the form:

On pre-filled applications, these fields will only display if there is a numeric value; if no numeric value is applicable, these fields will NOT appear on the form.
On Blank Forms, these fields will display.

112658

PTY Comparison: It was found that the PTY Comparison Worksheet was not calculating correctly; this has been corrected. This base change will apply to all Crop Years.

112990

Global

DESCRIPTION ID #

The Online Help Site was updated with topics as well as with current release notes.

111919

Mapping

DESCRIPTION ID #

When the custom labels layer is enabled, users now have the option to choose whether to display label lines for custom labels.

111896

The square pattern was not rendering the same way on the printout and the user interface. This has been corrected.

111898

Several additional enhancements and bugs surrounding the Custom Labels were identified during initial testing and addressed with this ticket.

1. When creating a “point label” (a label outside of a field), when you click on a location on the map, an indicator lets you know the exact point selected for the label.
2. Styles (font size, color, etc) are defaulted to the last template that was used for any other label.
3. In the Label Editor, the Move icon is displayed and allows a user to drag a label to a new position, and on update, the label is stored in the new location.
4. In the Templates tab, an option to Remove All was added, which removes all existing custom labels.
5. A Bold option was added to the font for Label Styles and Templates Label Styles sections.
6. Options on the Templates tab were divided into to collapsible/expandible banners to improve navigability.
7. A “No Label Selected” indicator displays when viewing the Label Editor prior to selecting a field or point for a label.

112562

MPCI

DESCRIPTION ID #

WFRP: In the 8.070 release, functionality to account for the 2018 Farm Bill changes to Native Sod procedures was implemented for the majority of crops/plans. The one exception to this was WFRP. Since Native Sod functionality works a bit differently on WFRP, this ticket was created to address the changes to Native Sod on WFRP separately.

Under the 2018 Farm Bill, Native Sod must be identified with an "N8" Program Indicator code on the P19 and P19A records if the ground was tilled after 12/20/2018. Otherwise, the "NS" Program Indicator and the 2014 Farm Bill Native Sod procedures apply. In addition, when less than 5 acres are broken out, Native Sod procedures do not apply, but RMA requires a Program Indicator Code of "DM" on the P19 and P19A record to identify this De Minimus acreage.

With this ticket, WFRP functionality was updated to account for the 2018 Farm Bill Native Sod procedures. In addition, functionality for De Minimus acreage has been implemented. This includes the following changes:

The existing Native Sod checkbox was moved on the Add New/Maintain Commodity page to the right corner of the page to better support the additional new fields.
A field was added for "Breakout Year" that will display when the Native Sod checkbox is selected.
A field was added for "Tilled after 12/20/2018" that will display when the Native Sod checkbox is selected and the Breakout Year field is "2018".
A field was added for "De Minimus Native Sod" that can only be selected if the Native Sod checkbox is not selected.

NOTE: RMA has not yet updated the P19 or P19A records to account for the new Program Indicator Codes applicable to Native Sod under the 2018 Farm Bill. TFS #112416 has been set up to address the necessary transmission changes once RMA makes the changes on their end.

111518

Quote: A bug was reported where a "Sorry..." error was received when attempting to create a new quote for WFRP. Research of this issue confirmed the "Sorry..." error only occurred when the user keyed information in the Detail Line section of the Add New Quote page. Since detail lines are not applicable to WFRP, the System displayed a "Sorry..." error when attempting to create a detail line for a WFRP quote. In addition, research of this issue found that the Tax Year and Accounting Method fields required on WFRP coverages were not displaying on the Add New Quote page.

With this ticket, the following changes have been made:

1. The Add New Quote page was updated to no longer display the Detail Line section of the page once the user selects a crop/plan of "WFRP".
2. The Add New Quote page was updated to display the following fields if the selected crop/plan is WFRP:
Accounting Method
Tax Year
Beginning Date - only displays if Tax Year is Early or Late Fiscal Year
Ending Date - only display if Tax Year is Early or Late Fiscal Year

113172

Perennials: An issue was reported where variability calculations weren't calculating correctly according to guidelines. It was found that the calculations in the Alternate Bearing Test were using a 5-year average instead of a 4-year average. According to CIH guidelines for Alternate Bearing, the System should calculate an average APH using the most recent 5 years in the APH database. If the most recent 5 years are not available, then the System should use the most recent 4 years. For Alternate Bearing tests, the System was updated to now use logic to calculate the yield average by using the most recent 5 years of history in the APH database, and if 5 years is not available, to use the 4 most recent APH years.

113320

Perennials: An issue was reported where the System was not correctly calculating a policy that was flagged for Almond Higher Yield request according to policy guidelines. In looking into the issue, it was found there was was obsolete code still being included in the APH calculation. The System was updated to remove the obsolete code that was causing the issue with the Higher Almond Yield policy procedures from the APH calculation. The System will now correctly update APH calculations according to policy guidelines.

113084

WFRP: During internal testing of WFRP functionality, an issue with the calculation of RX Avg Revenue and Indexed RX Avg Revenues on the Income & Expense Record was identified. The issue was occurring when different years should have been excluded in calculation of RX Avg Revenue vs. Indexed RX Avg Revenue. Instead of excluding one year from each calculation, the System was excluding both years from both calculations.

In addition, while researching this issue, a similar issue was found with RS Avg Revenue and Indexed RS Avg Revenue. When a year qualified for RS in calculation of Indexed RS Avg Revenue, the System was applying RS to that same year when calculating RS Avg Revenue even if the year didn't qualify for RS in calculation of RS Avg Revenue.

With this ticket, the RX Average Revenue, Indexed RX Average Revenue, RS Average Revenue, and Indexed RS Average Revenue calculations have been updated so these bugs no longer occur.

113113

Prevented Planting: During internal testing of Prevented Planting (PP) functionality, an issue was identified where the PP checkbox was not consistently displaying on the Add New and Maintain Detail Line pages. The logic that displays the PP checkbox has been updated so that the PP checkbox displays so long as PP is available for the State/County/Crop.

107808

Sugar Beets: The ADM reflects a price for Sugar Beets (in pounds) as a value with 3 places beyond the decimal. However, the detail line user interface was displaying a rounded value of 2 places beyond the decimal. The issue was identified on the form formatting and then referred back to a display issue on the premium line. This was a display-only issue. The display on the premium line was updated to display the price from the ADM (3 places beyond the decimal).

112272

WFRP: During internal testing, a bug was identified on the WFRP Fast Edit PR page. When final production/revenue is processed via the WFRP Fast Edit PR, if the New Commodity checkbox was previously selected on the Commodity, the System was removing the selection on save of the WFRP Fast Edit PR. With this ticket, the WFRP Fast Edit PR has been updated so that the New Commodity checkbox is no longer removed on save.

NOTE: The New Commodity checkbox only displays on the Maintain Commodity page when revising a commodity.

112875

Fast Edit PR: During internal testing, a bug was identified with the Assigned Yield functionality on the Fast Edit PR. When a user selects to apply Assigned Yield through the Fast Edit PR, the System applies a "P" Yield Type and an Annual Yield of 75% of the prior year yield to all APHs with acres greater than zero in the current RY-1 (current RY-2 for lag year crops) yield year. The one exception to this is any APH with a claim in that yield year will not receive the Assigned Yield. The issue found during internal testing was that the System was applying the Assigned Yield to APHs with claims in the prior year. With this ticket, the Fast Edit PR Assigned Yield functionality has been updated so that Assigned Yields are no longer applied to any APHs with a claim in the current RY-1 (current RY-2 for lag year crops) yield year.

113090

Private Products

DESCRIPTION ID #

ICE: For the 2020 Increased Coverage Election (ICE) product changes, this ticket updated the Confirmation of Coverage form. "Loss Deductible" and "Increased Price Option" fields were added to the form and the revision date was updated to "02-2020".

112435

ICE: For the 2020 Increased Coverage Election (ICE) product changes, this ticket updated the Schedule of Insurance form. "Loss Deductible" and "Increased Price Option" fields to the form and the revision date was updated to "02-2020".

112436

An issue was found where, when editing sales records from the MPCI side, the System was not saving changes. An update was made to correct the issue, and now, when editing the sales record from the MPCI policy, the change is saving correctly.

113246

When an existing linked Private Product policy was restored, the Practice was being wiped out. An update was made so that, when a user restores an existing linked Private Product policy, the Practice field is filled and not wiped out.

113389

System Infrastructure

DESCRIPTION ID #

An ICE 2018 update was made available by the RMA and has been implemented in the System. The following table has been updated for 2018:

IceYieldTypeCommodity

113423

An ICE 2019 update was made available by the RMA and has been implemented in the System. The following table has been updated for 2019:

IceYieldTypeCommodity

113428

An ICE 2020 update was made available by the RMA and has been implemented in the System. The following table has been updated for 2020:

IceYieldTypeCommodity

113430

An ICE 2016 update was made available by the RMA and has been implemented in the System. The following table has been updated for 2016:

IceYieldTypeCommodity

113447

An ICE 2017 update was made available by the RMA and has been implemented in the System. The following table has been updated for 2017:

IceYieldTypeCommodity

113449

An ICE 9999 update was made available by the RMA and has been implemented in the System. The following table has been updated for 9999:

ITS

113808

An ICE 2016 update was made available by the RMA and has been implemented in the System. The following tables have been updated for 2016:

CCWS
PASS
ROE

113809

An ICE 2017 update was made available by the RMA and has been implemented in the System. The following tables have been updated for 2017:

CCWS
PASS
ROE

113810

An ICE 2018 update was made available by the RMA and has been implemented in the System. The following tables have been updated for 2018:

CCWS
PASS
ROE

113811

An ICE 2019 update was made available by the RMA and has been implemented in the System. The following tables have been updated for 2019:

CCWS
PASS
ROE

113812

An ICE 2020 update was made available by the RMA and has been implemented in the System. The following tables have been updated for 2020:

CCWS
PASS
ROE
IcePriceElectionPercent
IceInsurancePlanCommodityCoverageType
IceNonPremiumAcreageInsurancePlanCommodity
IceGuaranteeAdjustmentTypeInsurancePlan
IceYieldTypeCommodity
IceInsurancePlanCommodityUnitStructure
IceContractPriceLimit
IceStageCommodity
IcePriceRounding
IceInsuranceOptionCriteria
IceInsuranceOfferGroup
IceProgramIndicatorCommodity
IceCoverageLevel
IceLrrFundCutoff

113814