Database Keys for EagleML Objects
There are two types of keys defining a database record explicitly:
- logical keys - these are a field or a number of fields, unique for the record in DB.
- business keys - these are a field or a number of fields, unique for each record from real customer point of view.
Note
The keys below are using Source Id, not Source Name. The relationship between these two is defined in the PACE_MASTERDBO.INTERFACES DB table, you can use the following query to get it:
select * from PACE_MASTERDBO.INTERFACES
The instance column contains all Source ids available and the short_desc column contains corresponding source names.
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 | 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 |
| 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 |