Product Classification Data Mapping

HTS (Harmonized Tariff Schedule) Mapping

The product classification data is saved in the GTM_PROD_CLASS_CODE table. The following table gives the data saved to the GTM_PROD_CLASS_CODE table.

Product Classification Code Table

File Name Content Provider Element GTM Element Description
_MASTER mstr_id GTM_PROD_CLASS_CODE_GID

Unique identifier used by GTM to create a classification code for a particular version.

Product Classification Code ID is a concatenation of Data_Version_ID+’_’+mstr_id.

To identify the classification code based on the data version.

_MASTER data_type+iso_country GTM_PROD_CLASS_TYPE_GID

Product Classification Type is a concatenation of data_type + <space> + (2-digit)country_code

Eg: data_type is HTS and country is US. Product Classification Type would be ‘HTS US’.

_MASTER hscode CLASSIFICATION_CODE Actual Product Classification Code from the harmonized tariff
_MASTER eff_beg_dt EFFECTIVE_DATE The date from which the classification code is active
_MASTER eff_end_dt EXPIRATION_DATE Expiration date of the classification code
_MASTER section_number SECTION Section number provided by HS
_MASTER chapter CHAPTER Chapter number provided by HS
The description of the product classification code based on the language is saved in the GTM_PROD_CLASS_CODE_DESC table.

Product Classification Code Description Table

File Name Content Provider Element GTM Element Description
_MASTER iso_language GTM_LANGUAGE_GID Language
_MASTER full_desc DESCRIPTION Description up to 3997 characters followed by ‘…’ is taken
The notes designed to clarify the proper classification of goods is saved in the table GTM_PROD_CLASS_CODE_NOTES.

Product Classification Code Notes Table

File Name Content Provider Element GTM Element Description
NOTE_TYPE Value : ‘Notes’
_MASTER notes NOTE_VALUE Notes up to 3997 characters followed by ‘…’ is taken
GTM derives the data related to the following attributes from the third party content provider and the respective attribute value is saved as ATTRIBUTE_VALUE for an ATTRIBUTE_NAME in the GTM_CLASS_CODE_ATTRIBUTE table.

Product Classification Code Attribute Table

File Name Content Provider Element GTM Element Description
_ATTRIBUTE attribute ATTRIBUTE_NAME Attribute name for the Classification code
_ATTRIBUTE value ATTRIBUTE_VALUE Attribute Value for the Attribute Name. There can be multiple values applicable for same attribute name. For example, OGA, PGA can have multiple values.
_ATTRIBUTE description ATTRIBUTE_DESCRIPTION Description for the attribute value applicable.
Following are the attribute names supported for HTS. The following list of attributes is explicitly coded in the data loader since an early release of GTM. However, to support flexibility in naming conventions and enable global content updates as regulatory changes occur, content partners are encouraged to use the more flexible ATTRIBUTE structure enumerated above.

Attribute Name Table

GTM Attribute Name Description
OGA Other Government Agency Indicator
PGA Participating Government Agency Indicator
ADD_FLAG Anti-Dumping Duties Flag
CVD_FLAG Countervailing Duties Flag
SITC Standard International Trade Classification
ENDUSE_CD End Use Classification
ASUSDA_FLAG ASUSDA Flag
NAICS North American Industry Classification System (NAICS) Classification
HITECH Hi-Tech Flag
QUOTA_INDICATOR Quota Program Indicator
SHORT_DESCRIPTION A shortened version of the tariff description often used for printing on documentation
IS_AES_REPORTABLE Indicator that the HS code can be used for US Export Declarations (AES Filing). If not populated, a Schedule-B Code must be submitted instead.
LACEY Lacey Act Flag
GTM supports download of unit of measure (UOM) details at classification code level for reporting the quantities of goods being imported or exported. These details are saved in the GTM_PROD_CLASS_CODE_UOM table. The following table gives the mapping of the UOM details saved to the GTM_PROD_CLASS_CODE_UOM table.

Product Classification Code UOM Table

File Name Content Provider Element GTM Element Description
_UOM name UOM_NAME Identifies the parameter name for which the unit of measure needs to be reported. The value can be either REPORTING UOM 1, REPORTING UOM 2.
_UOM oracle_unit_code UOM_CODE Standard UOM in which the quantity should be send.
_UOM country_specific_UOM REPORTING_UOM UOM in which the quantity should be reported.
In order to preserve the hierarchy of the product classification codes, the product classification data is saved in the GTM_PROD_CLASS_CODE_PART table. The following table gives the data saved to the GTM_PROD_CLASS_CODE_PART table.

