| key |
id |
string(100)* |
= |
Unique identifier for institution Branches |
|
assets |
decimal{22,8} |
|
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) |
| 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 |
|
companyIdParent |
string(13) |
|
Unique identifier for the highest-holder parent company |
|
deposits |
decimal{22,8}* |
|
Total deposits from customers. For US banks, this is the total deposits from customers and banks. Magnitude: ($000) |
|
institutionBranchesId |
string(36)* |
|
Unique identifier for institution Branches |
|
institutionId |
long(-2147483648,2147483647)* |
|
S&P's unique key to identify institutions. |
|
instnDepositsFiltered |
long(-9223372036854775807,9223372036854775806) |
|
Amounts in customers' banking deposits; any accounts subject to federal banking deposit insurance, including any portions in jumbo deposits that are not insured but subject to the FDIC deposit regulations, and excluding deposits in any excluded branches. Magnitude: ($000) |
|
loansCommIndAssets |
decimal{22,8} |
|
Commercial and industrial loans as a percent of assets. Magnitude: (%) |
|
loansCommercialIndustrial |
long(-2147483648,2147483647) |
|
Includes loans for commercial and industrial purposes to sole proprietorships, partnerships, corporations, and other business enterprises, whether secured (other than by real estate) or unsecured, single-payment or installment, in the form of either direct or purchased loans, for the fully consolidated bank. This also covers loans to individuals for commercial, industrial, and professional purposes, and those for financing capital expenditures and current operations. Specific inclusions are loans guaranteed by the Small Business Administration (SBA), loans made to finance construction not secured by real estate, and commercial and industrial loans guaranteed by foreign governmental institutions. (Magnitude: $000) |
|
loansConst |
long(-2147483648,2147483647) |
|
Total construction and development loans: Includes loans secured by real estate with original maturities of 60 months or less made to finance land development preparatory to erecting new structures or the on-site construction of industrial, commercial, residential, or farm buildings, for domestic offices only, including not only construction of new structures, but also additions or alterations to existing structures and the demolition of existing structures to make way for new structures. Includes loans secured by real estate the proceeds of which are to be used to acquire and improve developed and undeveloped property and loans made under Title I or Title X of the National Housing Act that conform to the definition of construction stated above and that are secured by real estate. Magnitude: ($000) |
|
loansConsumerAssets |
decimal{22,8} |
|
Consumer loans as a percent of assets. Magnitude: (%) |
|
loansConsumerBanking |
long(-2147483648,2147483647) |
|
Total consumer loans: Includes all loans to individuals for household, family, and other personal expenditures that are not secured by real estate, whether direct loans or purchased paper, for the fully consolidated bank. Magnitude: ($000) |
|
loansMultiFam |
long(-2147483648,2147483647) |
|
Total multifamily loans: Includes all other permanent nonfarm residential loans secured by real estate as evidenced by mortgages (FHA and conventional) or other liens, for domestic offices only. Includes, specifically, loans on: nonfarm properties with 5 or more dwelling units in structures used primarily to accommodate households on a more or less permanent basis, 5 or more unit housekeeping dwellings with commercial units combined where use is primarily residential, cooperative-type apartment buildings containing 5 or more dwelling units, vacant lots in established multifamily residential properties. Magnitude: ($000) |
|
loansSBBig |
long(-2147483648,2147483647) |
|
Small business loans between $250,000 and $1 million: Includes the total carrying value of all currently outstanding commercial and industrial loans with original amounts greater than $250,000 and less than $1,000,000. Magnitude: ($000) |
|
loansSBMid |
long(-2147483648,2147483647) |
|
Small business loans between $100,000 and $250,000: Includes the total carrying value of all currently outstanding commercial and industrial loans with original amounts greater than $100,000 and less than $250,000. Magnitude: ($000) |
|
loansSBREBig |
long(-2147483648,2147483647) |
|
Small business and commercial real estate loans between $250,000 and $1 million: Includes the total carrying value of all currently outstanding loans secured by nonfarm, nonresidential properties with original amounts greater than $250,000 and less than $1,000,000. Magnitude: ($000) |
|
loansSBREMid |
long(-2147483648,2147483647) |
|
Small business and commercial real estate loans between $100,000 and $250,000: Includes the total carrying value of all currently outstanding loans secured by nonfarm, nonresidential properties with original amounts greater than $100,000 and less than $250,000. Magnitude: ($000) |
|
loansSBRESmall |
long(-2147483648,2147483647) |
|
Small business and commercial real estate loans less than $100,000: Includes the total carrying value of all currently outstanding loans secured by nonfarm, nonresidential properties with original amounts of $100,000 or less. Magnitude: ($000) |
|
loansSBSmall |
long(-2147483648,2147483647) |
|
Small business loans less than $100,000: Includes the total carrying value of all currently outstanding commercial and industrial loans with original amounts less than $100,000. Magnitude: ($000) |
|
loansSingleFam |
long(-2147483648,2147483647) |
|
Includes revolving and permanent loans secured by real estate, such as mortgages (Federal Housing Administration (FHA), Farmers Home Administration (FmHA), Department of Veterans Affairs (VA), or conventional) or other liens on 1-4 family residential property, for domestic offices only. This covers nonfarm property with 1-4 dwelling units (or more if separated by ground-to-roof walls), mobile homes legally defined as real property and secured by mortgage, individual condominium units, cooperative housing units (even in larger buildings), vacant lots in single-family residential areas, and housekeeping dwellings with combined commercial units where use is primarily residential and involves 1-4 family units. (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) |
|
officesBankInStore |
long(-2147483648,2147483647)* |
|
Number of supermarket or other in-retail-store banking branches operated. Magnitude: (actual) |
|
officesBankTraditional |
long(-2147483648,2147483647)* |
|
Number of traditional (not in-store) banking branches operated. Magnitude: (actual) |
|
parentInstitutionId |
long(-2147483648,2147483647) |
|
S&P's unique key for the highest-holder parent institutions |
| link |
regDomainClassId |
RegDomainClass |
|
The primary division of companies for which regulatory information is available. |