| key |
id |
string(36)* |
= |
The identifier that uniquely identifies each company data record. Represents the S&P Cap IQ Company ID as a string. |
|
address |
string(4000) |
|
The street address of the company's registered office. |
|
averageAgeOfEmployeesUnconsolidated |
decimal{5,2} |
|
The average age of employees in years on an unconsolidated basis. |
|
averageAnnualIncomeOfEmployeesUnconsolidated |
long(0,2147483647) |
|
The average annual income of employees on an unconsolidated basis. Values are reported in actuals in the currency indicated by currencyCode. |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The batchRun that provided the data. |
|
buildingName |
string(4000) |
|
The name of the building where the company's registered office is located. |
|
businessDescription |
string(4000) |
|
Textual description of the company's primary business activities and operations. |
|
businessOffice |
string(4000) |
|
Information about the company's business offices including overseas count. |
|
ceoName |
string(4000) |
|
Name of the Chief Executive Officer (CEO) of the company. |
|
companyId |
long(-2147483648,2147483647)* |
|
The S&P Cap IQ Company ID for each company data record. |
|
companyMainBank |
string(4000)[255] |
|
The primary banking institution(s) associated with the company. Each array element represents one bank. |
|
currencyCode |
string(3) |
|
ISO 4217 three-letter currency code used to represent the currency. |
|
establishmentDate |
date |
|
The date on which the company was officially established or incorporated. |
| link |
industryCode |
ForeignIndustryClassification |
|
Reference to the industry classification entity providing the English and Native industry name for the company. |
|
isDeleted |
boolean* |
|
Indicates that this record has been logically deleted and should no longer be considered active. |
|
lastModifiedDate |
dateTime* |
|
The date and time when this record was last updated or modified in the source system. |
|
marketClassification |
string(4000) |
|
The descriptive market classification label for the exchange segment where the company is listed. |
|
marketClassificationCode |
long(-2147483648,2147483647) |
|
The numeric code representing the market classification of the company. This field is part of an unpivoted classification structure and may map to multiple descriptive labels in the marketClassification field. |
|
nameOfAuditFirm |
string(4000) |
|
The name of the audit firm responsible for auditing the company's financial statements. |
|
nameOfUnderwritingSecuritiesCompanies |
string(4000)[255] |
|
The name(s) of underwriting securities companies associated with the company. Each array element represents one securities company. |
|
nativeLanguage |
string(2) |
|
The ISO 639-1 language in which this record's text fields are stored. |
|
numberOfEmployeesConsolidated |
long(0,2147483647) |
|
The total number of employees on a consolidated basis including subsidiaries. (Magnitude: actual) |
|
numberOfEmployeesUnconsolidated |
long(0,2147483647) |
|
The total number of employees on an unconsolidated standalone company basis. (Magnitude: actual) |
|
positionOfRepresentative |
string(4000) |
|
The title or position of the company's representative. |
|
postalCode |
string(10) |
|
The postal code of the company's registered address. |
|
telephoneNumber |
string(4000) |
|
The primary contact telephone number of the company. |