Search Results igs_da_req_stdnts_id




Overview
Explore in AI Chat

Overview

The IGS_DA_REQ_STDNTS table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for the Degree Audit functionality. It serves as the central repository for identifying the specific students associated with a given Degree Audit request. In the context of EBS 12.1.1 and 12.2.2, a Degree Audit is a critical process that evaluates a student's academic progress against the requirements of a program or degree. This table links a batch request (BATCH_ID) to one or more students (PERSON_ID), establishing the foundational relationship upon which all audit input data is gathered and all output results are generated. It is a transactional table that enables both batch and individual student audit processing.

Key Information Stored

The table's primary purpose is to map students to audit requests. Its most critical columns, as inferred from the foreign key relationships, are BATCH_ID and PERSON_ID. The BATCH_ID links the record to the parent request in the IGS_DA_RQST table, while PERSON_ID identifies the student within the system. The table also includes a surrogate primary key, IGS_DA_REQ_STDNTS_ID. Furthermore, it stores codes for specific program scenarios within an audit, notably WIF_PROGRAM_CODE (What-If program) and SPECIAL_PROGRAM_CODE, which are foreign keys to the IGS_PS_COURSE table. This allows the audit to be run against standard, proposed, or special program paths for the student.

Common Use Cases and Queries

This table is essential for any process involving the execution or reporting of Degree Audits. Common use cases include identifying all students processed in a particular audit batch, troubleshooting audit results for a specific student, and generating lists of students who have had audits run against alternative programs. A fundamental query pattern involves joining to the main request table and person/student tables to provide context.

  • List Students in a Batch: SELECT person_id FROM igs_da_req_stdnts WHERE batch_id = :p_batch_id;
  • Find Audit Requests for a Student: SELECT rqst.* FROM igs_da_rqst rqst JOIN igs_da_req_stdnts std ON rqst.batch_id = std.batch_id WHERE std.person_id = :p_person_id;
  • Audit Reporting Context: Most reports on audit output (e.g., IGS_DA_OUT_STDNT, IGS_DA_OUT_PRG) will join through this table using both BATCH_ID and PERSON_ID to connect results to the specific student and request.

Related Objects

The IGS_DA_REQ_STDNTS table is a central hub with extensive relationships, primarily as the referenced table in foreign keys from numerous Degree Audit input and output tables. This design ensures data integrity by tying all audit details to a valid student-request combination.

All related output tables join on the composite key of BATCH_ID and PERSON_ID, demonstrating this table's role as the definitive source for valid student-and-request combinations within the Degree Audit subsystem.

  • Table: IGS_DA_REQ_STDNTS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_REQ_STDNTS,  object_name:IGS_DA_REQ_STDNTS,  status:VALID,  product: IGS - Student System ,  description: Storage for the Students that the Degree Audit Request is for. ,  implementation_dba_data: IGS.IGS_DA_REQ_STDNTS , 

  • View: IGS_DA_XML_GPA_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_GPA_V,  object_name:IGS_DA_XML_GPA_V,  status:VALID,  product: IGS - Student System ,  description: XML element GPAType (child of AcademicProgram). Returns the GPA Stored or Calculated on the identified by the program code, calendar and time frame. ,  implementation_dba_data: APPS.IGS_DA_XML_GPA_V , 

  • View: IGS_DA_REQ_STDNTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_REQ_STDNTS_V,  object_name:IGS_DA_REQ_STDNTS_V,  status:VALID,  product: IGS - Student System ,  description: View on top of igs_da_req_Stdnts ,  implementation_dba_data: APPS.IGS_DA_REQ_STDNTS_V , 

  • View: IGS_DA_XML_ACADEMICPROGRAM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_ACADEMICPROGRAM_V,  object_name:IGS_DA_XML_ACADEMICPROGRAM_V,  status:VALID,  product: IGS - Student System ,  description: XML element AcademicProgramSub view indexed by Degree Program view Provides the provides the DA specified program information "SPA" -- Students Selected Degree Program "WIF" -- What-if Program "SPECIAL" -- Special Program ,  implementation_dba_data: APPS.IGS_DA_XML_ACADEMICPROGRAM_V , 

  • View: IGS_DA_XML_SUBPROGRAM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_SUBPROGRAM_V,  object_name:IGS_DA_XML_SUBPROGRAM_V,  status:VALID,  product: IGS - Student System ,  description: XML element SubProgramType (child of AcademicProgram). Returns the Major(s), Minor(s), and Track(s) of the Academic Program. ,  implementation_dba_data: APPS.IGS_DA_XML_SUBPROGRAM_V ,