Search Results igs_ps_grp_all




Overview
Explore in AI Chat

Overview

The IGS_PS_GRP_ALL table is a core data object within the Oracle E-Business Suite Student System (IGS), specifically designed for managing academic program structures. Its primary function is to define and store logical groupings of academic programs (courses). These groupings serve as versatile administrative constructs used for various operational purposes across the student lifecycle, such as applying fees, managing enrollment controls, defining progression rules, and implementing exclusions. The table supports multi-organization architecture, as indicated by the "_ALL" suffix, meaning it stores data for multiple operating units with appropriate security filtering via the ORG_ID column. It is critical to note that the provided metadata explicitly states the Student System module is marked as "Obsolete" and the table is "Not implemented in this database," indicating its use is likely confined to legacy installations or specific upgrade paths.

Key Information Stored

The table's structure centers on identifying and classifying each program group. The primary key is the COURSE_GROUP_CD, a unique code that identifies the specific grouping. A critical attribute is the COURSE_GROUP_TYPE, which categorizes the group's purpose by referencing the IGS_PS_GRP_TYPE lookup table. This type dictates the group's permissible uses within the system. While the full column list is not detailed in the excerpt, standard practice suggests the table would also include descriptive fields (such as a name or description), start and end dates for validity, the ORG_ID for multi-org support, and standard Oracle EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE). The essence of the data is the relationship between this group header and its member programs, which is maintained in the separate child table IGS_PS_GRP_MBR.

Common Use Cases and Queries

This table is central to administrative rules and reporting based on program collections. A primary use case is fee management, where a specific fee trigger (IGS_PS_GRP_FEE_TRG) is associated with a course group rather than individual programs. Another is defining enrollment embargoes or prerequisites, where rules (IGS_PR_RU_OU_ALL, IGS_PR_STDNT_PR_OU_ALL) reference a group to control student eligibility. Common queries involve listing all active groups of a certain type or identifying the programs within a specific group for reporting. For example, to find all programs in a 'SCHOLARSHIP' group, one would join IGS_PS_GRP_ALL to IGS_PS_GRP_MBR and then to the main programs table.

  • Sample Query: SELECT g.COURSE_GROUP_CD, m.COURSE_CD FROM IGS_PS_GRP_ALL g, IGS_PS_GRP_MBR m WHERE g.COURSE_GROUP_CD = m.COURSE_GROUP_CD AND g.COURSE_GROUP_TYPE = 'FEE' AND SYSDATE BETWEEN g.START_DATE AND NVL(g.END_DATE, SYSDATE);

Related Objects

