| key |
id |
string(100)* |
= |
Unique identifier for institution Branch By Country |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the entity is sent. |
| link |
branchAsOfId |
BranchAsOf |
|
Date as of which the branch data is current. Data from the regulatory branch statement of deposits is always as of June 30 of any year. |
|
companyId |
long(-2147483648,2147483647)* |
|
Unique identifier assigned to a company |
| link |
countryId |
Country |
|
Two-letter abbreviation for countries, as defined by ISO-3166 |
|
depositRankInMarket |
long(-2147483648,2147483647) |
|
Marketshare rank of the company within the indicated market, based on deposits |
|
depositRankInMarketFiltered |
long(-2147483648,2147483647) |
|
Marketshare rank of the company within the indicated market, based on deposits, and excluding any excluded branches |
|
deposits |
decimal{22,8} |
|
Total deposits from customers. For US banks, this is the total deposits from customers and banks. Magnitude: ($000) |
|
institutionId |
long(-2147483648,2147483647)* |
|
S&P's unique key to identify institutions. |
|
instnBranchByCountryId |
string(36)* |
|
Unique identifier for institution Branch By Country |
|
instnDepositsInMarketFiltered |
long(-9223372036854775807,9223372036854775806) |
|
Deposits in market for the company, excluding any excluded branches. Magnitude: ($000) |
|
mostRecentCurrentOwner |
boolean* |
|
Indicates that this row represents 'current' ownership, that is, it is updated for any completed deals but does not reflect any deals announced but that have not closed |
|
mostRecentSequence |
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 entities, but not all entities, 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 entity to entity, but there will always be at least one row marked with a 1. |
|
offices |
long(-2147483648,2147483647) |
|
Number of locations as reported by the company. Magnitude: (actual) |
|
officesInMarketFilterNonZero |
long(-2147483648,2147483647) |
|
Bank branches in market for the company, retail only, exluding zero deposit branches. Magnitude: (actual) |
|
officesInMarketFiltered |
long(-2147483648,2147483647) |
|
Bank branches in market for the company, excluding any excluded branches. Magnitude: (actual) |
|
officesInMarketFilteredTot |
long(-2147483648,2147483647) |
|
Bank Branches in market for the company, retail only including open and closed branches. Magnitude: (actual) |
| link |
regDomainClassId |
RegDomainClass |
|
The primary division of companies for which regulatory information is available. |