Results for “chk_service_comp_date”

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

Overview

GHR_CPDF_CHECK6 is a PL/SQL validation package in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, owned by the APPS schema and declared with AUTHID CURRENT_USER. It belongs to the Oracle Human Resources (GHR) family of packages that support the Consolidated Personnel Data File (CPDF) processing used by U.S. federal agencies for personnel and payroll reporting. The package encapsulates a series of discrete validation routines, each responsible for verifying one or more data elements that map to specific CPDF sections. The procedures perform consistency and eligibility checks against field values captured during personnel actions, returning validation results that drive error handling in the downstream reporting flow. In the ETRM 12.2.2 classification, the package is categorized as OTHER and exposes sixteen documented procedures. The user query "chk_work_schedule" corresponds to the CHK_WORK_SCHEDULE procedure, one of the validation routines within this package.

Key Procedures and Functions

The package exposes sixteen documented procedures, each targeting a specific CPDF section:

• CHK_PRIOR_WORK_SCHEDULE — validates prior work schedule data (CPDF sections C74–C75).
• CHK_RACE_OR_NATNL_ORIGIN — validates race and national origin information (sections C75–C76).
• CHK_PRIOR_DUTY_STATION — validates prior duty station entries (section C87).
• CHK_RETENTION_ALLOWANCE — validates retention allowance data (section C88), including effective date handling.
• CHK_STAFFING_DIFFERENTIAL — validates staffing differential information (section C89).
• CHK_SUPERVISORY_DIFFERENTIAL — validates supervisory differential data.
• CHK_SERVICE_COMP_DATE — validates service computation date values.
• CHK_SCD_INFO — validates service computation date informational elements.
• CHK_SOCIAL_SECURITY — validates Social Security number data.
• CHK_STEP_OR_RATE — validates step or rate information.
• CHK_SUPERVISORY_STATUS — validates supervisory status indicators.
• CHK_TENURE — validates tenure group information.
• CHK_VETERANS_PREF — validates veterans' preference data.
• CHK_VETERANS_STATUS — validates veterans' status data.
• CHK_WORK_SCHEDULE — validates work schedule information; this is the procedure returned for the searched term.
• CHK_DEGREE_ATTAINED — validates degree attainment data.

Each procedure accepts parameters relevant to its validation domain, such as lookup codes, NOAC codes, effective dates, and field values. Parameter lists are not reproduced here beyond what is documented in the package header comments.

Tables Accessed

The package references two tables through APPS synonyms:

• GHR_PA_REQUESTS — the personnel action request table that stores the transaction data being validated. The check procedures read this table to obtain the field values submitted for a personnel action and to compare them against validation rules.
• GHR_POIS — the personnel office identifier / organizational information source used to resolve agency subelements, duty stations, and related organizational attributes referenced during validation.

These tables supply the authoritative values against which the CPDF checks are evaluated.

Usage Notes

GHR_CPDF_CHECK6 is typically invoked from Oracle Forms-based personnel action interfaces and from concurrent programs that assemble the Consolidated Personnel Data File. Individual check procedures are called as each CPDF section is populated, so that invalid or inconsistent data can be flagged before submission. The package is referenced by one other package, indicating it participates in a shared validation framework alongside sibling GHR_CPDF_CHECK packages. Custom extensions may call the procedures directly to enforce CPDF validation rules, but the package is intended for use within the standard federal HR processing flow rather than as a general-purpose API.