Results for “igs_ps_type_v”

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

Overview

IGS_PS_TYPE_V is a form-driven database view within the Oracle E-Business Suite Student System (IGS) product family. It exposes the set of user-defined program types maintained through the Program Types maintenance form, presenting the descriptive and control attributes that govern how a program type behaves across student records, admissions, and enrolment processing. In ETRM 12.1.1 and 12.2.2 the object is classified as obsolete, and the documentation notes that it is "not implemented in this database," meaning the view may exist only in legacy or partially upgraded environments rather than in a fresh 12.2.2 installation.

Its principal role is to support the Program Types form and any reporting or integration layer that needs the same program-type reference data. The view resolves the foreign-key relationship between the program type and the IGS_LOOKUP_VALUES table, translating the FIN_AID_PROGRAM_TYPE lookup code into a human-readable meaning. Because it is a form view rather than a pure reporting object, its column list mirrors the on-screen fields of the maintenance form, making it a convenient single source for validation lists, LOV-style queries, and downstream extracts.

Underlying Base Objects

The view is defined over two documented base objects. The first, IGS_PS_TYPE, is the primary program-type table and supplies almost every column in the select list. The second, IGS_LOOKUP_VALUES, is joined with an outer join (indicated by the (+) operator) to provide the MEANING column. The join condition is:

• TAB.FIN_AID_PROGRAM_TYPE = LV.LOOKUP_CODE (+)
• LV.LOOKUP_TYPE (+) = 'IGS_PS_FA_PROGRAM_TYPE'

Because both conditions are outer-joined, a program type that has no matching financial-aid lookup value is still returned, with MEANING as NULL. The ETRM metadata records no further referenced base objects, and no view owner is documented for this release. The view text additionally projects TAB.ROWID as ROW_ID, which is characteristic of Oracle Forms block definitions that require a row identifier for updateable blocks.

Key Columns

The columns exposed by IGS_PS_TYPE_V fall into three groups:

• Identity and description: COURSE_TYPE (the program type code), DESCRIPTION, and GOVT_COURSE_TYPE (the government reporting classification).
• Classification and behaviour flags: AWARD_COURSE_IND, COURSE_TYPE_GROUP_CD, TAC_COURSE_LEVEL, RESEARCH_TYPE_IND, CLOSED_IND, PRIMARY_AUTO_SELECT, and ENROLMENT_CAT. ENROLMENT_CAT is the enrolment category, the attribute most relevant to the user's search term "enrolment_cat"; it drives categorisation of enrolment records associated with the program type.
• Financial aid and audit: FIN_AID_PROGRAM_TYPE and its resolved FIN_AID_PROGRAM_TYPE_MEANING, plus CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and ORG_ID.

Common Use Cases and Queries

Typical uses include populating LOVs, validating program-type input, reporting enrolment categories by program type, and extracting program-type reference data for integration. The following query lists active program types with their enrolment category and financial aid meaning:

SELECT course_type,
       description,
       enrolment_cat,
       fin_aid_program_type,
       fin_aid_program_type_meaning
FROM   igs_ps_type_v
WHERE  closed_ind = 'N'
ORDER  BY course_type;

A focused lookup on enrolment categories for a given operating unit is equally common:

SELECT enrolment_cat, COUNT(*) program_type_count
FROM   igs_ps_type_v
WHERE  org_id = :p_org_id
GROUP  BY enrolment_cat;

Analysts should note the obsolete classification and confirm the view's presence in the target instance before relying on it for new development.