DOCUMENTATION
Data Dictionaries & Schema Reference
Explore the structure, fields, and definitions behind TenderAlpha's data feeds through interactive, searchable documentation.
DATA FEEDS
Government Contracts Data
Supply Chain Data
Corporate Data
Global Government Contracts
90 fields
Showing 90 of 90 fields
| FIELD NAME | DESCRIPTION | DATA TYPE | |
|---|---|---|---|
awardee_parent_address
|
Street address of the Parent Company. | VARCHAR(255) | |
awardee_parent_bizportal_id
|
ID of the Awarded Company’s Parent. [US companies and wherever applicable] | INT(10) UNSIGNED | |
awardee_parent_contact_point
|
A person or a department serving as the coordinator of information in the Parent Company. | VARCHAR(255) | |
awardee_parent_country
|
ISO2 country code of the Parent Company. | CHAR(2) | |
awardee_parent_email
|
Email address of the Parent Company. | VARCHAR(255) | |
awardee_parent_fax
|
The fax number of the Parent Company. | VARCHAR(255) | |
awardee_parent_isin_number
|
An International Securities Identification Number. [Available for public companies only] | VARCHAR(30) | |
awardee_parent_listing_status
|
Values: Delisted, Unlisted, Listed | VARCHAR(20) | |
awardee_parent_location
|
The location of the Parent Company. | VARCHAR(255) | |
awardee_parent_name
|
Name of the Parent Company. | TEXT | |
awardee_parent_phone
|
Phone number of the Parent Company. | VARCHAR(255) | |
awardee_parent_postcode
|
Zip code or postal code of the Parent Company address. | VARCHAR(30) | |
awardee_parent_state
|
ISO2 state code of the Parent Company. [US companies and wherever applicable] | CHAR(2) | |
awardee_parent_stock_exchange_country
|
ISO2 country code of the Stock exchange where the company’s shares are being officially traded. [Available for public companies only] | VARCHAR(2) | |
awardee_parent_stock_exchange_mic
|
Market Identifier Code of the Parent Company’s stock exchange | VARCHAR(10) | |
awardee_parent_stock_exchange_name
|
Stock exchange where the company’s shares are being officially traded. [Available for public companies only] | VARCHAR(100) | |
awardee_parent_ticker_symbol
|
Ticker symbol. [Available for public companies only] | VARCHAR(20) | |
awardee_parent_uic
|
National ID Number of the Parent Company. | VARCHAR(30) | |
awardee_parent_vat_number
|
Tax identification number of the Parent Company. | VARCHAR(20) | |
awardee_parent_website
|
Website of the Parent Company. | VARCHAR(255) | |
contracting_entity_address
|
Street address of the Contracting Authority. | VARCHAR(255) | |
contracting_entity_bizportal_id
|
ID of Contracting Authority | INT(10) UNSIGNED | |
contracting_entity_contact_point
|
A representative of the Contracting Authority staff who is responsible for initiating the tender. | VARCHAR(255) | |
contracting_entity_country
|
ISO2 country code of the Contracting Authority. | CHAR(2) | |
contracting_entity_email
|
Email address of the Contracting Authority. | VARCHAR(255) | |
contracting_entity_fax
|
Fax number of the Contracting Authority. | VARCHAR(255) | |
contracting_entity_location
|
The city of the Contracting Authority. | VARCHAR(255) | |
contracting_entity_name
|
The name of the Contracting Authority that has initiated the tender. | TEXT | |
contracting_entity_phone
|
Telephone number of the Contracting Authority. | VARCHAR(255) | |
contracting_entity_postcode
|
Postcode of the city where the Contracting Authority is located. | VARCHAR(30) | |
contracting_entity_state
|
ISO2 state code of the Contracting Authority. [US companies and wherever applicable] | CHAR(2) | |
contracting_entity_website
|
Official website of the Contracting Authority. | VARCHAR(255) | |
direct_awardee_address
|
Street address of the Awarded Company. | VARCHAR(255) | |
direct_awardee_amount
|
It is the mutually agreed upon total contract or order value. | DECIMAL(20,2) | |
direct_awardee_bizportal_id
|
ID of Directly awarded company | INT(10) UNSIGNED | |
direct_awardee_contact_point
|
A person or a department serving as the coordinator of information. | VARCHAR(255) | |
direct_awardee_country
|
ISO2 country code of the Awarded Company. | CHAR(2) | |
direct_awardee_currency
|
ISO3 currency code of the tender. | CHAR(3) | |
direct_awardee_email
|
Email address of the Awarded Company. | VARCHAR(255) | |
direct_awardee_fax
|
The fax number of the Awarded Company. | VARCHAR(255) | |
direct_awardee_isin_number
|
An International Securities Identification Number. [Available for public companies only] | VARCHAR(30) | |
direct_awardee_listing_status
|
Values: Delisted, Unlisted, Listed | VARCHAR(20) | |
direct_awardee_location
|
The location of the Awarded Company. | VARCHAR(255) | |
direct_awardee_name
|
Name of the Awarded Company. | TEXT | |
direct_awardee_phone
|
Phone number of the Awarded Company. | VARCHAR(255) | |
direct_awardee_postcode
|
Zip code or postal code of the Awarded Company address. | VARCHAR(30) | |
direct_awardee_state
|
ISO2 state code of the Awarded Company. [US companies and wherever applicable] | CHAR(2) | |
direct_awardee_stock_exchange_country
|
ISO2 country code of the Stock exchange where the company’s shares are being officially traded. [Available for public companies only] | CHAR(2) | |
direct_awardee_stock_exchange_mic
|
Market Identifier Code of the Awarded Company’s stock exchange | VARCHAR(10) | |
direct_awardee_stock_exchange_name
|
Stock exchange where the company’s shares are being officially traded. [Available for public companies only] | VARCHAR(100) | |
direct_awardee_ticker_symbol
|
Ticker symbol of the awarded company. [Available for public companies only] | VARCHAR(20) | |
direct_awardee_uic
|
Unique national ID Number of the Awarded Company. | VARCHAR(30) | |
direct_awardee_usd_amount
|
The amount of the tender in USD. | DECIMAL(20,2) | |
direct_awardee_vat_number
|
Tax identification number of the Awarded Company. | VARCHAR(20) | |
direct_awardee_website
|
Website of the Awarded Company. | VARCHAR(255) | |
event_type
|
Indicates whether the award is an initial procurement event or a consequent transactional one. | VARCHAR(50) | |
green_contract
|
Identifies if the contract is awarded for purchasing of products, services and works that respect the environmental criteria. | BOOLEAN (0 or 1) | |
origin
|
Geographical region where the award has been procured from (US, EEA, etc.) | VARCHAR(50) | |
origin_id
|
ID of Origin | INT(10) UNSIGNED | |
tender_award_criteria
|
Type of contract award criteria. | VARCHAR(255) | |
tender_bidders_count
|
The number of other participants (bidders) who have applied for the tender. | INT(10) UNSIGNED | |
tender_bizportal_id
|
ID of Awarded Tender/Contract. | INT(10) UNSIGNED | |
tender_budget_execution_percentage_to_date
|
The percentage of the contract budget exection a per th date of the event calculated by Ratio of “Tender - Value of Contract to Date” to “Tender - USD Potential Total Value of Contract” | DECIMAL(5,2) | |
tender_contract_end_date
|
Date on which the contract was finished. [US tenders and wherever applicable]. | DATE Format: YYYY-MM-DD | |
tender_contract_start_date
|
Date on which the contract was started. [US tenders and wherever applicable]. | DATE Format: YYYY-MM-DD | |
tender_country
|
ISO2 country code where the work was / is performed. | CHAR(2) | |
tender_currency
|
ISO3 currency code of the tender. | CHAR(3) | |
tender_current_event_amount
|
Amount of the specific initial/transactional award. | DECIMAL(20,2) | |
tender_current_event_amount_usd
|
Amount of the specific initial/transactional award in USD. | DECIMAL(20,2) | |
tender_date_of_award
|
The date that a mutually binding agreement was reached. | DATE Format: YYYY-MM-DD | |
tender_date_of_dispatch
|
The date on which the information becomes publicly available. | DATE Format: YYYY-MM-DD | |
tender_description
|
A brief description of the tendering procedure (works, goods, services). | TEXT | |
tender_framework
|
An agreement between one or more business organisations. | BOOLEAN 0 or 1 | |
tender_funding_origin_country
|
ISO2 code of origin country that provides financial resources. | CHAR(2) | |
tender_industry_codes
|
List of industry code as per the Common Procurement Vocabulary (CPV). | TEXT | |
tender_location
|
The principal place where the work was / is performed. | VARCHAR(255) | |
tender_min_delivery_date
|
The earliest date when the information could be delivered (would have been delivered as point in time in the past) to the Client receiving the feed on ongoing basis. | DATE Format: YYYY-MM-DD | |
tender_potential_value_of_contract
|
Possible maximum amount obligated for the full period of the contract. | DECIMAL(20,2) | |
tender_potential_value_of_contract_usd
|
Possible maximum amount obligated for the full period of the contract in USD. | DECIMAL(20,2) | |
tender_state
|
ISO2 state code in which the work was / is performed. [US companies and wherever applicable] | CHAR(2) | |
tender_title
|
Title name of the tender. | TEXT | |
tender_type_of_authority
|
Type of Contracting Authority that has initiated the tender. | VARCHAR(255) | |
tender_type_of_bid
|
Type of tendering procedure bidding. | VARCHAR(255) | |
tender_type_of_contract
|
Contract type of the tendering procedure. | VARCHAR(255) | |
tender_type_of_contract_pricing
|
Payment model for a contract. Each has a different way of accounting for costs, fees, and profits. | VARCHAR(255) | |
tender_type_of_procedure
|
Tender procedure type. | VARCHAR(255) | |
tender_type_of_regulation
|
Type of tendering procedure regulation. | VARCHAR(255) | |
tender_value_of_contract_to_date
|
The entire obligated amount of funds to the vendor as per the date of the event. | DECIMAL(20,2) | |
tender_value_of_contract_to_date_usd
|
The entire obligated amount of funds in USD to the vendor as per the date of the event. | DECIMAL(20,2) | |
transaction_bizportal_id
|
ID of Contract Award Transaction [Only for transactional feeds and wherever applicable] | INT(10) UNSIGNED |