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.

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

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