Results for “grade_desc”
32 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PQH_PTX_HISTORY_V is a reporting view owned by the APPS schema within the Public Sector HR (PQH) product family of Oracle E-Business Suite, documented as VALID in ETRM for releases 12.1.1 and 12.2.2. The view exposes historical position transaction data, presenting the effective-dated snapshot of position definitions as recorded when a Public Sector position transaction was applied. It serves as the read-only history surface for reporting and integration, allowing downstream consumers to reconstruct how a position looked at the point each transaction was executed without directly joining the highly normalized position and transaction base tables.
The view attributes every row to a POSITION_ID and EFFECTIVE_START_DATE pair, and it decorates the raw transaction record with decode-based descriptions for lookup-driven attributes such as transaction status, position type, location, organization, job, availability status, payroll, pay basis, grade, step, and grade rule values. Because these descriptions are derived through HR_GENERAL and PQH_UTILITY decode routines at query time, the view reflects the current lookup meanings against the historical transaction record. The user-search term "work_any_country" is commonly associated with the position transaction history area, since the transaction and history views are frequently queried together when auditing position and deployment attributes across legislation or country contexts.
Underlying Base Objects
The documented referenced base objects are HR_ALL_POSITIONS_F (synonym), HR_ALL_POSITIONS_F_TL (synonym), PER_DEPLOYMENT_FACTORS (synonym), PQH_POSITION_TRANSACTIONS (synonym), HR_GENERAL (package), and PQH_UTILITY (package). The view text confirms these dependencies: position attributes are drawn from the PSF alias, consistent with HR_ALL_POSITIONS_F and its translated name column sourced from HR_ALL_POSITIONS_F_TL, and deployment-level attributes such as SERVICE_MINIMUM, WORK_SCHEDULE, and WORK_DURATION are drawn from the DPF alias, corresponding to PER_DEPLOYMENT_FACTORS.
The historical dimension is anchored by PQH_POSITION_TRANSACTIONS, which records each position transaction and its applied status. HR_GENERAL supplies the DECODE_LOOKUP, DECODE_LOCATION, DECODE_ORGANIZATION, DECODE_JOB, DECODE_GRADE, DECODE_STEP, DECODE_PAYROLL, DECODE_PAY_BASIS, DECODE_AVAILABILITY_STATUS, and DECODE_GRADE_RULE functions, while PQH_UTILITY supplies GET_POS_REC_EED and the DECODE_GRADE_RULE variants returning VALUE, MIN, MID, and MAX. All base tables are referenced through APPS synonyms, so the view must be queried in the APPS context or through a synonym granted to the calling schema.
Key Columns
- POSITION_ID, EFFECTIVE_START_DATE — the identifying keys for the historical position transaction record.
- NAME — the position name from the translated positions table.
- Transaction status — a decoded value from the PQH_TRANSACTION_STATUS lookup, shown as APPLIED for applied history rows.
- POSITION_TYPE, PERMANENT_TEMPORARY_FLAG, SEASONAL_FLAG — position classification attributes.
- LOCATION_ID, ORGANIZATION_ID, JOB_ID — decoded to location, organization, and job descriptions through HR_GENERAL.
- FTE, MAX_PERSONS, WORKING_HOURS, FREQUENCY, TIME_NORMAL_START, TIME_NORMAL_FINISH — staffing and schedule measures.
- ENTRY_GRADE_ID, ENTRY_STEP_ID, ENTRY_GRADE_RULE_ID — decoded grade, step, and grade rule values, including MIN, MID, and MAX grade rule derivations.
- Deployment attributes — SERVICE_MINIMUM, WORK_SCHEDULE, and WORK_DURATION from PER_DEPLOYMENT_FACTORS, each decoded through HR_GENERAL lookups.
Common Use Cases and Queries
Typical uses include position history audits, transaction reconciliation against PQH_POSITION_TRANSACTIONS, and integration extracts feeding downstream HR or payroll systems. A representative query follows.
- SELECT POSITION_ID, EFFECTIVE_START_DATE, NAME, POSITION_TYPE, DATE_EFFECTIVE, FTE FROM APPS.PQH_PTX_HISTORY_V WHERE POSITION_ID = :p_position_id ORDER BY EFFECTIVE_START_DATE;
- Join to PQH_POSITION_TRANSACTIONS on POSITION_ID and EFFECTIVE_START_DATE to reconcile applied history rows with their source transactions.
- Filter on EFFECTIVE_START_DATE ranges to reconstruct position state as of a reporting date, accounting for the decode-based descriptions applied at run time.
-
View: PQH_PTX_HISTORY_V 12.1.1
APPS.PQH_PTX_HISTORY_V·↳ HR_ALL_POSITIONS_F·↳ HR_ALL_POSITIONS_F_TL·↳ HR_GENERAL·Explore PQH module →
-
View: OE_BLKT_LINES_HIST_V 12.1.1
This view is used to get BSA history lines information, which is used in BSA organizer.
APPS.OE_BLKT_LINES_HIST_V·↳ MTL_GRADES·↳ MTL_PARAMETERS·↳ OE_AGREEMENTS_TL·Explore ONT module →
-
This view is used to get BSA line history information, and it is udes in BSA version comparison UI.
APPS.OE_BLANKET_LINES_HIST_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
APPS.PQH_POSITION_TRANSACTIONS_V·↳ HR_GENERAL·↳ PQH_POSITION_TRANSACTIONS·↳ PQH_UTILITY·Explore PQH module →
-
APPS.PQH_POSITION_TRANSACTIONS_V·↳ HR_GENERAL·↳ PQH_POSITION_TRANSACTIONS·↳ PQH_UTILITY·Explore PQH module →
-
View: OE_BLKT_LINES_HIST_V 12.2.2
This view is used to get BSA history lines information, which is used in BSA organizer.
APPS.OE_BLKT_LINES_HIST_V·↳ MTL_GRADES·↳ MTL_PARAMETERS·↳ OE_AGREEMENTS_TL·Explore ONT module →
-
View: PQH_PTX_HISTORY_V 12.2.2
APPS.PQH_PTX_HISTORY_V·↳ HR_ALL_POSITIONS_F·↳ HR_ALL_POSITIONS_F_TL·↳ HR_GENERAL·Explore PQH module →
-
View: OE_BLANKET_LINES_V 12.2.2
This view is used to get the BSA lines information, used in BSA entry UI.
APPS.OE_BLANKET_LINES_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
This view is used to get BSA line history information, and it is udes in BSA version comparison UI.
APPS.OE_BLANKET_LINES_HIST_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
View: OE_BLANKET_LINES_V 12.1.1
This view is used to get the BSA lines information, used in BSA entry UI.
APPS.OE_BLANKET_LINES_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
VIEW: APPS.PQH_PTX_HISTORY_V 12.2.2
-
VIEW: APPS.PQH_PTX_HISTORY_V 12.1.1
-
eTRM - PQH Tables and Views 12.2.2
This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process.
-
eTRM - PQH Tables and Views 12.1.1
This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process.
-
eTRM - ONT Tables and Views 12.1.1
OM WorkFlow Activity Skip Log.
-
eTRM - ONT Tables and Views 12.2.2
OM WorkFlow Activity Skip Log.