Table: PQH_ROLE_TEMPLATES

Product:	PQH - Public Sector HR
Description:	Tempalte for a transaction category attached to a role
Implementation/DBA Data:	HR.PQH_ROLE_TEMPLATES

Primary Key: PQH_ROLE_TEMPLATES_PK

1. ROLE_TEMPLATE_ID

Primary Key: PQH_ROLE_TEMPLATES_UK1

1. ROLE_ID
2. TRANSACTION_CATEGORY_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PQH_ROLE_TEMPLATES		PQH_ROLES	PQH_ROLE_TEMPLATES.ROLE_ID
PQH_ROLE_TEMPLATES		PQH_TRANSACTION_CATEGORIES	PQH_ROLE_TEMPLATES.TRANSACTION_CATEGORY_ID
PQH_ROLE_TEMPLATES		PQH_TEMPLATES	PQH_ROLE_TEMPLATES.TEMPLATE_ID