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 |
|
| ObjectTypeEnum |
|
| not stored in DB |
| EagleML/referenceTransaction/issuerESG/objectType |
objectId |
|
| ObjectId |
|
| not stored in DB |
| EagleML/referenceTransaction/issuerESG/objectId |
objectDescription |
|
| FeedTypeEnum |
|
| not stored in DB |
| EagleML/referenceTransaction/issuerESG/objectDescription |
updateTimestamp |
|
| dateTime | 1106 |
| SECURITYDBO | ISSUER_ESG | UPDATE_DATE | DATE | EagleML/referenceTransaction/issuerESG/updateTimestamp |
customElements | Not recommended | CustomElements - reserved for customizations | EagleML/referenceTransaction/issuerESG/customElements/ |
sourceName |
| Required | string |
|
| SECURITYDBO | ISSUER_ESG | SRC_INTFC_INST |
| EagleML/referenceTransaction/issuerESG/sourceName |
updateSource |
|
| string |
|
|
|
|
|
| EagleML/referenceTransaction/issuerESG/updateSource |
effectiveDate |
| Required | date |
|
| SECURITYDBO | ISSUER_ESG | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/issuerESG/effectiveDate |
languageId |
|
| integer |
|
| not stored in DB |
| EagleML/referenceTransaction/issuerESG/languageId |
tagNochangecase |
|
| string |
|
| not stored in DB |
| EagleML/referenceTransaction/issuerESG/tagNochangecase |
preserveNull |
|
| string |
|
| not stored in DB |
| EagleML/referenceTransaction/issuerESG/preserveNull |
noLoadValidationFlag |
|
| YesNoOptionEnum |
|
| not stored in DB |
| EagleML/referenceTransaction/issuerESG/noLoadValidationFlag |
accountingValidationFlag |
|
| YesNoOptionEnum |
|
| 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 |