Type StatEntity
Type category Entity
Description StatEntity
Fields
Name Type Filters Description
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.
32 rows of 32 total
API Open API Specification