Seed Product Directory Guidelines
Business Purpose
This document provides information and guidelines around seed product data in the Ag Industry Identification System (AGIIS) directory in order to have more consistency in the way the seed products are loaded and maintained in AGIIS. The following help:
Clarify the definition of the fields used and needed for seed products
Understand what codes seed manufacturers are using, in certain key fields.
Provide an example for a product load and product extract.
Background
The Seed Council recognized that there was very little documentation as to how to implement and load the products (specially the seed products) in AGIIS. Because of the lack of guidelines, the Council feels that the previously loaded data is inconsistent and difficult for those wanting to utilize that data. AGIIS has provided the electronic capability to upload and download Seed products in the AGIIS product directory.
AGIISProductUpdate XML Mapping Document
Record Level | Data Element \ @Attribute | Required Y/N | Description |
|
Header/ThisDocumentIdentifier | DocumentIdentifier | Y | CIDX Chem eStandards v3.0 DateTime followed by a 4 digit sequence number. Total 19 digits | 000020110505T092261 |
Header/ThisDocumentDateTime | DateTime | Y | Follows the guidelines set forth by the CIDX Chem eStandards v3.0 for DateTime information YYYYMMDDhhmmss | 20110505T092261,2011-04-13T18:15:46Z |
Header/ThisDocumentDateTime/DateTime | DateTimeQualifier | Y | Data element that qualifies the Date Time element. "On" | On |
Header/From/PartnerInformation | PartnerName | Y | Sending Subscribers name | ABC Company |
Header/From/PartnerInformation | PartnerIdentifier | Y | Sending Subscriber's EBID | 8097318700000 |
Header/From/PartnerInformation / PartnerIdentifier | @Agency | Y | The type of unique identifier. (EBID) | EBID |
Header/From/PartnerInformation / ContactInformation | ContactName | Y | Name of the person to contact if problems exist in the file. | Bob Smith |
Header/From/PartnerInformation / ContactInformation / TelephoneNumber | NationalTelephoneNumber | N | Phone number to reach the sending subscriber contact. | 555-123-4567 |
Header/From/PartnerInformation / ContactInformation | EmailAddress | Y | Email address of the sending subscriber contact | |
Header/To/PartnerInformation | PartnerName | Y | Name of the receiving company | CSC |
Header/To/PartnerInformation | PartnerIdentifier | Y | Receiving company's EBID | 1324108090000 |
Header/To/PartnerInformation / PartnerIdentifier | @Agency | Y | The type of unique identifier (EBID | EBID |
Header/To/PartnerInformation / ContactInformation | ContactName | Y | Name of the designated contact at the receiving company | Help Desk |
Header/To/PartnerInformation / ContactInformation / TelephoneNumber | NationalTelephoneNumber | N | Phone number to reach the receiving company contact | 866-251-8618 |
Header/To/PartnerInformation / ContactInformation | EmailAddress | Y | Email address of the receiving company contact. | |
AGIISProductUpdate / Body / AGIISProductUpdateDetails / CompanyInformation | @ActiveFlag | Y | Indicates whether the company is active or inactive. Required. | Active, Inactive |
AGIISProductUpdate / Body / AGIISProductUpdateDetails / CompanyInformation | PartnerName | Y | Manufacturer name used to retrieve the records. | Bayer CropScience |
AGIISProductUpdate / Body / AGIISProductUpdateDetails / CompanyInformation | PartnerIdentifier | Y | Manufacturer's unique Identifier | 8097318700000 |
AGIISProductUpdate / Body / AGIISProductUpdateDetails / CompanyInformation / PartnerIdentifier | @Agency | Y | The type of unique identifier (EBID) | EBID |
AGIISProductUpdate / Body / AGIISProductUpdateDetails / CompanyInformation / AddressInformation | AddressLine1 | N | Manufacturer's physical address line 1. When doing e-Biz Connectivity, the correct address will be pulled forward through the EBID. If a company has multiple addresses, the correct address will show based on the EBID. | 123 South First Street |
AGIISProductUpdate / Body / AGIISProductUpdateDetails / CompanyInformation / AddressInformation | AddressLine2 | N | Manufacturer's physical address line 2. When doing e-Biz Connectivity, the correct address will be pulled forward through the EBID. If a company has multiple addresses, the correct address will show based on the EBID. | Suite 100 |
AGIISProductUpdate / Body / AGIISProductUpdateDetails / CompanyInformation / AddressInformation | CityName | N | Manufacturer's physical city | Minneapolis |
AGIISProductUpdate / Body / AGIISProductUpdateDetails / CompanyInformation / AddressInformation | StateOrProvince | N | Manufacturer's physical state/province. When doing e-Biz Connectivity, the correct address will be pulled forward through the EBID. If a company has multiple addresses, the correct address will show based on the EBID. | MN |
AGIISProductUpdate / Body / AGIISProductUpdateDetails / CompanyInformation / AddressInformation | PostalCode | N | Manufacturer's physical postal code. When doing e-Biz Connectivity, the correct address will be pulled forward through the EBID. If a company has multiple addresses, the correct address will show based on the EBID. | 55360 |
AGIISProductUpdate / Body / AGIISProductUpdateDetails / CompanyInformation / AddressInformation | PostalCounty | N | Manufacturer's postal county |
|
AGIISProductUpdate / Body / AGIISProductUpdateDetails / CompanyInformation / AddressInformation | FIPSCode | N | Manufacturer's FIPS code. Federal information processing standards codes (FIPS codes) |
|
AGIISProductUpdate / Body / AGIISProductUpdateDetails / CompanyInformation / AddressInformation | CountryName | N | Manufacturer's Country |
|
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / CompanyPrefixCode | @ActiveFlag | Y | Indicates whether the company prefix code is active or inactive. Required. | Active |
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / CompanyPrefixCode | CompanyPrefixCode | Y | A variable number issued by either the GS1 or AgGateway. The Co. Prefix Code is an element of the industry product code that uniquely identifies the manufacturer or company within that code. | 0785740 |
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / | URL | N | The subscriber's web site address. The full URL must be entered including the proper protocol, such as http:, ftp:, or https:. When doing e-Biz Connectivity, the correct URL will be pulled forward through the EBID. If a company has multiple URLs, the correct URL will show based on the EBID. |
|
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / | LastModifiedDateTime | N | If populated by the subscriber this field is ignored during product import but is automatically populated by the system. In a product extract this field contains the date\time the company information was last updated. System auto-populates if there is information at that level. |
|
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | @ActiveFlag | Y | Indicates whether the product is active or inactive. Changing the status of the product to Inactive will also change the status of all package size and package configuration records associated with the product. A warning message will be displayed to remind users of the automatic inactivation of package sizes and configurations. Required. | Active, Inactive |
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation / ProductIdentification | ProductIdentifier | Y | A unique number within your company that identifies the product. This is the manufacturer proprietary ID. Required. | 5501, AG0331 A3 |
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation / ProductIdentification | ProductName | Y | The registered name of the product. Required. | BCSX 0104B2F, AG0331 Diamir/Metalaxyl/Insecticide |
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | BrandName | Y | The manufacturer's name for the related grouping of products to which this product belongs. This field only displays if Primary Category selected is Seed. | BCSX, ASGROW |
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | ProductVariety | Y | The commercially used designation to represent the product in sales catalogs and literature. Required. | BCSX 0104B2F, AG0331 |
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | ProductMaturity | N | The amount of time that the seed requires prior to harvesting (a number of days e.g., 120) or the ideal seasonal growing zone for the seed product (a numeric value with or without a decimal, e.g., 4 or 3.1). Not a required field but should be defined for each crop for consistency. If no value is provided, default is '0'. |
|
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | ProductTraits | N | Specific biotech and non-biotech attributes associated with the genetics of the seed or germ plasma. The AGIIS length of the field is 255 characters. | LL, GENRR2Y |
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | ProductCrop | Y | Indicates the type of crop the seed will produce. Required. There is a code table for the Product Crop. That table can be found on the AgGateway and AGIIS website. | COTTON, Soybeans |
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | ProductTreatments | N | Processes and products applied to the seed. There is a code table for the ProductCrop. That table can be found on the AgGateway and AGIIS website. Value should "Untreated" or the specific treatment name. Recommendation is that it be a Required field. | BASE TREATMENT PACKAGE , Diamir/Metalaxyl/Insecticide; |
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | BuyingCompanyEBID | N | EBID Code of the company buying this product. This element is used when a product or the marketing rights has been purchased by another company. It is important to not only identify the company but the date the purchase takes into effect (see next item) |
|
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | OwnershipChangeDate | N | Date the product ownership changed to the current owner, if applicable. 2011- this element has been requested to be a Conditional Requirement that if the BuyingCompanyEBID is populated, then this element will be required to be populated. |
|
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | DateLastVerified | N | Date when the Product information was last verified. If this field is left blank, the system defaults to the current date during product add or update. Format ISO 8601 (yyyyMMddTHHmmss) | 20110504 |
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | PrimaryProductSegmentCode | Y | Indicates to which industry this product most closely belongs. Select the appropriate category. Packaging for material is listed under "Other" category. | SEED |
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | OtherProductSegmentCode | N | Indicates any additional categories to which this product belongs. More than one check box may be selected (cannot be the same as the Primary Category selected). |
|
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | OtherProductSegmentCode | N | Indicates any additional categories to which this product belongs. More than one check box may be selected (cannot be the same as the Primary Category selected). |
|
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | OtherProductSegmentCode | N | Indicates any additional categories to which this product belongs. More than one check box may be selected (cannot be the same as the Primary Category selected). |
|
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | EPARegistrationNumber | N | Required if the product category is chemical. Seeds does not have an EPA registration number. | NA |
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | UserdefinedField1 | N | Up to three Subscriber-defined fields that allow related data to be collected for this product record. Enter relevant information. | MTA2 |
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | UserdefinedField2 | N | Up to three Subscriber-defined fields that allow related data to be collected for this product record. Enter relevant information. Recommendation is to use this field as "GPOS Reportable". |
|
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | UserdefinedField3 | N | Up to three Subscriber-defined fields that allow related data to be collected for this product record. Enter relevant information. |
|
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation | LastModifiedDateTime | N | If populated by the subscriber this field is ignored during product import but is automatically populated by the system. In a product extract this field contains the date\time the product information was last updated. System auto-populates if there is information at that level. |
|
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation / LinkedAgreementInformation | PartnerIdentifier | CR | The unique identifier of the Agreement Owner. | 0062668030000 |
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation / LinkedAgreementInformation | @Agency | CR | The type of unique identifier (EBID) | EBID |
AGIISProductUpdate / Body / AGIISProductUpdateDetails /CompanyInformation / ProductInformation / LinkedAgreementInformation | AgreementCode |