Search Results enrp_clc_sua_load
Overview
IGS_EN_PRC_LOAD is a PL/SQL package in the APPS schema that belongs to the Oracle Student System (formerly Oracle iLearning/Student Administration) product family, specifically the Enrolment (IGS_EN) module. Its primary business function is the calculation and maintenance of student load, attendance, and Equivalent Full-Time Student Unit (EFTSU) figures across academic and teaching calendar instances. The package encapsulates the rules that translate unit attempt enrolment data into the credit-point, load, and EFTSU values used for fee assessment, reporting, and statutory student load returns.
The package header carries a version stamp of 120.3 dated 2005/12/04, confirming it is a long-standing component of the EBS codebase that is present in both 12.1.1 and 12.2.2. The change history embedded in the header records incremental additions such as the Extra Student Unit (SUA) load parameters, the no_assessment_ind flag, the uoo_id parameter on ENRP_CLC_SUA_LOAD, and the get_term_credits function, indicating the package has been extended to support term records build, billable credit points, and assessment-exempt calculations.
The package is classified as API classification OTHER, meaning it is not a formally declarative open interface but is nevertheless referenced by 35 other packages, making it a central internal utility for load processing.
Key Procedures and Functions
The documented procedures and functions divide into several logical groups.
- EFTSU calculation: ENRP_CLC_SUA_EFTSU calculates the EFTSU total for a unit attempt across all load calendar instances. ENRP_CLC_EFTSU_TOTAL totals EFTSU for a Student Course Attempt within a load calendar instance. ENRP_CLC_SUA_WEFTSU produces a weighted EFTSU value, and ENRP_CLC_EFTSU_TRUNC applies the truncation behaviour governed by the p_truncate_ind parameter (the term the user searched for, "enrp_clc_eftsu_trunc", refers to this function).
- Load aggregation: ENRP_GET_ANN_LOAD returns annual load; ENRP_CLC_LOAD_TOTAL computes total load; ENRP_GET_LOAD_INCUR handles incurred load; ENRP_GET_LOAD_ATT and ENRP_GET_LOAD_APPLY deal with attendance-related and applied load figures.
- Student Unit Attempt load: ENRP_CLC_SUA_LOAD loads and recalculates SUA-level load, extended over its lifetime with parameters for uoo_id, billable credit points, and no_assessment_ind.
- Program and progression: ENRP_CLC_KEY_PROG derives key program indicators (extended for Term Records Build); ENRP_GET_PRG_ATT_TYPE returns program attendance type; ENRP_GET_PRG_LOAD_CP and ENRP_GET_PRG_EFTSU_CP return program-level credit point and EFTSU values.
- Instance and attendance: ENRP_GET_INST_LATT, ENRP_GET_INST_LATT_FTE, ENRP_GET_INST_ATTENDANCE, ENRP_GET_INST_CP, ENRP_CLC_CP_UPTO_TP_START_DT, and GET_LATEST_LOAD_FOR_ACAD_CAL provide instance-level attendance, credit point, and latest-load lookups.
Tables Accessed
The package reads and maintains data across calendar, enrolment, and load tables. Calendar definitions and relationships are sourced from IGS_CA_TYPE, IGS_CA_INST, IGS_CA_DA_INST, IGS_CA_INST_REL, and IGS_CA_STAT, with general calendar control from IGS_GE_S_GEN_CAL_CON. Enrolment and attendance data come from IGS_EN_STDNT_PS_ATT_ALL, IGS_EN_ATD_TYPE_ALL, IGS_EN_SPA_TERMS, IGS_EN_CAL_CONF, and IGS_EN_INST_WL_STPS. Analytical load values are held in IGS_PS_ANL_LOAD and IGS_PS_ANL_LOAD_U_LN, while IGS_PS_COURSE supplies course definitions. Historical load records are stored in IGS_AD_ADM_UT_STT_LD, and student identity resolution uses HZ_PARTIES.
Usage Notes
IGS_EN_PRC_LOAD is invoked primarily from Oracle Student System forms and concurrent programs that build or recalculate student load, such as the EFTSU and load calculation processes, term records build, and billable credit point processing. Because 35 other packages reference it, it also appears as a dependency in custom extensions and integration code that need EFTSU or load totals. Developers should note the PRAGMA RESTRICT_REFERENCES declarations on the EFTSU functions, which constrain their use of package state and make them safe for SQL invocation. No declared parameter lists should be assumed from this summary; callers must consult the package specification for exact signatures, as several have changed across releases.