| key |
id |
string(36)* |
= |
Stat Entity 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. |
|
caFileNumber |
string(7) |
|
ID used by the California Department of Managed Health Care to identify health insurance companies |
| filter_list |
ciqCompanyId |
long(-2147483648,2147483647) |
= |
Unique identifier assigned to a company |
|
combinedEntityTopTier |
boolean |
|
Indicates that this entity is a top tier entity based on the P&C combined filing groups |
|
crossSectorEntityTopTier |
boolean |
|
Indicates that this entity is a cross sector top tier entity |
|
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. |
|
insuranceStatActivityBus |
string(50) |
|
The primary geographic focus or business line the company is engaged in |
|
insuranceStatActivityGeo |
string(50) |
|
The primary geographic focus or business line the company is engaged in |
|
naicCode |
long(-2147483648,2147483647) |
|
The NAIC code assigned to the entity, whether a combined P&C filer, an institution, or a branch |
|
naicCombinedCompanyCode |
long(-32768,32767) |
|
NAIC Combined Company Code |
|
naicFilerType |
string(30) |
|
Type of NAIC filer |
|
naicSeparateAccountId |
string(5) |
|
Unique code assigned by the NAIC that identifies the specific separate account among multiple separate accounts of an insurer |
|
regCurrentInsurance |
long(0,255) |
|
Indicates coverage of this company by SNL with respect to insurance regulatory financial information |
|
saFilingAssetType |
string(15) |
|
Separate account filing asset type |
|
saFilingDescription |
string(25) |
|
Designation of geography or business focus derived from the NAIC filed Separate Account company name |
|
spStatEntityId |
string(20) |
|
S&P's unique key to identify institutions that file U.S. statutory financials with the NAIC |
|
statEntityCSGroupId |
string(36) |
|
The key of the entity representing the cross sector group that the entity record is part of |
|
statEntityGroup |
boolean |
|
Indicates the entity is a group |
|
statEntityGroupId |
string(36) |
|
The key of the entity representing the top tier group that the entity record is part of |
|
statEntityId |
string(36)* |
|
Stat Entity Unique Identifier |
|
statEntityLongNameAccentIns |
string(140) |
|
Long name of entity |
|
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 |
|
statEntitySAId |
string(36) |
|
Unique Identifier of Separate Accounts Stat Entity |
|
statEntitySNLIndAggregate |
boolean |
|
Indicates the entity is an SNL industry aggregate |
|
statEntitySecondTier |
boolean |
|
Indicates the statutory insurance entity is a second tier entity |
|
statEntitySubGroup |
boolean |
|
Indicates if the statutory insurance entity is a sub group |
|
statEntitySubGroupId |
string(36) |
|
Key of Nearest Sub Group Entity |
|
statEntityTopTier |
boolean |
|
Indicates the statutory insurance entity is a top tier entity |
|
statEntityType |
string(20)* |
|
Stat Entity Type |