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

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.

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

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

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

File Name

Content Provider Element

GTM Element

Description

_MASTER

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

Classification Code Attribute Table


_MASTER	sme_ind	SME INDICATOR	Significant Military Equipment Indicator

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