Results for “ghr_pd_coversheet_v”

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

Overview

The GHR_PD_COVERSHEET_V view is a reporting object owned by the APPS schema and delivered as part of the GHR — US Federal Human Resources product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to expose Position Description Coversheet details, consolidating the header-level attributes that make up the coversheet of a federal Position Description (PD) into a single queryable structure. Position Descriptions are the formal, classified statements of duties, responsibilities, and organizational placement required under US federal position management rules, and the coversheet captures the administrative, classification, supervisory, and routing information associated with each PD.

The view functions as a denormalized reporting layer rather than a transactional table. It joins core Position Description data to position, person, and request records, and it applies lookup decoding and derived organizational attributes so that consumers receive human-readable values instead of raw codes. For ETRM (Electronic Technical Reference Manual) purposes, the view is most relevant as a source for BI Publisher reports, custom extracts, and integration interfaces that must reproduce the standard PD coversheet layout without reimplementing the underlying decode and derivation logic.

Underlying Base Objects

The ETRM 12.2.2 metadata documents the following referenced base objects:

• GHR_POSITION_DESCRIPTIONS (synonym) — the primary source of Position Description attributes such as FLSA category, financial statement status, position status, sensitivity, competitive level, and the supervisor, manager, and classifier signature blocks.
• GHR_PA_REQUESTS (synonym) — supplies the personnel action request context, including PA_REQUEST_ID, linking the coversheet to the action that initiated it.
• PER_POSITION_EXTRA_INFO (synonym) — provides POSITION_ID, the key used to retrieve organizational group attributes.
• PER_PEOPLE_X (view) and HR_PERSON_NAME (package) — resolve the incumbent's PERSON_ID and formatted FULL_NAME.
• HR_POSITIONS_X (view) — position definition data used in the broader PD context.
• GHR_PD_COVERSHEET_DATA (package) — supplies the derived functions GET_FR_POSITION_GROUP and GET_GEN_EMP that extract employing office, organization title, organization structure, and reason for submission.
• HR_GENERAL (package) — supplies DECODE_LOOKUP, which converts stored codes into their display meanings.
• HR_SECURITY (package) and FND_PROFILE (package) — support security and profile-option evaluation consistent with HRMS access rules.

Key Columns

The view projects identifying keys, decoded lookup values, and derived organizational fields:

• POSITION_DESCRIPTION_ID — primary identifier of the Position Description record.
• PA_REQUEST_ID — the associated personnel action request.
• POSITION_ID and PERSON_ID — links to the position and the incumbent; FULL_NAME gives the incumbent name.
• OPM_CERT_NUM — OPM certificate number associated with the action.
• D_FLSA, D_FINANCIAL_STATEMENT, D_SUBJECT_TO_IA_ACTION, D_POSITION_STATUS, D_POSITION_IS, D_POSITION_SENSITIVITY, D_COMPETITIVE_LEVEL, D_CAREER_LADDER — decoded display values corresponding to the raw FLSA, FINANCIAL_STATEMENT, SUBJECT_TO_IA_ACTION, POSITION_STATUS, POSITION_IS, POSITION_SENSITIVITY, COMPETITIVE_LEVEL, and CAREER_LADDER columns.
• D_POSITION_STATUS and D_POSITION_IS in particular answer whether a position is occupied and whether it is supervisory.
• SUPERVISOR_NAME, SUPERVISOR_TITLE, SUPERVISOR_DATE, MANAGER_NAME, MANAGER_TITLE, MANAGER_DATE, CLASSIFIER_NAME, CLASSIFIER_TITLE, CLASSIFIER_DATE — the certification signature blocks.
• EMPLOYING_OFFICE_LOC, ORG_TITLE, and ORG_STRUCTURE_ID — derived from GET_FR_POSITION_GROUP against position group GHR_US_POS_GRP1, truncated to 80 characters.
• REASON_FOR_SUBMISSION — decoded from GET_GEN_EMP using lookup type GHR_US_SUBMISSION_REASON.
• PD_REMARKS, POSITION_CLASS_STD, and CATEGORY — free-text and classification-standard context.

Common Use Cases and Queries

Typical scenarios include reproducing the standard PD coversheet for a given action request, auditing classification data across a set of positions, and feeding organizational routing information to downstream workflow or interfaces. The search term org_structure_id reflects the common need to filter or group coversheets by organizational structure, which in this view is a derived column rather than a stored key.

Retrieve a single coversheet by request:

• SELECT position_description_id, pa_request_id, full_name, d_flsa, d_position_status, org_title, org_structure_id FROM apps.ghr_pd_coversheet_v WHERE pa_request_id = :request_id;

Group coversheets by organizational structure:

• SELECT org_structure_id, org_title, COUNT(*) FROM apps.ghr_pd_coversheet_v GROUP BY org_structure_id, org_title ORDER BY org_structure_id;

List supervisory positions currently occupied:

• SELECT position_description_id, full_name, d_position_is, d_position_status FROM apps.ghr_pd_coversheet_v WHERE d_position_is = 'Supervisory' AND d_position_status = 'Occupied';