Product Classification Code Part Table

File Name Content Provider Element GTM Element Description
_PART part_id GTM_PROD_CLASS_CODE_PART_GID Product Classification Code Part ID is created by concatenating the Data Version ID and part_id with an underscore ‘_’.
_PART part_hscode CLASSIFICATION_CODE_PART Classification Code
_PART parent_id PARENT_GID

parent_id is the parent part ID and its detail must be present in the same file.

Concatenation of Dataversion_parent_id is saved as Parent GID. This is used to display the classification code details in tree format.

ROOT_GID Chapter for the product classification code
The description of the product classification code based on the language is saved in the GTM_PROD_CLASS_CODE_PART_DESC table.

Product Classification Code Part Description Table

File Name Content Provider Element GTM Element Description
_PART iso_language GTM_LANGUAGE_GID Language
_PART part_desc DESCRIPTION Description up to 3997 characters followed by ‘…’ is taken

Tariff Details Mapping

The trade program types are saved in the table GTM_TARIFF_TYPE.

Tariff Type Table

File Name Content Provider Element GTM Element Description
_TRADE_PROGRAM_TYPES TRADE_PROGRAM_TYPE GTM_TARIFF_TYPE_GID Trade Program Type ID
_TRADE_PROGRAM_TYPES TRADE_PROGRAM_TYPE_DESCRIPTION TARIFF_TYPE_NAME Trade Program Name
_TRADE_PROGRAM_TYPES TRADE_PROGRAM_TYPE EXTERNAL_REFERENCE_CODE External Code for Trade Program Type

HTS (Harmonized Tariff Schedule) Tariff Schedule Mapping

The trade programs are saved in the table GTM_TARIFF_CODE.

Tariff Code Table

File Name Content Provider Element GTM Element Description
_TRADE_PROGRAM TRADE_PROGRAM_ID GTM_TARIFF_CODE_GID

Unique identifier used by GTM to create trade program for a particular version.

Trade Program ID is a concatenation of Data_Version_ID+’_’+Product ClassificationType+’_’+ TRADE_PROGRAM_ID.

To identify the trade program based on the data version and product classification type.

_TRADE_PROGRAM SHORT_NAME TARIFF_CODE_SHORT_NAME Trade Program Short Name
_TRADE_PROGRAM NAME TARIFF_CODE_NAME Trade Program Name
_TRADE_PROGRAM FTA_ID GTM_TRADE_AGREEMENT Trade Agreement Short Name
_TRADE_PROGRAM IS_INCLUDED IS_INCLUDE_COUNTRY Specifies if the countries mentioned in the table TARIFF_COUNTRY are included or excluded in the rate calculation for trade program.
_TRADE_PROGRAM TRADE_PROGRAM_TYPE_ID GTM_TARIFF_TYPE_GID Trade Program Type ID
_TRADE_PROGRAM IS_DEFAULT_TRADE_PROGRAM IS_DEFAULT Specifies if the trade program is the default.
_TRADE_PROGRAM TRADE_PREFERENCE+COUNTRY_CODE2 GTM_TRADE_PREFERENCE_GID Trade Preference ID is the concatenation of TRADE_PREFERENCE+’-’+COUNTRY_CODE2
_TRADE_PROGRAM TRADE_PROGRAM_ID EXTERNAL_REFERENCE_CODE External Code for Trade Program

Trade Preferences are saved in the table GTM_TRADE_PREFERENCE. (This is not for a particular data version and is saved as master data of trade preferences.)

Trade Preference Table

File Name Content Provider Element GTM Element Description
_TRADE_PROGRAM TRADE_PREFERENCE+COUNTRY_CODE2 GTM_TRADE_PREFERENCE_GID

Unique identifier used by GTM to create trade preference.

Trade Preference ID is a concatenation of TRADE_PREFERENCE+’-’+COUNTRY_CODE2

_TRADE_PROGRAM TRADE_PREFERENCE CODE Trade Preference Name
The member nations related to the trade program are saved in the table GTM_TARIFF_COUNTRY. This table captures the list of countries to be included or excluded in the rate calculation related to a trade program.

Tariff Country Table

File Name Content Provider Element GTM Element Description
_TARIFF_COUNTRIES TRADE_PROGRAM_ID GTM_TARIFF_CODE_GID

