Table: PQH_TRANSACTION_TEMPLATES

Product:	PQH - Public Sector HR
Description:	Task templates which determines the type/security of a transaction is stored here
Implementation/DBA Data:	HR.PQH_TRANSACTION_TEMPLATES

Primary Key: PQH_TRANSACTION_TEMPLATES_PK

1. TRANSACTION_TEMPLATE_ID

Primary Key: PQH_TRANSACTION_TEMPLATE_UK

1. TEMPLATE_ID
2. TRANSACTION_ID
3. TRANSACTION_CATEGORY_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PQH_TRANSACTION_TEMPLATES		PQH_TRANSACTION_CATEGORIES	PQH_TRANSACTION_TEMPLATES.TRANSACTION_CATEGORY_ID
PQH_TRANSACTION_TEMPLATES		PQH_TEMPLATES	PQH_TRANSACTION_TEMPLATES.TEMPLATE_ID