Search Results unit_seq_num




Overview
Explore in AI Chat

Overview

The IGS_DA_OUT_PRG_USET table is a core data storage object within the Oracle E-Business Suite Student System (IGS). It functions as a detailed child table in the Degree Audit processing architecture. Its primary role is to store the specific unit set information associated with academic programs identified for a student during a Degree Audit request. This table captures the granular program structure, enabling the system to output and analyze a student's progress against the defined requirements of their program's unit sets, which are typically specializations, majors, or minors within a broader course of study.

Key Information Stored

The table stores a unique record for each unit set linked to a program in a student's audit. Its structure is defined by a composite primary key that ensures data integrity for each audit batch. The critical columns are:

  • BATCH_ID, PERSON_ID, PROGRAM_SEQ_NUM: These columns collectively form a foreign key reference to the parent IGS_DA_OUT_PRG table. They uniquely identify the specific audit batch, student, and program sequence to which this unit set detail belongs.
  • UNIT_SEQ_NUM: The sequence number that uniquely identifies this unit set record within the context of the parent program (BATCH_ID, PERSON_ID, PROGRAM_SEQ_NUM). It completes the table's primary key.
  • While the provided metadata focuses on keys, typical columns in such a table would include identifiers for the unit set (e.g., UNIT_SET_CD), its version, status, and potentially calculated fields related to the student's completion status against the unit set requirements.

Common Use Cases and Queries

This table is central to generating detailed Degree Audit reports and supporting related inquiries. A primary use case is the program-level breakdown within an audit, showing all constituent unit sets and the student's standing in each. For technical analysis or custom reporting, a common query pattern involves joining to its parent table to retrieve a complete program structure for an audit. For example, to list all unit sets for programs in a specific audit batch for a student:

SELECT uset.* FROM igs_da_out_prg_uset uset, igs_da_out_prg prg WHERE uset.batch_id = prg.batch_id AND uset.person_id = prg.person_id AND uset.program_seq_num = prg.program_seq_num AND uset.batch_id = :p_batch_id AND uset.person_id = :p_person_id ORDER BY uset.program_seq_num, uset.unit_seq_num;

Data from this table is also critical for downstream processes that may feed student advisement modules or institutional analytics on program and specialization completion trends.

Related Objects

The IGS_DA_OUT_PRG_USET table has a direct, dependent relationship within the Degree Audit output schema. Its primary related object is:

  • IGS_DA_OUT_PRG (Parent Table): This table stores the header-level program information for a degree audit. IGS_DA_OUT_PRG_USET references it via a foreign key on the composite columns (BATCH_ID, PERSON_ID, PROGRAM_SEQ_NUM). This relationship enforces that every unit set record must be associated with a valid, existing program record from the audit.

As a child table containing detailed output, it is typically populated by the Degree Audit engine and is referenced by reporting views or interfaces that present the detailed audit results to end-users.

  • Table: IGS_DA_OUT_PRG_USET 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_PRG_USET,  object_name:IGS_DA_OUT_PRG_USET,  status:VALID,  product: IGS - Student System ,  description: Storage for outgoing Program Unit Set information on the programs found for the Student in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_OUT_PRG_USET , 

  • Table: IGS_DA_OUT_UNT_REF 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_UNT_REF,  object_name:IGS_DA_OUT_UNT_REF,  status:VALID,  product: IGS - Student System ,  description: Storage for outgoing information on unit reference information on Academic History, Advanced Standing and Enrolments for the student in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_OUT_UNT_REF , 

  • Table: IGS_DA_OUT_AUDT_DTL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_AUDT_DTL,  object_name:IGS_DA_OUT_AUDT_DTL,  status:VALID,  product: IGS - Student System ,  description: Storage for the Degree Audit details for the units found for the Student in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_OUT_AUDT_DTL , 

  • Table: IGS_DA_OUT_UNT_AS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_UNT_AS,  object_name:IGS_DA_OUT_UNT_AS,  status:VALID,  product: IGS - Student System ,  description: Storage on outgoing Advanced Standing information on student in the Degree Audit Request ,  implementation_dba_data: IGS.IGS_DA_OUT_UNT_AS , 

  • Table: IGS_DA_OUT_UNT_AH 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_UNT_AH,  object_name:IGS_DA_OUT_UNT_AH,  status:VALID,  product: IGS - Student System ,  description: Storage for all outgoing Academic History on the Student in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_OUT_UNT_AH , 

  • Table: IGS_DA_OUT_UNT_CAT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_UNT_CAT,  object_name:IGS_DA_OUT_UNT_CAT,  status:VALID,  product: IGS - Student System ,  description: Storage for the outgoing unit categories on the units found for the Student in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_OUT_UNT_CAT , 

  • Table: IGS_DA_OUT_UNT_EN 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_UNT_EN,  object_name:IGS_DA_OUT_UNT_EN,  status:VALID,  product: IGS - Student System ,  description: Storage for the outgoing Enrollment units for the student in the Degree Audit Request ,  implementation_dba_data: IGS.IGS_DA_OUT_UNT_EN ,