| key |
id |
string(100)* |
= |
Unique identifier for branch deposit data |
| link |
bankBranchServiceId |
BankBranchService |
|
A key used in the Summary of Deposits to identify the broadest type of service offered by a bank branch |
| 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. |
|
branchAssets |
decimal{22,8} |
|
Assets as a percent of deposits at the branch, per regulatory accounting principles. This is an approximation for the branch, derived by using information for the entire company and applying that to the branch. Magnitude: (%) |
|
branchDepositId |
long(-2147483648,2147483647)* |
|
Unique identifier for branch deposit data |
|
branchDepositPriorId |
long(-2147483648,2147483647) |
|
branchDepositId of the data immediately prior to this one |
|
branchDeposits |
long(-2147483648,2147483647)* |
|
Federally-insured bank deposits at the branch. Magnitude: ($000) |
|
branchHomeOffice |
boolean* |
|
Indicates that the branch is the home office or the headquarters of the operating institution as originally reported |
| link |
branchId |
Branch |
|
Unique key to identify individual branch. |
|
branchLoansCommercialCalc |
long(-2147483648,2147483647) |
|
Loans for commercial and industrial purposes to various business entities (sole proprietorships, partnerships, corporations) and individuals, extended by the fully consolidated bank. These loans can be secured (excluding real estate) or unsecured, single-payment or installment, and direct or purchased. They finance capital expenditures and current operations, and include specialized categories such as those guaranteed by the Small Business Administration (SBA) or foreign governments, supported by the Agency for International Development (AID), non-real estate secured construction, dealer financing, credit card-based C&I, production payment collateralized, and commercial transportation equipment purchase loans. This value is an approximation for the branch, derived from company-wide information. Magnitude: ($000). |
|
branchLoansConstCalc |
long(-2147483648,2147483647) |
|
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. This is an approximation for the branch, derived by using information for the entire company and applying that to the branch. Magnitude: ($000) |
|
branchLoansConsumerCalc |
long(-2147483648,2147483647) |
|
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. This is an approximation for the branch, derived by using information for the entire company and applying that to the branch. Magnitude: ($000) |
|
branchLoansMultiFamCalc |
long(-2147483648,2147483647) |
|
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. This is an approximation for the branch, derived by using information for the entire company and applying that to the branch. Magnitude: ($000) |
|
branchLoansSBBigCalc |
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. This is an approximation for the branch, derived by using information for the entire company and applying that to the branch. Magnitude: ($000) |
|
branchLoansSBMid |
decimal{22,8} |
|
Small business loans between $100,000 and $250,000 as a percent of deposits. 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. This is an approximation for the branch, derived by using information for the entire company and applying that to the branch. Magnitude: (%) |
|
branchLoansSBMidCalc |
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. This is an approximation for the branch, derived by using information for the entire company and applying that to the branch. Magnitude: ($000) |
|
branchLoansSBREBigCalc |
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. This is an approximation for the branch, derived by using information for the entire company and applying that to the branch. Magnitude: ($000) |
|
branchLoansSBREMidCalc |
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. This is an approximation for the branch, derived by using information for the entire company and applying that to the branch. Magnitude: ($000) |
|
branchLoansSBRESmallCalc |
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. This is an approximation for the branch, derived by using information for the entire company and applying that to the branch. Magnitude: ($000) |
|
branchLoansSBSmallCalc |
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. This is an approximation for the branch, derived by using information for the entire company and applying that to the branch. Magnitude: ($000) |
|
branchLoansSingleFamCalc |
long(-2147483648,2147483647) |
|
Revolving and permanent loans secured by real estate via 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. Includes liens on: nonfarm property with 1-4 dwelling units (or more if separated by ground-to-roof walls); mobile homes (where state laws define them as real property and loans are secured by them); individual condominium and cooperative housing units (even in buildings with 5+ units); vacant lots in single-family residential areas; and primarily residential housekeeping dwellings combined with commercial units (if 1-4 family dwelling units). This is an approximation for the branch, derived from company-wide information. Magnitude: ($000). |
|
branchNumber |
long(-2147483648,2147483647) |
|
ID for a branch as filed with the regulatory agency. These are often consistent from year to year, but may change. |
|
companyId |
long(-2147483648,2147483647)* |
|
Unique identifier assigned to a company |
|
companyIdParent |
string(13) |
|
Unique identifier for the highest-holder parent company |
|
institutionId |
long(-2147483648,2147483647) |
|
S&P's unique key to identify institutions. |
|
maskBranchMarketExclusion |
long(-2147483648,2147483647)* |
|
Branches may be excluded from some marketshare analyses under certain circumstances. This is a bitmask of the reasons why this branch may be excluded. |
|
mostRecentActiveBranchDeposit |
boolean* |
|
Indicates that this row is most recent for the branch, and is also for the most recently available year's data |
|
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. |
|
parentInstitutionId |
long(-2147483648,2147483647) |
|
S&P's unique key for the highest-holder parent institutions |
|
regDomainClassBankLevelId |
long(0,255) |
|
Regulatory Domain key for the domain of the Institution; this is the subsidiary/bank-level Reg Domain |
|
regDomainClassHHIId |
long(0,255) |
|
Regulatory domain key for the domain of the InstitutionUltimateParent to use for HHI analysis |
| link |
regDomainClassId |
RegDomainClass |
|
The primary division of companies for which regulatory information is available. |
|
retailBankBranch |
boolean* |
|
Indicates that the branch is excluded from certain aggregations due to the presence of significant non-retail deposits |