Search Results igs_ps_awd_own

Overview

The IGS_PS_AWD_OWN table is a core data entity within the Oracle E-Business Suite Student System (IGS). It serves a critical administrative function by defining the organizational ownership of a specific program award. In the context of academic program management, an award (such as a degree or certificate) offered within a course of study can be managed by a designated organizational unit (e.g., a specific department, school, or faculty). This table establishes and maintains that relationship, ensuring proper accountability, reporting, and workflow routing for each award associated with a program. Its existence is fundamental to the structured governance of academic offerings in the EBS ecosystem.

Key Information Stored

The table stores the unique association between an award and its owning organizational unit. Its structure is defined by a composite primary key that precisely identifies a single ownership record. The key columns are COURSE_CD and VERSION_NUMBER, which identify the specific program; AWARD_CD, which identifies the award within that program; and ORG_UNIT_CD and OU_START_DT, which together identify the precise version of the responsible organizational unit. This design ensures that ownership can be tracked historically if the responsible department changes over different time periods. The table primarily acts as a junction, linking the award entity to the organizational unit entity without storing extensive descriptive attributes itself.

Common Use Cases and Queries

This table is essential for reports and processes that require filtering or grouping academic data by the responsible organizational unit. Common use cases include generating departmental workload reports, assigning administrative tasks for award approval workflows, and ensuring compliance with accreditation standards by organizational unit. A typical query would join this table to the award and organizational unit master tables to produce a readable list.

• Sample Query: To list all awards and their owning departments for a specific course version:
  SELECT a.course_cd, a.award_cd, o.org_unit_cd, o.ou_start_dt FROM igs_ps_awd_own a, igs_or_unit o WHERE a.org_unit_cd = o.org_unit_cd AND a.course_cd = 'BSC' AND a.version_number = 2022;
• Reporting: The table is a key dimension in data warehouses or operational reports for student headcount, award conferrals, and program efficiency, segmented by the responsible academic unit.

Related Objects

The IGS_PS_AWD_OWN table maintains defined foreign key relationships with core master tables in the Student System, ensuring referential integrity. The primary documented relationships are as follows:

• IGS_PS_AWARD: The table references the award master via the columns COURSE_CD, VERSION_NUMBER, and AWARD_CD. This enforces that an ownership record can only be created for a valid, existing program award.
• IGS_OR_UNIT (implied): While not explicitly listed in the provided excerpt, the columns ORG_UNIT_CD and OU_START_DT logically reference the organizational unit master table (commonly named IGS_OR_UNIT or similar) to validate the owning unit. The table's role is to link these two primary entities.

As a child table to IGS_PS_AWARD, it is often accessed in queries that start from the award definition and seek organizational context, or vice-versa.