Results for “basic_pay”

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

Overview

GHR_CPDF_CHECK8 is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle HRMS family of "GHR" packages that support the U.S. Federal Government's Central Personnel Data File (CPDF) reporting requirements. CPDF is the legacy Office of Personnel Management (OPM) reporting standard for federal civilian workforce data — now largely superseded by the Enterprise Human Resources Integration (EHRI) initiative — and EBS delivered a series of check packages (CHECK1 through CHECKn) to validate, extract, and format the SF-52 and SF-50 personnel action data that agencies transmit to OPM.

The specific concern of GHR_CPDF_CHECK8 is basic pay, corresponding to sections C76 through C82 of the CPDF submission record layout. Its single documented procedure, BASIC_PAY, segments pay plan, grade/level, step/rate, pay basis, retained pay, and agency sub-element information into the positional fields required by the CPDF file format. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking session rather than the owner, which is typical of EBS APIs that must respect row-level security via the user's own grants and security profiles. The source header references file ghcpdf08.pkh with an internal version of 120.0.12000000.1 dated January 2007, indicating the package is part of the long-stable 11i-to-R12 HRMS core and has not been materially revised since the R12.0 release cycle.

Key Procedures and Functions

ETRM documents a single procedure in this package:

• BASIC_PAY — Accepts the pay-related attributes of a personnel action (pay plan, rate determinant code, basic pay amount, retained pay plan, retained grade, retained step, agency sub-element, grade or level, step or rate, pay basis, the first action's nature-of-action legal authority codes, the NOAC lookup code, effective date, and occupation code) and writes them into the CPDF C76–C82 section of the extract record. The comment block explicitly labels the retained pay fields plus the agency sub-element as "Non-SF52 Data Item," confirming that these values are collected outside the standard SF-52 request and appended to the CPDF output. The procedure performs no DML of its own on HR data; its role is assembly and field-level formatting for the CPDF layout.

No functions or additional procedures are catalogued in the documented metadata.

Tables Accessed

The package references five tables through APPS synonyms. Although the package body is not exposed in the extract, the table set is consistent with a FastFormula-style lookup against user-defined payroll tables:

• GHR_PAY_PLANS — The Agency-specific pay plan definition table; used to validate and decode the pay plan and retained pay plan values supplied to BASIC_PAY.
• PAY_USER_TABLES, PAY_USER_ROWS_F, PAY_USER_COLUMN_INSTANCES_F, and PAY_USER_COLUMNS — Collectively these comprise the Payroll user-defined table infrastructure: the parent table definition, the effective-dated row instances, and the column-instance/column metadata that describe each row. BASIC_PAY reads these to resolve rate determinant codes, pay basis codes, and other coded values that the agency maintains as user tables rather than as seeded lookup values. This pattern allows each agency to configure its own CPDF pay mappings without a code change.

Usage Notes

GHR_CPDF_CHECK8 is not a user-facing object. It is invoked programmatically by the CPDF extract and validation framework, most likely from the parent CPDF reporting package or concurrent program that drives the full CHECK1–CHECKn sequence across the C-section record layout. ETRM records that the package is referenced by one other package, which is the expected caller. In practice, DBAs and HRMS developers encounter it when:

• Troubleshooting CPDF extract errors, particularly missing or malformed pay data in fields C76–C82.
• Extending agency-specific pay plan or user-table setup and needing to understand which lookups the extract consults.
• Auditing R12.1.1 and R12.2.2 environments for deprecated CPDF objects, since OPM retired CPDF in favor of EHRI and Oracle has since delivered replacement EHRI functionality.

The package should be treated as read-only reference code; direct invocation outside the CPDF framework is unsupported, and any customization should be confined to the underlying pay plan and user table configurations rather than to the package body.