NAIC Designation Data Map Table

Owned by Natalie Gesin (Deactivated)
Last updated: Oct 30, 2024 by Kinga Huszno
1 min read

Element

Required for Acct Validation

Required for Data Mgmt

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

Xpath

Element

Required for Acct Validation

Required for Data Mgmt

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

Xpath

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_naic_company_code

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

naicDesignationPrefix

 

 

string

5841

in_naic_designation_prefix

ISTAR

ISTAR_NAIC

NAIC_DESIGNATION_PREFIX

EagleML/referenceTransaction/naicDesignation/naicDesignationPrefix

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

naicReviewDate

 

 

date

8493

 

ISTAR

ISTAR_XREFERENCE

NAIC_REVIEW_DT

EagleML/referenceTransaction/naicDesignation/xreference/naicReviewDate

companyCodeType

 

 

companyCodeTypeEnum

990

 

 

 

 

EagleML/referenceTransaction/naicDesignation/companyCodeType

svoCompanyCode

 

 

string

4428

 

 

 

 

EagleML/referenceTransaction/naicDesignation/svoCompanyCode

naicCompanyCodeRMBS

 

 

string

9608

 

 

 

 

EagleML/referenceTransaction/naicDesignation/naicCompanyCodeRMBS

naicDesignationModifier

 

 

string

18104

in_naic_desig_modifier

ISTAR

ISTAR_NAIC

NAIC_DESIGNATION_MODIFIER

EagleML/referenceTransaction/naicDesignation/naicDesignationModifier

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

1176

 

PACE_MASTERDBO

CODE_VALUES

SHORT_DESC

EagleML/referenceTransaction/naicDesignation/countryCode

countryName

Conditionally Required (naicRatingType='V')

 

string

1177

 

PACE_MASTERDBO

CODE_VALUES

LONG_DESC

EagleML/referenceTransaction/naicDesignation/countryName

Â