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_WORKSHEET_DETAILS

Product:	PQH - Public Sector HR
Description:	Work table of Hr entities for Budget information
Implementation/DBA Data:	HR.PQH_WORKSHEET_DETAILS

Primary Key: PQH_WORKSHEET_DETAILS_PK

WORKSHEET_DETAIL_ID

Primary Key: PQH_WORKSHEET_DETAILS_UK

ACTION_CD
WORKSHEET_ID
GRADE_ID
POSITION_ID
JOB_ID
ORGANIZATION_ID
POSITION_TRANSACTION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PQH_WORKSHEET_DETAILS	HR_ALL_ORGANIZATION_UNITS	PQH_WORKSHEET_DETAILS.ORGANIZATION_ID
PQH_WORKSHEET_DETAILS	PQH_BUDGET_DETAILS	PQH_WORKSHEET_DETAILS.BUDGET_DETAIL_ID
PQH_WORKSHEET_DETAILS	PQH_POSITION_TRANSACTIONS	PQH_WORKSHEET_DETAILS.POSITION_TRANSACTION_ID
PQH_WORKSHEET_DETAILS	PER_JOBS	PQH_WORKSHEET_DETAILS.JOB_ID
PQH_WORKSHEET_DETAILS	PER_GRADES	PQH_WORKSHEET_DETAILS.GRADE_ID
PQH_WORKSHEET_DETAILS	PQH_WORKSHEETS	PQH_WORKSHEET_DETAILS.WORKSHEET_ID
PQH_WORKSHEET_DETAILS	PQH_WORKSHEET_DETAILS	PQH_WORKSHEET_DETAILS.PARENT_WORKSHEET_DETAIL_ID
PQH_WORKSHEET_DETAILS	PQH_WORKSHEET_DETAILS	PQH_WORKSHEET_DETAILS.PARENT_WORKSHEET_DETAIL_ID
PQH_WORKSHEET_PERIODS	PQH_WORKSHEET_DETAILS	PQH_WORKSHEET_PERIODS.WORKSHEET_DETAIL_ID