...
Object Type | Master Table | Logical Key | Business Key |
---|---|---|---|
Warehouse Trade | TRADES.DBO.TRADE | TRADE_ID | EFFECTIVE_DATE,ENTITY_ID,SRC_INTFC_INST,MASTER_TICKET_NUMBER |
Client | RULES.DBO.CLIENT | INSTANCE | CLIENT_ID |
Generic Entity | RULES.DBO.ENTITY | ENTITY_ID | ENTITY_ID |
Generic Entity (history mode) | RULES.DBO.ENTITY_HIST | ENTITY_ID | ENTITY_ID |
Issuer Relationship | SECURITY.DBO.ISSUER_RELATIONSHIP | INSTANCE | FROM_ISSUER_ALIAS,TO_ISSUER_ALIAS |
Warehouse GL Balances | LEDGER.dbo.GL_DETAIL_POSTING | GLDP_ID | GLDP_ID |
Issuer Organization | SECURITY.DBO.ISSUER_ORGANIZATION | ISSUER_ALIAS | ISSUER_ID |
Issuer Organization (history mode) | SECURITY.DBO.ISSUER_ORGANIZATION_HIST | ISSUER_ALIAS,SRC_INTFC_INST,EFFECTIVE_DATE | ISSUER_ID,SRC_INTFC_INST,EFFECTIVE_DATE |
Warehouse Open Lot | HOLDING.dbo.LOT_LEVEL_POSITION | LOT_LEVEL_POSITION | LOT_LEVEL_POSITION |
Warehouse Performance | PERFORMDBO.dbo.PERF_SUMMARY | PERF_SUM_INST | PERF_SUM_INST |
Warehouse Position | HOLDING.dbo.POSITION_DETAIL | POSITION_ID,SECURITY_ALIAS,LONG_SHORT_IND | POSITION_ID,SECURITY_ALIAS,LONG_SHORT_IND |
Generic SMF | SECURITY.DBO.SECURITY_MASTER | SECURITY_ALIAS | SECURITY_ALIAS |
SMF Identifiers | SECURITY.DBO.XREFERENCE | SECURITY_ALIAS | SECURITY_ALIAS |
SMF Identifiers (history mode) | SECURITY.DBO.XREFERENCE_HIST | SECURITY_ALIAS | SECURITY_ALIAS |
Rating | SECURITY.DBO.RATINGS | SECURITY_ALIAS,EFFECTIVE_DATE,SRC_INTFC_INST | SECURITY_ALIAS,EFFECTIVE_DATE,SRC_INTFC_INST |
Generic Issue Analytic | SECURITY.DBO.SECURITY_ANALYTICS | SECURITY_ALIAS,EFFECTIVE_DATE,SRC_INTFC_INST | SECURITY_ALIAS,EFFECTIVE_DATE,SRC_INTFC_INST |
Time Series | SECURITY.DBO.STAR_SECURITY_TIME_SERIES | SECURITY_ALIAS,EFFECTIVE_DATE,SRC_INTFC_INST | SECURITY_ALIAS,EFFECTIVE_DATE,SRC_INTFC_INST |
Schedule | SECURITY.DBO.SCHEDULE | SECURITY_ALIAS,EFFECTIVE_DATE,SRC_INTFC_INST,SCHEDULE_SUB_TYPE | SECURITY_ALIAS,EFFECTIVE_DATE,SRC_INTFC_INST,SCHEDULE_SUB_TYPE |
IssueFxRate | SECURITY.DBO.FX_RATES | SECURITY_ALIAS,FROM_SECALIAS,EFFECTIVE_DATE,SRC_INTFC_INST | SECURITY_ALIAS,FROM_SECALIAS,EFFECTIVE_DATE,SRC_INTFC_INST |
Generic SMF (history mode) | SECURITY.DBO.SECMASTER_HISTORY | SECURITY_ALIAS | SECURITY_ALIAS,SRC_INTFC_INST,EFFECTIVE_DATE |
Issue Price | RULES.DBO.ISSUEPRICE | SECURITY_ALIAS,SRC_INTFC_INST,EFFECTIVE_DATE | SECURITY_ALIAS,SRC_INTFC_INST,EFFECTIVE_DATE |
Warehouse Cash Activity | CASH.DBO.CASH_ACTIVITY | SRC_INTFC_INST,ENTITY_ID,SECURITY_ALIAS,MASTER_TRANS_NUM | SRC_INTFC_INST,ENTITY_ID,SECURITY_ALIAS,MASTER_TRANS_NUM |
...