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.INFORMATION4to resolve the institution name. - HR_GENERAL (PACKAGE) — invoked via
HR_GENERAL.DECODE_LOOKUPto translate lookup values such asPQH_CORPS_EXAM_TYPEandPQH_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_TYPEfromINFORMATION3. - 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_UNITSfor the matchingINSTITUTION_ID. - JOINING_WAY / JOINING_WAY_CD — decoded and coded joining method, based on lookup
PQH_CORPS_WAYSfromINFORMATION5. - MANDATORY_FLAG — flag from
INFORMATION6indicating 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';
-
View: PQH_CORPS_EXAMS_V 12.2.2
Corp Exam View
APPS.PQH_CORPS_EXAMS_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PQH module →
-
View: PQH_CORPS_TRAININGS_V 12.2.2
APPS.PQH_CORPS_TRAININGS_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PQH module →
-
View: PQH_CORPS_EXAMS_V 12.1.1
Corp Exam View
APPS.PQH_CORPS_EXAMS_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PQH module →
-
View: PQH_CORPS_RULES_V 12.1.1
Corp Rules View
APPS.PQH_CORPS_RULES_V·↳ HR_GENERAL·↳ PQH_CORPS_EXTRA_INFO·Explore PQH module →
-
View: PQH_CORPS_RULES_V 12.2.2
Corp Rules View
APPS.PQH_CORPS_RULES_V·↳ HR_GENERAL·↳ PQH_CORPS_EXTRA_INFO·Explore PQH module →
-
View: PQH_CORPS_TRAININGS_V 12.1.1
APPS.PQH_CORPS_TRAININGS_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PQH module →
-
VIEW: APPS.PQH_CORPS_EXAMS_V 12.1.1
-
VIEW: APPS.PQH_CORPS_RULES_V 12.1.1
-
VIEW: APPS.PQH_CORPS_RULES_V 12.1.1
-
VIEW: APPS.PQH_CORPS_EXAMS_V 12.2.2
-
VIEW: APPS.PQH_CORPS_RULES_V 12.2.2
-
VIEW: APPS.PQH_CORPS_EXAMS_V 12.2.2
-
VIEW: APPS.PQH_CORPS_RULES_V 12.2.2
-
VIEW: APPS.PQH_CORPS_EXAMS_V 12.1.1
-
eTRM - PQH Tables and Views 12.2.2
This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process.
-
eTRM - PQH Tables and Views 12.1.1
This is a Copy of PQH_WORKSHEET_PERIODS table populated by EFC (Euro as functinoal currency) process.