| key |
id |
string(36)* |
= |
Unique identifier for each Stock period |
| link |
batch |
Batch* |
= |
Definition of a batch, representing a set of updates linked to a particular condition. |
| link |
batchRun |
BatchRun* |
= |
Defines an instance of a Batch. Where a Batch has a fixed definition over time, a BatchRun represents a specific Version of the Batch on a specific asOf. |
|
ciqCompanyId |
long(-2147483648,2147483647) |
|
Unique identifier assigned to a company |
|
dateEndedStandard |
dateTime* |
|
Ending date of the fiscal period, standardized to be the last day of the month in which the period ends. For example, if a fiscal period ends on June 29, this date will be June 30, so that there is a consistency among different companies. |
|
finlStatStockId |
string(36)* |
|
Unique identifier for each Stock period |
|
finlStatStockPriorId |
string(36) |
|
Unique identifier for each Stock period of Prior period |
|
finlStatStockPriorYearId |
string(36) |
|
Unique identifier for each Stock period of Prior Year |
|
finlStatStockTotalLOBId |
string(36) |
|
Unique identifier for each of Total LOB |
|
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. |
|
insuranceStatLOBId |
long(-32768,32767)* |
|
Unique identifier for each Line of Business |
|
insuranceStatLOBShortName |
string(40) |
|
A short name for the insurance statutory line of business |
|
insuranceStatLineOfBusiness |
string(80) |
|
Insurance statutory line of business |
|
insuranceStatReportedDate |
dateTime* |
|
Date as of which the statutory insurance data is reported |
|
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 objects, but not all objects, 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 object to object, but there will always be at least the one row marked with a 1. |
|
mostRecentSequenceFiscalYears |
long(0,255) |
|
Indicates that the row is the most recent year end |
|
spStatEntityId |
string(20) |
|
S&P's unique key to identify institutions that file U.S. statutory financials with the NAIC |
|
statEntityId |
string(36)* |
|
Unique identifier for each Statutory entity |