Search Results igs_ps_unit




Overview
Explore in AI Chat

Overview

The IGS_PS_UNIT table is a core master data object within the Oracle E-Business Suite Student System (IGS). It serves as the primary repository for the high-level definition of an academic unit offered by an institution. In this context, a "unit" typically represents a discrete subject, course, or module that forms part of a larger program of study (e.g., "Introduction to Economics 101"). The table stores the fundamental code and attributes that identify the unit, acting as a parent record for more detailed version-specific information. Its primary role is to establish a unique identifier for a unit, which is then referenced extensively across the student lifecycle for enrollment, fee assessment, program requirements, and academic planning.

Key Information Stored

While the provided ETRM excerpt does not list all columns, it definitively identifies the primary key. The central and most critical column is UNIT_CD, which is the unique code allocated to the university unit and serves as the table's primary key (IGS_PS_UNIT_PK). This code is the fundamental identifier used throughout the application to reference the unit. Based on standard patterns for master tables in the Student System, other columns likely include descriptive fields such as a title, an effective status indicator (e.g., ACTIVE, INACTIVE), and audit columns for who created the record and when. The table's structure is designed to ensure each unit has a single, unique identifier that persists across different versions or offerings of that unit over time.

Common Use Cases and Queries

This table is central to numerous academic and administrative processes. Common use cases include validating unit codes during student enrollment, defining program structures and prerequisites, and configuring fee schedules. Reporting often involves joining IGS_PS_UNIT to related tables to analyze unit offerings, enrollment trends, or financial data. A fundamental query pattern retrieves active units or validates a unit code's existence.

  • Basic Unit Lookup: SELECT unit_cd FROM igs.igs_ps_unit WHERE unit_cd = '&UNIT_CODE';
  • Joining to Version Details: A critical query joins to the related version table (IGS_PS_UNIT_VER_ALL) to get specific offering details like title and credit points: SELECT u.unit_cd, uv.version_number, uv.title FROM igs.igs_ps_unit u, igs.igs_ps_unit_ver_all uv WHERE u.unit_cd = uv.unit_cd AND u.unit_cd = 'MATH101';

Related Objects

The IGS_PS_UNIT table has extensive relationships, as evidenced by its foreign key constraints. It is a parent table to several key entities. The most direct relationship is with IGS_PS_UNIT_VER_ALL, which stores multiple versions (e.g., 2024-1, 2024-2) for a single unit code. Other critical dependencies include financial objects like IGS_FI_FEE_AS_RATE and IGS_FI_UNIT_FEE_TRG for fee assessment, and academic planning objects like IGS_PS_PAT_STUDY_UNT (study pattern units) and IGS_PE_UNT_REQUIRMNT (unit requirements). The table is also referenced in student progression (IGS_PR_STDNT_PR_UNIT) and personal unit exclusions (IGS_PE_PERS_UNT_EXCL), highlighting its integral role across the Student System's functional modules.

  • Table: IGS_PS_UNIT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_UNIT,  object_name:IGS_PS_UNIT,  status:VALID,  product: IGS - Student System ,  description: This attribute describes the code allocated to a unit offered by the university. ,  implementation_dba_data: IGS.IGS_PS_UNIT , 

  • Table: IGS_PE_PERS_UNT_EXCL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PE_PERS_UNT_EXCL,  object_name:IGS_PE_PERS_UNT_EXCL,  status:VALID,  product: IGS - Student System ,  description: This entity describes a unit which a student has been excluded from. ,  implementation_dba_data: IGS.IGS_PE_PERS_UNT_EXCL , 

  • View: IGSFV_HIGHER_EDUCATION_UNITS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_HIGHER_EDUCATION_UNITS,  object_name:IGSFV_HIGHER_EDUCATION_UNITS,  status:VALID,  product: IGS - Student System ,  description: This is a full view, which contains the codes used to identify the units being offered by the university. ,  implementation_dba_data: APPS.IGSFV_HIGHER_EDUCATION_UNITS , 

  • Table: IGS_PE_UNT_REQUIRMNT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PE_UNT_REQUIRMNT,  object_name:IGS_PE_UNT_REQUIRMNT,  status:VALID,  product: IGS - Student System ,  description: Describes units that are required to be studied by the student as part of a hold ,  implementation_dba_data: IGS.IGS_PE_UNT_REQUIRMNT , 

  • Table: IGS_PS_PAT_STUDY_UNT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_PAT_STUDY_UNT,  object_name:IGS_PS_PAT_STUDY_UNT,  status:VALID,  product: IGS - Student System ,  description: This entity describes the units, which exist within a pattern of study period. ,  implementation_dba_data: IGS.IGS_PS_PAT_STUDY_UNT , 

  • Table: IGS_PR_STDNT_PR_UNIT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PR_STDNT_PR_UNIT,  object_name:IGS_PR_STDNT_PR_UNIT,  status:VALID,  product: IGS - Student System ,  description: This entity describes the units that a student is required to enroll in as part of their probation due to failing a progression rule. ,  implementation_dba_data: IGS.IGS_PR_STDNT_PR_UNIT , 

  • View: IGS_PS_UNIT_UNIT_VERSION_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PS_UNIT_UNIT_VERSION_V,  object_name:IGS_PS_UNIT_UNIT_VERSION_V,  status:VALID,  product: IGS - Student System ,  description: This view includes the title of the latest active version of a unit ,  implementation_dba_data: APPS.IGS_PS_UNIT_UNIT_VERSION_V , 

  • View: IGSBV_HIGHER_EDUCATION_UNITS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_HIGHER_EDUCATION_UNITS,  object_name:IGSBV_HIGHER_EDUCATION_UNITS,  status:VALID,  product: IGS - Student System ,  description: This is a base view, which contains the codes used to identify the units being offered by the university ,  implementation_dba_data: APPS.IGSBV_HIGHER_EDUCATION_UNITS , 

  • Table: IGS_FI_FEE_AS_RT_H_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_FEE_AS_RT_H_ALL,  object_name:IGS_FI_FEE_AS_RT_H_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes special contract based fee assessment rates ,  implementation_dba_data: IGS.IGS_FI_FEE_AS_RT_H_ALL , 

  • Table: IGS_FI_UNIT_FEE_TRG 12.1.1

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

  • Table: IGS_FI_FEE_AS_RATE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_FEE_AS_RATE,  object_name:IGS_FI_FEE_AS_RATE,  status:VALID,  product: IGS - Student System ,  description: This entity describes the method and parameters necessary for determining the amount to charge during fee assessment processing for a fee category fee liability. ,  implementation_dba_data: IGS.IGS_FI_FEE_AS_RATE , 

  • View: IGS_EN_SUSA_PARENT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_EN_SUSA_PARENT_V,  object_name:IGS_EN_SUSA_PARENT_V,  status:VALID,  product: IGS - Student System ,  description: This view determines the unit sets that are able to be linked as a parent for a student unit set attempt. The exists field is an indicator to show if the parent exists as a student unit set attempt. If not, then it will need to be created b ,  implementation_dba_data: APPS.IGS_EN_SUSA_PARENT_V , 

  • Table: IGS_PS_UNIT_VER_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_UNIT_VER_ALL,  object_name:IGS_PS_UNIT_VER_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes a version of a unit, which is offered by the university. ,  implementation_dba_data: IGS.IGS_PS_UNIT_VER_ALL ,