Data Rules Resource Availability

codevalue

PACE_MASTERDBO

CODE_VALUES
EGL_GENERIC_XLATION_ML (extract only)
INTERFACES (extract only)

History Table:
CODE_VALUES_HIST
EGL_GENERIC_XLATION_ML (extract only)
INTERFACES (extract only)

INSTANCE

INSTANCE, INTFC_INST, EFFECTIVE_DATE

History
Delta
Temporal

BNYM_EAGLE_DYNSQL_CODEVALUE

BNYM_EAGLE_DYNSQL_CODEVALUE_HISTORY

codecategory

PACE_MASTERDBO

CODES

INSTANCE

Delta
Temporal

BNYM_EAGLE_DYNSQL_CODECATEGORY

sources

PACE_MASTERDBO

INTERFACES

INSTANCE

Delta
Temporal

BNYM_EAGLE_DYNSQL_SOURCES

genericentity

RULESDBO

ENTITY

ENTITY_EXTENSION
ENTITY_EXTENSION_DETAIL
ENTITY_OVERRIDES
ENTITY_STAR_PROCESSING
ENTITY_ACCT_BASIS (extract only)
SECURITY.LEI_DETAILS (extract only)

History Tables:
ENTITY_HIST
ENTITY_EXTENSION_HIST
ENTITY_EXTENSION_DETAIL_HIST
ENTITY_OVERRIDES_HIST
ENTITY_STAR_PROCESSING_HIST
ENTITY_ACCT_BASIS_HIST (extract only)

ENTITY_ID

ENTITY_ID, EFFECTIVE_DATE

History
Delta
Temporal

BNYM_EAGLE_DYNSQL_GENERICENTITY

BNYM_EAGLE_DYNSQL_GENERICENTITY_HISTORY

genericsmf

SECURITYDBO

SECURITY_MASTER
COMMERCIAL_BANK
DERIVATIVES
DERIVATIVES_EXT
EQUITY
EQUITY_DETAIL
FIXED_INCOME
FIXED_INCOME_DETAIL
FIXED_INCOME_DETAIL_EXT
FIXED_INCOME_EXT
LIMITED_PARTNERSHIP
MBS
MBS_DETAIL
MBS_DETAIL_EXT
MTG_LOAN
MUNI
MUNI_DETAIL
NAIC
PORT_IND
REAL_ESTATE
SECMASTER_DETAIL_EXT
SECTOR
SECTOR_DETAIL
SECURITY_MASTER_DETAIL
SECURITY_MASTER_EXT
SECURITY_MIFID
SWAPS
SECURITY_REGULATORY

History Tables:
SECMASTER_HISTORY
COMMERCIAL_BANK_HIST
DERIVATIVES_HIST
DERIVATIVES_EXT_HIST
EQUITY_HIST
EQUITY_DETAIL_HIST
FIXED_INCOME_HIST
FIXED_INCOME_DETAIL_HIST
FIXED_INCOME_DETAIL_EXT_HIST
FIXED_INCOME_EXT_HIST
LIMITED_PARTNERSHIP_HIST
MBS_HIST
MBS_DETAIL_HIST
MBS_DETAIL_EXT_HIST
MTG_LOAN_HIST
MUNI_HIST
MUNI_DETAIL_HIST
NAIC_HIST
PORT_IND_HIST
REAL_ESTATE_HIST
SECMASTER_DETAIL_EXT_HIST
SECTOR_HIST
SECURITY_MASTER_DETAIL_HIST
SECURITY_MASTER_EXT_HIST
SWAPS_HIST
SECURITY_MIFID_HIST
SECTOR_DETAIL_HIST
SECURITY_REGULATORY_HIST

SECURITY_ALIAS

SECURITY_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE

History
Delta
Temporal

BNYM_EAGLE_DYNSQL_GENERICSMF
BNYM_EAGLE_DYNSQL_GENERICSMF_HISTORY

warehouseposition

HOLDINGDBO

POSITION
POSITION_DETAIL
POSITION_COST_DETAIL
POSITION_DETAIL_ANL_USER
POSITION_PLEDGE_DETAIL
POSITION_DETAIL_ANL
POSITION_DETAIL_ANL_EQ
POSITION_DETAIL_ANL_FI
POSITION_DETAIL_ANL_KRD
REAL_ESTATE_POSITION_DETAIL
POSITION_INCOME_DETAIL
POSITION_COST_DETAIL_USER

