NAIC Designation Data Map Table

objectType

Required

objectType

EagleML/referenceTransaction/naicDesignation/objectType

objectId

Required

objectId

EagleML/referenceTransaction/naicDesignation/objectId

objectDescription

objectDescription

EagleML/referenceTransaction/naicDesignation/objectDescription

updateTimestamp

Required

dateTime

EagleML/referenceTransaction/naicDesignation/updateTimestamp

customElements

Not recommended

Custom Elements - reserved for customizations 

EagleML/referenceTransaction/naicDesignation/customElements/

sourceName

Required

string

1102

EagleML/referenceTransaction/naicDesignation/sourceName

updateSource

Required

string

944

EagleML/referenceTransaction/naicDesignation/updateSource

effectiveDate

Required

date

1109

EagleML/referenceTransaction/naicDesignation/effectiveDate

languageId

integer

EagleML/referenceTransaction/naicDesignation/languageId

tagNochangecase

string

4637

EagleML/referenceTransaction/naicDesignation/tagNochangecase

preserveNull

5284

EagleML/referenceTransaction/naicDesignation/preserveNull

noLoadValidationFlag

YesNoOptionEnum

EagleML/referenceTransaction/naicDesignation/noLoadValidationFlag

accountingValidationFlag

YesNoOptionEnum

EagleML/referenceTransaction/naicDesignation/accountingValidationFlag

clientId

Required

string

1632

in_client_id

ISTAR

ISTAR_NAIC

NAIC_COMPANY_CODE

EagleML/referenceTransaction/naicDesignation/clientId

name

string

1150

in_name

EagleML/referenceTransaction/naicDesignation/name

naicRatingType

Required

NaicRatingTypeEnum

1862

EagleML/referenceTransaction/naicDesignation/naicRatingType

naicAsset

decimal

in_asset_id

ISTAR

ISTAR_NAIC

ASSET_ID

EagleML/referenceTransaction/naicDesignation/naicAsset

designation

Required

string

5842

in_naic_designation

ISTAR

ISTAR_NAIC

NAIC_DESIGNATION

EagleML/referenceTransaction/naicDesignation/designation

naicDesignationPreffix

string

5841

in_naic_designation_preffix

ISTAR

ISTAR_NAIC

NAIC_DESIGNATION_PREFFIX

EagleML/referenceTransaction/naicDesignation/naicDesignationPreffix

naicDesignationSuffix

string

5843

in_naic_designation_suffix

ISTAR

ISTAR_NAIC

NAIC_DESIGNATION_SUFFIX

EagleML/referenceTransaction/naicDesignation/naicDesignationSuffix

svoGroupCode

string

8492

in_svo_group_code

ISTAR

ISTAR_NAIC

SVO_GROUP_CODE

EagleML/referenceTransaction/naicDesignation/svoGroupCode

naicReviewDate

date

8493

in_naic_review_dt

ISTAR

ISTAR_NAIC

NAIC_REVIEW_DT

EagleML/referenceTransaction/naicDesignation/naicReviewDate

naicMarketIndicator

string

8494

in_naic_mkt_ind

ISTAR

ISTAR_NAIC

NAIC_MKT_IND

EagleML/referenceTransaction/naicDesignation/naicMarketIndicator

Asset Identifiers Model

Conditionally Required (naicRatingType='S')

EagleML/referenceTransaction/naicDesignation/ 

Issuer Identifiers Model

Conditionally Required (naicRatingType='I')

EagleML/referenceTransaction/naicDesignation/

brokerCode

Conditionally Required (naicRatingType='B')

string

88

PACE_MASTERDBO

CODE_VALUES

SHORT_DESC

EagleML/referenceTransaction/naicDesignation/brokerCode

brokerName

Conditionally Required (naicRatingType='B')

string

1235

PACE_MASTERDBO

CODE_VALUES

LONG_DESC

EagleML/referenceTransaction/naicDesignation/brokerName

countryCode

Conditionally Required (naicRatingType='V')

CountryCode

990

PACE_MASTERDBO

CODE_VALUES

SHORT_DESC

EagleML/referenceTransaction/naicDesignation/countryCode

countryName

Conditionally Required (naicRatingType='V')

string

4490

PACE_MASTERDBO

CODE_VALUES

LONG_DESC

EagleML/referenceTransaction/naicDesignation/countryName