Results for “fin_aid_program_type”

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

Overview

IGS_PS_TYPE is a Multi-Org secured view owned by the APPS schema in the Oracle E-Business Suite Student System (IGS) product family. It exposes program type (course type) reference data that drives program and course setup within Oracle Student System and related enrolment, admissions, and financial aid processes. In EBS 12.1.1 and 12.2.2, the view is registered with a status of VALID and presents program type information filtered by the operating unit (ORG_ID) of the current session, allowing each business unit to maintain its own set of program types without exposing data belonging to other organizations.

Because the view hides the underlying Multi-Org security predicate, it serves as the standard reporting and integration access point for program type data. Concurrent programs, BI Publisher reports, OBIEE extracts, and inbound/outbound interface scripts should query IGS_PS_TYPE rather than the underlying _ALL table so that Multi-Org (MOAC) security is respected automatically.

Underlying Base Objects

The view is defined over a single base table, IGS_PS_TYPE_ALL, which physically stores program type records for all operating units. The view definition selects all columns from the base table and appends a WHERE clause that restricts rows to the current organization:

• The security predicate derives the organization identifier from the USERENV('CLIENT_INFO') session context, reading the first ten characters when the first character is not a space.
• Where the session context is not populated, the predicate resolves to -99, matching only rows whose ORG_ID also evaluates to -99 (typically a null or unset organization).
• The view additionally exposes TAB.ROWID as ROW_ID, giving consumers a stable row identifier for the underlying physical row.
• No additional documented base objects, joins, or synonyms beyond IGS_PS_TYPE_ALL are referenced by the view text.

Key Columns

The view exposes the following significant columns:

• ROW_ID – ROWID of the underlying IGS_PS_TYPE_ALL row; useful for updates through the view or for tracing back to the base record.
• COURSE_TYPE – The program type code; primary business key used across Student System setup.
• DESCRIPTION – Descriptive name of the program type presented to users.
• GOVT_COURSE_TYPE – Government classification mapping, used for statutory reporting.
• AWARD_COURSE_IND – Indicates whether the type represents an award-bearing program.
• COURSE_TYPE_GROUP_CD – Grouping code used to aggregate program types for reporting and validation.
• TAC_COURSE_LEVEL – Teaching and course level attribute relevant to regulatory returns.
• RESEARCH_TYPE_IND – Flags research-oriented program types.
• CLOSED_IND – Marks the program type as inactive or closed to new use.
• PRIMARY_AUTO_SELECT – Controls automatic selection behaviour during enrolment.
• ENROLMENT_CAT – Enrolment category associated with the program type.
• FIN_AID_PROGRAM_TYPE – Financial aid program type classification.
• ORG_ID – Operating unit owning the record; the Multi-Org discriminator.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS audit columns.

Common Use Cases and Queries

Typical uses include validating program type setup per operating unit, populating LOVs in custom forms, extracting reference data for data warehouses, and reconciling financial aid or statutory reporting classifications.

List active program types for the current operating unit:

• SELECT course_type, description, award_course_ind, enrolment_cat FROM igs_ps_type WHERE NVL(closed_ind,'N') = 'N' ORDER BY course_type;

Retrieve full details for a specific program type:

• SELECT course_type, description, govt_course_type, tac_course_level, fin_aid_program_type FROM igs_ps_type WHERE course_type = :p_course_type;

Report counts grouped by course type group and organization:

• SELECT org_id, course_type_group_cd, COUNT(*) FROM igs_ps_type GROUP BY org_id, course_type_group_cd ORDER BY org_id, course_type_group_cd;

Because the view enforces Multi-Org security through CLIENT_INFO, queries executed from concurrent programs or forms correctly return only the rows for the active organization, while ad-hoc SQL run outside a Multi-Org context may return only rows with an unresolved ORG_ID.