eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: PQH_ROUTING_HISTORY

Product:	PQH - Public Sector HR
Description:	Keeps track of each hop during the routing / approver process. It also has some pre-identified attributes stored with new values
Implementation/DBA Data:	HR.PQH_ROUTING_HISTORY

Primary Key: PQH_ROUTING_HISTORY_PK

ROUTING_HISTORY_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PQH_ROUTING_HISTORY	PQH_ROUTING_CATEGORIES	PQH_ROUTING_HISTORY.ROUTING_CATEGORY_ID
PQH_ROUTING_HISTORY	PQH_TRANSACTION_CATEGORIES	PQH_ROUTING_HISTORY.TRANSACTION_CATEGORY_ID
PQH_ROUTING_HISTORY	PQH_ROUTING_LIST_MEMBERS	PQH_ROUTING_HISTORY.FORWARDED_BY_MEMBER_ID
PQH_ROUTING_HISTORY	PQH_ROUTING_LIST_MEMBERS	PQH_ROUTING_HISTORY.FORWARDED_TO_MEMBER_ID
PQH_ROUTING_HISTORY	PER_POS_STRUCTURE_VERSIONS	PQH_ROUTING_HISTORY.POS_STRUCTURE_VERSION_ID
PQH_ROUTING_HISTORY	PQH_ROLES	PQH_ROUTING_HISTORY.FORWARDED_TO_ROLE_ID
PQH_ROUTING_HISTORY	PQH_ROLES	PQH_ROUTING_HISTORY.FORWARDED_BY_ROLE_ID
PQH_ROUTING_HIST_ATTRIBS	PQH_ROUTING_HISTORY	PQH_ROUTING_HIST_ATTRIBS.ROUTING_HISTORY_ID