| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
|
cAFileNumber |
string(7)* |
|
ID used by the California Department of Managed Health Care to identify health insurance companies |
|
csGroupKeyStatEntityForPublication |
string(20)* |
|
S&P's unique key to identify institutions that file U.S. statutory financials with the NAIC |
|
csGroupStatEntityLongName |
string(140)* |
|
Long name of entity |
|
groupAggregateLastDate |
date |
|
Last Date to Calculate Group Aggregates |
|
groupAggregateLastRun |
date |
|
Date on which group aggregation was last successfully performed |
|
groupKeyStatEntityForPublication |
string(20)* |
|
S&P's unique key to identify institutions that file U.S. statutory financials with the NAIC |
|
groupStatEntityLongName |
string(140)* |
|
Long name of entity |
|
keyInstn |
long |
|
S&P's unique key to identify institutions. Institutions are corporations |
|
keyInstnGroup |
long |
|
The anchor KeyInstn that for the SNL group. The anchor KeyInstn is also the ultimate parent in the group. |
|
keyNAICFilerType |
long |
|
OID of NAICFilerType |
|
keySAFilingAssetType |
long |
|
S A Filing Asset Type OID |
|
keyStatEntityType |
long |
|
Key of Stat Entity Type |
|
nAICDerived |
long |
|
The NAIC code assigned to the entity |
|
statEntityLongName |
string(40)* |
|
Long name of entity |
|
subGroupKeyStatEntityForPublication |
string(20)* |
|
S&P's unique key to identify institutions that file U.S. statutory financials with the NAIC |
|
subGroupStatEntityLongName |
string(140)* |
|
Long name of entity |
|
updDate |
date |
|
Last modification date and time of a physical row |
|
updOperation |
long |
|
Indicates whether the row is new |