Release Notes 7.070.0

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

System Updates

Claims & Inspections

DESCRIPTION ID #

An enhancement was made to the Claim Summary page to give users the option to add additional crops or detail lines to existing Notices of Loss (NOLs) for Private Product claims. The Edit NOL button on this page will only be visible if the claim is in one of the following statuses: "Open", "Open-Corrected", "Assigned to Adjuster", or "Assigned to Supervisor".

96285

Forms & Reports

DESCRIPTION ID #

Rice: Updated provisions were added to the System with TFS #93304 for 2019 Margin Protection (MP) Rice in the 7.035.0 release. However, the ADMs for 2019 MP Rice had not yet been released, so that policy/crop could not be tested at the time. ADMs are now available, so this ticket tested 2019 MP Rice plans of insurance to verify updated policy provisions are printing. The below list of updated provisions for the 2019+ CYs were included with this ticket (previous versions of each document have been removed and replaced with the updated versions):

Common Crop Insurance Policy Margin Protection Plan (19mp)
Margin Price Provisions 2019 and Succeeding Crop Years (19mpp_sectionI)
Margin Price Provisions Rice (0018) 2019 and Succeeding Crop Years (19mpp_rice)
Margin Protection Plan Rice Crop Provisions (19mp018)

94531

RMA updated their website, so the URL link that printed on the Policy Declaration Page in the Policy Provision Statement in the footer was no longer accurate. The Policy Provision Statement in the footer was updated to "# The complete Policy Provisions are available on the RMA website at, http://www.rma.usda.gov.", and the revision date for all formats of the Policy Declaration Page was updated to "01-2019".

There are five formats of the Policy Declaration Page (see below). The format that prints is based on the crop.

Pasture, Rangeland, Forage (PRF) / Apiculture (API);
Whole-Farm Revenue Protection (WFRP);
Nursery;
Annual Forage; and
All Other Crops (this format will print for all crops except for PRF / API, WFRP, Nursery, and Annual Forage).

98309

WFRP: This ticket fixed a bug found on the Farm Op Report and the Farm Op Report pages in the WFRP Combo Form where, when the Farm Op Report data was revised in the System, the SCD Approved Revenue and Expense was not printing on the forms. The Farm Op Report and the Farm Op Report pages in the WFRP Combo Form were updated to have the SCD Approved Revenue and Expense data print on the forms when the data has been revised in the System. Since the database fields didn't exist prior to this ticket, those values will print as zero, which will also show on the user interface.

98280

STAX: RMA released updated STAX Cotton provisions for the 2019 and succeeding Crop Years (CYs). Provisions print with the MPCI Policy Declaration Page form when the print option to print provisions with the form is selected. This form can be printed from the MPCI policy Print tab and from the Batch Printing menu.

97735

The background infrastructure of the State Fraud Statement table has been upgraded to implement some efficiencies. With this ticket, all forms that are required to print a State Fraud Statement now pull that statement from the same location, and the "Fraud Warning" and "FRAUD WARNING" labels have been removed and will now only be included in the Fraud Statement if it is required by the state. Additionally, all Fraud Statements were reviewed to ensure they are accurate.

The Fraud Statement table is used for all forms that print a Private Product application and for claims forms. Applications and claims forms use the same Fraud Statement. If a state has a different Fraud Statement for applications versus claims forms, the Fraud Statement that prints is a combination of the two Fraud Statements.

97683

Global

DESCRIPTION ID #

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

95267

Infrastructure

DESCRIPTION ID #

2019 ADM & ICE updates were made available by the RMA and have been implemented in the System. The following tables have been updated for 2019:

BaseRate
Commodity
CommodityType
CoverageLevelDifferential
CroppingPractice
Date
DocumentBuilder
InsuranceOffer
InsuranceOption
Map
OptionRate
Practice
Price
Proration
Statement
SubCountyRate
SubsidyPercent
Type
UnitDiscount
IceRmaHoliday

98371

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

IceLegalDescription

98469

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

IceLegalDescription

98403

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:

IceLegalDescription

98404

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:

IceLegalDescription

98470

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:

IceLegalDescription

98405

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:

IceLegalDescription

98471

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:

IceLegalDescription