POSITION_ID
Batch Key: ENTITY_ID, EFFECTIVE_DATE, SRC_INTFC_INST

Batch
Temporal

BNYM_EAGLE_DYNSQL_WAREHOUSEPOSITION

warehouseopenlot

HOLDINGDBO

LOT_LEVEL_POSITION
POSITION_COST_LOT
REAL_ESTATE_POSITION_LOT
POSITION_INCOME_LOT
POSITION_COST_LOT_USER
POSITION_DETAIL
POSITION (extract only)

LOT_LEVEL_POSITION
Batch Key: ENTITY_ID, EFFECTIVE_DATE, SRC_INTFC_INST

Batch
Temporal

BNYM_EAGLE_DYNSQL_WAREHOUSEOPENLOT

warehousetrade

TRADESDBO

TRADE
TRADE_DETAIL
TRADE_EXT
TRADE_DETAIL_EXT

TRADE_ID
Batch Key: ENTITY_ID, EFFECTIVE_DATE, SRC_INTFC_INST

Batch
Temporal

BNYM_EAGLE_DYNSQL_WAREHOUSETRADE

warehousependingtrade

TRADESDBO

PENDING_TRADES

PENDING_TRADE_ID

Delta
Temporal

BNYM_EAGLE_DYNSQL_WAREHOUSEPENDINGTRADE

warehousecashactivity

CASHDBO

CASH_ACTIVITY

CASH_INT
Batch Key: ENTITY_ID, EFFECTIVE_DATE, SRC_INTFC_INST

Batch
Temporal

BNYM_EAGLE_DYNSQL_WAREHOUSECASHACTIVITY

issuerorganization

SECURITYDBO

ISSUER_ORGANIZATION
History Table:
ISSUER_ORGANIZATION_HIST

ISSUER_ALIAS

ISSUER_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE

History
Delta
Temporal

BNYM_EAGLE_DYNSQL_ISSUERORGANIZATION
BNYM_EAGLE_DYNSQL_ISSUERORGANIZATION_HISTORY

issuerregulatory

SECURITYDBO

ISSUER_REGULATORY
History Table:
ISSUER_REGULATORY_HIST

ISSUER_ALIAS

ISSUER_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE

History
Delta
Temporal

BNYM_EAGLE_DYNSQL_ISSUERREGULATORY
BNYM_EAGLE_DYNSQL_ISSUERREGULATORY_HISTORY

issuerrole

SECURITYDBO

ISSUER_ROLE_DETAILS
History Table:
ISSUER_ROLE_DETAILS_HIST

ROLE_ALIAS

ROLE_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE

History
Delta
Temporal

BNYM_EAGLE_DYNSQL_ISSUERROLE
BNYM_EAGLE_DYNSQL_ISSUERROLE_HISTORY

entitydetail

RULESDBO

ENTITY_DETAIL
History Table:
ENTITY_DETAIL_HISTORY

ENTITY_ID, ENTITY_DETAIL_ID, ENTITY_TYPE, LIST_ORDER

ENTITY_ID, ENTITY_DETAIL_ID, ENTITY_TYPE, LIST_ORDER, EFFECTIVE_DATE

History
Delta
Temporal

BNYM_EAGLE_DYNSQL_ENTITYDETAIL
BNYM_EAGLE_DYNSQL_ENTITYDETAIL_HISTORY

entityidentifiers

RULESDBO

ENTITY_XREFERENCE
ENTITY (extract only)

INSTANCE

Delta
Temporal

BNYM_EAGLE_DYNSQL_ENTITYIDENTIFIERS

smfidentifier

SECURITYDBO

XREFERENCE
History Table:
XREFERENCE_HIST

XREF_SECURITY_ALIAS
Batch Key: SECURITY_ALIAS (ASISCOPY mode only)

Delta
Temporal
Batch (ASISCOPY mode only)

BNYM_EAGLE_DYNSQL_SMFIDENTIFIER

BNYM_EAGLE_DYNSQL_SMFIDENTIFIER_HISTORY

smfidentifiers

SECURITYDBO