Unique identifier used by GTM to create trade program for a particular version.

Trade Program ID is a concatenation of Data_Version_ID+’_’+Product ClassificationType+’_’+ TRADE_PROGRAM_ID.

To identify the trade program based on the data version and product classification type.

_TARIFF_COUNTRIES ORIGIN_COUNTRY_CD COUNTRY_CODE3_GID Country Code ID. It is a 2-digit country code.
The tariff rates are saved in the table GTM_TARIFF_RATE. This table captures the tariff rate related to a classification code.

Tariff Rate Table

File Name Content Provider Element GTM Element Description
_TARIFF_RATE TRADE_PROGRAM_ID GTM_TARIFF_CODE_GID

Unique identifier used by GTM to create trade program for a particular version.

Trade Program ID is a concatenation of Data_Version_ID+’_’+Product ClassificationType+’_’+ TRADE_PROGRAM_ID.

To identify the trade program based on the data version and product classification type.

_TARIFF_RATE CLASSIFICATION_CODE CLASSIFICATION_CODE Product Classification Code
_TARIFF_RATE ADDVALOREM_RATE ADDVALOREM_RATE The percentage rate used for calculating the tariffs based on the value of goods imported.
_TARIFF_RATE PER_UNIT_CHARGE PER_UNIT_CHARGE The amount to be paid as tariff for each unit of goods imported.
_TARIFF_RATE UNIT_CODE UOM_CODE The UOM code to use with per unit charge.
The details of the trade agreements are saved in the GTM_TRADE_AGREEMENTS table.

Trade Agreements Table

File Name Content Provider Element GTM Element Description
_ROO_TRADE_AGREEMENTS fta_id GTM_TRADE_AGREEMENT_GID Trade Agreement ID
_ROO_TRADE_AGREEMENTS fta_id EXTERNAL_REFERENCE_CODE Trade Agreement ID
_ROO_TRADE_AGREEMENTS shortname GTM_TA_SHORT_NAME Short Name
_ROO_TRADE_AGREEMENTS fta_name GTM_TA_NAME Name
_ROO_TRADE_AGREEMENTS Fta_type GTM_TA_TYPE_GID Trade Agreement Type
_ROO_TRADE_AGREEMENTS effective_Date EFFECTIVE_DATE Effective Date
_ROO_TRADE_AGREEMENTS expiration_Date EXPIRATION_DATE Expiration Date
Note: Supported fta_type values are PREFERENTIAL and NON-PREFERENTIAL
Note: Download of Schedule B classification data is modeled the same as HS type.

ECCN (Dual-Use Export Control Classification Numbers) Mapping

ECCN Mapping Table

File Name Content Provider Element GTM Element Description
_MASTER mstr_id GTM_PROD_CLASS_CODE_GID

Unique identifier used by GTM to create classification code for a particular version.

Product Classification Code ID is a concatenation of Data_Version_ID+’_’+mstr_id.

To identify the classification code based on the data version.

_MASTER ‘ECCN ‘ + iso_country GTM_PROD_CLASS_TYPE_GID

Product Classification Type is a concatenation of data_type + <space> + (2-digit)country_code

Eg: For country = US, Product Classification Type would be ‘ECCN US’.

_MASTER eccn_no CLASSIFICATION_CODE Actual Product Classification Code
_MASTER eff_beg_dt EFFECTIVE_DATE The date from which the classification code is active
_MASTER eff_end_dt EXPIRATION_DATE Expiration date of the classification code
The description of the product classification code based on the language is saved in the GTM_PROD_CLASS_CODE_DESC table.

Product Classification Code Description Table

File Name Content Provider Element GTM Element Description
_MASTER iso_language GTM_LANGUAGE_GID Language
_MASTER eccn_desc DESCRIPTION Description up to 3997 characters followed by ‘…’ is taken
The notes designed to clarify the proper classification of goods is saved in the table GTM_PROD_CLASS_CODE_NOTES.

Product Classification Code Notes Table

File Name Content Provider Element GTM Element Description
_MASTER NOTE_TYPE Value : ‘Notes’
_MASTER notes NOTE_VALUE Notes up to 3997 characters followed by ‘…’ is taken
GTM derives the data related to the following attributes from the third party content provider and the respective attribute value is saved as ATTRIBUTE_VALUE for an ATTRIBUTE_NAME in the GTM_CLASS_CODE_ATTRIBUTE table.

