Table: PQH_POSITION_TRANSACTIONS

Product:	PQH - Public Sector HR
Description:	POSITION_TRANSACTION is used to maintain and create positions. Each transaction needs to be approved by pre-identified approvers. On approval these transactions are applied to database.Each transaction can have a combination of one or more
Implementation/DBA Data:	HR.PQH_POSITION_TRANSACTIONS

Primary Key: PQH_POSITION_TRANSACTIONS_PK

1. POSITION_TRANSACTION_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PQH_POSITION_TRANSACTIONS		PER_GRADES	PQH_POSITION_TRANSACTIONS.ENTRY_GRADE_ID
PQH_POSITION_TRANSACTIONS		PER_SHARED_TYPES	PQH_POSITION_TRANSACTIONS.AVAILABILITY_STATUS_ID
PQH_POSITION_TRANSACTIONS		PER_PAY_BASES	PQH_POSITION_TRANSACTIONS.PAY_BASIS_ID
PQH_POSITION_TRANSACTIONS		PQH_TRANSACTION_CATEGORIES	PQH_POSITION_TRANSACTIONS.WF_TRANSACTION_CATEGORY_ID
PQH_POSITION_TRANSACTIONS		HR_LOCATIONS_ALL	PQH_POSITION_TRANSACTIONS.LOCATION_ID
PQH_POSITION_TRANSACTIONS		PER_JOBS	PQH_POSITION_TRANSACTIONS.JOB_ID
PQH_POSITION_TRANSACTIONS		PER_POSITION_DEFINITIONS	PQH_POSITION_TRANSACTIONS.POSITION_DEFINITION_ID
PQH_POSITION_TRANSACTIONS		HR_ALL_ORGANIZATION_UNITS	PQH_POSITION_TRANSACTIONS.BUSINESS_GROUP_ID
PQH_POSITION_TRANSACTIONS		HR_ALL_ORGANIZATION_UNITS	PQH_POSITION_TRANSACTIONS.ORGANIZATION_ID
PQH_PTX_DPF_DF		PQH_POSITION_TRANSACTIONS	PQH_PTX_DPF_DF.POSITION_TRANSACTION_ID
PQH_PTX_EXTRA_INFO		PQH_POSITION_TRANSACTIONS	PQH_PTX_EXTRA_INFO.POSITION_TRANSACTION_ID
PQH_PTX_SHADOW		PQH_POSITION_TRANSACTIONS	PQH_PTX_SHADOW.POSITION_TRANSACTION_ID
PQH_TXN_JOB_REQUIREMENTS		PQH_POSITION_TRANSACTIONS	PQH_TXN_JOB_REQUIREMENTS.POSITION_TRANSACTION_ID
PQH_WORKSHEET_DETAILS		PQH_POSITION_TRANSACTIONS	PQH_WORKSHEET_DETAILS.POSITION_TRANSACTION_ID