Results for “convert_hours”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_NZ_QES_PKG is an Oracle EBS Payroll package owned by the APPS schema and classified as a non-API ("OTHER") database object. Its name and dependency profile identify it as a New Zealand localization package supporting Quarterly Employment Survey (QES) reporting. The QES is a statutory statistical return administered by Statistics New Zealand, and employers are required to supply aggregated payroll information such as employee counts, hours worked, ordinary-time earnings, and related balance totals for survey reference periods. PAY_NZ_QES_PKG encapsulates the query and calculation logic required to derive these figures directly from Oracle Payroll and Oracle Human Resources data, rather than requiring manual compilation. The package is fully validated (Status: VALID) in the documented ETRM 12.2.2 metadata and references only standard Oracle HRMS payroll and people tables, confirming that it is a read-oriented, extraction-focused utility rather than a transactional component of the payroll run.

Key Procedures and Functions

The ETRM metadata documents eight callable units within PAY_NZ_QES_PKG. Their purposes are summarised below; parameter lists are not reproduced.

• COUNT_EMPLOYEES — Returns a headcount of employees within a given scope, forming the core QES "number of employees" metric.
• COUNT_EMPLOYEES_USING_BALANCE — Produces an employee count filtered by the presence of a specific payroll balance, allowing surveys to report on employees who actually received a given payment or accrual.
• SUM_BALANCES — Aggregates payroll balance values across a population, used for total remuneration, earnings, or hours figures.
• ID_FOR_DEFINED_BALANCE — Resolves the identifier of a defined balance, serving as a lookup helper for the balance-based procedures.
• ORDINARY_TIME_PAYOUT — Calculates ordinary-time pay amounts, a specific QES data element distinct from overtime and other premiums.
• HOURS_WORKED — Derives total hours worked for the reporting population, another mandatory QES statistic.
• CONVERT_HOURS — Normalises hours to a consistent unit or period basis, ensuring comparability across assignments and payroll periods.
• NO_PERIODS_PER_YEAR — Returns the number of payroll periods in a year, supporting annualisation and period-based proration of survey values.

Tables Accessed

The package reads from standard HRMS tables via APPS synonyms. PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F supply the employee and assignment population, including effective-dated assignment attributes. PAY_ALL_PAYROLLS_F identifies payroll definitions and period structures, while PER_TIME_PERIODS and PER_TIME_PERIOD_TYPES provide the survey date ranges and period boundaries against which balances are evaluated. Balance information is obtained from PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES, and PAY_BALANCE_DIMENSIONS, which together define the balance, its classification, and the dimensions used for aggregation. HR_ORGANIZATION_UNITS supports organisational grouping of survey results. HR_SOFT_CODING_KEYFLEX is also referenced, indicating that cost allocation or key flexfield context can be used to filter or classify the reported data.

Usage Notes

PAY_NZ_QES_PKG is referenced by no other package, so it is not part of a larger delivered call hierarchy; it is invoked directly. In practice it is called from a New Zealand localization concurrent program or report that extracts QES figures for a chosen survey period and organisation. The procedures return scalar or aggregate values intended to be consumed by that calling program. Because the package only reads HRMS data, it carries no write-side side effects. Sites extending QES reporting typically call these functions from custom PL/SQL or BI Publisher data models, passing the relevant payroll, period, and organisation identifiers. As with all APPS-owned packages, direct modification is not supported; customisations should wrap the package rather than alter it.