Classification Code Attribute Table

File Name Content Provider Element GTM Element Description
_MASTER unit UNIT Units of Measure
_MASTER at CONTROL-AT Reason for Control: Anti-Terrorism
_MASTER at1 CONTROL-AT1 Reason for Control: Anti-Terrorism Column 1
_MASTER at2 CONTROL-AT2 Reason for Control: Anti-Terrorism Column 2
_MASTER cb CONTROL-CB Reason for Control: Chemical & Biological Weapons
_MASTER cb1 CONTROL-CB1 Reason for Control: Chemical & Biological Weapons Column 1
_MASTER cb2 CONTROL-CB2 Reason for Control: Chemical & Biological Weapons Column 2
_MASTER cb3 CONTROL-CB3 Reason for Control: Chemical & Biological Weapons Column 3
_MASTER cc CONTROL-CC Reason for Control: Crime Control
_MASTER cc1 CONTROL-CC1 Reason for Control: Crime Control Column 1
_MASTER cc2 CONTROL-CC2 Reason for Control: Crime Control Column 2
_MASTER cc3 CONTROL-CC3 Reason for Control: Crime Control Column 3
_MASTER cw CONTROL-CW Reason for Control: Chemical Weapons
_MASTER ei CONTROL-EI Reason for Control: Encryption Items
_MASTER fc1 CONTROL-FC1 Reason for Control: Firearms Convention Column 1
_MASTER mt1 CONTROL-MT1 Reason for Control: Missile Tech Column 1
_MASTER mt2 CONTROL-MT2 Reason for Control: Missile Tech Column 2
_MASTER np CONTROL-NP Reason for Control: Nuclear Nonproliferation
_MASTER np1 CONTROL-NP1 Reason for Control: Nuclear Nonproliferation Column 1
_MASTER np2 CONTROL-NP2 Reason for Control: Nuclear Nonproliferation Column 2
_MASTER ns1 CONTROL-NS1 Reason for Control: National Security Column 1
_MASTER ns2 CONTROL-NS2 Reason for Control: National Security Column 2
_MASTER rs CONTROL-RS Reason for Control: Regional Stability
_MASTER rs1 CONTROL-RS1 Reason for Control: Regional Stability Column 1
_MASTER rs2 CONTROL-RS2 Reason for Control: Regional Stability Column 2
_MASTER si CONTROL-SI Reason for Control: Significant Items
_MASTER sl CONTROL-SL Reason for Control: Surreptitious Listening
_MASTER ss CONTROL-SS Reason for Control: Short Supply
_MASTER un CONTROL-UN Reason for Control: United Nations Embargo
_MASTER z CONTROL-Z Generic attribute for items regulated by other agencies
_MASTER agr EXCEPTION-AGR License Exception: Agricultural Commodities
_MASTER app EXCEPTION-APP License Exception: Computers
_MASTER apr EXCEPTION-APR License Exception: Additional Permissive Re-exports
_MASTER avs EXCEPTION-AVS License Exception: Aircraft, Vessels and Spacecraft
_MASTER bag EXCEPTION-BAG License Exception: Baggage
_MASTER civ EXCEPTION-CIV License Exception: Civil End-Users
_MASTER enc EXCEPTION-ENC License Exception: Encryption Commodities, Software and Technology
_MASTER gbs EXCEPTION-GBS License Exception: Shipments to Country Group B Countries
_MASTER gft EXCEPTION-GFT License Exception: Gift Parcels and Humanitarian Donations
_MASTER gov EXCEPTION-GOV License Exception: Governments, International Organizations, International Inspections Under the Chemical Weapons Convention, and the International Space Station
_MASTER kmi EXCEPTION-KMI License Exception: Key Management Infrastructure – Amendments Only
_MASTER lvs EXCEPTION-LVS License Exception: Shipments of Limited Value
_MASTER rpl EXCEPTION-RPL License Exception: Servicing and Replacement of Parts and Equipment
_MASTER sta EXCEPTION-STA License Exception: Strategic Trade Authorization
_MASTER tmp EXCEPTION-TMP License Exception: Temporary Imports, Exports, Reexports, and Transfers (In-Country)
_MASTER tsr EXCEPTION-TSR License Exception: Technology and Software Under Restriction
_MASTER tsu EXCEPTION-TSU License Exception: Technology and Software Unrestricted
In order to preserve the hierarchy of the product classification codes, the product classification data is saved in the GTM_PROD_CLASS_CODE_PART table. The following table gives the data saved to the GTM_PROD_CLASS_CODE_PART table.

