Search Results igs_ps_anl_load_u_ln_u1

Overview

The IGS_PS_ANL_LOAD_U_LN table is a core data entity within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Student Management (i.e., Campus Solutions) module under the IGS (iGATE Student) schema. This table defines the relationship between an academic unit (subject) and an annual load figure assigned to a specific program year. Its primary role is to support the calculation of Equivalent Full-Time Student Units (EFTSU) for a unit by linking it to the appropriate annual workload for a given year of a program. For instance, it can specify that a particular unit version contributes to the first-year load calculation of its associated program.

Key Information Stored

The table stores the linkage definition, audit information via standard Who columns, and is constrained by a unique composite primary key. The most critical columns are:

• COURSE_CD, CRV_VERSION_NUMBER: Identify the program (course) and its specific version.
• YR_NUM: The program year (e.g., 1, 2, 3) to which the annual load figure applies.
• EFFECTIVE_START_DT: The date from which this unit-to-annual-load linkage becomes active.
• UNIT_CD, UV_VERSION_NUMBER: The unique code and version number of the unit being linked. The user's search for "uv_version_number" highlights this column's role in ensuring the link is to a specific, versioned unit definition.
• CREATED_BY, LAST_UPDATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN: Standard EBS Who columns for auditing.

Common Use Cases and Queries

This table is central to workload and EFTSU reporting, academic planning, and fee calculations. A common operational query retrieves all unit links for a specific program version to validate or audit annual load mappings. For reporting, it is frequently joined to unit and program master tables.

Sample Query 1: Fetch all unit-to-annual-load links for a given program and version. SELECT UNIT_CD, UV_VERSION_NUMBER, YR_NUM, EFFECTIVE_START_DT FROM IGS.IGS_PS_ANL_LOAD_U_LN WHERE COURSE_CD = 'BSC_COMPSCI' AND CRV_VERSION_NUMBER = 1 ORDER BY YR_NUM, UNIT_CD;

Sample Query 2: Identify the specific version of a unit linked to a program's annual load (directly addressing the "uv_version_number" search context). SELECT * FROM IGS.IGS_PS_ANL_LOAD_U_LN WHERE UNIT_CD = 'CS101' AND UV_VERSION_NUMBER = 2022;

Related Objects

Based on the provided dependency information, the primary relationship is that the IGS_PS_ANL_LOAD_U_LN table is referenced by the APPS synonym IGS_PS_ANL_LOAD_. This indicates the table is accessed via this public synonym within the EBS application layer. The unique index (IGS_PS_ANL_LOAD_U_LN_U1) defines the primary key constraint on the combination of COURSE_CD, CRV_VERSION_NUMBER, YR_NUM, EFFECTIVE_START_DT, UNIT_CD, and UV_VERSION_NUMBER. The non-unique index (IGS_PS_ANL_LOAD_U_LN_N1) on UNIT_CD and UV_VERSION_NUMBER facilitates efficient queries looking for links from a specific unit version, as per the user's search interest.