| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
|
appstatus |
long |
|
Status of this object's data with respect to approval for publication |
|
entitylastsynced |
date |
|
The date and time the entity was last synchronized with the DMZ servers |
|
groupaggregatelastdate |
date |
|
Last Date to Calculate Group Aggregates |
|
groupaggregatelastrun |
date |
|
Date on which group aggregation was last successfully performed |
|
groupaggregatestartdate |
date |
|
Begin Date of Group Aggregation |
|
keyinstn |
long |
|
S&P's unique key to identify institutions. Institutions are corporations, partnerships, proprietorships, not-for-profit organizations, government agencies, and any other chartered organization. |
|
keyinstncahealth |
long |
|
CA Health Instn Key |
|
keyinstncorp |
long |
|
Subsidiary company within the group or combined entity that best represents the corporate and officer data of the group or combined entity |
|
keyinstncorpbest |
long |
|
The institution or the subsidiary company within the group or combined entity that best represents the corporate and officer data of the group or combined entity |
|
keyinstnderived |
long |
|
The KeyInstn derived from a related table based on the KeyStatEntityType |
|
keyinstngroup |
long |
|
The anchor KeyInstn that for the SNL group. The anchor KeyInstn is also the ultimate parent in the group. |
|
keyinstninsurancestatlob |
long |
|
Instn Insurance Stat OID |
|
keynaicfilertype |
long |
|
OID of NAICFilerType |
|
keynaicfilertypederived |
long |
|
The filer type derived from a related table based on the KeyStatEntityType |
|
keynaicfilertypegroup |
long |
|
The filer type of the group |
|
keysafilingassettype |
long |
|
S A Filing Asset Type OID |
|
keystatentity |
string |
|
Stat Entity OID |
|
keystatentityforpublication |
string(20) |
|
S&P's unique key to identify institutions that file U.S. statutory financials with the NAIC |
|
keystatentitytype |
long |
|
Key of Stat Entity Type |
|
keystatsubindustry |
long |
|
Stat Sub Industry OID |
|
naiccombinedcompanycode |
long |
|
NAIC Combined Company Code |
|
naicseparateaccountid |
string(5) |
|
Unique code assigned by the NAIC that identifies the specific separate account among multiple separate accounts of an insurer |
|
safilingdescription |
string(25) |
|
Designation of geography or business focus derived from the NAIC filed Separate Account company name |
|
statentitybranch |
boolean |
|
Indicates the entity is a branch |
|
statentitycompany |
boolean |
|
Indicates the entity is a company |
|
statentitygroup |
boolean |
|
Indicates the entity is a group |
|
statentityname |
string(120) |
|
Created at the segment level of a given industry sector within the same corporate tree |
|
statentitypccombined |
boolean |
|
Indicates the entity is a P&C combined entity |
|
statentitysnlindaggregate |
boolean |
|
Indicates the entity is an SNL industry aggregate |
|
upddate |
date |
|
Last modification date and time of a physical row |
|
updoperation |
long |
|
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. |