Search Results igs_ps_ofr_opt_all




Overview
Explore in AI Chat

Overview

The IGS_PS_OFR_OPT_ALL table is a core data entity within the Oracle E-Business Suite Student System (IGS) in releases 12.1.1 and 12.2.2. It serves as a junction table that defines the specific configuration options available for a given program offering. A program offering (IGS_PS_OFR_ALL) defines when and where a specific version of a program (course) is available. This table further refines that offering by detailing the permissible combinations of attendance mode (e.g., full-time, part-time), attendance type (e.g., on-campus, distance), and location. Its primary role is to establish the valid enrollment paths for students, forming a critical link between the structural definition of a program and the operational details of student admissions and enrollment.

Key Information Stored

The table stores a composite key that uniquely identifies each offering option, linking it to its parent offering and defining its specific characteristics. The primary key columns are COURSE_CD, VERSION_NUMBER, CAL_TYPE, LOCATION_CD, ATTENDANCE_MODE, and ATTENDANCE_TYPE. A surrogate key, COO_ID, provides a unique identifier for the record and is used as a foreign key by related child entities. Other significant columns include ENR_OFFICER_PERSON_ID, which links to the HZ_PARTIES table to designate a responsible enrollment officer for that specific option. The table's structure ensures that each distinct combination of location, attendance mode, and type for a program offering is a discrete entity for administrative and transactional purposes.

Common Use Cases and Queries

This table is central to processes involving program availability, application handling, and enrollment setup. A common use case is generating a list of all available enrollment options for a prospective student inquiring about a specific program. Administrators use this data to manage application cycles and define which options are open for admission. Typical reporting queries involve joining this table with the program offering (IGS_PS_OFR_ALL) and reference code tables for attendance modes and types to produce human-readable catalogs. For technical operations, a frequent query pattern is to retrieve the COO_ID for a specific offering combination to serve as a key for downstream processes in admissions or unit set management.

  • Retrieve all offering options for a specific program: SELECT * FROM igs_ps_ofr_opt_all WHERE course_cd = '<CODE>' AND version_number = <VERSION>;
  • Find the COO_ID for a precise offering configuration: SELECT coo_id FROM igs_ps_ofr_opt_all WHERE course_cd='...' AND version_number=... AND cal_type='...' AND location_cd='...' AND attendance_mode='...' AND attendance_type='...';

Related Objects

The IGS_PS_OFR_OPT_ALL table sits at the center of a detailed relationship network, primarily as the parent table for entities storing additional option-specific data. As documented, its primary foreign key relationship is with IGS_PS_OFR_ALL, defining the base offering. It references lookup tables for ATTENDANCE_MODE (IGS_EN_ATD_MODE_ALL) and ATTENDANCE_TYPE (IGS_EN_ATD_TYPE_ALL), and location details (IGS_AD_LOCATION_ALL). Crucially, it is the parent table for several key child entities:

