Results for “igs_fi_f_cat_fee_lbl_sca_v”

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

Overview

IGS_FI_F_CAT_FEE_LBL_SCA_V is a database view owned by the APPS schema in the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environments. It belongs to the IGS (Student System) product family, which encompasses the Oracle Student System and its fees, admissions, enrolment, and calendar sub-modules. The view exposes a consolidated, denormalised projection that describes the fee types applicable to a fee category period — that is, a specific fee category calendar instance. Its name reflects this purpose: "FI" denotes the Fees component, "F_CAT_FEE" refers to fee category fees, "LBL" signals a label-oriented (descriptive) view, and "SCA" reflects that the driving rows originate from the student course attempt entity.

Rather than serving as a transactional table, the view functions as a read-only reporting and integration artefact. It is typically consumed by fee assessment processes, student financials reports, and external integrations that need to resolve, for a given student course attempt, the set of fee types and calendar-boundary dates that govern fee liability. The view is registered as VALID in the data dictionary at the time of documentation.

Underlying Base Objects

The view is defined over four principal base objects:

• IGS_EN_STDNT_PS_ATT (SCA) — the student course attempt table, providing person, course, version, calendar type, location, attendance mode/type, attempt status, and commencement/discontinued dates.
• IGS_LOOKUPS_VIEW (SCAS) — a lookup view restricted to the lookup type CRS_ATTEMPT_STATUS, used to resolve the course attempt status code into a descriptive value.
• IGS_FI_F_CAT_FEE_LBL_V (FCFLV) — the fee category fee label view, supplying fee category, fee calendar type, calendar instance sequence, fee type, liability status, start/end/retro date aliases and sequence numbers, charge method, rule sequence, and currency.
• IGS_FI_FEE_TYPE (FT) — the fee type table, contributing the system fee type, trigger category, and related descriptive attributes.

The joins link each student course attempt to its applicable fee category, then to the fee label records for that category, and finally to the fee type definitions. The fee category label set is itself derived from fee category calendar instances, meaning the view bridges enrolment data with calendar and fee configuration.

Key Columns

• PERSON_ID, COURSE_CD, VERSION_NUMBER — identify the student and the specific course attempt.
• CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE — contextual attributes of the attempt.
• HECS_PAYMENT_OPTION — computed via IGS_FI_GEN_001.FINP_GET_HECS_PYMNT_OPTN, resolving the HECS payment option for the student/course combination.
• COURSE_ATTEMPT_STATUS — the descriptive status resolved from the lookup.
• COMMENCEMENT_DT, DISCONTINUED_DT — attempt lifecycle dates.
• FEE_ASS_IND, FEE_CAT — fee assessment indicator and the fee category assigned to the attempt.
• FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER — the fee calendar type and calendar instance sequence identifying the fee category period.
• FEE_TYPE, S_FEE_TYPE, S_FEE_TRIGGER_CAT — the fee type code and its descriptive/trigger classifications.
• FEE_LIABILITY_STATUS — indicates the liability standing for the fee.
• START_DT, END_DT, RETRO_DT — resolved calendar boundary dates, computed through IGS_CA_GEN_001.CALP_GET_ALIAS_VAL from the stored alias and sequence references.
• S_CHG_METHOD_TYPE, RUL_SEQUENCE_NUMBER, CURRENCY_CD — charging method, rule sequence, and currency.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The view is commonly used to determine which fee types apply to a student's course attempt within a given fee category period, and to retrieve the effective start, end, and retroactive dates for those fees. A typical reporting query follows the pattern below:

• Listing applicable fee types for a student:
  SELECT person_id, course_cd, fee_cat, fee_type, s_fee_type, start_dt, end_dt
FROM apps.igs_fi_f_cat_fee_lbl_sca_v
WHERE person_id = :p_person_id;
• Filtering by fee liability status to isolate active or pending liabilities.
• Joining to fee assessment or invoice tables to reconcile computed charges against configured fee types.
• Extracting calendar-boundary dates for downstream billing or integration feeds.

Because the view performs date resolution and status lookups at query time, it should be used in reporting and integration contexts rather than as a persistent staging table. Due to limited documented base object metadata, the descriptions above are grounded in the supplied view text and standard IGS fee model conventions.