| key |
id |
string(36)* |
= |
The bank regulatory stock period identifier |
|
accountingPrinciple |
string(255) |
|
An accounting principle used to create financial statements |
|
accountingPrincipleId |
long(-32768,32767) |
|
The bank regulatory accounting principle identifier |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the Price is calculated. |
|
companyId |
long(-2147483648,2147483647) |
|
S&P company identifier. |
|
currencyISOCode |
string(3)* |
|
Alphabetic code used to identify currencies pursuant to ISO-4217 |
|
currentFinl |
boolean |
|
For any financial period, current data is the most up-to-date financial information available |
|
institutionId |
long(-2147483648,2147483647) |
|
S&P's unique key to identify institutions. Institutions are corporations, partnerships, proprietorships, not-for-profit organizations, government agencies, and any other chartered organization. |
|
isCurrent |
boolean |
|
For any financial period, current data is the most up-to-date financial information available |
|
isOriginal |
boolean |
|
For any financial period, originally reported data is that which was reported to the public prior to any later restatement |
|
lastUpdateDate |
date |
|
Date the regulatory filing was last updated as per regulatory agency |
|
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, 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, but there will always be at least the one row marked with a 1. |
|
periodEndDate |
date* |
|
Date on which the fiscal period ended |
|
regEntityId |
long(-2147483648,2147483647)* |
|
Key of Bank Regulatory Entity |
|
regFilingSource |
string(30) |
|
Financial reporting forms submitted to regulatory agencies, with preference for consolidated filings when multiple types are filed for the same period, include: 031 (FFIEC 031 for banks with domestic and foreign offices), 041 (FFIEC 041 for banks with domestic offices only), 051 (FFIEC 051 for banks with domestic offices and assets under $1 billion), Y9SP (FR Y-9SP for small holding companies, unconsolidated), Y9LP (FR Y-9LP for large holding companies, unconsolidated), Y9C (FR Y-9C for holding companies, consolidated), 5300 (NCUA 5300 for natural person credit unions), 5310 (NCUA 5310 for corporate credit unions), 2320 (FR 2320 for savings and loan holding companies), and TFR (Thrift Financial Report for savings associations; FFIEC 032, 033, 034 replaced by FFIEC 041 in 2001). |
|
regFilingSourceId |
long(0,255) |
|
The financial reporting form filed with the institution's regulatory agency with priority given to the consolidated filing when more than one filing type is filed for a given period. |
|
regStockPeriodId |
string(36)* |
|
The bank regulatory stock period identifier |
|
restatement |
long(0,255)* |
|
For restated bank regulatory financial information, indicates the latest restatement for which the financial period was updated. |
|
unitarySubsidiaryKey |
long(-2147483648,2147483647) |
|
Institution id for bank regulatory entities |
|
unitarySubsidiaryName |
string(80) |
|
Complete name of the institution, as specified in its charter |
|
updDate |
dateTime* |
|
Last modification date and time of a physical row |