XREFERENCE
SECURITY_MASTER (extract only)
SECURITY_MASTER_DETAIL (extract only)
SECMASTER_DETAIL_EXT (extract only)
DERIVATIVES (extract only)
SWAPS (extract only)

XREF_SECURITY_ALIAS

Delta
Temporal

BNYM_EAGLE_DYNSQL_SMFIDENTIFIERS

Please, use smfidentifier resource for all purposes.
To resolve previously reported issue with duplicates, please rerun full conversion for smfidentifier resource to correct the data in Vault.
Please disable jobs for executing smfidentifiers/smfidentifiershist.

smfidentifiershist

SECURITYDBO

XREFERENCE_HIST
SECURITY_MASTER (extract only)
SECURITY_MASTER_DETAIL (extract only)
SECMASTER_DETAIL_EXT (extract only)
DERIVATIVES (extract only)
SWAPS (extract only)

XREF_SECURITY_ALIAS

Delta
Temporal

BNYM_EAGLE_DYNSQL_SMFIDENTIFIERSHIST

issueprice

SECURITYDBO

PRICE

SECURITY_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE

Delta
Temporal

BNYM_EAGLE_DYNSQL_ISSUEPRICE

exchangeprice

SECURITYDBO

PRICE_EXCHANGE

History Table:
PRICE_EXCHANGE_ARCH

SECURITY_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE ,EXCHANGE_CODE

SECURITY_ALIAS, SRC_INTFC_INST,EFFECTIVE_DATE,EXCHANGE_CODE

History
Delta
Temporal

BNYM_EAGLE_DYNSQL_EXCHANGEPRICE

issuerrelationship

SECURITYDBO

ISSUER_RELATIONSHIP

SRC_INTFC_INST, EFFECTIVE_DATE, FROM_ISSUER_ALIAS, TO_ISSUER_ALIAS, ROLE_TYPE

Delta
Temporal

BNYM_EAGLE_DYNSQL_ISSUERRELATIONSHIP

issuerrelationshipsummary

SECURITYDBO

ISSUER_RELATIONSHIP_SUMMARY

RELATION_INSTANCE

Delta

Temporal

BNYM_EAGLE_DYNSQL_ISSUERRELATIONSHIPSUMMARY

issuerrating

SECURITYDBO

ISSUER_RATINGS

ISSUER_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE

Delta
Temporal

BNYM_EAGLE_DYNSQL_ISSUERRATING

warehousenav

HOLDINGDBO

NAV

ENTITY_ID, SRC_INTFC_INST, EFFECTIVE_DATE, CLASS_LEVEL
Batch Key: ENTITY_ID, EFFECTIVE_DATE, SRC_INTFC_INST

Batch
Temporal

BNYM_EAGLE_DYNSQL_WAREHOUSENAV

warehousenavmulti

HOLDINGDBO

NAV_MULTI

PORTFOLIO_ACCT, SHARE_CLASS, VALUATION_DATE, NAV_SEQUENCE, LOCAL_CURRENCY
Batch Key: PORTFOLIO_ACCT, VALUATION_DATE

Batch
Temporal

BNYM_EAGLE_DYNSQL_WAREHOUSENAVMULTI

warehousecloselot

TRADESDBO

DISPOSAL_LOTS
TRADE (Extract Only)

DISPOSAL_LOT_ID
Batch Key: ENTITY_ID, EFFECTIVE_DATE

Batch
Temporal

BNYM_EAGLE_DYNSQL_WAREHOUSECLOSELOT

warehouseperformance

PERFORMDBO

PERF_SUMMARY
PSR_ANALYTICS
PERF_SEC_RETURNS
PERF_SEC_RETURNS_EXT
PSR_LIQUIDITY
RULESDBO.DICTIONARY_DETAIL (Extract Only)

PERF_SUM_INST
Batch Key: ENTITY_ID, END_EFFECTIVE_DATE, SRC_INTFC_INST, PERF_FREQ_CODE, PERF_SUMMARY_TYPE, DICTIONARY_ID, STRATEGY_ID

Batch
Temporal

BNYM_EAGLE_DYNSQL_WAREHOUSEPERFORMANCE

warehouseperformancesummarystatus

PERFORMDBO

PERF_APPROVAL_JOURNAL

DeltaBatch Extract

In progress

client

RULESDBO

