Results for “igs_ps_fa_program_type”

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

Overview

The view APPS.IGS_PS_TYPE_HIST_V is a reporting construct in the Oracle E-Business Suite (EBS) Higher Education / Student System (IGS) product family. It presents a consolidated, versioned history of course type definitions, exposing the effective-dated attribute set that governs how a course type is classified for program, government reporting, research, and financial aid purposes. The _HIST_V suffix indicates that the view overlays the current course type record with its historical audit rows, so that consumers can retrieve the attribute values that were in force at a given point in time rather than only their present values.

The view is significant for reporting and integration because many downstream processes — regulatory extracts, student records processing, and financial aid eligibility determination — must reflect the state of a course type as it existed on a relevant effective date. The user search term fin_aid_program_type maps directly to a column exposed by this view, confirming its role as the authoritative source for the financial aid program type associated with a course type.

Underlying Base Objects

The documented view definition selects from three principal sources:

• IGS_PS_TYPE_HIST cth1 — the historical/audit table holding dated rows of course type attribute changes.
• IGS_PS_TYPE ct1 — the base course type table holding the current definition.
• IGS_LOOKUP_VALUES lv1 — joined with an outer join ((+)) on lookup_type = 'IGS_PS_FA_PROGRAM_TYPE' to resolve the financial aid program type lookup code to its display meaning.

Also referenced is the packaged function IGS_AU_GEN_001.audp_get_cth_col, which the view invokes to retrieve the historical column value for a course type at a specified hist_end_dt. This function performs the audit-table lookup that supports the NVL fallback logic: the view first attempts to use the explicit historical column value, then the function-returned value, and finally the current base table value. The view definition ends with a UNION ALL branch that selects from IGS_PS_TYPE_HIST cth2 using MAX(cth2.hist_end_dt), extending coverage to course types whose most recent history row must be identified dynamically. No additional base objects are documented in the ETRM metadata beyond these.

Key Columns

• COURSE_TYPE — the primary identifier of the course type being described.
• HIST_START_DT, HIST_END_DT — the effective date range for the historical record.
• DESCRIPTION — the course type description, truncated to 60 characters in the historical path.
• GOVT_COURSE_TYPE — the government reporting classification of the course type.
• AWARD_COURSE_IND — indicates whether the course type leads to an award.
• COURSE_TYPE_GROUP_CD — a grouping code used for categorisation and reporting rollups.
• TAC_COURSE_LEVEL — the TAC ( Tertiary Admissions Centre) course level classification.
• RESEARCH_TYPE_IND — indicates whether the course type is a research type.
• CLOSED_IND — indicates whether the course type is closed for new use.
• PRIMARY_AUTO_SELECT — controls automatic selection behaviour.
• FIN_AID_PROGRAM_TYPE — the financial aid program type code, joined to IGS_LOOKUP_VALUES.
• MEANING — the decoded display value of the financial aid program type lookup.
• Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The view is typically used to report the financial aid program type and related classifications for a course type as they applied on a given date, and to build extracts for government and financial aid reporting. A representative query returns the current and historical financial aid program type meaning for a course type:

• Financial aid extract: filter by FIN_AID_PROGRAM_TYPE and HIST_END_DT to determine which course types were aid-eligible in a reporting period.
• Point-in-time lookup: constrain HIST_START_DT and HIST_END_DT to retrieve the attribute set effective on a student's admission or enrolment date.
• Reference data listing: join to IGS_LOOKUP_VALUES through the exposed MEANING column to present human-readable program types.

A minimal sample statement follows: SELECT course_type, hist_start_dt, hist_end_dt, fin_aid_program_type, meaning FROM apps.igs_ps_type_hist_v WHERE fin_aid_program_type IS NOT NULL ORDER BY course_type, hist_end_dt DESC; This returns the effective-dated financial aid program type for every course type, with the decoded meaning, ordered by most recent effective date.