Search Results igf_aw_coa_rate_det

Overview

The IGS_PR_CLASS_STD table is a core setup table within the Oracle E-Business Suite Student System (IGS) module. It functions as the master repository for institution-defined Class Standing values. Class Standing is a critical academic concept used to categorize students based on their progression, typically defined by earned credit hours (e.g., Freshman, Sophomore, Junior, Senior). This table stores the valid list of these standings, which are then referenced throughout the student lifecycle to drive processes in admissions, enrollment, progression, assessment, and financial aid. Its role is foundational, providing a standardized set of codes that ensure consistency across multiple functional areas of the student information system.

Key Information Stored

The table's primary purpose is to maintain a unique list of class standing codes. While the full column list is not detailed in the provided metadata, the documented primary and unique keys reveal the core data structure. The table is designed with a surrogate primary key, IGS_PR_CLASS_STD_ID, which is a system-generated unique identifier. More critically, it enforces a unique constraint on the CLASS_STANDING column itself, which stores the actual institutional code or short description for the standing (e.g., 'FR', 'SO'). Other typical columns in such setup tables would include a description field, an effective dating mechanism (start and end dates), and control attributes like closed indicator or system default flags, though these are inferred based on common EBS patterns.

Common Use Cases and Queries

This table is primarily queried for validation, reporting, and as a lookup source. Common operational scenarios include validating a class standing value entered on a student's program attempt, determining fee rates or financial aid award rates specific to a student's standing, and running population reports grouped by class standing. A fundamental query retrieves the active list of standings for a user interface drop-down:

SELECT class_standing, description FROM igs_pr_class_std WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE) ORDER BY class_standing;

Another frequent use case is joining to student enrollment data to analyze distributions. For example, a report to count students by their current class standing would involve joining IGS_EN_STDNT_PS_ATT_ALL to this table via IGS_PR_CLASS_STD_ID.

Related Objects

As indicated by the extensive foreign key relationships, IGS_PR_CLASS_STD is a central reference point. Key dependent tables include:

IGS_EN_STDNT_PS_ATT_ALL: Stores the student's program attempt, linking to their current class standing.
IGS_EN_SPA_TERMS: Holds term-level details for a student's program attempt, also referencing class standing.
IGF_AP_FA_ANT_DATA & IGF_AW_COA_RATE_DET: Financial Aid tables using class standing for need analysis and award rate calculations.
IGS_FI_FEE_AS_RATE: Fee assessment rates that can be conditioned on class standing.
IGS_AS_GPC_CLS_STNDG & IGS_AS_SC_ATTEMPT_H_ALL: Assessment-related tables for grade processing controls and historical attempt data.
IGS_PR_CSS_CLASS_STD & IGS_PR_RU_APPL_ALL: Progression rule engine tables for defining and applying class standing-specific rules.

This network of relationships underscores the table's integral role in connecting academic standing to financial, enrollment, and progression business rules.

Table: IGS_PR_CLASS_STD 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_PR_CLASS_STD, object_name:IGS_PR_CLASS_STD, status:VALID, product: IGS - Student System , description: Maintains the institution defined Class Standing set-up values , implementation_dba_data: IGS.IGS_PR_CLASS_STD ,
Table: IGS_EN_ATD_TYPE_ALL 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_EN_ATD_TYPE_ALL, object_name:IGS_EN_ATD_TYPE_ALL, status:VALID, product: IGS - Student System , description: Describes available university program attendance types , implementation_dba_data: IGS.IGS_EN_ATD_TYPE_ALL ,
Table: IGS_EN_ATD_MODE_ALL 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_EN_ATD_MODE_ALL, object_name:IGS_EN_ATD_MODE_ALL, status:VALID, product: IGS - Student System , description: Describes available university program attendance modes , implementation_dba_data: IGS.IGS_EN_ATD_MODE_ALL ,
Table: IGS_PS_COURSE 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_PS_COURSE, object_name:IGS_PS_COURSE, status:VALID, product: IGS - Student System , description: This entity describes the programs which are offered by the university, covering both award and non-award programs. , implementation_dba_data: IGS.IGS_PS_COURSE ,
Table: IGS_PS_TYPE_ALL 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_PS_TYPE_ALL, object_name:IGS_PS_TYPE_ALL, status:VALID, product: IGS - Student System , description: This entity describes the university set of program types. This set is not limited to the DEET set and values, which are reported to DEET, will be mapped onto DEET equivalent values. , implementation_dba_data: IGS.IGS_PS_TYPE_ALL ,
Table: IGS_AD_LOCATION_ALL 12.1.1
owner:IGS, object_type:TABLE, fnd_design_data:IGS.IGS_AD_LOCATION_ALL, object_name:IGS_AD_LOCATION_ALL, status:VALID, product: IGS - Student System , description: Describes available geographic locations at which programs and units may be offered or taught , implementation_dba_data: IGS.IGS_AD_LOCATION_ALL ,
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 ,