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_TRANSACTION_CATEGORIES

Product:	PQH - Public Sector HR
Description:	Setup information to allow selective routing of transactions
Implementation/DBA Data:	HR.PQH_TRANSACTION_CATEGORIES

Primary Key: PQH_TRANSACTION_CATEGORIES_PK

TRANSACTION_CATEGORY_ID

Primary Key: PQH_TRANSACTION_CATEGORIES_UK

SHORT_NAME
BUSINESS_GROUP_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
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_COPY_ENTITY_TXNS	PQH_TRANSACTION_CATEGORIES	PQH_COPY_ENTITY_TXNS.TRANSACTION_CATEGORY_ID
PQH_COPY_ENTITY_TXNS	PQH_TRANSACTION_CATEGORIES	PQH_COPY_ENTITY_TXNS.WF_TRANSACTION_CATEGORY_ID
PQH_FYI_NOTIFY	PQH_TRANSACTION_CATEGORIES	PQH_FYI_NOTIFY.TRANSACTION_CATEGORY_ID
PQH_POSITION_TRANSACTIONS	PQH_TRANSACTION_CATEGORIES	PQH_POSITION_TRANSACTIONS.WF_TRANSACTION_CATEGORY_ID
PQH_ROLE_TEMPLATES	PQH_TRANSACTION_CATEGORIES	PQH_ROLE_TEMPLATES.TRANSACTION_CATEGORY_ID
PQH_ROUTING_CATEGORIES	PQH_TRANSACTION_CATEGORIES	PQH_ROUTING_CATEGORIES.TRANSACTION_CATEGORY_ID
PQH_ROUTING_HISTORY	PQH_TRANSACTION_CATEGORIES	PQH_ROUTING_HISTORY.TRANSACTION_CATEGORY_ID
PQH_TEMPLATES	PQH_TRANSACTION_CATEGORIES	PQH_TEMPLATES.TRANSACTION_CATEGORY_ID
PQH_TRANSACTION_TEMPLATES	PQH_TRANSACTION_CATEGORIES	PQH_TRANSACTION_TEMPLATES.TRANSACTION_CATEGORY_ID
PQH_TXN_CATEGORY_ATTRIBUTES	PQH_TRANSACTION_CATEGORIES	PQH_TXN_CATEGORY_ATTRIBUTES.TRANSACTION_CATEGORY_ID
PQH_WORKSHEETS	PQH_TRANSACTION_CATEGORIES	PQH_WORKSHEETS.WF_TRANSACTION_CATEGORY_ID