The IGS_PS_GRP_ALL table sits at the center of a relational hierarchy. Its primary relationships, as defined by foreign keys, are as follows:

  • IGS_PS_GRP_TYPE: Lookup table for validating the COURSE_GROUP_TYPE.
  • IGS_PS_GRP_MBR: Child table that stores the individual program codes that are members of each group.
  • IGS_PS_GRP_FEE_TRG: Links course groups to specific financial fee triggers.
  • IGS_PE_CRS_GRP_EXCL: Used to define exclusions where persons (students) are prevented from enrolling in programs within a specific group.
  • IGS_PR_RU_OU_ALL & IGS_PR_STDNT_PR_OU_ALL: Reference the group to enforce progression rules and enrollment embargoes (ENCMB_COURSE_GROUP_CD).
  • Table: IGS_PS_GRP_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_GRP_ALL,  object_name:IGS_PS_GRP_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes a grouping of programs, which are used for a variety of purposes within the system. ,  implementation_dba_data: IGS.IGS_PS_GRP_ALL , 

  • Table: IGS_PE_CRS_GRP_EXCL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PE_CRS_GRP_EXCL,  object_name:IGS_PE_CRS_GRP_EXCL,  status:VALID,  product: IGS - Student System ,  description: This entity describes a course group from which a person has been excluded. ,  implementation_dba_data: IGS.IGS_PE_CRS_GRP_EXCL , 

  • View: IGSBV_HIGH_EDU_PRG_GRP_MEMBERS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_HIGH_EDU_PRG_GRP_MEMBERS,  object_name:IGSBV_HIGH_EDU_PRG_GRP_MEMBERS,  status:VALID,  product: IGS - Student System ,  description: This is a base view, which describes the programs that are members in a program grouping. ,  implementation_dba_data: APPS.IGSBV_HIGH_EDU_PRG_GRP_MEMBERS , 

  • Table: IGS_PS_GRP_FEE_TRG 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_GRP_FEE_TRG,  object_name:IGS_PS_GRP_FEE_TRG,  status:VALID,  product: IGS - Student System ,  description: This entity describes the program group based fee triggers. It is used during fee assessment processing to indicate a program group based fee applies for a fee type. ,  implementation_dba_data: IGS.IGS_PS_GRP_FEE_TRG , 

  • Table: IGS_PS_GRP_MBR 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_GRP_MBR,  object_name:IGS_PS_GRP_MBR,  status:VALID,  product: IGS - Student System ,  description: This entity describes the programs, which are members in a program grouping. ,  implementation_dba_data: IGS.IGS_PS_GRP_MBR , 

  • Table: IGS_PS_GRP_TYPE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_GRP_TYPE,  object_name:IGS_PS_GRP_TYPE,  status:VALID,  product: IGS - Student System ,  description: This entity describes the available types of program groups that can be defined on the system. E.g. Equivalents, available double programs, common entrance requirements. ,  implementation_dba_data: IGS.IGS_PS_GRP_TYPE , 

  • View: IGS_PS_GRP 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PS_GRP,  object_name:IGS_PS_GRP,  status:VALID,  product: IGS - Student System ,  implementation_dba_data: APPS.IGS_PS_GRP , 

  • View: IGSBV_HIGH_EDU_PRG_GROUPS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_HIGH_EDU_PRG_GROUPS,  object_name:IGSBV_HIGH_EDU_PRG_GROUPS,  status:VALID,  product: IGS - Student System ,  description: This is a base view, which describes a grouping of programs,which are used for a variety of purposes within the system. ,  implementation_dba_data: APPS.IGSBV_HIGH_EDU_PRG_GROUPS , 

  • View: IGSFV_HIGH_EDU_PRG_GRP_MEMBERS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_HIGH_EDU_PRG_GRP_MEMBERS,  object_name:IGSFV_HIGH_EDU_PRG_GRP_MEMBERS,  status:VALID,  product: IGS - Student System ,  description: This is a full view, which describes the programs that are members in a program grouping. ,  implementation_dba_data: APPS.IGSFV_HIGH_EDU_PRG_GRP_MEMBERS , 

  • View: IGSFV_HIGH_EDU_PRG_GROUPS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_HIGH_EDU_PRG_GROUPS,  object_name:IGSFV_HIGH_EDU_PRG_GROUPS,  status:VALID,  product: IGS - Student System ,  description: This is a full view, which describes a grouping of programs, which are used for a variety of purposes within the system. ,  implementation_dba_data: APPS.IGSFV_HIGH_EDU_PRG_GROUPS , 

  • 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 , 

  • Table: IGS_PR_RU_OU_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_RU_OU_ALL,  object_name:IGS_PR_RU_OU_ALL,  status:VALID,  product: IGS - Student System ,  description: This table describes the outcomes applicable to failure of the related progression rule in the way described by the attributes of the outcome. A given rule may have multiple outcomes for any given failure type if required. ,  implementation_dba_data: IGS.IGS_PR_RU_OU_ALL , 

  • View: IGSFV_PR_STDNT_PR_OU 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PR_STDNT_PR_OU,  object_name:IGSFV_PR_STDNT_PR_OU,  status:VALID,  product: IGS - Student System ,  description: Describes Student Progression Rule Check ,  implementation_dba_data: APPS.IGSFV_PR_STDNT_PR_OU ,