Results for “retro_dt”

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

Overview

IGS_FI_F_CAT_FEE_LBL_SCA_PRR_V is a reporting view in the Oracle EBS Student System (IGS) product family, now classified as obsolete in the ETRM 12.1.1 / 12.2.2 documentation set. The view presents the fee types applicable to a fee category period — that is, a fee category calendar instance — extended across the current and prior fee calendars. Its purpose is to resolve the calendar alias placeholders held on fee category fee-type records (start date, end date, and retroactive date aliases) into concrete dates by invoking the calendar alias resolution function, while simultaneously exposing the student course attempt data against which those fee liabilities accrue.

The name itself reflects this composition: CAT_FEE denotes fee category fee types, LBL indicates the label or label-value resolution layer, SCA identifies the student course attempt driving table, and PRR denotes the prior-calendar scope. Because the object is documented as not implemented in the reference database, it should be treated as a historical artifact, retained for backward compatibility of dependent reports or custom code rather than for new development.

Underlying Base Objects

The ETRM metadata records no referenced base objects for this view, and the view text is the only authoritative structural evidence available. From that text, the following sources are joined:

• IGS_EN_STDNT_PS_ATT (aliased SCA) — the student course attempt, supplying person, course, version, calendar type, location, attendance attributes, commencement and discontinuation dates, fee category, program type, and key program.
• IGS_LOOKUPS_VIEW (aliased SCAS) — restricted to lookup type CRS_ATTEMPT_STATUS, used to validate and decode the course attempt status.
• IGS_FI_F_CAT_FEE_LBL_V (aliased FCFLV) — the fee category fee-type label view supplying fee calendar type, calendar instance sequence, fee type, liability status, alias and daily-instance sequence numbers, charge method, rule sequence, and currency.
• IGS_FI_FEE_TYPE (aliased FT) — the fee type definition, contributing system fee type and fee trigger category.

Functionally, the view also depends on two PL/SQL entry points: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL for alias-to-date resolution and IGS_FI_GEN_001.FINP_GET_HECS_PYMNT_OPTN for the HECS payment option derived for each row.

Key Columns

The projection divides into identity, calendar resolution, and fee definition groups:

• Identity columns — PERSON_ID, COURSE_CD, VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, ATTENDANCE_TYPE, COURSE_ATTEMPT_STATUS, COMMENCEMENT_DT, DISCONTINUED_DT, PRIMARY_PROGRAM_TYPE, KEY_PROGRAM.
• Fee category context — FEE_CAT, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, FEE_TYPE, S_FEE_TYPE, S_FEE_TRIGGER_CAT, FEE_LIABILITY_STATUS, FEE_ASS_IND, S_CHG_METHOD_TYPE, RUL_SEQUENCE_NUMBER, CURRENCY_CD.
• Resolved calendar dates — START_DT, END_DT and RETRO_DT, each produced by CALP_GET_ALIAS_VAL from the corresponding alias and daily-instance sequence combination.
• Derived payment attribute — HECS_PAYMENT_OPTION, computed at query time using SYSDATE, meaning results are non-deterministic across executions.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The view is typically consumed to report the effective liability windows for a student's fee categories and to identify prior-calendar fee types that remain applicable.

Resolving liability dates for a student:

• SELECT person_id, course_cd, fee_cat, fee_type, start_dt, end_dt, retro_dt FROM igs_fi_f_cat_fee_lbl_sca_prr_v WHERE person_id = :person_id AND fee_liability_status = 'A';

Listing fee types per fee calendar instance:

• SELECT fee_cal_type, fee_ci_sequence_number, fee_type, s_fee_type, currency_cd FROM igs_fi_f_cat_fee_lbl_sca_prr_v WHERE fee_cat = :fee_cat GROUP BY fee_cal_type, fee_ci_sequence_number, fee_type, s_fee_type, currency_cd;

Reviewing HECS payment option distribution across a cohort:

• SELECT hecs_payment_option, COUNT(*) FROM igs_fi_f_cat_fee_lbl_sca_prr_v WHERE commencement_dt BETWEEN :from_dt AND :to_dt GROUP BY hecs_payment_option;

Because the view performs row-by-row function calls and resolves aliases dynamically, queries should be filtered by person, fee category, or calendar instance wherever possible. The obsolete status further suggests verifying that any replacement view introduced in later IGS releases is used instead of this object in new integrations.