Search Results degree_seq_num

Overview

The IGS_DA_OUT_STDT_DEG table is a data staging table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Global Systems (IGS) product area. Its primary role is to store outgoing degree information for students who have been selected as part of a specific batch request. As indicated by its status and storage location (the APPS_TS_INTERFACE tablespace), this table functions as an interface or temporary holding area for data being processed or extracted, often for reporting or data exchange purposes. The documentation explicitly marks the table as "Obsolete," indicating it is part of a legacy data model that may be superseded in future releases, though it remains valid and operational in the specified versions.

Key Information Stored

The table's structure is centered on linking a student's degree history to a specific processing batch. The composite primary key uniquely identifies each record through the combination of BATCH_ID, PERSON_ID, and DEGREE_SEQ_NUM. The DEGREE_SEQ_NUM is a critical column, as it is a sequence-generated value derived from the core student degree table, ensuring a unique identifier for each degree record associated with a person. Other significant columns store details about the student's academic history, including PRIOR_ATTMPT_DEGREE for enrollment history, PRIOR_DEGREE_EARNED for completed programs, and PRIOR_DEGREE_INST / PRIOR_DEGREE_INST_NAME for the awarding institution. Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, etc.) are present for auditing.

Common Use Cases and Queries

This table is typically accessed in scenarios involving batch processing of student degree data for external reporting, transcript generation, or compliance submissions. A common use case is to extract all degree information for students included in a particular batch request. The following query pattern, based on the provided metadata, is fundamental for retrieving this staged data:

SELECT BATCH_ID, PERSON_ID, DEGREE_SEQ_NUM, PRIOR_DEGREE_EARNED, PRIOR_DEGREE_INST_NAME
FROM IGS.IGS_DA_OUT_STDT_DEG
WHERE BATCH_ID = :batch_id
ORDER BY PERSON_ID, DEGREE_SEQ_NUM;

Reporting often involves joining this table to the main student request table (IGS_DA_REQ_STDNTS) to provide context on the batch selection criteria. Queries may also filter on PRIOR_DEGREE_EARNED to isolate students with specific completed qualifications or on PRIOR_DEGREE_INST to analyze the feeder institutions for a cohort.

Related Objects

Based on the provided relationship data, IGS_DA_OUT_STDT_DEG has a defined dependency as a child table in a foreign key relationship. The table's BATCH_ID column references a parent table, establishing its link to the broader batch request process.

• Primary Key: IGS_DA_OUT_STDT_DEG_PK (BATCH_ID, PERSON_ID, DEGREE_SEQ_NUM)
• Foreign Key (References): The BATCH_ID column in IGS_DA_OUT_STDT_DEG is a foreign key referencing the IGS_DA_REQ_STDNTS table. This relationship ties the outgoing degree records to the master list of students selected for a given request batch.

No other referencing objects are documented in the provided metadata, reinforcing its role as a terminal point for data staging within this specific process flow.