Search Results igs_da_rqst




Overview
Explore in AI Chat

Overview

The IGS_DA_RQST table is a core data structure within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for the Degree Audit functionality. As the parent table for storing all degree audit requests, it serves as the primary transactional record for initiating and tracking the process of evaluating a student's academic progress against program requirements. Its role is central to the operational workflow of degree auditing, acting as the anchor point from which related batch processing, student details, and audit features are managed. The table's validity across both EBS 12.1.1 and 12.2.2 versions confirms its established and consistent role in the application architecture.

Key Information Stored

The table's primary key is the BATCH_ID, which uniquely identifies each distinct degree audit request batch. According to the provided foreign key relationships, other critical columns include REQUEST_TYPE_ID, which links to the IGS_DA_CNFG_REQ_TYP table to define the nature of the audit request. The PERSON_ID column establishes a relationship with the HZ_PARTIES table, identifying the individual student for whom a single audit is requested. For batch operations involving multiple students, the PERSON_ID_GROUP_ID column links to the IGS_PE_PERSID_GROUP_ALL table, which defines the specific group of persons. The structure indicates that a single request batch can be associated with either an individual student or a predefined group.

Common Use Cases and Queries

This table is primarily accessed for generating audit reports, monitoring batch request statuses, and troubleshooting the degree audit process. A common reporting use case involves joining IGS_DA_RQST with related detail tables to get a comprehensive view of a request. For example, to list all audit requests for a specific student, one might query: SELECT rqst.BATCH_ID, rqst.REQUEST_TYPE_ID FROM IGS.IGS_DA_RQST rqst WHERE rqst.PERSON_ID = <STUDENT_PARTY_ID>;. For batch processing analysis, administrators may join IGS_DA_RQST with IGS_DA_REQ_STDNTS to correlate the batch header with its detailed list of students. Another critical use case is data validation, ensuring that request batches have corresponding configuration and student data by checking the integrity of its foreign key relationships.

Related Objects

