Table: PQH_ROUTING_CATEGORIES

Product:	PQH - Public Sector HR
Description:	Transaction Routing Information
Implementation/DBA Data:	HR.PQH_ROUTING_CATEGORIES

Primary Key: PQH_ROUTING_CATEGORIES_PK

1. ROUTING_CATEGORY_ID

Primary Key: PQH_ROUTING_CATEGORIES_UK1

1. TRANSACTION_CATEGORY_ID
2. DEFAULT_FLAG
3. ROUTING_LIST_ID
4. POSITION_STRUCTURE_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PQH_ROUTING_CATEGORIES		PQH_ROUTING_LISTS	PQH_ROUTING_CATEGORIES.ROUTING_LIST_ID
PQH_ROUTING_CATEGORIES		PQH_TRANSACTION_CATEGORIES	PQH_ROUTING_CATEGORIES.TRANSACTION_CATEGORY_ID
PQH_ROUTING_CATEGORIES		PER_POSITION_STRUCTURES	PQH_ROUTING_CATEGORIES.POSITION_STRUCTURE_ID
PQH_ROUTING_CATEGORIES		PQH_ROLES	PQH_ROUTING_CATEGORIES.OVERRIDE_ROLE_ID
PQH_ATTRIBUTE_RANGES		PQH_ROUTING_CATEGORIES	PQH_ATTRIBUTE_RANGES.ROUTING_CATEGORY_ID
PQH_ROUTING_HISTORY		PQH_ROUTING_CATEGORIES	PQH_ROUTING_HISTORY.ROUTING_CATEGORY_ID