Search Results igs_en_gen_002




Overview
Explore in AI Chat

Overview

APPS.IGS_FI_CNG_FCAT_LBL_SCA_PR_V is a student-facing fees view within the Oracle E-Business Suite (EBS) Student System (IGS) product family. It exposes fee category label and student course attempt data for students who have an associated fee category calendar relationship, enriching the base student attempt record with derived fee-liability, fee-type, and date information. In the 12.1.1 and 12.2.2 releases, the view is a key element for reporting on Higher Education Contribution Scheme (HECS) payment options and fee liability status — particularly relevant to Australian higher-education institutions that use the IGS financials and enrolment modules.

The view is named for the objects it relates: FI (financials), CNG (change/course-ng), FCAT (fee category), LBL (label), SCA (student course attempt), and the _PR_V suffix denoting a product/periodical-style reporting view. Its primary role is to serve as a single denormalised source for downstream reports, concurrent programs, and integration extracts that must present fee category codes alongside a student's course attempt, attendance mode, attendance type, and HECS payment option.

Underlying Base Objects

The view is defined over five principal source objects:

  • IGS_EN_STDNT_PS_ATT (aliased sca) — the student course attempt record, providing person, course, version, calendar type, location, attendance mode/type, course attempt status, commencement and discontinuation dates, primary program type, and key program.
  • IGS_FI_F_CAT_CAL_REL (FCCR) — the fee category calendar relationship, supplying fee category and fee calendar type/sequence joins back to the student.
  • IGS_LOOKUPS_VIEW (scas) — the lookup for CRS_ATTEMPT_STATUS, decoding the course attempt status and providing fee_ass_ind.
  • IGS_FI_F_CAT_FEE_LBL_V (fcflv) — the fee category fee label view, exposing fee liability status, fee type, currency, charge method, rule sequence number, and date aliases.
  • IGS_FI_FEE_TYPE (ft) — the fee type master, providing s_fee_type and s_fee_trigger_cat.

The metadata does not document base tables explicitly, but the view text confirms these five objects as its relational foundation. Join conditions align the fee category calendar relationship to the student attempt on PERSON_ID, COURSE_CD, and VERSION_NUMBER.

Key Columns

Common Use Cases and Queries

Typical uses include fee liability reconciliation, HECS/payment-option reporting by cohort, and student fee extracts feeding external government reporting. A representative query lists current fee liability per student and course attempt:

SELECT person_id,
       course_cd,
       version_number,
       fee_cat,
       fee_liability_status,
       HECS_PAYMENT_OPTION,
       START_DT,
       END_DT
FROM   APPS.IGS_FI_CNG_FCAT_LBL_SCA_PR_V
WHERE  fee_cal_type = :p_cal_type
AND    fee_liability_status = 'ASSESSED';

Another common pattern joins the view back to IGS_EN_STDNT_PS_ATT via person_id, course_cd, and version_number to enrich enrolment reports with fee data. Because the view already resolves date aliases and HECS payment options, reports avoid re-implementing the calp_get_alias_val and finp_get_hecs_pymnt_optn API calls. Analysts should note the view performs several function calls per row, so restricting by fee calendar type or person is recommended for performance.