The IGS_DA_RQST table has extensive relationships within the Degree Audit subsystem. It is the parent table referenced by several key child tables that store specific request details: IGS_DA_REQ_STDNTS (for student lists), IGS_DA_REQ_FTRS (for audit features), IGS_DA_REQ_WIF (for "What-If" analyses), and IGS_DA_REQ_WIFPRGS (for "What-If" program details). Its primary key, BATCH_ID, is a foreign key in these tables. Furthermore, it references master data tables: IGS_DA_CNFG_REQ_TYP for request type configuration, HZ_PARTIES for student party information, and IGS_PE_PERSID_GROUP_ALL for student groups. The IGS_DA_REQ_BATCH table also references IGS_DA_RQST, suggesting a potential hierarchical or status-tracking relationship within the batch request lifecycle.

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

  • View: IGS_DA_XML_COURSEINSTITUTION_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_COURSEINSTITUTION_V,  object_name:IGS_DA_XML_COURSEINSTITUTION_V,  status:VALID,  product: IGS - Student System ,  description: XML element CourseInstitutionTypeProvides the Unit"s Institution code based on the batch_id, person_id and local_institution_cd. ,  implementation_dba_data: APPS.IGS_DA_XML_COURSEINSTITUTION_V , 

  • View: IGS_DA_XML_COURSE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_COURSE_V,  object_name:IGS_DA_XML_COURSE_V,  status:VALID,  product: IGS - Student System ,  description: XML element CourseType (child of CourseInstitution)1)(SUA) Student Unit Attempt"s at local Institution. Includes Units local institution Units and currently enrolled units.Enrolled units can be excluded EIP Control feature code.2) (AV) Adv ,  implementation_dba_data: APPS.IGS_DA_XML_COURSE_V , 

  • Table: IGS_DA_REQ_FTRS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_REQ_FTRS,  object_name:IGS_DA_REQ_FTRS,  status:VALID,  product: IGS - Student System ,  description: Storage of Degree Audit configuration on Features allowed on the Request Screen ,  implementation_dba_data: IGS.IGS_DA_REQ_FTRS , 

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

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_REQ_BATCH,  object_name:IGS_DA_REQ_BATCH,  status:VALID,  product: IGS - Student System ,  description: Storage for Degree Audits on criteria for students in the request. ,  implementation_dba_data: IGS.IGS_DA_REQ_BATCH , 

  • View: IGS_DA_XML_CONTROLGPA_V 12.1.1

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

  • View: IGS_DA_XML_TRANSACTION_TYPE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_TRANSACTION_TYPE_V,  object_name:IGS_DA_XML_TRANSACTION_TYPE_V,  status:VALID,  product: IGS - Student System ,  description: XML element TransactionType part of the Envelope. Providing routing information along with EXC transmittal information. Based on OAG Standards. ,  implementation_dba_data: APPS.IGS_DA_XML_TRANSACTION_TYPE_V , 

  • Table: IGS_DA_REQ_WIFPRGS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_REQ_WIFPRGS,  object_name:IGS_DA_REQ_WIFPRGS,  status:VALID,  product: IGS - Student System ,  description: Storage on the Degree Audit Request What-If programs for the Student. Information only allowed during the Single Request Types not Batch ,  implementation_dba_data: IGS.IGS_DA_REQ_WIFPRGS , 

  • Table: IGS_DA_CNFG_REQ_TYP 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_CNFG_REQ_TYP,  object_name:IGS_DA_CNFG_REQ_TYP,  status:VALID,  product: IGS - Student System ,  description: Storage of Degree Audit configurations on Run Types allowed on the Request Screen ,  implementation_dba_data: IGS.IGS_DA_CNFG_REQ_TYP , 

  • View: IGS_DA_OUT_RQST_FTR_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_OUT_RQST_FTR_V,  object_name:IGS_DA_OUT_RQST_FTR_V,  status:VALID,  product: IGS - Student System ,  description: This view is to be created so that all information about all the feature values that have been defined for the features defined ,  implementation_dba_data: APPS.IGS_DA_OUT_RQST_FTR_V , 

  • Table: IGS_PE_PERSID_GROUP_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PE_PERSID_GROUP_ALL,  object_name:IGS_PE_PERSID_GROUP_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the available groups to which persons can be assigned for reporting purposes. ,  implementation_dba_data: IGS.IGS_PE_PERSID_GROUP_ALL , 

  • View: IGS_DA_XML_TE_REFERENCE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_TE_REFERENCE_V,  object_name:IGS_DA_XML_TE_REFERENCE_V,  status:VALID,  product: IGS - Student System ,  description: XML element ReferenceType (child of TransferEvaluation) ,  implementation_dba_data: APPS.IGS_DA_XML_TE_REFERENCE_V , 

  • View: IGS_DA_XML_ORIGINALCOURSE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_ORIGINALCOURSE_V,  object_name:IGS_DA_XML_ORIGINALCOURSE_V,  status:VALID,  product: IGS - Student System ,  description: XML element OriginalCourseType (child of CourseType). Gets the original Unit/(course) information for Units Transferred from other institutions. ,  implementation_dba_data: APPS.IGS_DA_XML_ORIGINALCOURSE_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 , 

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

  • View: IGS_DA_XML_EXAMINATION_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_EXAMINATION_V,  object_name:IGS_DA_XML_EXAMINATION_V,  status:VALID,  product: IGS - Student System ,  description: XML element ExaminationProvides Student"s basic examination information test type, dates, scores. All Examination information can be excluded with ETS feature value set to Y. ,  implementation_dba_data: APPS.IGS_DA_XML_EXAMINATION_V , 

  • 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_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_XML_CONTROL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_CONTROL_V,  object_name:IGS_DA_XML_CONTROL_V,  status:VALID,  product: IGS - Student System ,  description: XML element ControlType. View of the request configuration. Provides 3rd Party Software specific processing instructions. ,  implementation_dba_data: APPS.IGS_DA_XML_CONTROL_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 ,