CLIENT
INSTITUTION
INDIVIDUAL
CLIENT_ADDRESS (extract only)
CLIENT_RELATIONSHIPS (extract only)
CLIENT_RELATIONSHIP_DETAIL (extract only)

History Table:
CLIENT_HIST
INSTITUTION_HIST
INDIVIDUAL_HIST
CLIENT_ADDRESS (extract only)
CLIENT_RELATIONSHIPS (extract only)
CLIENT_RELATIONSHIP_DETAIL (extract only)

INSTANCE
INSTANCE
INSTANCE

INSTANCE, EFFECTIVE_DATE
INSTANCE, EFFECTIVE_DATE
INSTANCE, EFFECTIVE_DATE

History
Delta
Temporal

BNYM_EAGLE_DYNSQL_CLIENT
BNYM_EAGLE_DYNSQL_CLIENT_HISTORY

clientaddress

RULESDBO

CLIENT_ADDRESS

INSTANCE, EFFECTIVE_DATE, ADDRESS_TYPE

Delta
Temporal

BNYM_EAGLE_DYNSQL_CLIENTADDRESS

clientrelationship

RULESDBO

CLIENT_RELATIONSHIPS
CLIENT_RELATIONSHIP_DETAIL

INSTANCE, EFFECTIVE_DATE

Delta
Temporal

BNYM_EAGLE_DYNSQL_CLIENTRELATIONSHIP

clientcommunication

RULESDBO

CLIENT_COMMUNICATION
CLIENT_ADDRESS (extract only)

ADDRESS_INST, COMM_TYPE, EFFECTIVE_DATE

Delta
Temporal

BNYM_EAGLE_DYNSQL_CLIENTCOMMUNICATION

clientidentifiers

RULESDBO

CLIENT_XREFERENCE
CLIENT (extract only)

INSTANCE

Delta
Temporal

BNYM_EAGLE_DYNSQL_CLIENTIDENTIFIERS

genericissueanalytic

SECURITYDBO

SECURITY_ANALYTICS
SECURITY_ANALYTICS_DERV
SECURITY_ANALYTICS_EQUITY
SECURITY_ANALYTICS_EXT
SECURITY_ANALYTICS_FI
SECURITY_ANALYTICS_MTG
SECURITY_ANALYTICS_USER
SECURITY_EPS_EQUITY
SECURITY_PRICE_EARN_EQUITY

SECURITY_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE

Delta
Temporal

BNYM_EAGLE_DYNSQL_GENERICISSUEANALYTIC

genericissueanalyticfi

SECURITYDBO

SECURITY_ANALYTICS_FI

SECURITY_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE

Delta

Temporal

BNYM_EAGLE_DYNSQL_GENERICISSUEANALYTICFI

these resources should be used only in case when there is no corresponding record in securitydbo.security_analitytics

genericissueanalyticequity

SECURITYDBO

SECURITY_ANALYTICS_EQUITY

SECURITY_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE

Delta

Temporal

BNYM_EAGLE_DYNSQL_GENERICISSUEANALYTICEQUITY

genericca

TRADESDBO

CORP_ACT_HIST
History Tables:
CORP_ACT_ANNOUNCEMENT_HIST

INSTANCE

INSTANCE

Delta
Temporal
History

BNYM_EAGLE_DYNSQL_GENERICCA
BNYM_EAGLE_DYNSQL_GENERICCA_HISTORY

genericcadetail

TRADESDBO

CORP_ACT_HIST_DETAIL
History Table:
CORP_ACT_HIST_DETAIL_HIST

INSTANCE

INSTANCE, PRIMARY_INSTANCE

Delta
Temporal
History

BNYM_EAGLE_DYNSQL_GENERICCADETAIL
BNYM_EAGLE_DYNSQL_GENERICCADETAIL_HISTORY

genericcaextension

TRADESDBO

CORP_ACT_HIST_EXTENSION
History Table:
CORP_ACT_HIST_EXTENSION_HIST

INSTANCE

INSTANCE, PRIMARY_INSTANCE

Delta
Temporal
History

BNYM_EAGLE_DYNSQL_GENERICCAEXTENSION
BNYM_EAGLE_DYNSQL_GENERICCAEXTENSION_HISTORY

pacecalendar

PACE_MASTERDBO

BUSINESS_CALENDAR

BUSINESS_DATE, SRC_INTFC_INST

