Search Results igs_st_dft_load_appo




Overview
Explore in AI Chat

Overview

The IGS_ST_DFT_LOAD_APPO table is a core data entity within the Oracle E-Business Suite Student System (IGS) for versions 12.1.1 and 12.2.2. It serves a critical function in the management and reporting of student academic load for government compliance. Specifically, this table stores default apportionment rules, defining the percentage of a student's total academic load that is attributed to specific teaching periods within an academic calendar. This apportionment is essential for accurately determining the Equivalent Full-Time Student Load (EFTSL) or similar metrics required for government funding and statistical reporting. Where no explicit apportionment record exists for a given calendar and teaching period combination, the system assumes a default of 100%.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each apportionment rule. The key columns are CAL_TYPE and CI_SEQUENCE_NUMBER, which together identify the academic calendar instance (e.g., Semester 1, 2024), and TEACH_CAL_TYPE, which identifies the specific teaching period within that calendar. While the provided metadata does not list all columns explicitly, the description confirms the table stores a percentage value representing the portion of load attributed to the TEACH_CAL_TYPE. This percentage is the central data point for load calculation. The table's integrity is maintained through foreign key relationships to foundational calendar tables, IGS_CA_TYPE and IGS_CA_INST_ALL.

Common Use Cases and Queries

The primary use case is the automated derivation of a student's load for a teaching period during processes like enrollment reporting or government submission batch jobs. System logic queries this table using the relevant academic calendar keys to find the applicable apportionment percentage. A typical query pattern would retrieve the default load percentage for a specific calendar and teaching period, often joining to calendar description tables for reporting clarity. For example:

  • Identifying all apportionment rules for a given academic year to validate setup before a reporting cycle.
  • Troubleshooting load calculation discrepancies by verifying the apportionment percentage applied to a student's unit attempts via related tables like IGS_ST_UNT_LOAD_APPO.
  • Generating setup audit reports to find calendar instances where no explicit apportionment exists (implying the 100% default is in effect).

Related Objects

The IGS_ST_DFT_LOAD_APPO table is a central reference point within the Student System's load management framework. It is referenced by several other key entities, as documented by the foreign key relationships:

  • Referenced by IGS_AD_ADM_UT_STT_LD: Links admission unit attempt stated load records to the default apportionment rule (joined on CAL_TYPE, CI_SEQUENCE_NUMBER, TEACH_CAL_TYPE).
  • Referenced by IGS_ST_GVTSEMLOAD_OV: Links government semester load override records to the default rule (joined on CAL_TYPE, CI_SEQUENCE_NUMBER, TEACH_CAL_TYPE).
  • Referenced by IGS_ST_UNT_LOAD_APPO: Links unit-specific load apportionment records to the default rule (joined on DLA_CAL_TYPE, CI_SEQUENCE_NUMBER, TEACH_CAL_TYPE). This table allows for unit-level overrides of the default percentages stored in IGS_ST_DFT_LOAD_APPO.

Furthermore, this table itself references the calendar foundation tables IGS_CA_TYPE (for TEACH_CAL_TYPE) and IGS_CA_INST_ALL (for CAL_TYPE and CI_SEQUENCE_NUMBER).

  • Table: IGS_ST_DFT_LOAD_APPO 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_ST_DFT_LOAD_APPO,  object_name:IGS_ST_DFT_LOAD_APPO,  status:VALID,  product: IGS - Student System ,  description: This entity describes the portion of load which is attributed to a teaching period (defined as a percentage value). Used for determining load to be reported to the government . Where no apportionment exists, 100% is assumed ,  implementation_dba_data: IGS.IGS_ST_DFT_LOAD_APPO , 

  • Table: IGS_CA_TYPE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_CA_TYPE,  object_name:IGS_CA_TYPE,  status:VALID,  product: IGS - Student System ,  description: Describes available calendar types ,  implementation_dba_data: IGS.IGS_CA_TYPE , 

  • Table: IGS_AD_ADM_UT_STT_LD 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_ADM_UT_STT_LD,  object_name:IGS_AD_ADM_UT_STT_LD,  status:VALID,  product: IGS - Student System ,  description: Describes load calendar type relationship to administrative unit status to determine load incurred ,  implementation_dba_data: IGS.IGS_AD_ADM_UT_STT_LD , 

  • Table: IGS_ST_UNT_LOAD_APPO 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_ST_UNT_LOAD_APPO,  object_name:IGS_ST_UNT_LOAD_APPO,  status:VALID,  product: IGS - Student System ,  description: This entity describes the apportion of load for a particular unit in a teaching period. Example. 75% in semester 1 only and 25% in semester 2 only ,  implementation_dba_data: IGS.IGS_ST_UNT_LOAD_APPO , 

  • Table: IGS_ST_GVTSEMLOAD_OV 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_ST_GVTSEMLOAD_OV,  object_name:IGS_ST_GVTSEMLOAD_OV,  status:VALID,  product: IGS - Student System ,  description: This table describes the link between a government report semester and load from specific teaching periods. This link is made to the relationship between a teaching period and a load calendar instance to ensure consistency across all load ,  implementation_dba_data: IGS.IGS_ST_GVTSEMLOAD_OV , 

  • View: IGS_CA_LOAD_TO_TEACH_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_CA_LOAD_TO_TEACH_V,  object_name:IGS_CA_LOAD_TO_TEACH_V,  status:VALID,  product: IGS - Student System ,  description: Describes the teaching calendars for the give load calendar ,  implementation_dba_data: APPS.IGS_CA_LOAD_TO_TEACH_V , 

  • View: IGS_CA_TEACH_TO_LOAD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_CA_TEACH_TO_LOAD_V,  object_name:IGS_CA_TEACH_TO_LOAD_V,  status:VALID,  product: IGS - Student System ,  description: Describes the teaching calendars for the give load calendar ,  implementation_dba_data: APPS.IGS_CA_TEACH_TO_LOAD_V , 

  • Table: IGS_CA_INST_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_CA_INST_ALL,  object_name:IGS_CA_INST_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes an instance of a calendar type ,  implementation_dba_data: IGS.IGS_CA_INST_ALL ,