98406

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:

IceClaimProcess
IceLegalDescription

98472

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:

IcePriceElectionPercent
IcePerennialCommodity
IceInsurancePlanCommodityCoverageType
IceNonPremiumAcreageInsurancePlanCommodity
IceGuaranteeAdjustmentTypeInsurancePlan
IceYieldTypeCommodity
IceInsurancePlanCommodityUnitStructure
IceStageCommodity
IcePriceRounding
IceInsuranceOptionCriteria
IceInsuranceOfferGroup
IceProgramIndicatorCommodity
IceRmaHoliday
IceCoverageLevel
IceLegalDescription
IceLrrFundCutoff

98407

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:

IceRmaHoliday
IceLegalDescription

98473

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

IceLegalDescription

98710

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:

IceLegalDescription

98711

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:

IceLegalDescription

98712

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:

IceLegalDescription

98713

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:

IceRmaHoliday
IceLegalDescription

98715

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

IceLegalDescription

98925

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:

IceLegalDescription

98926

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:

IceLegalDescription

98927

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:

IceLegalDescription

98928

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:

IceRmaHoliday
IceLegalDescription

98929

Livestock

DESCRIPTION ID #

DRP: Currently, the Agent dropdown for all coverages is set up to display only agents that are associated with the agency on the policy and that have been appointed in the policy state. An enhancement request was received to update the Agent dropdown logic for Dairy Revenue Protection (DRP) policies to add an additional filter to display only agents who have completed their DRP-specific training for the RY. This change will affect the Agent dropdowns on both the Add New Livestock Policy and the Maintain Grower pages. This change is applicable for Dairy Revenue Protection policies only. The Agent dropdowns on these pages will now populate for DRP policies based on the following:

Agent is tied to the agency.
Agent has an active license.
Agent is appointed in the policy state.
Agent has fulfilled training requirements for the current year.

96740

With TFS #95100, a new permission named "Livestock DRP Policy" was added to support Dairy Revenue Protection (DRP) policy processing. The new permission drives the Program Type dropdown on the Add New Policy and Add New Coverage pages for Livestock policies. If a user has the "Livestock DRP Policy" permission (and has the Livestock Agent or Livestock Admin role with the "Create" right), they will see the Dairy Revenue Protection plan in the Program Type dropdown. Without that permission, they will not be able to add DRP policies. With this ticket, two new permissions were created for LGM and LRP to mirror the logic used for DRP. The following new permissions were added with the "Create" right:

"Livestock LGM Policy" for Livestock Gross Margin (Plan 82)
"Livestock LRP Policy" for Livestock Risk Protection (Plan 81)

NOTE: Users will need the new permission(s) with the "Create" right in order to see the applicable plan(s) in the Program Type dropdown. These permissions will be needed in addition to either the Livestock Agent or Livestock Admin roles. These new permissions will only affect the Program Type dropdown on the Add New Livestock Policy and Add New Coverage pages for Livestock policy processing. AIPs will need to set up two new Roles, one for LRP users and one for LGM users. The new roles will need the applicable permission's "Create" right selected ("Livestock LGM Policy" or "Livestock LRP Policy"). Once the new roles are set up, AIPs will need to add the new roles as needed to users, which will give those users the ability to add new LGM and LRP policies and coverages.

95409

During internal testing an issue was found with navigation where, when a user was on the Maintain SBI page for on a Livestock policy, if they clicked the Close button, the System was not taking them back to the Grower tab as expected. This issue has been resolved.

NOTE: This issue was only affecting Livestock policies.

97425

MPCI

DESCRIPTION ID #

WFRP: RMA's Pass Status Report Release on 11-08-2018 made note of CR 154996 and was slated for the December release. Changes for this release will be for the 2019+ RYs and include the creation of two new fields in the P19A WFRP Farm Reports Detail record called "Intended Percent Produced to Sell" and "Actual Percent Produced to Sell" (database fields were added with TFS #97259). These fields were added to the UI and database in order for the System to accommodate these changes from RMA. These values will be included in the calculation of the Expected Revenue Amount on the P19A WFRP Farm Reports record. The calculation of the Expected Revenue will be impacted within the System with the implementation of the new fields, and these new field values are transmitted on the P19A record.

