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 | TRADESDBO.TRADE | TRADE_ID | EFFECTIVE_DATE+ENTITY_ID+SRC_INTFC_INST |
Generic SMF | SECURITYDBO.SECURITY_MASTER | SECURITY_ALIAS | SECURITY_ALIAS |
Generic SMF (history mode) | SECURITYDBO.SECMASTER_HISTORY | SECURITY_ALIAS | SECURITY_ALIAS+SRC_INTFC_INST+EFFECTIVE_DATE |
SMF Identifiers | SECURITYDBO.XREFERENCE | SECURITY_ALIAS | SECURITY_ALIAS |
SMF Identifiers (history mode) | SECURITYDBO.XREFERENCE_HIST | SECURITY_ALIAS | SECURITY_ALIAS |
Issuer Organization | SECURITYDBO.ISSUER_ORGANIZATION | ISSUER_ALIAS | ISSUER_ID |
Issuer Relationship | SECURITYDBO.ISSUER_RELATIONSHIP | INSTANCE | FROM_ISSUER_ALIAS+TO_ISSUER_ALIAS |
Rating | SECURITYDBO.RATINGS | SECURITY_ALIAS,EFFECTIVE_DATE,SRC_INTFC_INST | SECURITY_ALIAS+SRC_INTFC_INST+EFFECTIVE_DATE |
Generic Issue Analytics | SECURITYDBO.SECURITY_ANALYTICS | SECURITY_ALIAS,EFFECTIVE_DATE,SRC_INTFC_INST | SECURITY_ALIAS+SRC_INTFC_INST+EFFECTIVE_DATE |
Client | RULESDBO.CLIENT | INSTANCE | CLIENT_ID |
Schedule | SECURITYDBO.SCHEDULE | SECURITY_ALIAS,EFFECTIVE_DATE,SRC_INTFC_INST,SCHEDULE_SUB_TYPE | SECURITY_ALIAS+EFFECTIVE_DATE+SRC_INTFC_INST+SCHEDULE_SUB_TYPE |
Time Series | SECURITYDBO.STAR_SECURITY_TIME_SERIES | SECURITY_ALIAS,EFFECTIVE_DATE,SRC_INTFC_INST | SECURITY_ALIAS+SRC_INTFC_INST+EFFECTIVE_DATE |