Delta
Temporal

BNYM_EAGLE_DYNSQL_PACECALENDAR

perfsecrollup

PERFORMDBO

PERF_SEC_ROLLUP_RELATION

INSTANCE

Delta
Temporal

BNYM_EAGLE_DYNSQL_PERFSECROLLUP

entitypolicy

RULESDBO

POLICY
POLICY_DETAIL (extract only)
POLICY_RATES (extract only)
POLICY_MAP (extract only)

INSTANCE

Delta
Temporal

BNYM_EAGLE_DYNSQL_ENTITYPOLICY

entitypolicydetail

RULESDBO

POLICY_DETAIL
POLICY (extract only)

INSTANCE

Delta
Temporal

BNYM_EAGLE_DYNSQL_ENTITYPOLICYDETAIL

entitypolicyrate

RULESDBO

POLICY_RATES

INSTANCE

Delta
Temporal

BNYM_EAGLE_DYNSQL_ENTITYPOLICYRATE

entitypolicymap

RULESDBO

POLICY_MAP
POLICY (extract only)

INSTANCE

Delta
Temporal

BNYM_EAGLE_DYNSQL_ENTITYPOLICYMAP

issuefxrate

SECURITYDBO

FX_RATES

SECURITY_ALIAS, FROM_SECALIAS, SRC_INTFC_INST, EFFECTIVE_DATE

Delta
Temporal

BNYM_EAGLE_DYNSQL_ISSUEFXRATE

custombenchmark

RULESDBO

CUSTOM_INDEX_ATTRIBUTES
CUSTOM_INDEX_ATTR_DETAIL

INSTANCE
Batch Key: EFFECTIVE_DATE, ENTITY_ID, ENTITY_DETAIL_ID, TARGET_DICT_ID, SOURCE_DICT_ID, DICT_LEVEL, TARGET_DICT_ITEM_ID

Batch
Temporal

BNYM_EAGLE_DYNSQL_CUSTOMBENCHMARK

entityshareclass

RULESDBO

ENTITY_SHARE_CLASS
History Table:
ENTITY_SHARE_CLASS_HIST

ENTITY_ID, CLASS_CODE

ENTITY_ID, CLASS_CODE, EFFECTIVE_DATE

History
Delta
Temporal

BNYM_EAGLE_DYNSQL_ENTITYSHARECLASS
BNYM_EAGLE_DYNSQL_ENTITYSHARECLASS_HISTORY

reportdictionarysummary

RULESDBO

DICTIONARIES

DICTIONARY_ID

Delta
Temporal

BNYM_EAGLE_DYNSQL_REPORTDICTIONARYSUMMARY

reportdictionarydetail

RULESDBO

DICTIONARY_DETAIL
DICTIONARIES (extract only)

DICTIONARY_DETAIL_ID

Delta
Temporal

BNYM_EAGLE_DYNSQL_REPORTDICTIONARYDETAIL

reportdictionarylevel

RULESDBO

DICTIONARY_FORMAT
FIELD_ATTRIBUTES (extract only)
PACE_MASTER.CODES (extract only)
PACE_MASTER.GROUP_CODES (extract only)
DICTIONARIES (extract only)

DICTIONARY_ID, DICTIONARY_LEVEL

Delta
Temporal

BNYM_EAGLE_DYNSQL_REPORTDICTIONARYLEVEL

reportdictionarylinkedasset

RULESDBO

SECURITY_DICTIONARY_LINK
DICTIONARIES (extract only)

SECURITY_DICTIONARY_LINK_ID

Delta
Temporal

BNYM_EAGLE_DYNSQL_REPORTDICTIONARYLINKEDASSET

legalentityid

SECURITYDBO

LEI_DETAILS

LEI

Delta
Temporal

BNYM_EAGLE_DYNSQL_LEGALENTITYID

entityaccountingbasis

RULESDBO

ENTITY_ACCT_BASIS
ESTAR_ACCOUNTING_PERIODS (extract only)
History Table:
ENTITY_ACCT_BASIS_HIST

PORTFOLIO_ACCT, ACCT_BASIS

PORTFOLIO_ACCT, ACCT_BASIS, EFFECTIVE_DATE

History
Delta
Temporal

