Issuer ESG Data Map Table
- Dmitry Donosiyan (Unlicensed)
- Kinga Huszno
- Anna Krapivina
Load supports History Only mode:
Database | Table | Tags Required | Partitioned | Data Category | Purge Priority | Purging Comments | Threshold | Description |
|---|---|---|---|---|---|---|---|---|
SECURITYDBO | ISSUER_ESG | N | N | Reference | Low | Â | 100K | stores gold copy of ESG data for Issuers |
SECURITYDBO | ISSUER_ESG_HIST | N | N | Reference | Low | Â | 100K | stores composite and vendor records of ESG data for Issuers |
SCRUBDBO | ISSUER_ESG_HIST | N | N | Reference | Low | Â | 100K | scrubdbo version of ESG data for Issuers |
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 | ||
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 |
socialWeight | Â | Â | decimal | 17303 | in_social_weight | SECURITYDBO | ISSUER_ESG | SOCIAL_WEIGHT | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/socialWeight |
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 |
governanceWeight | Â | Â | decimal | 17306 | in_gov_weight | SECURITYDBO | ISSUER_ESG | GOV_WEIGHT | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/governanceWeight |
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 |
adultEntertainmentIndicator | Â | Â | YesNoOptionEnum | 17453 | in_adult_ent | SECURITYDBO | ISSUER_ESG | ADULT_ENT | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/adultEntertainmentIndicator |
alcoholIndicator | Â | Â | YesNoOptionEnum | 17454 | in_alcohol | SECURITYDBO | ISSUER_ESG | ALCOHOL | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/alcoholIndicator |
defenceIndicator | Â | Â | YesNoOptionEnum | 17455 | in_defense | SECURITYDBO | ISSUER_ESG | DEFENSE | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/defenceIndicator |
fossilFuelIndicator | Â | Â | YesNoOptionEnum | 17456 | in_fossil_fuel | SECURITYDBO | ISSUER_ESG | FOSSIL_FUEL | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/fossilFuelIndicator |
gamblingIndicator | Â | Â | YesNoOptionEnum | 17457 | in_gambling | SECURITYDBO | ISSUER_ESG | GAMBLING | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/gamblingIndicator |
gmoIndicator | Â | Â | YesNoOptionEnum | 17458 | in_gmo | SECURITYDBO | ISSUER_ESG | GMO | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/gmoIndicator |
nuclearIndicator | Â | Â | YesNoOptionEnum | 17459 | in_nuclear | SECURITYDBO | ISSUER_ESG | NUCLEAR | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/nuclearIndicator |
porkIndicator | Â | Â | YesNoOptionEnum | 17460 | in_pork | SECURITYDBO | ISSUER_ESG | PORK | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/porkIndicator |
stemCellIndicator | Â | Â | YesNoOptionEnum | 17461 | in_stem_cell | SECURITYDBO | ISSUER_ESG | STEM_CELL | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/stemCellIndicator |
tobaccoIndicator | Â | Â | YesNoOptionEnum | 17462 | in_tobacco | SECURITYDBO | ISSUER_ESG | TOBACCO | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/tobaccoIndicator |
weaponsIndicator | Â | Â | YesNoOptionEnum | 17463 | in_weapons | SECURITYDBO | ISSUER_ESG | WEAPONS | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/weaponsIndicator |
enterpriseValue | Â | Â | decimal | 18426 | in_enterprise_value | SECURITYDBO | ISSUER_ESG | ENTERPRISE_VALUE | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/enterpriseValue |
enterpriseValuationYear | Â | Â | integer | 18427 | in_enterprise_valuation_year | SECURITYDBO | ISSUER_ESG | ENTERPRISE_VALUATION_YEAR | NUMBER(38) | EagleML/referenceTransaction/issuerESG/enterpriseValuationYear |
carbonEmissionsScope1 | Â | Â | integer | 18428 | in_carbon_emissions_scope_1 | SECURITYDBO | ISSUER_ESG | CARBON_EMISSIONS_SCOPE_1 | NUMBER(38) | EagleML/referenceTransaction/issuerESG/carbonEmissionsScope1 |
carbonEmissionsScope2 | Â | Â | integer | 18429 | in_carbon_emissions_scope_2 | SECURITYDBO | ISSUER_ESG | CARBON_EMISSIONS_SCOPE_2 | NUMBER(38) | EagleML/referenceTransaction/issuerESG/carbonEmissionsScope2 |
carbonEmissionsScope1and2 | Â | Â | integer | 18430 | in_carbon_emissions_scope_1_2 | SECURITYDBO | ISSUER_ESG | CARBON_EMISSIONS_SCOPE_1_2 | NUMBER(38) | EagleML/referenceTransaction/issuerESG/carbonEmissionsScope1and2 |
carbonEmissionsReviewYear | Â | Â | integer | 18431 | in_carbon_emissions_year | SECURITYDBO | ISSUER_ESG | CARBON_EMISSIONS_YEAR | NUMBER(38) | EagleML/referenceTransaction/issuerESG/carbonEmissionsReviewYear |
carbonEmissionsKey | Â | Â | string | 18432 | in_carbon_emissions_key | SECURITYDBO | ISSUER_ESG | CARBON_EMISSIONS_KEY | VARCHAR2(255) | EagleML/referenceTransaction/issuerESG/carbonEmissionsKey |
carbonEmissionsScope3 | Â | Â | integer | 18433 | in_carbon_emissions_scope_3 | SECURITYDBO | ISSUER_ESG | CARBON_EMISSIONS_SCOPE_3 | NUMBER(38) | EagleML/referenceTransaction/issuerESG/carbonEmissionsScope3 |
Â