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