The WFRP Add New and Maintain Commodity pages have been updated with two new fields named "Percent Produced to Sell" and "Revised Percent Produced to Sell". The fields will be located within the Commodity Details below the Share field for both the Intended and Revised Reports. Along with populating the new database fields, an update was also done for the calculation formula for Expected Revenue and to include the two new values.

95786

Enterprise Units & MCEU: Beginning in the 2019 RY, for crops with a Filing Date of 11/30 or later, RMA has expanded Enterprise Units to include a Multi-County Enterprise Unit Endorsement (MCEU). This endorsement will allow growers to combine acreage of an insured crop in one county with acreage of that same insured crop in another contiguous county. RMA has issued a new option code of "MC" that will be used to elect Multi-County Enterprise Units when elected on the coverage in conjunction with the EU or EP unit structure. In addition, there are a number of qualification requirements that must be met at the Acreage Reporting Date in order for the coverage to qualify for MCEU.

A number of System changes were made to account for this new endorsement. This includes functionality to allow users to elect Multi-County Enterprise Units on the coverage as well as various updates to validation, override, and suspension logic. With this ticket, the following coverage changes have been made to allow MCEU to be elected on the coverage:

The "MC" option was added to the options available on the coverage if "MC" is available for the RY/State/County/Crop.
A validation was added to require EU or EP to be elected on the coverage if "MC" is selected.

This ticket will address these coverages changes only. All other MCEU related changes will be handled in a future release with a separate TFS ticket.

NOTE: All MCEU qualification requirements are being reviewed and the necessary tickets are being created to address changes to MCEU validation, overrides, and suspensions.

88840

RMA: For the Agency Extract, the 2019 RY records definitions were updated for the C20, C20A, and C20X.

97307

Margin Protection: Per the PASS Release Notes from 11/9, RMA is updating their rules to allow a Primary County designation on more than one P14 record for Margin Protection when multiple P14s exist by type/practice. Previously, the System only allowed a Primary County designation to be applied to a single coverage for the crop when a national Primary County election was applied and to a single coverage for the state/crop when a state Primary County election existed. To account for RMA's update, with this ticket, the System was updated to allow a Primary County designation to be applied to more than one coverage for the crop or state/crop, provided the plan is Margin Protection and coverages by type/practice exist.

96917

PHTS: RMA changed the Unit of Measurement for Sugar Beets (0039) from standardized tons to pounds of raw sugar. In TFS #88824, a change was made in the 2019+ RYs only for counties with a Contract Change Date of 11/30/2018 and in the 2020+ RYs for all counties to account for RMA's change to the Sugar Beet Unit of Measurement (UOM). The PHTS import process was updated to account for these changes. The ticket updated the PHTS import process to account for the UOM conversion for Sugar Beets within the 2019 RY P81 file format. AIPs may reference the 2019 RY M13 (on RMA's website) and the P81 record layout for the scope of 2019 RY changes.

For 2018 production, the PHTS import process will import Sugar Beet production in tons and it will be the responsibility of the user to convert the tons to pounds; the System will convert the prior years.

89035

WFRP: During internal testing of WFRP functionality, a bug was identified with the WFRP Qualifying Commodity Count calculation. RMA recently updated the procedures around Qualifying Commodity Counts to state that commodities with different rate codes but with the same WFRP commodity code would be considered one commodity for the purposes of the Qualifying Commodity Count calculation. This calculation was updated back in the 7.030 release.

The bug found during internal testing was that the System was not calculating qualifying commodities correctly in certain scenarios. If more than one commodity with the same WFRP commodity code existed on the policy and one of the lines did not meet the qualifying revenue threshold, the System was calculating the qualifying commodity incorrectly. The WFRP Qualifying Commodity Count calculation has been updated to account for multiple commodities with the same WFRP commodity code, and qualifying commodities are now calculating correctly.

NOTE: A spinoff, TFS #97672, was created to address an issue where 2019 RY Premium is calculating incorrectly when multiple commodities with the same WFRP commodity code exist.

94617