These relationships underscore the table's function as a master definition for all configurable aspects of a program offering.

  • Table: IGS_PS_OFR_OPT_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_OFR_OPT_ALL,  object_name:IGS_PS_OFR_OPT_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the available options for each program offering. ,  implementation_dba_data: IGS.IGS_PS_OFR_OPT_ALL , 

  • Table: IGS_PS_OFR_OPT_NOTE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_OFR_OPT_NOTE,  object_name:IGS_PS_OFR_OPT_NOTE,  status:VALID,  product: IGS - Student System ,  description: This table describes the notes associated with a program offering option. ,  implementation_dba_data: IGS.IGS_PS_OFR_OPT_NOTE , 

  • Table: IGS_PS_OF_OPT_UNT_ST 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_OF_OPT_UNT_ST,  object_name:IGS_PS_OF_OPT_UNT_ST,  status:VALID,  product: IGS - Student System ,  description: This entity describes the program unit sets, which are available to the particular program offering option. If there are no values in this entity for a program, it will assume that all program unit sets are available. ,  implementation_dba_data: IGS.IGS_PS_OF_OPT_UNT_ST , 

  • Table: IGS_PS_ENT_PT_REF_CD 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_ENT_PT_REF_CD,  object_name:IGS_PS_ENT_PT_REF_CD,  status:VALID,  product: IGS - Student System ,  description: This entity describes a reference code(s) that relate to the program offering entry point e.g. TAC codes, CRICOS codes. ,  implementation_dba_data: IGS.IGS_PS_ENT_PT_REF_CD , 

  • Table: IGS_PS_OF_OPT_AD_CAT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_OF_OPT_AD_CAT,  object_name:IGS_PS_OF_OPT_AD_CAT,  status:VALID,  product: IGS - Student System ,  description: This entity describes the set of admission categories, which may enroll in the particular program offering option. ,  implementation_dba_data: IGS.IGS_PS_OF_OPT_AD_CAT , 

  • Table: IGS_PS_OFR_PAT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_OFR_PAT,  object_name:IGS_PS_OFR_PAT,  status:VALID,  product: IGS - Student System ,  description: This entity describes the offering pattern of a program offering option. This is related to a calendar instance, nominating when each option is available. ,  implementation_dba_data: IGS.IGS_PS_OFR_PAT , 

  • Table: IGS_EN_STDNT_PS_ATT_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_STDNT_PS_ATT_ALL,  object_name:IGS_EN_STDNT_PS_ATT_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes a student's attempt at studying a particular course offered by the university. ,  implementation_dba_data: IGS.IGS_EN_STDNT_PS_ATT_ALL , 

  • Table: IGS_AS_SC_ATTEMPT_H_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AS_SC_ATTEMPT_H_ALL,  object_name:IGS_AS_SC_ATTEMPT_H_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes history of changes to student program attempt ,  implementation_dba_data: IGS.IGS_AS_SC_ATTEMPT_H_ALL , 

  • Table: IGS_HE_POOUS_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_HE_POOUS_ALL,  object_name:IGS_HE_POOUS_ALL,  status:VALID,  product: IGS - Student System ,  description: Program Offering Option Unit Set HESA Details ,  implementation_dba_data: IGS.IGS_HE_POOUS_ALL , 

  • Table: IGS_EN_SPA_TERMS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_SPA_TERMS,  object_name:IGS_EN_SPA_TERMS,  status:VALID,  product: IGS - Student System ,  description: Program attempt attributes based on Term Calendar. ,  implementation_dba_data: IGS.IGS_EN_SPA_TERMS , 

  • Table: IGS_HE_POOUS_CC_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_HE_POOUS_CC_ALL,  object_name:IGS_HE_POOUS_CC_ALL,  status:VALID,  product: IGS - Student System ,  description: Stores HESA Cost Center information for Program Offering Option Unit Sets ,  implementation_dba_data: IGS.IGS_HE_POOUS_CC_ALL , 

  • Table: IGS_HE_POOUS_OU_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_HE_POOUS_OU_ALL,  object_name:IGS_HE_POOUS_OU_ALL,  status:VALID,  product: IGS - Student System ,  description: stores HESA Org. Unit information for Program Offering Option Unit Sets ,  implementation_dba_data: IGS.IGS_HE_POOUS_OU_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_OFR_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_OFR_ALL,  object_name:IGS_PS_OFR_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes an offering of a university program within a calendar type. ,  implementation_dba_data: IGS.IGS_PS_OFR_ALL , 

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

  • View: IGSBV_PROG_CAL_OFFERINGS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_PROG_CAL_OFFERINGS,  object_name:IGSBV_PROG_CAL_OFFERINGS,  status:VALID,  product: IGS - Student System ,  description: This entity describes the offerings for a program calendar containing details of Program Code, calendar instance details and minimum / guaranteed assessment score. ,  implementation_dba_data: APPS.IGSBV_PROG_CAL_OFFERINGS , 

  • View: IGSFV_PROG_CAL_OFFERINGS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PROG_CAL_OFFERINGS,  object_name:IGSFV_PROG_CAL_OFFERINGS,  status:VALID,  product: IGS - Student System ,  description: This entity describes the offerings for a program calendar containing details of Program Code, calendar instance details and minimum / guaranteed assessment score. ,  implementation_dba_data: APPS.IGSFV_PROG_CAL_OFFERINGS , 

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

  • View: IGSBV_PROG_OFFERING_PATTERNS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_PROG_OFFERING_PATTERNS,  object_name:IGSBV_PROG_OFFERING_PATTERNS,  status:VALID,  product: IGS - Student System ,  description: This is a base view, which describes the Offering Pattern of a program offering option. This is related to a calendar instance, nominating when each option is available. ,  implementation_dba_data: APPS.IGSBV_PROG_OFFERING_PATTERNS , 

  • View: IGS_PS_OFR_OPT 12.1.1

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

  • View: IGSFV_PROG_OFFERING_PATTERNS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PROG_OFFERING_PATTERNS,  object_name:IGSFV_PROG_OFFERING_PATTERNS,  status:VALID,  product: IGS - Student System ,  description: This is a full view, which describes the Offering Pattern of a program offering option. This is related to a calendar instance, nominating when each option is available. ,  implementation_dba_data: APPS.IGSFV_PROG_OFFERING_PATTERNS ,