| Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|
| objectType |
|
|
|
|
| not stored in DB |
| EagleML/referenceTransaction/issuerESG/objectType |
| objectId |
|
|
|
|
| not stored in DB |
| EagleML/referenceTransaction/issuerESG/objectId |
| objectDescription |
|
|
|
|
| not stored in DB |
| EagleML/referenceTransaction/issuerESG/objectDescription |
| updateTimestamp |
|
| dateTime | 1106 |
| SECURITYDBO | ISSUER_ESG | UPDATE_DATE | DATE | EagleML/referenceTransaction/issuerESG/updateTimestamp |
| customElements | Not recommended |
|
|
|
|
|
|
| EagleML/referenceTransaction/issuerESG/customElements/ |
| sourceName |
|
|
|
|
|
|
|
|
| EagleML/referenceTransaction/issuerESG/sourceName |
| updateSource |
| Required |
|
|
|
|
|
|
| EagleML/referenceTransaction/issuerESG/updateSource |
| effectiveDate |
| Required |
|
|
|
|
|
|
| EagleML/referenceTransaction/issuerESG/effectiveDate |
| languageId |
|
|
|
|
| not stored in DB |
| EagleML/referenceTransaction/issuerESG/languageId |
| tagNochangecase |
|
|
|
|
| not stored in DB |
| EagleML/referenceTransaction/issuerESG/tagNochangecase |
| preserveNull |
|
|
|
|
| not stored in DB |
| EagleML/referenceTransaction/issuerESG/preserveNull |
| noLoadValidationFlag |
|
|
|
|
| not stored in DB |
| EagleML/referenceTransaction/issuerESG/noLoadValidationFlag |
| accountingValidationFlag |
|
|
|
|
| not stored in DB |
| EagleML/referenceTransaction/issuerESG/accountingValidationFlag |
| Issuer Identifiers Model | EagleML/referenceTransaction/issuerESG/ |
| historyOnlyFlag |
|
| YesNoOptionEnum |
|
| not stored in DB |
| EagleML/referenceTransaction/issuerESG/historyOnlyFlag |
| releaseStatus |
|
| string | 614 | in_release_status | SECURITYDBO | ISSUER_ESG | RELEASE_STATUS | CHAR(1) | EagleML/referenceTransaction/issuerESG/releaseStatus |
| releaseDate |
|
| date | 8984 | in_release_date | SECURITYDBO | ISSUER_ESG | RELEASE_DATE | DATE | EagleML/referenceTransaction/issuerESG/releaseDate |
| esgScoreAlpha |
|
| string | 17295 | in_esg_score_alpha | SECURITYDBO | ISSUER_ESG | ESG_SCORE_ALPHA | VARCHAR2(20) | EagleML/referenceTransaction/issuerESG/esgScoreAlpha |
| esgScoreNumeric |
|
| decimal | 17296 | in_esg_score_numeric | SECURITYDBO | ISSUER_ESG | ESG_SCORE_NUMERIC | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/esgScoreNumeric |
| companiesGroupAverage |
|
| decimal | 17297 | in_comp_group_avg | SECURITYDBO | ISSUER_ESG | COMP_GROUP_AVG | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/companiesGroupAverage |
| environmentScoreAlpha |
|
| string | 17298 | in_env_score_alpha | SECURITYDBO | ISSUER_ESG | ENV_SCORE_ALPHA | VARCHAR2(20) | EagleML/referenceTransaction/issuerESG/environmentScoreAlpha |
| environmentScoreNumeric |
|
| decimal | 17299 | in_env_score_numeric | SECURITYDBO | ISSUER_ESG | ENV_SCORE_NUMERIC | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/environmentScoreNumeric |
| environmentWeight |
|
| decimal | 17300 | in_env_weight | SECURITYDBO | ISSUER_ESG | ENV_WEIGHT | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/environmentWeight |
| socialScoreAlpha |
|
| string | 17301 | in_social_score_alpha | SECURITYDBO | ISSUER_ESG | SOCIAL_SCORE_ALPHA | VARCHAR2(20) | EagleML/referenceTransaction/issuerESG/socialScoreAlpha |
| socialScoreNumeric |
|
| decimal | 17302 | in_social_score_numeric | SECURITYDBO | ISSUER_ESG | SOCIAL_SCORE_NUMERIC | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/socialScoreNumeric |
| socialWeght |
|
| decimal | 17303 | in_social_weight | SECURITYDBO | ISSUER_ESG | SOCIAL_WEIGHT | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/socialWeght |
| governanceScoreAlpha |
|
| string | 17304 | in_gov_score_alpha | SECURITYDBO | ISSUER_ESG | GOV_SCORE_ALPHA | VARCHAR2(20) | EagleML/referenceTransaction/issuerESG/governanceScoreAlpha |
| governanceScoreNumeric |
|
| decimal | 17305 | in_gov_score_numeric | SECURITYDBO | ISSUER_ESG | GOV_SCORE_NUMERIC | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/governanceScoreNumeric |
| governanceWeght |
|
| decimal | 17306 | in_gov_weight | SECURITYDBO | ISSUER_ESG | GOV_WEIGHT | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/governanceWeght |
| controversyScore |
|
| string | 17307 | in_controversy_score | SECURITYDBO | ISSUER_ESG | CONTROVERSY_SCORE | VARCHAR2(20) | EagleML/referenceTransaction/issuerESG/controversyScore |
| countryDomicile |
|
| string | 4353 | in_country_of_domicile | SECURITYDBO | ISSUER_ESG | COUNTRY_OF_DOMICILE | VARCHAR2(30) | EagleML/referenceTransaction/issuerESG/countryDomicile |
| region |
|
| string | 5423 | in_region | SECURITYDBO | ISSUER_ESG | REGION | VARCHAR2(50) | EagleML/referenceTransaction/issuerESG/region |
| gicsSector |
|
| string | 16809 | in_gics_sector | SECURITYDBO | ISSUER_ESG | GICS_SECTOR | VARCHAR2(60) | EagleML/referenceTransaction/issuerESG/gicsSector |
| globalCompactTotal |
|
| decimal | 17329 | in_gc_total | SECURITYDBO | ISSUER_ESG | GC_TOTAL | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/globalCompactTotal |
| globalCompactWeight |
|
| decimal | 17330 | in_gc_weight | SECURITYDBO | ISSUER_ESG | GC_WEIGHT | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/globalCompactWeight |
| globalCompactHuman |
|
| decimal | 17331 | in_gc_human | SECURITYDBO | ISSUER_ESG | GC_HUMAN | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/globalCompactHuman |
| globalCompactLabor |
|
| decimal | 17332 | in_gc_labor | SECURITYDBO | ISSUER_ESG | GC_LABOR | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/globalCompactLabor |
| globalCompactEnvironmental |
|
| decimal | 17333 | in_gc_env | SECURITYDBO | ISSUER_ESG | GC_ENV | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/globalCompactEnvironmental |
| globalCompactAntiCorruption |
|
| decimal | 17334 | in_gc_anti_corrupt | SECURITYDBO | ISSUER_ESG | GC_ANTI_CORRUPT | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/globalCompactAntiCorruption |
| adultIntertainmentIndicator |
|
| YesNoOptionEnum | 17453 |
| SECURITYDBO | ISSUER_ESG | ADULT_ENT | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/adultIntertainmentIndicator |
| alcoholIndicator |
|
| YesNoOptionEnum | 17454 |
| SECURITYDBO | ISSUER_ESG | ALCOHOL | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/alcoholIndicator |
| defenceIndicator |
|
| YesNoOptionEnum | 17455 |
| SECURITYDBO | ISSUER_ESG | DEFENSE | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/defenceIndicator |
| fossilFuelIndicator |
|
| YesNoOptionEnum | 17456 |
| SECURITYDBO | ISSUER_ESG | FOSSIL_FUEL | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/fossilFuelIndicator |
| gamblingIndicator |
|
| YesNoOptionEnum | 17457 |
| SECURITYDBO | ISSUER_ESG | GAMBLING | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/gamblingIndicator |
| gmoIndicator |
|
| YesNoOptionEnum | 17458 |
| SECURITYDBO | ISSUER_ESG | GMO | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/gmoIndicator |
| nuclearIndicator |
|
| YesNoOptionEnum | 17459 |
| SECURITYDBO | ISSUER_ESG | NUCLEAR | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/nuclearIndicator |
| porkIndicator |
|
| YesNoOptionEnum | 17460 |
| SECURITYDBO | ISSUER_ESG | PORK | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/porkIndicator |
| stemCellIndicator |
|
| YesNoOptionEnum | 17461 |
| SECURITYDBO | ISSUER_ESG | STEM_CELL | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/stemCellIndicator |
| tobaccoIndicator |
|
| YesNoOptionEnum | 17462 |
| SECURITYDBO | ISSUER_ESG | TOBACCO | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/tobaccoIndicator |
| weaponsIndicator |
|
| YesNoOptionEnum | 17463 |
| SECURITYDBO | ISSUER_ESG | WEAPONS | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/weaponsIndicator |