Fast Edit PR: Stand-alone Margin Protection coverages (Plans 16 and 17) leverage the same Fast Edit PR grid designed to support ARPI (Plans 04, 05, and 06) and Stand-alone STAX (Plans 35 and 36) coverages. For all of these plan codes, the Production Reporting Date (PRD) in the ADM/Actuarial Documents drives the agent-level lockout logic and is determined by the System as the PRD + AIP offset days. A bug was reported on 1/7/19 where agent users were unable to key production for Stand-alone Margin Protection policies because the System behaved as though agents were locked out. It was determined that the Margin Protection plans were not correctly leveraging existing logic for the Fast Edit PR grid and an adjustment was needed to include these plan codes in the existing Fast Edit PR logic for ARPI and Stand-alone STAX functionality. This has been resolved.

98706

An issue with entering acreage and share information for Transfers of Coverage and Rights to an Indemnity (TOC/TOR) was reported. When a TOC is received, users key an SBI record with an entity type of "Transfer of Rights to an Indemnity (SBI Only)". Once this SBI record is created, users navigate to the detail line and select to associate the TOC SBI with the detail line as a shareholder. Once the SBI record is listed as a shareholder on a detail line, the shareholder name becomes a hyperlink in the Shareholder Information section of the View Detail Line Shareholder Details page. Clicking the link is supposed to take the user to a page where they can enter the acreage or share being transferred to the TOC. However, due to this bug, a "Sorry..." error was received instead. With this ticket, the "Sorry..." error has been resolved and users will now be taken to the page to enter acreage or share information for a TOC when the Shareholder Name link is clicked.

98415

WFRP: On 11/8/2018, RMA released a Pass Status Report for WFRP that included White Paper changes slated for the 2018+ RYs as part of CR 148612. This CR will allow County Changes on WFRP Policies when a Late Reported Reason (LRR) of 19 applies. The 2019 WFRP Handbook states the county insured should be the county that represents the majority of the expected revenue. The county with the most revenue at the Sales Closing Date (SCD) could be different than the county with the most revenue when the Revised Farm Operation Report is submitted, so given this, RMA will allow the county to change following the SCD.

With TFS #34540, a System change was implemented for the Late Reported Reason (Late Processed Flag in UI) of "19" – Whole Farm Revenue Protection (WFRP) Revised Coverage Level. The change allowed for the Coverage Level Percent to change after the Sales Closing Date if it was due to a change in the insured's revenue that affects the allowable coverage levels and not be penalized with a Late Reported Reason. RMA is now going to use the Late Reported Reason "19" as a multipurpose code. Along with allowing the "Coverage Level Percent" to change after the Sales Closing Date, it will also allow the "Location County Code" to change after the Sales Closing Date due to changes in the insured's revenue affecting the allowable Coverage Level and/or Location County. RMA will continue to not assess LRRs on WFRP coverages as long as the late processed reason is selected and transmitted on the P14 record. Currently, the Late Reported Ice Table (D00006) includes this code for WFRP and should continue to only display the Late Reported Reason "19 – Whole Farm Revenue Protection (WFRP) Revised Coverage Level" when the coverage is a WFRP Coverage.

Functionality is already in place to apply a Late Processed Flag of 19 if the Late Reported Reason = Whole Farm Revenue Protection (WFRP) Revised Coverage Level. The only change needed to account for this procedure change is to allow the county to be edited so long as the Late Processed Flag of 19 is applied.

With this ticket, for the 2018+ RYs only, the Maintain Coverage page was updated to allow users to change the County for WFRP policies when the Late Processed Flag is equal to the Late Reported Reason of "19-Whole Farm Revenue Protection (WFRP) Revised Coverage Level" and a save is initiated to store the value in database. Once the save is initiated in this instance, the System will open the County dropdown for correction.

96742

WFRP: With TFS #97360, the System was updated to add two new database fields in the AgrIncomeExpense table in order to store the SCD Approved Revenue and SCD Approved Expenses. With this ticket, the System was updated to populate these new database fields on the Add New and Maintain Income Expense pages in order for them to print on the Farm Operation Report even after a revised report has been submitted.

