Rules of Origin Data Mapping

The details of the trade agreements is 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.

The partners of the trade agreements is saved in the GTM_TA_PARTNERS table.

Trade Agreement Partners Table

File Name Cntent Provider Element GTM Element Description
_ROO_TRADEAGREEMENTS_PARTNERS fta_id GTM_TRADE_AGREEMENT_GID Trade Agreement ID
_ROO_TRADEAGREEMENTS_PARTNERS Partner_Name REGION_GID

Region ID

Cocatenation of partner_name+”_”+fta_id

_ROO_TRADEAGREEMENTS_PARTNERS Iso_Country_Cd COUNTRY_CODE3_GID Country Code ID
The details of the rules of origin is saved in the GTM_RULES_OF_ORIGIN table.

Rules of Origin Table

File Name Content Provider Element GTM Element Description
_ROO_HEADER roo_id

GTM_RULES_OF_ORIGIN_GID

GTM_RULES_OF_ORIGIN_XID

Unique identifier used by GTM to create rules of origin ID for a particular version.

Rules of Origin ID is a concatenation of Data_Version_ID+’_’+ id.

For Example: If the data version is 26877and rool_id is EU_GB, ID is created as 26877_EU_GB

To identify the rules of origin based on the data version.

_ROO_HEADER name GTM_RULES_OF_ORIGIN_NAME Rules of Origin Name
_ROO_HEADER roo_id SHORT_NAME Short Name
_ROO_HEADER roo_id EXTERNAL_REFERENCE_CODE External Reference Code
_ROO_HEADER Rule_type GTM_RULES_OF_ORIGIN_TYPE Rules of Origin Type
_ROO_HEADER Fta_id TRADE_AGREEMENT_SHORT_NAME Trade Agreement Name
_ROO_HEADER End_dt EXPIRATION_DATE Expiration Date
_ROO_HEADER Partner_name REGION_GID

Identifies the region for which the Rules of origin is applicable.

If it is a region in trade_agreement_partners, region_gid is created

_ROO_HEADER Partner_name COUNTRY_CODE3_GID

Identifies the country of import for which the Rules of origin is applicable.

If it is a country code in trade_agreement_partners, country_code3_gid is created

_ROO_HEADER Version_number -- Not mapped to any GTM element. It is used to uniquely identify the roo_header file as a mapping for rule of origin data
The details of the product specific rules is saved in the GTM_ROO_PSR table.

Product Specific Rules Table

File Name Content Provider Element GTM Element Description
_ROO_PSRULES roo_id

GTM_RULES_OF_ORIGIN_GID

Rules of Origin ID is a concatenation of Data_Version_ID+’_’+ id.

For Example: If the data version is 26877and rool_id is EU_GB, ID is created as 26877_EU_GB

To identify the rules of origin based on the data version.

_ROO_PSRULES Hs_Start START_CLASSIFICATION_CODE Defines the code level starting range
_ROO_PSRULES Hs_end END_CLASSIFICATION_CODE Defines the code level ending range.
_ROO_PSRULES Suffix SUFFIX Holds the suffix value.
_ROO_PSRULES Ex IS_EX Determines if rollup to parent Harmonized System code is needed.
_ROO_PSRULES Attribute ATTRIBUTE Holds the description.
_ROO_PSRULES Rule_Expression EXPRESSION

Note : The expression should be in the below format

· {ruleCode1}

· {ruleCode1} OR {ruleCode2}

· {ruleCode1} AND {ruleCode2}

· ({ruleCode1}) AND ({ruleCode2} AND {ruleCode3})For example,

· ({TS4_100EQ}) OR ({RVCT_50GE} AND {TS6_100EQ})· {EXCL:17} AND {TS2_100EQ}

The details of the product specific rule codes is saved in the GTM_ROO_RULE_CODE table.

Rule Codes Table

File Name Content Provider Element GTM Element Description
_ROO_PSRULE_CODES roo_id GTM_RULES_OF_ORIGIN_GID

Rules of Origin ID is a concatenation of Data_Version_ID+’_’+ id.

For Example: If the data version is 26877and rool_id is EU_GB, ID is created as 26877_EU_GB

To identify the rules of origin based on the data version.

_ROO_PSRULE_CODES rule GTM_ROO_RULE_CODE_GID

Rules of Origin Code ID is a concatenation of Data_Version_ID+’_’+ roo_id+”_”+rule.

For Example: If the data version is 26877, rool_id is EU_GB and rule is ‘DMN_10LE’, ID is created as 26877_EU_GB_DMN_10LE

To identify the rules of origin codes based on the data version and rules of origin.

_ROO_PSRULE_CODES Rule GTM_ROO_RULE_CODE_NAME Rule Code Name
_ROO_PSRULE_CODES Rule EXTERNAL_REFERENCE_CODE External Reference Code
_ROO_PSRULE_CODES Rule_Type GTM_ROO_RULE_TYPE_GID Rules of Origin Type
_ROO_PSRULE_CODES HS_Start START_CLASSIFICATION_CODE Defines the code level starting range.
_ROO_PSRULE_CODES HS_End END_CLASSIFICATION_CODE Defines the code level ending range.
_ROO_PSRULE_CODES Percentage PERCENTAGE_VALUE Stores the percentage value.
_ROO_PSRULE_CODES Operator PERCENTAGE_OPERATOR Stores the percentage operator. The values can be any of <,>,<=,>=,=
Note:
The following rule type values supported:
  • THIRD COUNTRY CHECK
  • FIFTY, CONDITION
  • HS EXCLUSION
  • HS INCLUSION
  • RVC – NC
  • RVC – TV
  • RVC – UP
  • RVC – DOWN
  • TS – CHAPTER
  • TS – HEADING
  • TS – SUBHEADING
  • TS - ITEM
  • NTS – CHAPTER
  • NTS – HEADING
  • NTS – SUBHEADING
  • NTS – ITEM
The descriptions of the product specific rule codes is saved in the GTM_ROO_RULE_CODE_DESC table.

Rule Code Description Table

File Name Content Provider Element GTM Element Description
_ROO_PSRULE_CODE_DESCS Rule GTM_ROO_RULE_CODE_GID

Rules of Origin Code ID is a concatenation of Data_Version_ID+’_’+ roo_id+”_”+rule.

For Example: If the data version is 26877, rool_id is EU_GB and rule is ‘DMN_10LE’, ID is created as 26877_EU_GB_DMN_10LE

To identify the rules of origin codes based on the data version and rules of origin.

_ROO_PSRULE_CODE_DESCS language GTM_LANGUAGE_GID Language
_ROO_PSRULE_CODE_DESCS Text TEXT Description
The details of the base rules is saved in the GTM_ROO_BASE_RULE table.

Base Rule table

File Name Content Provider Element GTM Element Description
_ROO_BASE_RULES roo_id GTM_RULES_OF_ORIGIN_GID

Rules of Origin ID is a concatenation of Data_Version_ID+’_’+ id.

For Example: If the data version is 26877and rool_id is EU_GB, ID is created as 26877_EU_GB

To identify the rules of origin based on the data version.

_ROO_BASE_RULES base_rule_type_name GTM_ROO_BASE_RULE_TYPE The rules of origin base rule type can be any of the values: DEMIN, SETOFGOODS or MINOPS
_ROO_BASE_RULES base_rule_code EXPRESSION The expression for rules of origin base rule.
Following is the format of the base rule expression:

Base Rule Expression Format

ROO_BASE_RULE_TYPE Expression Format
DEMIN {DMN_10LE}
SETOFGOODS {SOG_10LE}
MINOPS {MOP_00EQ}