Search Results igs_ps_ofr_all




Overview
Explore in AI Chat

Overview

The IGS_PS_OFR_ALL table is a core data entity within the Oracle E-Business Suite Student System (IGS), specifically in releases 12.1.1 and 12.2.2. It serves as the master table for defining and managing the offering of an academic program (course) within a specific academic calendar type. An offering represents a scheduled instance of a program, linking the program's definition to the temporal structure (calendar) in which it is available for enrollment. This table is fundamental to the academic structure, enabling the university to manage multiple intakes or offerings of the same program across different terms, semesters, or other calendar periods. Its 'ALL' suffix indicates it is a multi-organization table, capable of storing data partitioned by operating unit.

Key Information Stored

The table's structure centers on a composite primary key that uniquely identifies each program offering. The key columns are COURSE_CD (the code identifying the academic program), VERSION_NUMBER (the specific version of that program), and CAL_TYPE (the academic calendar type, such as 'SEMESTER' or 'QUARTER', in which the program is offered). Beyond the key, the table typically stores descriptive and control attributes for the offering. While the provided metadata does not list all columns, common attributes in such an entity include offering status (e.g., Active, Inactive), start and end dates for the offering within the calendar, location codes, attendance mode, and various system control columns like CREATION_DATE, LAST_UPDATE_DATE, and ORG_ID for multi-org support.

Common Use Cases and Queries

This table is central to numerous academic operations and reports. A primary use case is the setup and maintenance of program availability for student admissions and enrollment cycles. System administrators use this table to define which program versions are offered in which upcoming academic periods. Common reporting needs include listing all active offerings for a given term or generating a catalog of available programs. Sample SQL to retrieve active offerings for a specific calendar would leverage joins to the program (IGS_PS_VER_ALL) and calendar (IGS_CA_TYPE) tables:

  • SELECT ofr.course_cd, ofr.version_number, ver.title, ofr.cal_type FROM igs_ps_ofr_all ofr JOIN igs_ps_ver_all ver ON (ofr.course_cd = ver.course_cd AND ofr.version_number = ver.version_number) WHERE ofr.cal_type = '&CAL_TYPE' AND ofr.status = 'ACTIVE';

Another critical use case is enforcing data integrity in downstream processes like creating program patterns (IGS_PS_PAT_OF_STUDY) or unit sets (IGS_PS_OFR_UNIT_SET), which must reference a valid program offering.

Related Objects

The IGS_PS_OFR_ALL table sits at the center of a significant relational hierarchy within the Student System, as evidenced by its foreign key relationships. It is a child of IGS_PS_VER_ALL (Program Version) and IGS_CA_TYPE (Calendar Type). Crucially, it acts as a parent table to numerous other entities that define the specifics of an offering. Key child tables include:

These relationships underscore the table's role as the anchor point for all configuration and operational data pertaining to a specific instance of a program.

  • 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_PS_OFR_UNIT_SET 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_OFR_UNIT_SET,  object_name:IGS_PS_OFR_UNIT_SET,  status:VALID,  product: IGS - Student System ,  description: This entity describes the link between unit sets and programs. E.g. it would link the possible majors to a program ,  implementation_dba_data: IGS.IGS_PS_OFR_UNIT_SET , 

  • Table: IGS_PS_OFR_INST 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_OFR_INST,  object_name:IGS_PS_OFR_INST,  status:VALID,  product: IGS - Student System ,  description: This entity describes the instances of a calendar type in which a particular program is on offer. ,  implementation_dba_data: IGS.IGS_PS_OFR_INST , 

  • View: IGSFV_PROGRAM_OFFERINGS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PROGRAM_OFFERINGS,  object_name:IGSFV_PROGRAM_OFFERINGS,  status:VALID,  product: IGS - Student System ,  description: This is a full view, which describes an offerings of a university program within a calendar type. ,  implementation_dba_data: APPS.IGSFV_PROGRAM_OFFERINGS , 

  • Table: IGS_CA_TYPE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_CA_TYPE,  object_name:IGS_CA_TYPE,  status:VALID,  product: IGS - Student System ,  description: Describes available calendar types ,  implementation_dba_data: IGS.IGS_CA_TYPE , 

  • Table: IGS_AD_PECRS_OFOP_DT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_PECRS_OFOP_DT,  object_name:IGS_AD_PECRS_OFOP_DT,  status:VALID,  product: IGS - Student System ,  description: Describes program offering option specified by the admission period program offering option ,  implementation_dba_data: IGS.IGS_AD_PECRS_OFOP_DT , 

  • Table: IGS_PS_OFR_NOTE 12.1.1

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

  • Table: IGS_AD_PRD_PS_OF_OPT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_PRD_PS_OF_OPT,  object_name:IGS_AD_PRD_PS_OF_OPT,  status:VALID,  product: IGS - Student System ,  description: Describes the relationship among admission periods, admission process types, admission categories, and program offering options ,  implementation_dba_data: IGS.IGS_AD_PRD_PS_OF_OPT , 

  • Table: IGS_PS_PAT_OF_STUDY 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_PAT_OF_STUDY,  object_name:IGS_PS_PAT_OF_STUDY,  status:VALID,  product: IGS - Student System ,  description: This entity describes a pattern of study, which applies to a program offering. ,  implementation_dba_data: IGS.IGS_PS_PAT_OF_STUDY , 

  • View: IGSBV_PROGRAM_OFFERINGS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_PROGRAM_OFFERINGS,  object_name:IGSBV_PROGRAM_OFFERINGS,  status:VALID,  product: IGS - Student System ,  description: This is a base view, which describes an offerings of a university program within a calendar type. ,  implementation_dba_data: APPS.IGSBV_PROGRAM_OFFERINGS , 

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

  • View: IGS_PS_OFR 12.1.1

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

  • Table: IGS_PS_VER_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_VER_ALL,  object_name:IGS_PS_VER_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the versions of programs which are offered by the university, covering both award and non-award programs. ,  implementation_dba_data: IGS.IGS_PS_VER_ALL ,