Prior to these changes there was only one database field for the Approved Revenue and Revised Approved Expenses and the values were updated when a revised report was keyed. Once the Income and Expense Record was updated with revised values, the Approved Revenue and Approved Expense values in the database were updated to the revised values. With the addition of the new SCD Approved Revenue and SCD Approved Expense fields, the System will continue to populate the existing Approved Revenue and Approved Expenses database fields as they are currently since these fields are used for premium calculations. In addition, the System will populate the new fields with the Approved Revenue and Approved Expenses at the SCD.

NOTE: Forms updates will be addressed with TFS #95589 and #95590 to point to the new database fields being populated as part of this ticket.

97361

APH: By design, the System will automatically apply YA to an APH yield year when the annual yield falls below 60% of the t-yield. When YA does not apply due to a procedural exception, the user must de-select the YA checkbox on the APH Utilities grid, manually key a yield type of "AY", and select the "*" (override) checkbox. In addition, if the grower opts out of YA in a given year, the user must de-select the YA checkbox from the APH Utilities grid, manually key a yield type of "NA", and select the "*" (override) checkbox. A bug was reported where users were not able to remove YA from a particular yield year using the "NA" yield type. The APH logic has been updated to allow YA to be removed from a yield year using the "NA" yield type.

91180

APH: TFS #90348 introduced new logic in the Additional Functions dropdown within the APH tab that allows users to apply current year simple averages to Category B crops. During the testing of the new current year's simple average functionality, two issues were identified as needing clean-up work done. Both of the following issues occurred when Personal T-Yields (PTYs) existed for the crop and a Personal T-Yield Summary unit existed: if a Personal T-Yield Summary unit has already been set up for the crop, the PTY Summary unit should not be displayed in the list of units to apply the simple average to, even if there were less than 4 years of actual history on the crop; also, if the PTY Summary unit already existed, the user should not have been able to make changes to the non-summary units without first deleting the PTY Summary Unit. With this ticket, the Apply Current Year SA T-Yield popup was updated to exclude PTY Summary units from the list of available units to apply the simple average logic to. The popup was also updated to force users to delete PTY Summary units prior to being able to apply the simple average logic to any non-summary APH units for that crop. Once the PTY Summary unit has been deleted and the Simple Average logic applied, users will then need to set up new PTY Summary units as needed.

91378

Contracts: An AIP reported an issue where a price could not be keyed correctly to a contract. The issue involved a coverage with an XC Written Agreement as well as a contract. On the contract, when the user attempted to select a type and practice, the correct type and practice were not available due to the XC Written Agreement. In addition, when the user attempted to key the applicable contract price, the System was displaying an error stating the maximum contract price was exceeded, even though the price was less than or equal to the price from the Written Agreement ADM table.

The System will now display all type/practices on the contract UI when a Written Agreement exists. In addition, the maximum contract price validation logic has been updated to use the maximum contract price from the Written Agreement ADM table.

98349

Fast Edit PR: A bug related to Fast Edit PR was reported on Almonds that resulted in the Approved APH yield not being calculated at save of the grid. An adjustment was made to the code to correct this calculation at successful save of updated data. This bug impacted Almonds only.

98767

MP/STAX: TFS #90348 introduced new logic in the Additional Functions dropdown within the APH tab that allows users to apply current year simple averages to Category B crops. During the testing of that ticket, an issue with MP and STAX coverages was identified as needing clean-up work done. For STAX and MP related coverage policies, the units did not populate until premium existed on the related MPCI coverage. Once the MP and/or STAX detail lines were populated with the related MPCI details, the user should not have been able to use the "Apply Current Year SA T-Yield" option from the Additional Functions dropdown. With this ticket, the logic was updated to prevent the "Apply Current Year SA T-Yield" option from displaying in the Additional Functions dropdown if the coverage is STAX or MP and the details have already populated with the related MPCI details.

91572

Private Products

DESCRIPTION ID #

VIP: VIP will be introduced as a new Private Product for Hudson in 2019. This ticket established VIP policy creation and coverage importing from the quotes that were created.

95941

ICE: On some occasions, the line order of the imported detail lines on an Increased Coverage Election (ICE) policy was not matching the unit order of the associated MPCI Coverage. The System has been updated to order the ICE Detail lines to match the Unit Number order which is displayed on the associated MPCI Coverage. This should allow the user to view each policy's detail lines in the same order.

97909