...
The following table lists the logical keys and the business keys for each supported object type.
| Object Type | Master Table | Logical Key | Business Key |
|---|
| Warehouse Trade |
TRADESDBO| TRADES.DBO.TRADE | TRADE_ID | EFFECTIVE_DATE |
++Generic SMF | ,SRC_INTFC_INST,MASTER_TICKET_NUMBER |
| Client | RULES.DBO.CLIENT | INSTANCE | CLIENT_ID |
| Generic Entity | RULES.DBO.ENTITY |
| Generic SMF | SECURITYDBO.SECURITY_MASTER | SECURITY_ALIAS | SECURITY_ALIAS |
| 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) |
SECURITYDBO.SECMASTER_HISTORY | SECURITY_ALIAS | SECURITY_ALIAS+| SECURITY.DBO.ISSUER_ORGANIZATION_HIST | ISSUER_ALIAS,SRC_INTFC_INST,EFFECTIVE_DATE | ISSUER_ID,SRC_INTFC_INST |
+| SMF Identifiers | SECURITYDBO.XREFERENCE | SECURITY_ALIAS | SECURITY_ALIAS |
SMF Identifiers (history mode) | SECURITYDBO.XREFERENCE_HIST |
| 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 |
Issuer Organization | SECURITYDBO.ISSUER_ORGANIZATION | ISSUER| SMF Identifiers | SECURITY.DBO.XREFERENCE | SECURITY_ALIAS |
ISSUERIDIssuer Relationship | SECURITYDBO.ISSUER_RELATIONSHIP | INSTANCE | FROM_ISSUER_ALIAS+TO_ISSUER_| ALIAS |
| SMF Identifiers (history mode) | SECURITY.DBO.XREFERENCE_HIST | SECURITY_ALIAS | SECURITY_ALIAS |
| Rating |
SECURITYDBO| SECURITY.DBO.RATINGS | SECURITY_ALIAS,EFFECTIVE_DATE,SRC_INTFC_INST | SECURITY_ALIAS |
+| ,EFFECTIVE_DATE,SRC_INTFC_INST |
+EFFECTIVE_DATE AnalyticsSECURITYDBO| SECURITY.DBO.SECURITY_ANALYTICS | SECURITY_ALIAS,EFFECTIVE_DATE,SRC_INTFC_INST | SECURITY_ALIAS |
+| ,EFFECTIVE_DATE,SRC_INTFC_INST |
+EFFECTIVE_DATEClient | RULESDBO.CLIENT | INSTANCE | CLIENT_ID |
Schedule | SECURITYDBO |
| 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 |
+++SECURITY_ALIAS,EFFECTIVE_DATETime Series | SECURITYDBO.STAR_SECURITY_TIME_SERIES | | 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 |
++| ,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 |
