Search Results assignment_status_code




Overview
Explore in AI Chat

Overview

The IGS_FI_WAV_STD_PGMS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) or Campus Solutions modules under the IGS (iGrants) schema. Its primary function is to store the assignment of financial waiver programs to individual students. This table acts as the system of record for tracking which tuition or fee waiver programs are applicable to a student for a specific academic period, enabling automated financial adjustments and reporting within the student financials ecosystem.

Key Information Stored

The table's columns are designed to uniquely identify a waiver assignment and its context. The primary key, WAIVER_STUDENT_ID, is a system-generated sequence number. The core business keys that define a unique assignment are FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER (together identifying the academic calendar instance), WAIVER_NAME (the specific program), and PERSON_ID (the student). A critical column for operational logic is ASSIGNMENT_STATUS_CODE, which holds the active status of the assignment, typically 'Active' or 'Inactive', controlling whether the waiver is applied in financial calculations. The table also includes standard Oracle EBS audit columns (CREATED_BY, CREATION_DATE, etc.) and an OBJECT_VERSION_NUMBER for optimistic locking.

Common Use Cases and Queries

This table is central to processes involving student financial aid and billing. Common use cases include generating student bills with applied waivers, auditing waiver utilization, and managing the lifecycle of a waiver assignment (activating or inactivating it). A frequent reporting need is to list all active waivers for a student or a cohort within a term. Based on the provided metadata, a typical query pattern would be:

  • To find active waiver assignments for a specific student and fee calendar: SELECT WAIVER_NAME, ASSIGNMENT_STATUS_CODE FROM IGS.IGS_FI_WAV_STD_PGMS WHERE PERSON_ID = :stu_id AND FEE_CAL_TYPE = :cal_type AND FEE_CI_SEQUENCE_NUMBER = :seq_num AND ASSIGNMENT_STATUS_CODE = 'Active';
  • To audit all waiver assignments, including who created them: SELECT p.WAIVER_NAME, p.PERSON_ID, p.ASSIGNMENT_STATUS_CODE, p.CREATION_DATE, u.USER_NAME FROM IGS.IGS_FI_WAV_STD_PGMS p, FND_USER u WHERE p.CREATED_BY = u.USER_ID;

Related Objects

According to the provided dependency information, the IGS_FI_WAV_STD_PGMS table does not have foreign key dependencies on other objects listed in this excerpt. However, it is referenced by the APPS synonym IGS_FI_WAV_STD_PGMS, which is the standard access point for all application code and reports. In a full implementation, this table would be related to core person (IGS_PE_PERSON) and calendar (IGS_CA_INST) tables via the PERSON_ID, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER columns, and likely to a master waiver definition table via the WAIVER_NAME column, though these specific relationships are not detailed in the provided metadata.