| key |
id |
string(36)* |
= |
Financial Period Key. A financial period is any period of time over which an institution's financial information is measured. Different measures of financial information may be available for the same institution and time period as the result of restatements. |
|
accountingPrincipleId |
long(-32768,32767)* |
|
Lookup key used to identify accounting principles used to create financial statements |
|
accountsPayableAccruedExp |
long(-2147483648,2147483647) |
|
Total accounts payable and accrued expenses. Magnitude: ($000) |
|
accountsReceivable |
long(-9223372036854775807,9223372036854775806) |
|
Amounts owed to the company including amounts due from customers and affiliated entities. Magnitude: ($000) |
|
accruedCompensation |
long(-2147483648,2147483647) |
|
Compensation accrued and payable for services already rendered. Magnitude: ($000) |
|
annualization |
decimal{22,8}* |
|
Number by which flow financial items need to be multiplied to get an annualized figure |
|
asReportedRevenue |
long(-2147483648,2147483647) |
|
Revenue as reported by the company. Magnitude: ($000) |
|
asReportedRevenueGrowth |
decimal |
|
Growth in revenue reported by the company. Magnitude: (%) |
|
assetGrowth |
decimal |
|
Growth in total assets. Magnitude: (%) |
|
assetMgmtFeesReceivable |
long(-2147483648,2147483647) |
|
Fees receivable based on the value of assets being managed. Magnitude: ($000) |
|
assetsManagedforIndividuals |
long(-9223372036854775807,9223372036854775806) |
|
Assets managed for individuals. Magnitude: ($000) |
|
assetsManagedforInstitutions |
long(-9223372036854775807,9223372036854775806) |
|
Assets managed for institutional investors. Magnitude: ($000) |
|
assetsManagedforTaxableOrgs |
long(-2147483648,2147483647) |
|
Discretionary assets under management for which income is subject to taxation. Magnitude: ($000) |
|
assetsManagedforTaxexemptOr |
long(-2147483648,2147483647) |
|
Discretionary assets under management for which income is not subject to taxation. Magnitude: ($000) |
|
assetsUnderAdministration |
long(-9223372036854775807,9223372036854775806) |
|
Assets in accounts over which the firm has administrative responsibilities. Includes trust administration, custody, fiduciary, and escrow services. Magnitude: ($000) |
|
assetsUnderManagement |
long(-9223372036854775807,9223372036854775806) |
|
All assets directly managed by the firm, over which the firm has discretionary investment authority, not for its own accounts. May include mutual funds, money market funds, institutional accounts. Magnitude: ($000) |
|
assetsUnderManagementOther |
long(-9223372036854775807,9223372036854775806) |
|
Component of assets under management that represents all investments not included above. Magnitude: ($000) |
|
aumEquity |
long(-9223372036854775807,9223372036854775806) |
|
The portion of assets under management invested in equity-type securities. Magnitude: ($000) |
|
aumFixedIncome |
long(-9223372036854775807,9223372036854775806) |
|
The portion of assets under management invested in fixed-income securities. Magnitude: ($000) |
|
avgEmployees |
decimal |
|
Average full-time equivalent employees for the period, as reported by the company, if available, otherwise calculated. Magnitude: (actual) |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the Price is calculated. |
|
brokers |
long(-2147483648,2147483647) |
|
Retail and institutional brokers either employed directly by or acting as independent contractors for the company. Magnitude: (actual) |
|
brokersEmployed |
long(-2147483648,2147483647) |
|
Retail and institutional brokers directly employed by the company. Magnitude: (actual) |
|
capitalEquityNoncurrentSu |
long(-9223372036854775807,9223372036854775806) |
|
Shareholders' equity, both common and preferred, and subordinated debt. Magnitude: ($000) |
|
capitalGrowth |
decimal |
|
Growth in capital consisting of equity and subordinated debt. Magnitude: (%) |
|
cashCashEquivalents |
long(-9223372036854775807,9223372036854775806) |
|
Cash and cash equivalents such as money orders, coins, and checks. For banks, this includes central bank balances. Magnitude: ($000) |
|
cashSegregatedunderRegulation |
long(-9223372036854775807,9223372036854775806) |
|
Mandatory cash deposits required by central banks or cash restricted for redistribution by regulatory bodies. Magnitude: ($000) |
|
cashandCashBalances |
long(-9223372036854775807,9223372036854775806) |
|
Money deposited in a bank and items that a bank will accept for immediate deposit such as paper money, coins, checks, and money orders. Includes money market funds and balances with other banks. Magnitude: ($000) |
|
clearingDeposits |
long(-2147483648,2147483647) |
|
Deposits maintained for clearing transactions. Magnitude: ($000) |
|
commercialPaperOutstanding |
long(-2147483648,2147483647) |
|
Short-term loans (secured or unsecured), usually issued at a discount with maturities not beyond 270 days, typically used to finance accounts receivable and inventories. Magnitude: ($000) |
|
companyId |
long(-2147483648,2147483647) |
|
S&P company identifier. |
|
currencyISOCode |
string(3)* |
|
Alphabetic code used to identify currencies pursuant to ISO-4217 |
|
dataSourcePeriod |
string(6)* |
|
A unique key used to identify a financial period within the DataSource. Concatenation of the Fiscal Year and Fiscal Period values, or for derived periods. |
|
dateBegun |
date* |
|
Date on which fiscal period began |
|
dateEnded |
date* |
|
Date on which the fiscal period ended |
|
dateEndedStandard |
date* |
|
Ending date of the fiscal period, standardized to be the last day of the month in which the period ends. For example, if a fiscal period ends on June 29, this date will be June 30, so that there is a consistency among different companies. |
|
discretionaryAccounts |
long(-2147483648,2147483647) |
|
The number of customer accounts the firm considers active and for which the institution has direct investment control, including both retail and institutional accounts. Magnitude: (actual) |
|
dueFromBDsClearingOrg |
long(-2147483648,2147483647) |
|
Accounts receivable from brokers, dealers or clearing organizations. Magnitude: ($000) |
|
dueFromCustomers |
long(-2147483648,2147483647) |
|
Amounts owed to the company in the normal course of trade, by customers for products or services provided on credit or by counterparties for pending trades of financial assets. Magnitude: ($000) |
|
duetoBrokersDealersCleari |
long(-2147483648,2147483647) |
|
Accounts payable to brokers, dealers and clearing organizations. Includes contract value of securities which have not been received by settlement date and payables for clearing house services. Magnitude: ($000) |
|
duetoCustomers |
long(-2147483648,2147483647) |
|
Accounts payable to customers'. Magnitude: ($000) |
|
earningsReleaseDate |
date |
|
Date on which earnings were first released to the public via news release, securities filing, or other public disclosure |
|
ebitdaGrowth |
decimal |
|
Growth rate of earnings before interest, taxes, depreciation and amortization. Magnitude: (%) |
|
equityAttributabletoParent |
long(-9223372036854775807,9223372036854775806) |
|
Total equity attributable to the parent as defined under the indicated accounting principles. Includes par value, paid in capital, retained earnings, and other adjustments to equity. Includes all classes of common and non-redeemable preferred equity. Magnitude: ($000) |
|
equityGrowth |
decimal |
|
Growth in total equity. Magnitude: (%) |
|
excessNetCapital |
long(-2147483648,2147483647) |
|
Regulatory net capital over and above the required minimum net capital as defined by SEC's (Securities and Exchange Commission) Uniform Net Capital Rule (Rule 15c3). Magnitude: ($000) |
|
fiscalQuarter |
string(1) |
|
Fiscal quarter to which the financial information is applicable |
|
fiscalYear |
string(4) |
|
Fiscal year to which the financial information is applicable |
|
fixedAssets |
long(-2147483648,2147483647) |
|
Property, plant and equipment acquired for long-term use in normal operations. Fixed assets are carried at cost, net of accumulated depreciation. Magnitude: ($000) |
|
flowPeriodId |
long(-2147483648,2147483647) |
|
Financial Period Key. A financial period is any period of time over which an institution's financial information is measured. Different measures of financial information may be available for the same institution and time period as the result of restatements. |
|
fteEmployees |
long(-2147483648,2147483647) |
|
The number of full-time-equivalent employees working for the company and its subsidiaries. In determining this value, it assumes two part-time employees equal one full-time employee, but excludes temporary employees. Magnitude: (actual) |
|
incomeTaxesPayable |
long(-2147483648,2147483647) |
|
Federal, state, and other income taxes payable. Magnitude: ($000) |
|
independentBrokersContracted |
long(-2147483648,2147483647) |
|
Retail and institutional brokers acting as independent contractors for the company. Magnitude: (actual) |
|
institutionId |
long(-2147483648,2147483647) |
|
S&P's unique key to identify institutions. Institutions are corporations, partnerships, proprietorships, not-for-profit organizations, government agencies, and any other chartered organization. |
|
investmentInPartnerships |
long(-2147483648,2147483647) |
|
Investments in joint ventures and partnerships that are not consolidated. Magnitude: ($000) |
|
investments |
long(-2147483648,2147483647) |
|
Total investment in securities and unconsolidated subsidiaries, excluding segregated securities or securities pledged as collateral for broker-dealers and asset managers. Magnitude: ($000) |
|
isCurrent |
boolean |
|
Indicates the financial period, current data is the most up-to-date financial information available |
|
isLatestPeriod |
long(-32768,32767) |
|
Indicates the most recent data available within a time series. Rows with this value = 1 indicate that the row is the most recent. Some objects, but not all objects, require the calculation of varying numbers of data prior to the most recent. These rows are indicated with increasing values moving back through time. For example, the most recent row has a value of 1, the next most recent, or immediately prior, has a value of 2. The next prior record has a value of 3, and so on. The number of rows flagged with these values varies from object to object, but there will always be at least the one row marked with a 1. |
|
isOriginal |
boolean |
|
Indicates that financial period, originally reported data is that which was reported to the public prior to any later restatement |
|
mutualFundsunderManagement |
long(-9223372036854775807,9223372036854775806) |
|
Net asset value of mutual funds managed, including open-end funds and closed-end funds. Magnitude: ($000) |
|
netCapitalRatio |
decimal{5,2} |
|
Aggregate indebtedness as a multiple of regulatory net capital, as reported by the company. Magnitude: (x) |
|
netIncome |
long(-9223372036854775807,9223372036854775806) |
|
Net income after taxes, minority interest, and extraordinary and other after-tax items. Noncontrolling interest may be included, per relevant accounting standards (e.g., FAS 160 for U.S. GAAP which includes noncontrolling interests for fiscal years starting after December 15, 2008). Magnitude: ($000) |
|
netIncomeGrowth |
decimal |
|
Growth in net income, after taxes, minority interest, and extraordinary and other after-tax items. Noncontrolling interest may be included, per relevant accounting standards (e.g., FAS 160 for U.S. GAAP which includes noncontrolling interest for fiscal years starting after December 15, 2008). Magnitude: (%) |
|
noncontrollingInterests |
long(-2147483648,2147483647) |
|
Portion of net assets of a subsidiary attributable to equity interests that are not owned by the parent. Magnitude: ($000) |
|
numberOfInstitutionalAccounts |
long(-2147483648,2147483647) |
|
Number of accounts over which the company has direct investment control, managed for institutional clients. Magnitude: (actual) |
|
numberOfRetailAccounts |
long(-2147483648,2147483647) |
|
Number of accounts over which the company has direct investment control, managed for individual clients. Magnitude: (actual) |
|
obligationtoReturnSecurities |
long(-2147483648,2147483647) |
|
Obligation to return securities in matched book term repurchase agreements for which the collateral provider does not have the explicit contractual right to substitute. Magnitude: ($000) |
|
otherAccountsPayableAccru |
long(-2147483648,2147483647) |
|
Accounts payable not otherwise classified above. Magnitude: ($000) |
|
otherAccountsReceivable |
long(-9223372036854775807,9223372036854775806) |
|
Other accounts receivable not otherwise classified above. Magnitude: ($000) |
|
otherSeniorDebt |
long(-2147483648,2147483647) |
|
Any senior debt obligations not otherwise classified above. Magnitude: ($000) |
|
periodTypeId |
long(0,255) |
|
Standardized code that classifies a financial records reporting period type. Allowable values include: ‘1’ – Yearly, ‘2’ – Quarterly, ‘3’ – Triannual, ‘4’ – Semiannual and ‘10’ – Half-Year. |
|
redeemableFinancialInstruments |
long(-2147483648,2147483647) |
|
Mandatorily redeemable preferred and other redeemable financial instruments. For companies under US-GAAP, this does not include those securities classified in the mezzanine prior to the adoption of FAS 150 or those exempted from that statement. Magnitude: ($000) |
|
regulatoryNetCapital |
long(-2147483648,2147483647) |
|
Regulatory Net Capital at all brokerage subsidiaries, as determined by the Securities and Exchange Commission (SEC). Generally equal to equity and subordinated debt, subject to certain adjustments. Magnitude: ($000) |
|
regulatoryNetCapitalGrowth |
decimal |
|
Growth in regulatory net capital. Magnitude: (%) |
|
reportedEBITDA |
long(-2147483648,2147483647) |
|
Reported earnings before interest, taxes, depreciation and amortization. Magnitude: ($000) |
|
reportedEBITDAGrowth |
decimal |
|
Growth rate of reported earnings before interest, taxes, depreciation and amortization. Magnitude: (%) |
|
repurchaseAgreements |
long(-9223372036854775807,9223372036854775806) |
|
Securities that are sold under a corresponding agreement that those securities will be repurchased by the original holder on a specified future date and at an agreed-upon price. Magnitude: ($000) |
|
requiredMinimumNetCapital |
long(-2147483648,2147483647) |
|
Minimum regulatory net capital the company is required to maintain as defined by the Securities and Exchange Commission (SEC) uniform net capital rule (rule 15c3). Companies can calculate this using the basic method, which requires net capital to be the greater of a minimum amount mandated by the SEC or 6 2/3 percent of its aggregate indebtedness, or by using the alternative method, which requires net capital to be the greater of a minimum amount mandated by the SEC or 2 percent of its customer-related receivables. Magnitude: ($000) |
|
restatementReason |
string(30) |
|
Generalized reason why a financial restatement might occur |
|
securitiesBorrowed |
long(-2147483648,2147483647) |
|
Securities borrowed from another party, usually another broker-dealer, usually to cover a customer's short sale. Magnitude: ($000) |
|
securitiesLoaned |
long(-2147483648,2147483647) |
|
Loan of securities by one broker to another, usually to cover a customer's short sale. The lending broker is secured by the cash proceeds of the sale. Magnitude: ($000) |
|
securitiesPledgedAsCollateral |
long(-2147483648,2147483647) |
|
Securities pledged as collateral in matched-book term-resale agreements for which the collateral provider does not have the explicit contractual right to substitute. Magnitude: ($000) |
|
securitiesPurchasedToResell |
long(-2147483648,2147483647) |
|
Securities that have been purchased under an agreement that those securities will be resold to the original holder on a specified date and at an agreed-upon price. Also known as Reverse Repurchase Agreements. Magnitude: ($000) |
|
securitiesSoldnotyetPurchas |
long(-2147483648,2147483647) |
|
Securities sold short, to be purchased at a later date. Magnitude: ($000) |
|
seniorDebt |
long(-9223372036854775807,9223372036854775806) |
|
Principal amounts outstanding on loans, notes payable, bonds, securities sold under repurchase agreements, mortgage-backed bonds, short term borrowings, mortgage notes and other notes payable, capitalized lease obligations, and other debt instruments not classified as subordinated debt. Magnitude: ($000) |
|
stockPeriodId |
long(-2147483648,2147483647) |
|
Object key identifying end-of-period financial data |
|
totalAssets |
long(-9223372036854775807,9223372036854775806) |
|
All assets owned by the company as of the date indicated, as carried on the balance sheet and defined under the indicated accounting principles. Magnitude: ($000) |
|
totalDebt |
long(-9223372036854775807,9223372036854775806) |
|
The aggregate unpaid principal balance owed under financial obligations to other parties, required to be paid by a specified date or on demand. Magnitude: ($000) |
|
totalDeposits |
long(-9223372036854775807,9223372036854775806) |
|
Total deposits from customers. For US banks, this is the total deposits from customers and banks. Magnitude: ($000) |
|
totalEquity |
long(-9223372036854775807,9223372036854775806) |
|
Equity as defined under the indicated accounting principles. Includes par value, paid in capital, retained earnings, and other adjustments to equity. Minority interest may be included, per relevant accounting standards (e.g., FAS 160 for U.S. GAAP which includes minority interest for fiscal years starting after December 15, 2008). Magnitude: ($000) |
|
totalEquityTotalAssets |
decimal |
|
Equity as a percent of assets. Magnitude: (%) |
|
totalIntangibleAssets |
long(-2147483648,2147483647) |
|
Total goodwill and any other intangible assets. Under IFRS guidance, total intangibles may include value of business acquired (VOBA) where applicable. Magnitude: ($000) |
|
totalLiabilities |
long(-9223372036854775807,9223372036854775806) |
|
Total liabilities as carried on the balance sheet and defined by the indicated accounting principles. Excludes minority interests and other mezzanine-level financings. Magnitude: ($000) |
|
totalMezzanineLevelItems |
long(-2147483648,2147483647) |
|
Minority interest, redeemable equity, and all other items that appear between liabilities and equity on the face of the balance sheet. Magnitude: ($000) |
|
totalNetLoans |
long(-9223372036854775807,9223372036854775806) |
|
Total loans and finance leases outstanding, including those held for sale. The value is net of unearned discount and loan-loss reserves, and does not include interest receivable on loans. Magnitude: ($000) |
|
totalOtherAssets |
long(-9223372036854775807,9223372036854775806) |
|
All assets not otherwise classified above. Magnitude: ($000) |
|
totalOtherLiabilities |
long(-9223372036854775807,9223372036854775806) |
|
All liabilities not otherwise classified above. Magnitude: ($000) |
|
totalSecurities |
long(-9223372036854775807,9223372036854775806) |
|
Total of all securities owned, valued as shown on the balance sheet according to the applicable accounting standards used for this financial statement. For U.S. GAAP, includes all securities in the trading, available for sale, held to maturity and other securities categories and does not include segregated securities or securities pledged as collateral for broker-dealers and asset managers. For full coverage banks outside of the U.S. and Canada and summary coverage banks, includes other financial assets. Magnitude: ($000) |
|
totalSubordinatedDebt |
long(-2147483648,2147483647) |
|
Debt in which the creditor's claims to the assets of the company are subordinated to those of other creditors. In the event of liquidation, dissolution, bankruptcy, or reorganization, such debts are junior to present or future obligations (e.g., payables, deposits, and senior debt). Subordinated debt is usually not collateralized by any specific asset, but only pledged by the full faith and credit of the company. Magnitude: ($000) |
|
valueOfClientAssets |
long(-9223372036854775807,9223372036854775806) |
|
Total value of client's assets in customer accounts. Includes both assets under management and assets in client accounts over which the institution does not exercise discretionary investment powers. Magnitude: ($000) |