Results for “pqh_corps_ways”

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

Overview

APPS.PQH_CORPS_TRAININGS_V is a reporting view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Enterprise Talent and Resource Management (ETRM) module. It presents training-related information stored against Corps of Engineers (CORPS) definitions, exposing qualification, institution, training duration, and attendance attributes in a denormalized, business-friendly form. The view is read-only and functions as a presentation layer over the generic PQH_CORPS_EXTRA_INFO extension table, which stores flexible "information1..N" columns against CORPS definitions.

The view isolates rows where INFORMATION_TYPE = 'TRAINING', meaning the underlying extra-info rows are specifically modeled as training records. By decoding raw lookup codes into user-facing descriptions and joining to qualification and organization tables, the view supports reporting on workforce qualifications and training history without requiring consumers to understand the underlying flexible-column schema. It is commonly referenced by CORPS configuration pages, OBIEE/BI Publisher reports, and integration extracts.

Underlying Base Objects

The view is defined over several documented base objects within the APPS schema:

• PQH_CORPS_EXTRA_INFO (synonym) — the driving table, aliased CEI. It holds the CORPS definition identifier, object version, information type, and the positional information columns that are re-aliased into semantic names.
• PER_QUALIFICATION_TYPES_TL (synonym) — the translated qualification types table, aliased QTT. It supplies the qualification name, joined on INFORMATION3.
• HR_ORGANIZATION_UNITS (view) — the organization view, aliased ORG. It supplies the institution name, joined on INFORMATION4.
• HR_GENERAL (package) — provides the DECODE_LOOKUP function used to translate lookup codes into descriptions.
• HR_SECURITY (package) — supports security processing in the organization/HR context.

Two outer joins are effectively required in practice: qualification and institution may be null, and the LANGUAGE = USERENV('LANG') predicate ensures qualification names are returned in the session language.

Key Columns

• CORPS_DEFINITION_ID, CORPS_EXTRA_INFO_ID, OBJECT_VERSION_NUMBER — primary identity and versioning columns.
• INFORMATION_TYPE — always 'TRAINING' in this view; the discriminator column.
• QUALIFICATION / QUALIFICATION_ID — decoded qualification name and its underlying ID.
• INSTITUTION_NAME / INSTITUTION_ID — training provider or institution.
• TRAINING_DURATION, TRAINING_DURATION_UOM, UOM_DESC — duration value, its UOM code, and the decoded FREQUENCY lookup description.
• JOINING_WAY, JOINING_WAY_CD, MANDATORY_FLAG — the raw code, its decoded PQH_CORPS_WAYS description, and whether the training is mandatory.

Common Use Cases and Queries

Typical uses include qualification/training gap analysis, institution participation reporting, and extracting training attributes into downstream systems. A representative query:

• SELECT corps_definition_id, qualification, institution_name, training_duration, uom_desc, joining_way, mandatory_flag FROM apps.pqh_corps_trainings_v WHERE mandatory_flag = 'Y';
• Joining back to PQH_CORPS_DEFINITIONS_V on CORPS_DEFINITION_ID to enrich with the CORPS definition name.
• Filtering by JOINING_WAY_CD to analyze how trainings are joined or scheduled.