NAIC Designation Data Map Table
- Natalie Gesin (Deactivated)
- Alexey Trubitsyn
- Alexey Chunikhin
- Dmitry Donosiyan (Unlicensed)
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 | ||
Conditionally Required (naicRatingType='S') | EagleML/referenceTransaction/naicDesignation/Â | ||||||||
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 | ||