Catalog Glossary

Altana Catalog Glossary

Transactions

Field

Type

Description

Transaction ID

UUID

A unique identifier for the transaction represented by the edge

Transaction Date

Date (YYYY-MM-DD H:mm:ss)

The date of the underlying transaction. For import records, this will be the customs clearance date or customs import release date. For exports, this is the date when the consignment left the country.

Sender Name

String

The name of the sending party

Sender Full Address

String

The full address of the sender

Receiver Name

String

The name of the receiving party

Receiver Full Address

String

The address of the receiving party

HS Code

String

The harmonized system tariff code classifying the goods on the transaction

HS6 Code

String

The six-digit, if applicable, version of the harmonized system (HS) code on the transaction

HS6 Details

String

The description of the six-digit HS code on the transaction

Goods Description

String

The description of the goods listed on the transaction

Quantity

Integer

The listed quantity of goods on the transaction record

Quantity Unit

String

The unit type of quantity on the transaction record

KG Net

Integer

The net weight of the goods on the transaction

KG Gross

Integer

The gross weight of goods on the transaction

IMO Number

String

A unique seven-digit number assigned to a ship by the International Maritime Organization (IMO)

Data Source Country

String

The country customs authority listed on the transaction record

Country of Origin ISO Alpha2

String

The origin country of the goods on the transaction, in ISO Alpha 2-digit format (e.g. 'United States' = 'US')

Country of Destination ISO Alpha2

String

The destination country of the goods on the transaction, in ISO Alpha 2-digit format (e.g. 'United States' = 'US')

Product ID

UUID

Unique identifier for the product, from which a multi-tier network originates. For example, Product 'Photolithography Machine' has a unique Product ID, Tier 0 Suppliers (receivers of photolithography machines), Tier 1 Suppliers (senders of finished photolithography machines or relevant inputs, such as specific optics, or electronic inputs), Tier 2 Suppliers (senders to Tier 1 of relevant inputs), etc. These relationships include physical shipment transactions in the transaction_table.

Product Name

String

The unique name for a Product, from which a multi-tier network originates

Source ID

UUID

The Altana facility canon ID for the sender facility in the transaction

Source Operating Company ID

UUID

The Altana company canon ID operating the sender facility in the transaction

Source Operating Company Name

UUID

The Altana company name operating the sender facility in the transaction

Source Address

String

The address of the facility sending the goods in the transaction

Destination ID

UUID

The Altana facility canon ID for the receiver facility in the transaction

Destination Operating Company ID

UUID

The Altana company canon ID operating the receiver facility in the transaction

Destination Operating Company Name

String

The Altana company name operating the receiver facility in the transaction

Destination Address

String

The address of the facility receiving the goods in the transaction

Bill of Lading Number

String

The number created by the shipper to identify the shipment

Mode of Transport

String

The transportation method used to move the goods (e.g. AIR, RAIL, SEA, etc.)

Container Number

String

The container number that goods were transported in

Monetary Value FOB

Integer

The Free on Board (FOB) monetary value of the goods

Monetary Unit FOB

String

The units of the Free on Board (FOB) monetary value

Port of Origin

String

The name of the port where the goods originated

Port of Origin Country

String

The country of the port where the goods originated

Port of Lading

String

The name of the port from where goods are sent (or laded)

Port of Lading Country

String

The country of the port from where goods are sent

Port of Unlading

String

The name of the port where goods are received from

Port of Unlading Country

String

The country of the port from where goods are received (or unladed)

Port of Destination

String

The arrival port of the goods

Port of Destination Country

String

The country of the arrival port of the goods

Receiver Tier

String

The tier in the multi-tier value chain at which the goods were received

Sender Tier

String

The tier in the multi-tier value chain at which the goods were sent

Analytical USD Value

Float

Altana-derived analytical United States dollar valuation estimation of the goods

Estimated Price-per-Unit Confidence

Float

Altana-derived estimated price per unit confidence score

Potential ECCN(s)

String

