Type BranchDeposit
Type category Entity
Description Bank branch deposit data, and other information that comes in on the annual tapes.
Fields
Name Type Filters Description
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
35 rows of 35 total
API Open API Specification