Search Results igs_da_req_stdnts




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_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 , 

  • 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 , 

  • Table: IGS_PS_COURSE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_COURSE,  object_name:IGS_PS_COURSE,  status:VALID,  product: IGS - Student System ,  description: This entity describes the programs which are offered by the university, covering both award and non-award programs. ,  implementation_dba_data: IGS.IGS_PS_COURSE , 

  • 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_TRANSFEREVAL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_TRANSFEREVAL_V,  object_name:IGS_DA_XML_TRANSFEREVAL_V,  status:VALID,  product: IGS - Student System ,  description: XML element TransferEvaluation ,  implementation_dba_data: APPS.IGS_DA_XML_TRANSFEREVAL_V , 

  • View: IGS_DA_XML_REQUESTDATA_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_REQUESTDATA_V,  object_name:IGS_DA_XML_REQUESTDATA_V,  status:VALID,  product: IGS - Student System ,  description: XML element RequestData ,  implementation_dba_data: APPS.IGS_DA_XML_REQUESTDATA_V , 

  • Table: IGS_DA_OUT_STDNT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_STDNT,  object_name:IGS_DA_OUT_STDNT,  status:VALID,  product: IGS - Student System ,  description: Storage for specific outgoing information on the Student in the Degree Audit Request ,  implementation_dba_data: IGS.IGS_DA_OUT_STDNT , 

  • Table: IGS_DA_IN_USR_DEF 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_IN_USR_DEF,  object_name:IGS_DA_IN_USR_DEF,  status:VALID,  product: IGS - Student System ,  description: Storage for the incoming user specific information on the Student in the Degree Audit Request ,  implementation_dba_data: IGS.IGS_DA_IN_USR_DEF , 

  • Table: IGS_DA_OUT_TSTS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_TSTS,  object_name:IGS_DA_OUT_TSTS,  status:VALID,  product: IGS - Student System ,  description: Storage for the outgoing Test information for the Student in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_OUT_TSTS , 

  • Table: IGS_DA_OUT_USR_DEF 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_USR_DEF,  object_name:IGS_DA_OUT_USR_DEF,  status:VALID,  product: IGS - Student System ,  description: Storage for outgoing institution specific information that is to be sent out for each student in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_OUT_USR_DEF , 

  • Table: IGS_DA_OUT_STDT_SPT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_STDT_SPT,  object_name:IGS_DA_OUT_STDT_SPT,  status:VALID,  product: IGS - Student System ,  description: Storage for outgoing information on all Sports the Student in the Degree Audit Request is involved with. ,  implementation_dba_data: IGS.IGS_DA_OUT_STDT_SPT , 

  • Table: IGS_DA_IN_RSLT_UNTS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_IN_RSLT_UNTS,  object_name:IGS_DA_IN_RSLT_UNTS,  status:VALID,  product: IGS - Student System ,  description: Storage for the Resulting Unit information from the 3rd party about Units for the Students in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_IN_RSLT_UNTS , 

  • Table: IGS_DA_REQ_WIF 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_REQ_WIF,  object_name:IGS_DA_REQ_WIF,  status:VALID,  product: IGS - Student System ,  description: This table holds program and unit set details for a what-if request ,  implementation_dba_data: IGS.IGS_DA_REQ_WIF , 

  • Table: IGS_DA_IN_PRG 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_IN_PRG,  object_name:IGS_DA_IN_PRG,  status:VALID,  product: IGS - Student System ,  description: Storage for the incoming information from the 3rd party about programs related to the Students in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_IN_PRG , 

  • Table: IGS_DA_REQ_RPTS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_REQ_RPTS,  object_name:IGS_DA_REQ_RPTS,  status:VALID,  product: IGS - Student System ,  description: Storage for Degree Audit Request Reports generated by the 3rd Party. ,  implementation_dba_data: IGS.IGS_DA_REQ_RPTS , 

  • Table: IGS_DA_RQST 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_RQST,  object_name:IGS_DA_RQST,  status:VALID,  product: IGS - Student System ,  description: Parent table for storage of all Degree Audit Requests made. ,  implementation_dba_data: IGS.IGS_DA_RQST , 

  • 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_SPCL_REQ 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_SPCL_REQ,  object_name:IGS_DA_OUT_SPCL_REQ,  status:VALID,  product: IGS - Student System ,  description: Storage for the outgoing Special Requirements on the Student found for the Degree Audit Request ,  implementation_dba_data: IGS.IGS_DA_OUT_SPCL_REQ , 

  • View: IGS_DA_XML_DEGREEPROGRAM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_DEGREEPROGRAM_V,  object_name:IGS_DA_XML_DEGREEPROGRAM_V,  status:VALID,  product: IGS - Student System ,  description: XML element DegreeProgramLead index view to Academic Program and Academic Subprogram. Provides the batch_id, local_institution_cd, and person_id to the sub views whereclause is provide in XML map. ,  implementation_dba_data: APPS.IGS_DA_XML_DEGREEPROGRAM_V , 

  • View: IGS_DA_XML_PERSON_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_PERSON_V,  object_name:IGS_DA_XML_PERSON_V,  status:VALID,  product: IGS - Student System ,  description: XML element PersonType ,  implementation_dba_data: APPS.IGS_DA_XML_PERSON_V , 

  • Table: IGS_DA_OUT_PRG 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_PRG,  object_name:IGS_DA_OUT_PRG,  status:VALID,  product: IGS - Student System ,  description: Storage for the outgoing program for the declared and requested information on the Student in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_OUT_PRG , 

  • 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 , 

  • Table: IGS_DA_OUT_STDT_DEG 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_STDT_DEG,  object_name:IGS_DA_OUT_STDT_DEG,  status:VALID,  product: IGS - Student System ,  description: Storage for the outgoing information on the degree information for the Student in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_OUT_STDT_DEG , 

  • Table: IGS_DA_IN_SRC_UNTS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_IN_SRC_UNTS,  object_name:IGS_DA_IN_SRC_UNTS,  status:VALID,  product: IGS - Student System ,  description: Storage for all the Source Units given by the 3rd party for the Students in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_IN_SRC_UNTS , 

  • 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_EXPL_PRG_CAT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_EXPL_PRG_CAT_V,  object_name:IGS_DA_EXPL_PRG_CAT_V,  status:VALID,  product: IGS - Student System ,  description: View is used to determine the program catalogs allowed to be displayed for the Explore Program Catalog LOV based on configuration of profiles setup and the user allowed to choose Explore Program options. ,  implementation_dba_data: APPS.IGS_DA_EXPL_PRG_CAT_V , 

  • View: IGS_DA_RQST_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_RQST_V,  object_name:IGS_DA_RQST_V,  status:VALID,  product: IGS - Student System ,  description: View over Degree Audit Request ,  implementation_dba_data: APPS.IGS_DA_RQST_V ,