Search Results igs_ps_ofr_pat




Overview
Explore in AI Chat

Overview

The IGS_PS_OFR_PAT table is a core entity within the Oracle E-Business Suite Student System (IGS), now marked as obsolete. It serves as a junction table that defines the offering pattern for a specific program (course) offering option. Its primary role is to link a program offering option with a calendar instance, thereby specifying the precise temporal availability—such as the academic term or session—for that option. This table is essential for modeling when and where a particular program pathway, with its defined attendance mode and type, is offered within the institutional academic calendar.

Key Information Stored

The table stores composite identifiers that define a unique offering pattern. The primary key (IGS_PS_OFR_PAT_PK) is a combination of columns that identify the specific program offering instance and its attributes: COURSE_CD, VERSION_NUMBER, CAL_TYPE, CI_SEQUENCE_NUMBER, LOCATION_CD, ATTENDANCE_MODE, and ATTENDANCE_TYPE. A critical surrogate key is the COP_ID column, which serves as a unique identifier for each row and is the basis for the alternate unique key (IGS_PS_OFR_PAT_UK1). Other significant columns include COO_ID, which links to the parent offering option, and columns for associating a grading schema (GRADING_SCHEMA_CD, GS_VERSION_NUMBER) and an administrative contact person (ADM_CONTACT_PERSON_ID).

Common Use Cases and Queries

A primary use case is querying all available offering patterns for a specific program to support academic advising or enrollment planning. For instance, an administrator might need to list all the terms and locations where a Master's program is offered full-time. Given the user's search for "cop_id," a common query pattern involves retrieving a specific offering pattern record using this unique identifier for integration or data validation purposes.

  • Retrieve a specific pattern by COP_ID: SELECT * FROM IGS_PS_OFR_PAT WHERE cop_id = :p_cop_id;
  • List patterns for a program offering instance: SELECT cop_id, location_cd, attendance_mode FROM IGS_PS_OFR_PAT WHERE course_cd = :p_crs_cd AND version_number = :p_ver AND cal_type = :p_cal_type AND ci_sequence_number = :p_ci_seq;

Related Objects

The table maintains several documented foreign key relationships, integrating it deeply within the Student System's data model. Key related objects include:

  • IGS_PS_OFR_INST: Links to the parent program offering instance via COURSE_CD, VERSION_NUMBER, CAL_TYPE, and CI_SEQUENCE_NUMBER.
  • IGS_PS_OFR_OPT_ALL: Has two relationships. One links via the business key columns (COURSE_CD, VERSION_NUMBER, etc.), and another links directly via the COO_ID column.
  • IGS_AS_GRD_SCHEMA: Associates a grading schema via GRADING_SCHEMA_CD and GS_VERSION_NUMBER.
  • HZ_PARTIES: Identifies an administrative contact via ADM_CONTACT_PERSON_ID.
  • IGS_PS_OFR_PAT_NOTE: Child table storing notes; linked both by the composite primary key columns and by the COP_ID column.
  • 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_PS_OFR_PAT_NOTE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_OFR_PAT_NOTE,  object_name:IGS_PS_OFR_PAT_NOTE,  status:VALID,  product: IGS - Student System ,  description: This table describes the notes associated with a Program Offering Pattern. ,  implementation_dba_data: IGS.IGS_PS_OFR_PAT_NOTE , 

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

  • Table: IGS_AS_GRD_SCHEMA 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AS_GRD_SCHEMA,  object_name:IGS_AS_GRD_SCHEMA,  status:VALID,  product: IGS - Student System ,  description: Describes set of available marks, grades, and results used in the assessment of student unit attempts ,  implementation_dba_data: IGS.IGS_AS_GRD_SCHEMA , 

  • View: IGS_PS_OFR_PAT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PS_OFR_PAT_V,  object_name:IGS_PS_OFR_PAT_V,  status:VALID,  product: IGS - Student System ,  description: View of the program offering pattern table. Required for program offering pattern LOV in ADMF1200 ,  implementation_dba_data: APPS.IGS_PS_OFR_PAT_V , 

  • View: IGS_PS_OFR_PATTERN_V 12.1.1

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

  • View: IGS_PS_OFR_PAT_APCOO_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PS_OFR_PAT_APCOO_V,  object_name:IGS_PS_OFR_PAT_APCOO_V,  status:VALID,  product: IGS - Student System ,  description: This view is used to display for the admission period program offering option - Program Offering LOV in form ADMF2M61. ,  implementation_dba_data: APPS.IGS_PS_OFR_PAT_APCOO_V , 

  • View: IGS_PS_OFR_PAT_ADM_PERD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PS_OFR_PAT_ADM_PERD_V,  object_name:IGS_PS_OFR_PAT_ADM_PERD_V,  status:VALID,  product: IGS - Student System ,  description: This view is used to display for the admission period Program Offering Pattern in form ADMF2M61. ,  implementation_dba_data: APPS.IGS_PS_OFR_PAT_ADM_PERD_V , 

  • View: IGS_PS_OFR_PAT_CRSVRSN_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PS_OFR_PAT_CRSVRSN_V,  object_name:IGS_PS_OFR_PAT_CRSVRSN_V,  status:VALID,  product: IGS - Student System ,  description: This view describes the offering pattern of a program offering option. It also describes the relationship between admission periods, admission process types and admission categories. ,  implementation_dba_data: APPS.IGS_PS_OFR_PAT_CRSVRSN_V , 

  • View: IGS_PS_OFR_PAT_OFERPAT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PS_OFR_PAT_OFERPAT_V,  object_name:IGS_PS_OFR_PAT_OFERPAT_V,  status:VALID,  product: IGS - Student System ,  description: View of the program offering pattern table. Required for program offering pattern LOV in ADMF3240 ,  implementation_dba_data: APPS.IGS_PS_OFR_PAT_OFERPAT_V , 

  • View: IGS_PS_OFR_PAT_APCOOD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PS_OFR_PAT_APCOOD_V,  object_name:IGS_PS_OFR_PAT_APCOOD_V,  status:VALID,  product: IGS - Student System ,  description: This view describes the offering pattern of a program offering option. It also describes the relationship between admission periods, admission process types and admission categories. ,  implementation_dba_data: APPS.IGS_PS_OFR_PAT_APCOOD_V , 

  • View: IGS_PS_OFR_PAT_APCOOD_PAT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PS_OFR_PAT_APCOOD_PAT_V,  object_name:IGS_PS_OFR_PAT_APCOOD_PAT_V,  status:VALID,  product: IGS - Student System ,  description: This view is used to display the admission period program offering pattern dates in ADMF2M62. ,  implementation_dba_data: APPS.IGS_PS_OFR_PAT_APCOOD_PAT_V , 

  • View: IGSFV_PGM_OFR_PATTERN_ADM_PERD 12.1.1

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

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

  • View: IGS_PS_OFR_PAT_UNITSET_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PS_OFR_PAT_UNITSET_V,  object_name:IGS_PS_OFR_PAT_UNITSET_V,  status:VALID,  product: IGS - Student System ,  description: This view describes the offering pattern of a program offering option. It also describes a unit-set, being a logical sub-grouping of program. ,  implementation_dba_data: APPS.IGS_PS_OFR_PAT_UNITSET_V ,