| key |
id |
string(36)* |
= |
Insurance Stat History Unique Identifier |
| 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. |
|
dataSourcePeriod |
string(6) |
|
Together with the KeyInstn and the restatement status, completes the unique key used to identify a financial period within the DataSource. Concatenation of the Fiscal Year and Fiscal Period values, or, for derived periods, may be 'LTM' or some other designation. |
|
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. |
|
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. |
|
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. |
|
naicGroupCode |
long(-2147483648,2147483647) |
|
ID used by the National Association of Insurance Commissioners to identify affiliated groups of companies. Companies with the same NAIC Group are affiliates. |
|
naicGroupHistoryId |
string(36) |
|
Insurance Stat History Unique Identifier |
|
naicGroupName |
string(50) |
|
Name of NAIC Group, as reported |
|
updDate |
dateTime* |
|
Last modification date and time of a physical row |
|
updOperation |
long(0,255)* |
|
Indicates whether the row is new, updated, or (logically) deleted. Logically deleted rows should not appear in any product data, nor in default views of the data. 0: New, 1: Updated, 2: Logical Deletion. |