Results for “chk_date_of_birth”

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

Overview

GHR_CPDF_CHECK2 is a PL/SQL package owned by the APPS schema that forms part of the Oracle HRMS legislative and statutory reporting infrastructure, specifically serving the U.S. Federal Civilian Personnel Data File (CPDF) verification process. The CPDF is a government-mandated reporting format used by federal agencies to transmit personnel action and workforce data to central authorities. This package consolidates a library of validation routines that interrogate incoming or existing HR data against the CPDF business rules governing sections C-8 through C-19 of the report. Each procedure encapsulates the logic required to determine whether a given combination of personnel attribute values is valid for a specific CPDF data element, returning results that downstream reporting programs use to flag, reject, or correct records before submission. The package is classified as a non-shipped (noship) customization object under Oracle's versioning scheme, as indicated by the source header, and is referenced by one other package in the application suite, confirming its role as a supporting validation module rather than a standalone entry point.

Key Procedures and Functions

The package exposes eleven documented procedures, each responsible for validating a discrete CPDF reporting element or a closely related cluster of elements.

• CHK_INSTRUCTIONAL_PGM — Validates instructional program data spanning CPDF sections C-8 and C-9, checking education level, academic discipline, degree attainment year, and related attributes.
• CHK_AWARD_AMOUNT — Verifies award amount integrity for CPDF sections C-10 and C-11, evaluating one-time payment amounts against basic pay and adjusted base pay references.
• CHK_BENEFIT_AMOUNT — Checks the benefit amount reported in section C-11.
• CHK_CUR_APPT_AUTH — Validates current appointment authority data across CPDF sections C-12 through C-19, the broadest rule set in the package.
• CHK_DATE_OF_BIRTH — This is the procedure directly relevant to the search term "chk_date_of_birth." It performs date-of-birth validation logic, which appears among the C-12 through C-19 appointment authority checks (the CHK_INSTRUCTIONAL_PGM procedure also carries an employee date of birth parameter, reflecting the pervasive influence of birth date on federal personnel eligibility and retirement computation rules).
• CHK_DUTY_STATION — Validates duty station codes against CPDF assignment rules.
• CHK_EDUCATION_LEVEL — Verifies the education level code supplied for a record.
• CHK_EFFECTIVE_DATE — Confirms that the effective date of a personnel action falls within acceptable boundaries.
• CHK_HANDICAP — Validates handicap designation coding used in federal appointment processing.
• CHK_INDIV_AWARD — Checks individual award records distinct from the aggregate award amount validation.
• CHK_SCD_HANDICAP — Validates service computation date logic in conjunction with handicap coding.

Tables Accessed

The ETRM metadata for this object lists no directly referenced tables through APPS synonyms. The procedures receive their data exclusively through input parameters, indicating that the calling program bears responsibility for querying base HRMS tables such as PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, and related lookup views, then passing the extracted values into these validation routines. This parameter-driven design keeps the package decoupled from the data model and permits reuse across multiple reporting contexts.

Usage Notes

GHR_CPDF_CHECK2 is invoked programmatically rather than through a user-facing form. It is typically called by the parent CPDF extraction or validation package (the single documented referencer) during report generation, when each personnel record is examined against the statutory edit rules. Customizations or extensions to federal CPDF reporting that need to reproduce Oracle's standard date-of-birth, appointment authority, or award validation logic should call the corresponding procedure directly, passing the effective date and code values already retrieved from the HRMS tables. Because the package is marked noship, it should be treated as a fixed internal dependency; modifications carry risk of breaking the referencing reporting program. In EBS 12.1.1 and 12.2.2 environments, the package resides in the APPS schema and requires no separate grants beyond standard APPS execution privileges.