Search Results igs_pr_stdnt_pr_fnd




Overview
Explore in AI Chat

Overview

The IGS_PR_STDNT_PR_FND table is a data entity within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically designated as obsolete. Its primary function is to manage the association between Student Progression Outcome records and specific fund codes that are to be excluded from consideration. A Student Progression Outcome (SPO) record tracks a student's formal academic standing within a course of study. This table provides a mechanism to define financial or funding-related exceptions tied to that academic standing, ensuring that certain fund codes are not applied to the student under the conditions defined by the progression outcome. Its role is to maintain referential integrity between progression data and institutional funding rules.

Key Information Stored

The table's structure is defined by a composite primary key that uniquely identifies each exclusion record. The key columns are PERSON_ID, which stores the unique identifier for the student; COURSE_CD, which holds the code for the specific course of study; SPO_SEQUENCE_NUMBER, which identifies the particular instance of the Student Progression Outcome for that student and course; and FUND_CODE, which is the specific financial fund code to be excluded. The table's sole purpose is to store these relationships, implying that the FUND_CODE column is the core piece of business data, while the other three columns serve as foreign key references to the parent progression outcome record.

Common Use Cases and Queries

The primary use case involves querying or maintaining the list of fund exclusions for a student's specific academic standing. This is critical for generating accurate financial aid reports, billing statements, or budget analyses that must respect these exclusions. A common reporting query would join this table to the parent progression outcome table to list all excluded funds for students on academic probation or other specific standings. For data maintenance, processes would insert or delete records here when funding rules change for a given progression outcome. A typical selective query pattern would be:

  • SELECT fund_code FROM igs_pr_stdnt_pr_fnd WHERE person_id = :p_id AND course_cd = :p_course AND spo_sequence_number = :p_seq;

It is crucial to note the ETRM metadata states this table is "Not implemented in this database," indicating it may be a legacy definition not present in all deployments, which would affect any development or reporting plans.

Related Objects

The table has a defined foreign key relationship to a single parent table, establishing its dependency. The related objects are:

  • IGS_PR_STDNT_PR_OU_ALL: This is the primary parent table for Student Progression Outcome records. The IGS_PR_STDNT_PR_FND table references it via a composite foreign key on the columns PERSON_ID, COURSE_CD, and SPO_SEQUENCE_NUMBER. Any record in IGS_PR_STDNT_PR_FND must have a corresponding master record in IGS_PR_STDNT_PR_OU_ALL. This relationship ensures that fund exclusions cannot exist without an associated progression outcome.
  • Table: IGS_PR_STDNT_PR_FND 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_STDNT_PR_FND,  object_name:IGS_PR_STDNT_PR_FND,  status:VALID,  product: IGS - Student System ,  description: The entity stores the exclude fund codes related to a particular Student Progression Outcome record. ,  implementation_dba_data: IGS.IGS_PR_STDNT_PR_FND , 

  • View: IGS_PR_STDNT_PR_FND_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PR_STDNT_PR_FND_V,  object_name:IGS_PR_STDNT_PR_FND_V,  status:VALID,  product: IGS - Student System ,  description: This entity stores the exclude fund codes related to a particular student progression outcome record. ,  implementation_dba_data: APPS.IGS_PR_STDNT_PR_FND_V , 

  • View: IGSFV_PR_STDNT_PRG_FUNDS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PR_STDNT_PRG_FUNDS,  object_name:IGSFV_PR_STDNT_PRG_FUNDS,  status:VALID,  product: IGS - Student System ,  description: Describes the financial aid fund the student will be excluded from when a student progression outcome is applied. ,  implementation_dba_data: APPS.IGSFV_PR_STDNT_PRG_FUNDS , 

  • View: IGSBV_PR_STDNT_PRG_FUNDS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_PR_STDNT_PRG_FUNDS,  object_name:IGSBV_PR_STDNT_PRG_FUNDS,  status:VALID,  product: IGS - Student System ,  description: Describes the financial aid fund the student will be excluded from when a student progression outcome is applied. ,  implementation_dba_data: APPS.IGSBV_PR_STDNT_PRG_FUNDS , 

  • Table: IGS_PR_STDNT_PR_OU_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_STDNT_PR_OU_ALL,  object_name:IGS_PR_STDNT_PR_OU_ALL,  status:VALID,  product: IGS - Student System ,  description: This table describes a progression outcome applied to a student, either manually or by the system, as a result of failing a progression rule. This detail is subject to approval, waiving etc. prior to application to the student. ,  implementation_dba_data: IGS.IGS_PR_STDNT_PR_OU_ALL ,