Results for “joining_way_cd”

20 results




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

Overview

The APPS.PQH_CORPS_EXAMS_V view is a Public Sector HR (PQH) reporting and integration object that presents corporate examination records associated with a Corps definition in Oracle E-Business Suite 12.1.1 and 12.2.2. It is documented in ETRM as "Corp Exam View" and carries a VALID status in the APPS schema. The view is defined over PQH_CORPS_EXTRA_INFO and restricts output to rows where INFORMATION_TYPE = 'EXAM', effectively isolating the exam-related slice of the extensible Corps information model. Its purpose is to expose examination data in a denormalized, decode-friendly form, resolving lookup codes and institution identifiers into human-readable values. Users searching for institution_id will find that the view surfaces this attribute directly, aliased from CEI.INFORMATION4, and additionally joins to HR_ORGANIZATION_UNITS to resolve the corresponding institution name. Because the view decodes descriptive flexfield-style attributes into labelled columns, it is well suited to concurrent program reports, OBIEE/XML Publisher data sources, and inbound integration staging rather than to transactional data entry, which is handled by the underlying Corps extra information forms.

Underlying Base Objects

The documented referenced base objects are:

  • PQH_CORPS_EXTRA_INFO (SYNONYM) — the primary driving table, containing the Corps extensible information rows filtered to INFORMATION_TYPE = 'EXAM'.
  • HR_ORGANIZATION_UNITS (VIEW) — joined on ORG.ORGANIZATION_ID = CEI.INFORMATION4 to resolve the institution name.
  • HR_GENERAL (PACKAGE) — invoked via HR_GENERAL.DECODE_LOOKUP to translate lookup values such as PQH_CORPS_EXAM_TYPE and PQH_CORPS_WAYS.
  • HR_SECURITY (PACKAGE) — referenced for security processing within the HR organization hierarchy.

The view therefore joins the Corps extra information store to the HR organization model and uses HR lookup utilities to present decoded attributes. The join to HR_ORGANIZATION_UNITS is an inner join on INFORMATION4, so exam rows whose institution identifier does not match a valid organization are excluded.

Key Columns

  • CORPS_DEFINITION_ID — identifier of the parent Corps definition to which the exam belongs.
  • CORPS_EXTRA_INFO_ID — primary key of the underlying extra information row.
  • OBJECT_VERSION_NUMBER — optimistic locking version number.
  • INFORMATION_TYPE — always 'EXAM' in this view.
  • EXAMINATION_TYPE / EXAMINATION_TYPE_CD — decoded and coded form of the examination type, based on lookup PQH_CORPS_EXAM_TYPE from INFORMATION3.
  • INSTITUTION_ID — the institution organization identifier, sourced from CEI.INFORMATION4; this is the column most commonly sought by users searching for the institution key.
  • INSTITUTION_NAME — the organization name resolved from HR_ORGANIZATION_UNITS for the matching INSTITUTION_ID.
  • JOINING_WAY / JOINING_WAY_CD — decoded and coded joining method, based on lookup PQH_CORPS_WAYS from INFORMATION5.
  • MANDATORY_FLAG — flag from INFORMATION6 indicating whether the exam is mandatory.

Common Use Cases and Queries

Typical uses include listing exams by institution, reporting mandatory exams, and joining exam data to Corps definitions for integration extracts.

SELECT institution_id, institution_name, examination_type, mandatory_flag
FROM   apps.pqh_corps_exams_v;

Viewing all exams for a specific institution:

SELECT corps_definition_id, examination_type, joining_way
FROM   apps.pqh_corps_exams_v
WHERE  institution_id = :p_institution_id;

Reporting mandatory examinations joined to Corps:

SELECT v.corps_definition_id, v.examination_type, v.institution_name
FROM   apps.pqh_corps_exams_v v
WHERE  v.mandatory_flag = 'Y';