Type SNLRegStockPeriod
Type category Entity
Description The descriptive entity contains key attributes for United States (U.S.) bank regulatory stock period data.
Fields
Name Type Filters Description
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
22 rows of 22 total
API Open API Specification