Table: PQH_TEMPLATES

Product:	PQH - Public Sector HR
Description:	Position control data security
Implementation/DBA Data:	HR.PQH_TEMPLATES

Primary Key: PQH_TEMPLATES_PK

1. TEMPLATE_ID

Primary Key: PQH_TEMPLATES_UK

1. SHORT_NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
PQH_TEMPLATES		PQH_TRANSACTION_CATEGORIES	PQH_TEMPLATES.TRANSACTION_CATEGORY_ID
PQH_REF_TEMPLATES		PQH_TEMPLATES	PQH_REF_TEMPLATES.PARENT_TEMPLATE_ID
PQH_REF_TEMPLATES		PQH_TEMPLATES	PQH_REF_TEMPLATES.BASE_TEMPLATE_ID
PQH_ROLE_TEMPLATES		PQH_TEMPLATES	PQH_ROLE_TEMPLATES.TEMPLATE_ID
PQH_TEMPLATE_ATTRIBUTES		PQH_TEMPLATES	PQH_TEMPLATE_ATTRIBUTES.TEMPLATE_ID
PQH_TRANSACTION_TEMPLATES		PQH_TEMPLATES	PQH_TRANSACTION_TEMPLATES.TEMPLATE_ID