2017-05-04 Joint Council Connectivity Implementation Issue - PriceSheets

Participants:

Marilyn Hunter (Unlicensed), Eric Hoefing (Unlicensed), Theresa Fitzsimmons, Brandon Scherzer, Mindy Hendrickson, Matt Garcia, Stephanie Frazier (Unlicensed), Cheryl McWhorter, Lee Kreutter, Kim Flaugher, Julie Bauman (Unlicensed), RANDALL FRY (Unlicensed), Julie Malson (Deactivated) Uma Subrahmanyam Scott Rockafellow,

Business Issue: Manufacturers/Seller need to be able to designate what segment the price sheet is for (CP vs. Seed vs. Specialty) so customers can distinguish the segments. Found that this only applies to version 5.1.1 or before. V5.2 and higher have an element for the segment in both the Properties and Line level.

Goal: To have a recommendation to the S&G Committee on how to implement PriceSheet with designated segments in V5.1.1.

Purpose of call: To determine how manufacturers should consistently identify price sheets to distinguish the segments (CP, Seed or Specialty Chem) when sending the V5.1.1 XML message PriceSheet. Determine the deliverables out of this call that would include a recommendation on how to implement (any new business rules for the documentation).

Meeting Day/Time	Thursday, May 4th, 2017 @ 10:30 am EDT/ 9:30 am CDT/ 8:30 am MDT/ 7:30 am PDT
Duration	1.5 hour
Web Access:	https://global.gotomeeting.com/join/625925607
Call-in #:	Dial +1 (213) 493-0622
Access ID:	625-925-607

Agenda:

	Topic	Desired Outcome	Notes/Minutes
1	Welcome & attendance	Understand who is on the call	All accounted for
2	Anti-trust guidelines	All the attendees are willing to abide by the AgGateway Anti-trust Guidelines /wiki/spaces/SBD/overview	All willing to abide.
3	Review the Business Issue, Goal & Purpose of Call	All are aware of the items above and discuss any confusion or need for clarification	Everyone agrees
4	Recap from prior call	From last call This issue only refers to the v5.1.1 PriceSheet work around For v5.1.1 - we reviewed the message standard and decided the best place to create a "work around" for v5.1.1 would be in the SpecialInstructions - because that structure is at both the Properties level and the Line level. Reviewed the SpecialInstructionType code list - the closest value was "PriceCondition" Some of the manufacturers will need to check to make sure that won't cause any issues in their ERP (if used in another message for something else). The value that will be put in the SpecialInstruction - the group thought it would be best to use the values listed in v5.2, which are: Chemical, CropNutrition, CropProtection, Energy, Feed, Grain, OrnamentalHorticulture, Paper and Seed. SpecialtyChemical is not on the code list, so we will need to request to add that value to the code list from S&G for future versions. For the work-around for Specialty Chemical, the group will consider using either OrnamentalHorticulture or Chemical. All versions v5.2 or higher already has the segment at both the Properties and Line levels Decision: All agreed to define the segments within the message instead of the messaging protocol
5	Review current Business Use Case & updated draft	An agreed upon Business Use Case that includes how the manufacturer will specify segment PriceSheet V5.1.1 Including Segment	Modifications were made directly to document linked here.
6	Determine business rule(s) for implementation	Determine the business rule(s) that would specify how to implement. Proposed Business Rule: To designate the segment of a price sheet within v5.1.1, the SpecialInstruction structure will be used with the value of: Chemical, CropNutrition, CropProtection, Energy, Feed, Grain, OrnamentalHorticulture, Paper, Seed to determine the segment. The SpecialInstructionType will be "PriceCondition". Proposed Business Rule: Only 1 industry segment will be sent per message Proposed Business Rule: As a work around for any version V5.4 or lower, the Specialty Chemical segment will be identified as "OrnamentalHorticulture".	Do we need to add the segment to the PriceSheetRequest? Probably... In the PriceSheetDescription - Dow is currently describing the type of price sheet. Could this be used for the work around instead of the SpecialInstruction? Monsanto is using the PriceSheetDescription for other purposes. Dow is OK with SpecialInstructions as the work around Marilyn will send out an email for the councils to respond prior to the MYM. That way any concerns could be addressed at the MYM. In the PriceSheetRequest - noticed that the ZoneID and ProductClassification are required with 1 occurrence. For other segments these elements would probably not be used, but the requester would need to specify the segment. If we change the occurrence, that would not make the new version backward compatible (Marilyn believes, would need to verify with Jim Wilson). The group didn't think it would need to be unbounded. In the PriceSheetRequest, the requestor might request by ZoneID, and/or ProductClassification (this is typically used to specify a product like corn, soybeans, etc., or products with a certain trait). We need to request changes to the ZoneID and ProductClassification from required to optional and request that IndustrySegment element be added to the PriceSheetRequest. The retailers use the PriceSheetRequest to request price sheets at the beginning and throughout the year. Ceres Solution requests by zone for their locations. Decision: All agreed to the 3 proposed business rules and will send out for vetting to the councils. Action: Marilyn Hunter will send out the 3 proposed business rules to the 4 councils (CPC, SC, SCC, APC) to see if there are any concerns prior to 01 Jun 2017 . Action: Eric Hoefing (Unlicensed) to request the 3 proposed business rules to S&G for inclusion in the documentation at the MYM if there aren't any issues from the council vetting. *Action: Eric Hoefing (Unlicensed) Need to request from S&G an new element in the PriceSheetRequest - IndustrySegment element (0...) prior to the MYM.** Action: Eric Hoefing (Unlicensed) - Need to ask S&G for changes in the ZoneID and ProductClassification to optional (0...1). This request is due to the fact that other than Seed who will use as conditional, the other segments typically would not use these elements. Need to request prior to the MYM.
7	Mapping Tool	Review current mapping tool and suggest changes to it for any new business rules with V5.1.1 and V5.4.	Defer until Marilyn can get an updated version of CLICK that include v5.4. Marilyn did add the proposed business rules for the v5.1.1 mapping tool.
8	Next steps	Determine if there is any other meetings or actions needed to finish up this issue	Tentative meeting for the first week in June. Marilyn Hunter (Unlicensed) to send out Doodle Poll
9	Adjourn	Meeting is adjourned.	Adjourned 11:40 am ET.

Action Items:

Date	Who's Responsible	Status
04 Apr 2017	Mike Glidden - Request from S&G to add "SpecialtyChemical" as a new value for the IndustrySegment list cod
04 Apr 2017	All manufacturers - to check internally to see if when using v5.1.1 would PriceConditions work as a SpecialInstructionType to designate the segment for PriceSheets by 5/1/2017.
04 Apr 2017	Marilyn Hunter (Unlicensed) will contact the other manufacturers that are implementing PriceSheets that are not on the phone and check with them.