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 | |||||||
| 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 | ||
| socialWeghtsocialWeight | decimal | 17303 | in_social_weight | SECURITYDBO | ISSUER_ESG | SOCIAL_WEIGHT | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/socialWeghtsocialWeight | ||
| 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 | ||
| governanceWeghtgovernanceWeight | decimal | 17306 | in_gov_weight | SECURITYDBO | ISSUER_ESG | GOV_WEIGHT | NUMBER(38,12) | EagleML/referenceTransaction/issuerESG/governanceWeghtgovernanceWeight | ||
| 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 | ||
| adultIntertainmentIndicatoradultEntertainmentIndicator | YesNoOptionEnum | 17453 | in_adult_ent | SECURITYDBO | ISSUER_ESG | ADULT_ENT | VARCHAR2(3) | EagleML/referenceTransaction/issuerESG/adultIntertainmentIndicatoradultEntertainmentIndicator | ||
| 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 | ||