Is it possible to have a Single Relational field in an Aux table reference a system table?


Hi,

I would like a single relational field in my aux table to be able to reference records in the "TS_STATES" table. Does anyone know if this is possible?

The use case is that the aux table contains logic for our service level agreements that scripts will utilize. I realize the workaround would be to manually enter the state TS_IDs in the aux table, but I'd like to do this as cleanly as possible.

Update:

Hmm, upon looking at the schema guide I guess the TS_STATES table may not technically be a "System Table," that designation appears to be reserved for the ones with the "BPEL" prefixes etc. Not sure exactly what type to call it...

(SBM 2009 R4.02)

Thanks,

Aaron