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