Table: PQH_TABLE_ROUTE

Product:	PQH - Public Sector HR
Description:	Table information for dynamic queries
Implementation/DBA Data:	HR.PQH_TABLE_ROUTE

Primary Key: PQH_TABLE_ROUTE_PK

1. TABLE_ROUTE_ID

Primary Key: PQH_TABLE_ROUTE_UK1

1. TABLE_ALIAS

Primary Key: PQH_TABLE_ROUTE_UK2

1. DISPLAY_NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
PQH_TABLE_ROUTE		PQH_TABLE_ROUTE	PQH_TABLE_ROUTE.SHADOW_TABLE_ROUTE_ID
PQH_ATTRIBUTES		PQH_TABLE_ROUTE	PQH_ATTRIBUTES.MASTER_TABLE_ROUTE_ID
PQH_COPY_ENTITY_FUNCTIONS		PQH_TABLE_ROUTE	PQH_COPY_ENTITY_FUNCTIONS.TABLE_ROUTE_ID
PQH_COPY_ENTITY_PREFS		PQH_TABLE_ROUTE	PQH_COPY_ENTITY_PREFS.TABLE_ROUTE_ID
PQH_PROCESS_LOG		PQH_TABLE_ROUTE	PQH_PROCESS_LOG.TXN_TABLE_ROUTE_ID
PQH_TABLE_ROUTE		PQH_TABLE_ROUTE	PQH_TABLE_ROUTE.SHADOW_TABLE_ROUTE_ID
PQH_TRANSACTION_CATEGORIES		PQH_TABLE_ROUTE	PQH_TRANSACTION_CATEGORIES.CONSOLIDATED_TABLE_ROUTE_ID
PQH_TRANSACTION_CATEGORIES		PQH_TABLE_ROUTE	PQH_TRANSACTION_CATEGORIES.MASTER_TABLE_ROUTE_ID
PQH_TXN_CATEGORY_ATTRIBUTES		PQH_TABLE_ROUTE	PQH_TXN_CATEGORY_ATTRIBUTES.TRANSACTION_TABLE_ROUTE_ID