Results for “fin_aid_program_type_meaning”

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

Overview

IGS_PS_TYPE_HIST_V is a reporting view within the Oracle E-Business Suite Student System (IGS) product family. Its purpose, as documented in the ETRM metadata for releases 12.1.1 and 12.2.2, is to merge program type history records with the current program type details so that all attribute values remain accessible across time, up to and including the present day. Each row returned by the view represents the full set of column values that were valid during a defined effective period, delimited by HIST_START_DT and HIST_END_DT.

The object is classified as Obsolete and is marked "Not implemented in this database." This means the view is retained only for historical or backward-compatibility reference and is not created or maintained in current deployments. Report authors and integrators who encounter it should treat it as documentation of prior institutional behavior rather than as an invocable runtime object. The view is nonetheless significant because it exposes COURSE_TYPE_GROUP_CD, the column most relevant to the search that led here, alongside the other program type attributes needed to reconstruct how a course type was configured at any point in time.

Underlying Base Objects

The ETRM metadata documents no referenced base objects, and the view text itself reveals the mechanism. The primary driver is CTH1, an alias for the course type history table (IGS_PS_TYPE_HIST, the "CTH" table), which supplies the historical rows keyed by COURSE_TYPE, HIST_START_DT, HIST_END_DT and HIST_WHO. The second participant, CT1, is the current course type table (IGS_PS_TYPE, the "CT" table), supplying fallback values when a historical column is null.

Because the Student System is heavily client-extended, the view does not read the history table directly for every attribute. It calls the client hook package IGS_AU_GEN_001.AUDP_GET_CTH_COL, an auditing/history column retrieval API, passing the column name, the COURSE_TYPE, and HIST_END_DT. This function returns the historical value for columns such as DESCRIPTION, GOVT_COURSE_TYPE, COURSE_TYPE_GROUP_CD, TAC_COURSE_LEVEL and PRIMARY_AUTO_SELECT when the base history row does not carry it. The characteristic three-level NVL and SUBSTR nesting — first the stored history value, then the hook-returned value, then the current table value — defines every attribute projected by the view. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are carried through from CTH1.

Key Columns

• COURSE_TYPE — the program/course type identifier that joins the history and current records.
• HIST_START_DT / HIST_END_DT — effective dating bounds that make the view a time-sliced record of attributes.
• COURSE_TYPE_GROUP_CD — the grouping code for the course type, resolved through stored value, hook function (SUBSTR to 10 characters), then current value.
• DESCRIPTION — truncated to 60 characters when sourced through the hook.
• GOVT_COURSE_TYPE, TAC_COURSE_LEVEL, AWARD_COURSE_IND, RESEARCH_TYPE_IND, CLOSED_IND, PRIMARY_AUTO_SELECT, FIN_AID_PROGRAM_TYPE — configuration flags and classifications, each resolved with the same three-tier logic.
• HIST_WHO — the user or process responsible for the historical change.
• Audit columns — creation and update metadata inherited from the history table.

Common Use Cases and Queries

The view is used for point-in-time reporting on program type configuration: reconstructing which course type group applied to a student's enrolment at a given date; auditing changes to research type, award indicators or financial aid program type; and reconciling historical extracts against current setup. A typical query filters a single course type across all its effective periods and orders chronologically:

• SELECT course_type, hist_start_dt, hist_end_dt, course_type_group_cd, award_course_ind, closed_ind FROM igs_ps_type_hist_v WHERE course_type = :course_type ORDER BY hist_start_dt;
• SELECT course_type_group_cd, COUNT(*) FROM igs_ps_type_hist_v WHERE :as_of_date BETWEEN hist_start_dt AND hist_end_dt GROUP BY course_type_group_cd;
• SELECT course_type, hist_start_dt, hist_end_dt, tac_course_level, research_type_ind, fin_aid_program_type FROM igs_ps_type_hist_v WHERE TRUNC(hist_start_dt) >= TRUNC(:from_date);

Because the object is documented as obsolete and not implemented, any such statement should be validated against the specific institution's schema before use, and consideration given to the equivalent current history table and hook-driven logic that the view historically encapsulated.