Altana-derived potential licenses needed for shipment, based on jurisdiction and good type (HS code)

Estimated Value FOB (USD)

Float

Altana-derived estimated Free on Board (FOB) value

Translation of goods description

String

Altana-derived translation of goods description

Analytical HS Code

String

Altana-derived HS code

Last Known Voyage #

String

Last known voyage number of vessel involved in transaction

Last Known Location - City

String

Last known location of Vessel in transaction

Shipment Movement Log

String

Shipment movement log for the transaction

Calculated Price-per-Unit

Float

Altana-derived price per unit calculation

Estimated Value FOB Confidence

Float

Confidence score for Altana-derived Estimated Free on Board (FOB) value calculation

Citation Note

String

Citation for sourcing on data provenance

Estimated Price-per-Unit (Upper Bound)

Float

Upper bound of estimated price per unit calculation

Value FOB USD Conversion

Float

Free on Board (FOB) value converted to 2023 United States dollar values

Calculated Weight-per-Unit (kg)

Float

Altana-derived weight per unit values

Estimated Value FOB (Upper Bound)

Float

Altana-derived upper bound of Estimated Free on Board (FOB) values

Estimated Value FOB (Lower Bound)

Float

Altana-derived lower bound of Estimated Free on Board (FOB) values

Estimated Price-per-Unit (USD)

Float

Altana-derived price per unit calculation

Normalized Quantity Unit

String

Quantity unit lowercased, normalized

Estimated Price-per-Unit (Lower Bound)

Float

Lower bound of Altana-derived estimated price per unit

Products

Field

Type

Description

Product ID

UUID

Unique identifier for the product, from which a multi-tier network originates. For example, Product 'Photolithography Machine' has a unique Product ID, Tier 0 Suppliers (receivers of photolithography machines), Tier 1 Suppliers (senders of finished photolithography machines or relevant inputs, such as specific optics, or electriconic inputs), Tier 2 Suppliers (senders to Tier 1 of relevant inputs), etc. These relationships include physical shipment transactions in the transaction_table.

Product Name

String

The unique name for a Product, from which a multi-tier network originates

Upstream Supplier Count

Integer

Number of upstream suppliers in the multi-tier network

Exposure Count

Integer

Number of risk exposed suppliers in the multi-tier network

Suppliers

Field

Type

Description

Product ID

UUID

Facility ID

UUID

Unique identifier for the Altana facility canon ID of the supplier

Value Chain ID

Unique ID for a group of products and their multi-tier networks, known as a value chain

Product Name

String

The unique name for a Product, from which a multi-tier network originates

Company Name

String

The Altana company name of the supplier

Tier

String - Categorical (0, 1, 2, 3, ...n)

The supplier tier in the multi tier network, ending at the Tier 0 finished product

Facility Address

String

The address of the facility in the value chain network

Country

String

The country of the facility in the value chain network

Last Transaction Date

Date (YYYY-MM-DD)

Latest date at which this facility sent or received goods in the Altana system

Transaction Count

Integer

Number of shipment transactions in a given value chain network, for a given supplier

Status

String - Categorical (Not Assessed, In Review, Escalated, Not Trusted, Reviewed, Approved)

The user-defined status of the exposed facility. This is a categorical field with possible values 'Not Assessed', 'In Review', 'Escalated', 'Not Trusted', 'Reviewed, Approved'.

Company ID

UUID

The Altana company canon ID for the supplier

Broad Sanctions Count

Integer

Number of unique suppliers flagged on exposures lists classified as exposure category 'Broad Sanctions', which includes specific Risk Lists such as the 'Non-SDN Chinese Military-Industrial Complex Companies List (OFAC)' from Issuing Authority 'US Dept. of Treasury'. Preferences for categorized risk importance can be user defined in the user-admin panel.

Broad Sanctions Importance

String

Corruption/Fraud Count

Integer

Number of unique suppliers flagged on exposures lists classified as exposure category 'Corruption/Fraud'

Corruption/Fraud Importance

String

Countermeasures Count

Integer