BNYM_EAGLE_DYNSQL_ENTITYACCOUNTINGBASIS
BNYM_EAGLE_DYNSQL_ENTITYACCOUNTINGBASIS_HISTORY

entityaccountingperiods

ESTAR

ESTAR_ACCOUNTING_PERIODS

PORTFOLIO_ACCT, ACCT_BASIS, START_DT, END_DT

Delta
Temporal

BNYM_EAGLE_DYNSQL_ENTITYACCOUNTINGPERIODS

benchmarkassignment

RULESDBO

Extract Only

factor

SECURITYDBO

FACTOR

SECURITY_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE

Delta
Temporal

BNYM_EAGLE_DYNSQL_FACTOR

issuevariablerate

SECURITYDBO

VARIABLE_RATE

SECURITY_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE

Delta
Temporal

BNYM_EAGLE_DYNSQL_ISSUEVARIABLERATE

timeseries

SECURITYDBO

STAR_SECURITY_TIME_SERIES

SECURITY_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE

Delta
Temporal

BNYM_EAGLE_DYNSQL_TIMESERIES

vendorcashflow

SECURITYDBO

VENDOR_CASH_FLOW

SECURITY_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE, CASH_FLOW_TYPE, SPEED_TYPE, FLOW_DATE, ROW_ID

Delta
Temporal

BNYM_EAGLE_DYNSQL_VENDORCASHFLOW

rating

SECURITYDBO

RATINGS

SECURITY_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE

Delta
Temporal

BNYM_EAGLE_DYNSQL_RATING

fieldattribute

RULESDBO

FIELD_ATTRIBUTES
FIELD_ATTRIBUTE_DETAIL
FIELD_ATTRIBUTE_PROCESS
FIELD_PROCESS_DEFINITION

FIELD_ATTRIBUTE_ID

schedule

SECURITYDBO

SCHEDULE

SECURITY_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE, SCHEDULE_SUB_TYPE

Delta

Temporal

BNYM_EAGLE_DYNSQL_SCHEDULE

issueridentifiers

SECURITYDBO

ISSUER_XREF

ISSUER_ALIAS, SUB_ISSUER_ID, SUB_ISSUER_ID_TYPE

Delta
Temporal

BNYM_EAGLE_DYNSQL_ISSUERIDENTIFIERS

issueresg

SECURITYDBO

ISSUER_ESG
History Table:
ISSUER_ESG_HIST

ISSUER_ALIAS

ISSUER_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE

History
Delta
Temporal

BNYM_EAGLE_DYNSQL_ISSUERESG
BNYM_EAGLE_DYNSQL_ISSUERESG_HISTORY

underlyingsmf

SECURITYDBO

UNDERLYING_SECURITY

SECURITY_ALIAS, UNDERLYING_SEC_ALIAS, BEGIN_DATE

Delta
Temporal

BNYM_EAGLE_DYNSQL_UNDERLYINGSMF

entitymanagerrelationship

RULESDBO

ENTITY_RANGE_DETAILS

ENTITY_ID, ENTITY_DETAIL_ID, START_DATE

Delta
Temporal

BNYM_EAGLE_DYNSQL_ENTITYMANAGERRELATIONSHIP

codetranslation

PACE_MASTERDBO

CODE_TRANSLATION

INSTANCE

Delta
Temporal

BNYM_EAGLE_DYNSQL_CODETRANSLATION

washsaleopenlot

HOLDINGDBO

LOT_LEVEL_WS_POSITION

LOT_LEVEL_POSITION

Delta
Temporal

BNYM_EAGLE_DYNSQL_WASHSALEOPENLOT

entityanalytic

RULESDBO

ENTITY_ANALYTICS
ENTITY_PEER_GRP_ANALYTICS

ENTITY_ID, SRC_INTFC_INST, EFFECTIVE_DATE, TIME_PERIOD
ENTITY_ID, SRC_INTFC_INST, EFFECTIVE_DATE, TIME_PERIOD

Delta
Temporal

BNYM_EAGLE_DYNSQL_ENTITYANALYTIC

entitycharacteristic

RULESDBO

ENTITY_CHARACTERISTICS
History Table:
ENTITY_CHARACTERISTICS_HIST

ENTITY_ID, CODE

ENTITY_ID, EFFECTIVE_DATE, CODE

History
Delta
Temporal

