Results for “to_pay_plan”

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

Overview

GHR_CPDF_TEMP is a transient staging table owned by the HR schema within the GHR – US Federal Human Resources product family in Oracle E-Business Suite 12.1.1 and 12.2.2. As its name implies, the table temporarily stores the flattened, report-ready record set required to generate a variety of CPDF (Central Personnel Data File–style) federal personnel reports. Records are written at run time by the reporting concurrent programs, consumed by the report formatting engine, and then purged or overwritten per reporting session.

The object is documented in ETRM as VALID with 255 columns in the 12.2.2 physical schema. Its heuristic Data Vault classification, derived from the mined foreign-key structure, is that of a standalone table rather than a conformed hub, link, or satellite. This classification reflects its role as a session-scoped reporting buffer: it does not participate in the normalized person/assignment model and is not intended as a system of record. Any Data Vault modeling exercise should therefore treat it as a staging artifact rather than a candidate integration point. The only documented foreign key — PERSONNEL_OFFICE_ID → GHR_POIS — ties each staged row to the personnel office that owns the report scope.

Key Information Stored

Because the table carries 255 columns, only the functionally significant groups are described here.

• REPORT_TYPE and SESSION_ID — the two operational discriminators. Every row belongs to a specific report run, and SESSION_ID is the practical isolation key used to partition and purge data between concurrent requests.
• PERSONNEL_OFFICE_ID — the sole documented foreign key, referencing GHR_POIS; defines the reporting organization scope.
• Identity columns — EMPLOYEE_FIRST_NAME, EMPLOYEE_MIDDLE_NAMES, EMPLOYEE_LAST_NAME, NAME_TITLE, together with prior-name fields such as PRIOR_FAMILY_NAME, PRIOR_GIVEN_NAME and PRIOR_MIDDLE_NAME used for corrected-name reporting.
• Personnel attributes — EMPLOYEE_DATE_OF_BIRTH, SEX, CITIZENSHIP, WORLD_CITIZENSHIP, RACE_NATIONAL_ORIGIN, VETERANS_PREFERENCE, and HANDICAP_CODE.
• Position and appointment data — POSITION_NUMBER, POSITION_TITLE, POSITION_ORG, APPOINT_TYPE_CODE, TENURE, SUPERVISORY_STATUS, and WORK_SCHEDULE fields.
• Pay and grade movement — the FROM/TO pairs (FROM_GRADE_OR_LEVEL/TO_GRADE_OR_LEVEL, FROM_STEP_OR_RATE/TO_STEP_OR_RATE, FROM_BASIC_PAY/TO_BASIC_PAY, FROM_TOTAL_SALARY/TO_TOTAL_SALARY) supporting pay-change and promotion reports.
• Benefits elections — indicator, election-date and notify-date triples for FEGLI, FEHB, retirement and TSP, plus FERS_COVERAGE and RETIREMENT_PLAN.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE and LAST_UPDATE_LOGIN.

No unique index or surrogate primary key is documented for this table; it is a reporting buffer. In practice, the effective composite business key is SESSION_ID plus REPORT_TYPE plus an employee identifier such as EHRI_EMPLOYEE_ID or AGENCY_EMPLOYEE_ID.

Common Use Cases and Queries

The table is primarily an internal staging area for concurrent programs generating personnel action, benefits-election, and pay-change reports. Typical operational and diagnostic queries include:

• Diagnosing a failed report run — confirm whether the program populated rows before failing:

  SELECT COUNT(*) FROM hr.ghr_cpdf_temp
   WHERE session_id = :session_id;

• Inspecting the most recent run for a report type:

  SELECT * FROM hr.ghr_cpdf_temp
   WHERE report_type = :report_type
   ORDER BY last_update_date DESC;

• Housekeeping — resolving space pressure caused by orphaned rows from interrupted sessions:

  DELETE FROM hr.ghr_cpdf_temp
   WHERE session_id = :session_id
     AND creation_date < SYSDATE - 1;

• Joining to the owning personnel office for organization-level reporting:

  SELECT t.employee_last_name, p.* 
    FROM hr.ghr_cpdf_temp t, hr.ghr_pois p
   WHERE t.personnel_office_id = p.personnel_office_id
     AND t.session_id = :session_id;

• Reconciliation — comparing staged FROM/TO grade and salary values against PER_ALL_ASSIGNMENTS_F to validate report output before release.

Related Objects

• GHR_POIS — the only documented referential relationship, via PERSONNEL_OFFICE_ID; supplies the personnel office context for each report row.
• PER_ALL_PEOPLE_F — canonical source for the employee name, birth date, and sex attributes populated into the temp table.
• PER_ALL_ASSIGNMENTS_F — source of position, appointment, and organizational component data.
• PAY_PROPOSED_ASSIGNMENTS and the CWB/PAY element tables — source of the FROM/TO pay, grade, and step values.
• BEN_PERSON_BENEFIT-family tables — underlying source for FEGLI, FEHB, TSP and retirement election fields.
• GHR_CPDF_PERSONNEL_ACTIONS and sibling CPDF report programs — the concurrent programs most commonly responsible for populating and consuming this table.
• HR_PERSONAL_INFO style reporting views — frequently joined to the temp table when building the final CPDF output.