Number of unique suppliers flagged on exposures lists classified as exposure category 'Countermeasures'. This field includes lists with potential for adversarial foreign control from the perspective of the United States Defense Industrial Base.

Countermeasures Importance

String

Criminal Indictments or Wanted Persons Count

Integer

Number of unique suppliers flagged on exposures lists classified as exposure category 'Criminal Indictments or Wanted Persons'

Criminal Indictments or Wanted Persons Importance

String

Deforestation/Environmental Count

Integer

Number of unique suppliers flagged on exposures lists classified as exposure category 'Deforestation/Environmental'

Deforestation/Environmental Importance

String

Export Controls Count

Integer

Number of unique suppliers flagged on exposures lists classified as exposure category 'Export Controls'

Export Controls Importance

String

Financial Sanctions Count

Integer

Number of unique suppliers flagged on exposures lists classified as exposure category 'Financial Sanctions'

Financial Sanctions Importance

String

Forced Labor Count

Integer

Number of unique suppliers flagged on exposures lists classified as exposure category 'Forced Labor'

Forced Labor Importance

String

Special Entities and Persons Count

Integer

Number of unique suppliers flagged on exposures lists classified as exposure category 'Special Entities and Persons'

Special Entities and Persons Importance

String

Terrorism Count

Integer

Number of unique suppliers flagged on exposures lists classified as exposure category 'Terrorism'

Terrorism Importance

String

Transportation Safety Count

Integer

Number of unique suppliers flagged on exposures lists classified as exposure category 'Transportation Safety'

Transportation Safety Importance

String

Uncategorized Count

Integer

Number of unique suppliers flagged on exposures lists classified as exposure category 'Uncategorized'

Uncategorized Importance

String

Total Exposure Count

Integer

Total number of exposure flags for the multi-tier product-supplier network

Exposure Importance

String - Categorical (LOW, MEDIUM, HIGH)

User-defined importance of the risk, adjusted at the account-level in the user-admin panel

Exposures

Field

Type

Description

Product ID

UUID

Product

String

The unique name for a Product, from which a multi-tier network originates

Exposed Supplier

String

Name of the company listed on the risk list. Companies have many facility canon IDs. This company's risk is associated with the facility found in the value chain.

Status

String - Categorical (Not Assessed, In Review, Escalated, Not Trusted, Reviewed, Approved)

The user-defined status of the exposed facility. This is a categorical field with possible values 'Not Assessed', 'In Review', 'Escalated', 'Not Trusted', 'Reviewed, Approved'.

Exposed Country

String

The country inside of which the exposed facility operates

Exposed Supplier Tiers

String - Categorical (0, 1, 2, 3, ...n)

The tier inside of the multi-tier network in which this exposed facility can be found. The exposed facility can exist in multiple tiers. If an exposed facility is both in tier 2 and tier 3, the value will be '2, 3', etc.

Tier 1 Supplier

String

The Tier 1 supplier affected by the exposed facility. Example, if my organization's facilities, or facilities my organization cares about are in the Tier 0 slot, they receive directly from Tier 1 suppliers. This version of the Tier 1 supplier name is the version inside of Altana that was matched with the 'Provided Supplier Name' as an input.

Provided Supplier Name

String

The input name for the supplier matching process. The output of the supplier matching process results in the name in 'Tier 1 Supplier'.

Importance

String - Categorical (LOW, MEDIUM, HIGH)

User-defined importance of the risk, adjusted at the account-level in the user-admin panel

Issuing Authority

String

The issuing authority (e.g. a government agency, Altana, think tank, etc) which produced the list of companies to be flagged

List Name

String

The name of the risk list containing the list of companies, and the specific exposed company in the value chain

Proximity

String - Categorical (DIRECT, INDIRECT)

Risk proximity. Can be 'DIRECT' if the company itself is listed on a risk list. Can be 'INDIRECT' if exposed by an ownership linkage (standard application is indirect two levels of ownership up, to parent companies, and two levels of ownership down, to subsidiaries.