BNYM_EAGLE_DYNSQL_ENTITYCHARACTERISTIC
BNYM_EAGLE_DYNSQL_ENTITYCHARACTERISTIC_HISTORY

processcenter

RULESDBO

PROCESS_CENTER

PROCESS_CENTER

Delta
Temporal

BNYM_EAGLE_DYNSQL_PROCESSCENTER

yieldcurve

SECURITYDBO

YIELD_CURVE

YIELD_CURVE_DETAIL

YIELD_CURVE_ID
Batch Key: YIELD_CURVE_CODE, EFFECTIVE_DATE, SRC_INTFC_INST

Batch
Temporal

BNYM_EAGLE_DYNSQL_YIELDCURVE

Extract only

issuetenor

SECURITYDBO

SECURITY_TENOR

SECURITY_ALIAS, SRC_INTFC_INST, EFFECTIVE_DATE

Delta
Temporal

BNYM_EAGLE_DYNSQL_ISSUETENOR

Extract only

entitylist

RULESDBO

ENTITY_LIST

INSTANCE

Delta

Temporal

BNYM_EAGLE_DYNSQL_ENTITYLIST

Extract only

languagetranslation

PACE_MASTERDBO

EGL_GENERIC_XLATION_ML

INSTANCE

Delta

Temporal

BNYM_EAGLE_DYNSQL_LANGUAGETRANSLATION

Extract only

warehousenavmonthend

ESTAR

MONTHLY_ESTAR_NAV

PORTFOLIO_ACCT,SHARE_CLASS,VALUATION_DATE,NAV_SEQUENCE

Batch Key: PORTFOLIO_ACCT,VALUATION_DATE

Batch
Temporal

BNYM_EAGLE_DYNSQL_WAREHOUSENAVMONTHEND

Extract only

tradedcashactivity

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

INSTANCE
Batch Key: PORTFOLIO_ACCT, EFFECTIVE_DT, ACCT_BASIS, LNG_SHT_C, SHARE_CLASS

Batch
Temporal

BNYM_EAGLE_DYNSQL_TRADEDCASHACTIVITY

Extract only

settledcashactivity

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

INSTANCE
Batch Key: PORTFOLIO_ACCT, EFFECTIVE_DT, ACCT_BASIS, LNG_SHT_C, SHARE_CLASS

Batch
Temporal

BNYM_EAGLE_DYNSQL_SETTLEDCASHACTIVITY

Extract only

entitybankrelationship

RULESDBO

ENTITY_CUSTODY_RELATIONSHIP
History Table:
ENTITY_CUSTODY_REL_HIST

ENTITY_BANK_ALIAS

ENTITY_BANK_ALIAS, EFFECTIVE_DATE

History
Delta
Temporal

BNYM_EAGLE_DYNSQL_ENTITYBANKRELATIONSHIP
BNYM_EAGLE_DYNSQL_ENTITYBANKRELATIONSHIP_HISTORY

Extract only

issueranalytic

SECURITYDBO

ISSUER_ANALYTICS

ISSUER_ALIAS,EFFECTIVE_DATE,SRC_INTFC_INST

Delta
Temporal

BNYM_EAGLE_DYNSQL_ISSUERANALYTIC

genericjournal

PACE_MASTERDBO

JOURNAL_MASTER

GENERIC_JOURNAL_DETAILS

INSTANCE

Batch

BNYM_EAGLE_DYNSQL_GENERICJOURNAL

Extract only

securityjournal

PACE_MASTERDBO

SECURITY_JOURNAL_MASTER

GENERIC_JOURNAL_DETAILS

INSTANCE

Batch

BNYM_EAGLE_DYNSQL_SECURITYJOURNAL

Extract only

warehouseglbalances

LEDGERDBO

GL_DETAIL_POSTING

ENTITY_ID + GLDP_EFFECTIVE_DATE + SRC_INTFC_INST

Batch

Temporal

BNYM_EAGLE_DYNSQL_WAREHOUSEGLBALANCES

entitypeergroupranking

RULESDBO

ENTITY_PEER_GRP_RANKINGS

ENTITY_ID, SRC_INTFC_INST, EFFECTIVE_DATE, TIME_PERIOD, PEER_GROUP_ID

Delta
Temporal

BNYM_EAGLE_DYNSQL_ENTITYPEERGROUPRANKING