| key |
id |
string(100)* |
= |
Unique key to identify individual branch. |
| 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. |
|
branchCloseDate |
date |
|
Date on which the branch ceased operations, or, if the exact date is not known, the closing date is approximated to the last month in which the branch could have operated |
|
branchClosedExpectedDate |
date |
|
Date on which the branch is expected to cease operations |
|
branchClosedFilingDate |
date |
|
Date on which the branch filed its intention to cease operations |
|
branchDescription |
string(255) |
|
Description of the branch, often a common name used for the branch, as reported by the company |
|
branchId |
long(-2147483648,2147483647)* |
|
Unique key to identify individual branch. |
|
branchOpenDate |
date |
|
Date on which the branch first opened for business |
|
branchOpenedExpectedDate |
date |
|
Date on which the branch is expected to first open for business |
| link |
branchStatusExtendedId |
BranchStatusExtended |
|
A key identifying the operating status of the branch, including dependencies on the availability of deposit data |
| link |
branchStatusId |
BranchStatus |
|
A key identifying the operating status of the branch, whether open, closed, or pending operations as a de-novo branch |
| link |
censusTractId |
CensusTract |
|
Government code used to identify U.S. counties and other first-order subdivisions of states. Codes are pursuant to U.S. FIPS 6-4. |
|
centroid |
boolean |
|
Indicates that the latitude and longitude for this location are approximated. If this field is true, it indicates that the latitude and longitude are that of the Centroid, or geographic center of the best available area for the location |
| link |
centroidBasisId |
CentroidBasis |
|
Lookup key for Centroid Basis; If the exact latitude and longitude of a location are unknown, they can be calculated as the 'centroid' (geographic center) of a given geographic area in which we know them to be located. When we do this, this is the type of geographic area from which the centroid was derived. |
| link |
cityAsReportedId |
CityAsReported |
|
Unique identifier for cities |
| link |
countyId |
County |
|
Government code used to identify U.S. counties and other first-order subdivisions of states. Codes are pursuant to U.S. FIPS 6-4. |
|
deNovoBranch |
boolean |
|
Indicates that the branch is operating but has not yet filed deposit data; these branches will have no most recent statement of deposits data |
|
fdicBranchId |
long(-2147483648,2147483647) |
|
The identifier used by the FDIC to identify branches within one year's disclosure |
|
fullZip |
string(10) |
|
U.S. Postal Service ZIP Code (Zone Improvement Plan)plus the four-digit extension if available |
|
geoLocation |
string(4096) |
|
The geo location is essentially a GUID that stores spatial info and can be used by ArcGIS to plot shapes on a map |
|
instnInstoreBranchId |
long(-2147483648,2147483647) |
|
For in-store branches, the Institution of the company in whose store the branch is located |
|
instoreBranch |
boolean |
|
Indicates that the branch is located in a retail facility |
|
latitude |
decimal{10,6} |
|
Asset GPS location latitude degree. |
|
longitude |
decimal{11,6} |
|
Asset GPS location longitude degree. |
|
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. |
|
mercatorX |
decimal{22,8} |
|
X or east west coordinate of a point in a Mercator projection |
|
mercatorY |
decimal{22,8} |
|
Y or north south coordinate of a point in a Mercator projection |
| link |
msaId |
MSA2003 |
|
Five digit code of the assigned Metro- or Micropolitan area in which the branch is located pursuant to the 2003 OMB definitions. These are collectively called the Core Based Statistical Areas (CBSA). |
|
ncuaBranchId |
long(-2147483648,2147483647) |
|
The identifier used by the NCUA to identify branches |
|
retailBankBranch |
boolean* |
|
Indicates that the branch is excluded from certain aggregations due to the presence of significant non-retail deposits |
| link |
stateId |
State |
|
State postal code, as defined by U.S. FIPS 5-2 |
|
street1 |
string(40)* |
|
First line of an address |
|
street2 |
string(40) |
|
Second line of an address |
| link |
zipCodeId |
ZipCodes |
|
U.S. Postal Service ZIP Code (Zone Improvement Plan) |
|
zipPlus4 |
string(4) |
|
U.S. Postal Service's four-digit ZIP Code (Zone Improvement Plan) extension |