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_LIST_MEMBERS

Product:	PQH - Public Sector HR
Description:	Roles and role users that constitute the routing list
Implementation/DBA Data:	HR.PQH_ROUTING_LIST_MEMBERS

Primary Key: PQH_ROUTING_LIST_MEMBERS_PK

ROUTING_LIST_MEMBER_ID

Primary Key: PQH_ROUTING_LIST_MEMBERS_UK

ROUTING_LIST_ID
ROLE_ID
USER_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PQH_ROUTING_LIST_MEMBERS	PQH_ROLES	PQH_ROUTING_LIST_MEMBERS.ROLE_ID
PQH_ROUTING_LIST_MEMBERS	PQH_ROUTING_LISTS	PQH_ROUTING_LIST_MEMBERS.ROUTING_LIST_ID
PQH_ATTRIBUTE_RANGES	PQH_ROUTING_LIST_MEMBERS	PQH_ATTRIBUTE_RANGES.ROUTING_LIST_MEMBER_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