Product Classification Code Part Table

File Name Content Provider Element GTM Element Description
_PART part_id GTM_PROD_CLASS_CODE_PART_GID Product Classification Code Part ID is created by concatenating the Data Version ID and part_id with an underscore ‘_’.
_PART eccn_no CLASSIFICATION_CODE_PART Classification Code
_PART parent_id PARENT_GID Concatenation of Dataversion_parent_id is saved as Parent GID. This is used to display the classification code details in tree format.
ROOT_GID Chapter for the product classification code
The description of the product classification code based on the language is saved in the GTM_PROD_CLASS_CODE_PART_DESC table.

Product Classification Code Part Description Table

File Name Content Provider Element GTM Element Description
_PART iso_language GTM_LANGUAGE_GID Language
_PART eccn_desc DESCRIPTION Description up to 3997 characters followed by ‘…’ is taken

ML (Munitions List) Mapping

ML Mapping Table

File Name Content Provider Element GTM Element Description
_MASTER id GTM_PROD_CLASS_CODE_GID

Unique identifier used by GTM to create classification code for a particular version.

Product Classification Code ID is a concatenation of Data_Version_ID+’_’+ id.

To identify the classification code based on the data version.

_MASTER country_cd GTM_PROD_CLASS_TYPE_GID

Product Classification Type is a concatenation of ML + <space> + (2-digit) country_code

Eg: For country US, Product Classification Type would be ‘ML US’.

_MASTER ml_code CLASSIFICATION_CODE Actual Product Classification Code
The description of the product classification code based on the language is saved in the GTM_PROD_CLASS_CODE_DESC table.

Product Classification Code Description Table

File Name Content Provider Element GTM Element Description
_MASTER iso_language GTM_LANGUAGE_GID Language
_MASTER ml_desc DESCRIPTION Description up to 3997 characters followed by ‘…’ is taken
GTM derives the data related to the following notes from the third party content provider and the respective note value is saved as NOTE_VALUE (maximum 4000 characters) for an NOTE_TYPE in the GTM_PROD_CLASS_CODE_NOTES table.

Product Classification Code Notes Table

File Name Content Provider Element GTM Element Description
_MASTER note NOTE Description up to 3997 characters followed by ‘…’ is taken
_MASTER note1 NOTE1 Description up to 3997 characters followed by ‘…’ is taken
_MASTER note2 NOTE2 Description up to 3997 characters followed by ‘…’ is taken
_MASTER note3 NOTE3 Description up to 3997 characters followed by ‘…’ is taken
_MASTER note4 NOTE4 Description up to 3997 characters followed by ‘…’ is taken
_MASTER note5 NOTE5 Description up to 3997 characters followed by ‘…’ is taken
_MASTER note6 NOTE6 Description up to 3997 characters followed by ‘…’ is taken
GTM derives the data related to the following attributes from the third party content provider and the respective attribute value is saved as ATTRIBUTE_VALUE for an ATTRIBUTE_NAME in the GTM_CLASS_CODE_ATTRIBUTE table.

Classification Code Attribute Table

_MASTER sme_ind SME INDICATOR Significant Military Equipment Indicator
In order to preserve the hierarchy of the product classification codes, the product classification data is saved in the GTM_PROD_CLASS_CODE_PART table. The following table gives the data saved to the GTM_PROD_CLASS_CODE_PART table.

Product Classification Code Part Table

File Name Content Provider Element GTM Element Description
_PART ID GTM_PROD_CLASS_CODE_PART_GID Product Classification Code Part ID is created by concatenating the Data Version ID and part_id with an underscore ‘_’.
_PART ml_code CLASSIFICATION_CODE_PART Classification Code
_PART parent_id PARENT_GID Concatenation of Dataversion_parent_id is saved as Parent GID. This is used to display the classification code details in tree format.
ROOT_GID Chapter for the product classification code
The description of the product classification code based on the language is saved in the GTM_PROD_CLASS_CODE_PART_DESC table.

Product Classification Code Part Description Table

File Name Content Provider Element GTM Element Description
_PART iso_language GTM_LANGUAGE_GID Language
_PART ml_desc DESCRIPTION Description up to 3997 characters followed by ‘…’ is taken