Search Results igs_da_req_ftrs




Overview
Explore in AI Chat

Overview

The IGS_DA_REQ_FTRS table is a core configuration table within the Oracle E-Business Suite (EBS) Student System (IGS). It functions as a control table for the Degree Audit module, specifically governing which features are permitted to be displayed and used on the Degree Audit Request Screen. Its role is to store the valid feature-to-request mapping, ensuring that only pre-configured and authorized features are available to users when submitting a degree audit request. This table is essential for maintaining the integrity and consistency of the degree audit request process by enforcing a controlled set of operational parameters.

Key Information Stored

The table stores a mapping between a degree audit batch configuration and the specific features enabled for it. The primary data elements are defined by its composite primary key. The BATCH_ID column links to a specific degree audit request batch configuration. The FEATURE_CODE column stores the unique identifier for a configurable feature, such as a specific reporting option, inclusion rule, or display parameter. Together, these columns define a single rule permitting a specific feature for a specific request batch. The table's structure is minimal, serving purely as a junction to enforce these business rules.

Common Use Cases and Queries

A primary use case is validating user selections on the request screen. The application queries this table to populate available feature checkboxes or list of values (LOVs). System administrators use it during setup to define which features are active for different audit types. Common reporting queries involve listing all features enabled for a particular batch or identifying which batches have a specific feature turned on. A typical SQL pattern retrieves active features for a known batch:

  • SELECT feature_code FROM igs.igs_da_req_ftrs WHERE batch_id = :p_batch_id;

Conversely, to audit configuration, one might join to the IGS_DA_RQST table to get batch details:

  • SELECT r.batch_id, r.batch_name, f.feature_code FROM igs.igs_da_rqst r, igs.igs_da_req_ftrs f WHERE r.batch_id = f.batch_id ORDER BY r.batch_id;

Related Objects

IGS_DA_REQ_FTRS has defined foreign key relationships central to its function. It is a child of the IGS_DA_RQST table via the BATCH_ID column, which holds the master configuration for a degree audit request batch. It is also a child of the IGS_DA_FTR_VAL_MAP table via the FEATURE_CODE column, which likely serves as the master validation table for all available feature codes and their possible values within the Degree Audit module. These relationships ensure referential integrity, guaranteeing that entries in IGS_DA_REQ_FTRS correspond to valid, existing batch configurations and feature definitions elsewhere in the system.

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

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

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_XML_TE_INSTITUTION_V,  object_name:IGS_DA_XML_TE_INSTITUTION_V,  status:VALID,  product: IGS - Student System ,  description: XML element InstitutionType (child of TransferEvaluation) ,  implementation_dba_data: APPS.IGS_DA_XML_TE_INSTITUTION_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_FTR_VAL_MAP 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_FTR_VAL_MAP,  object_name:IGS_DA_FTR_VAL_MAP,  status:VALID,  product: IGS - Student System ,  description: Storage location for mapping between Configurable features and their lookup values ,  implementation_dba_data: IGS.IGS_DA_FTR_VAL_MAP , 

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

  • View: IGS_DA_REQ_FTRS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_DA_REQ_FTRS_V,  object_name:IGS_DA_REQ_FTRS_V,  status:VALID,  product: IGS - Student System ,  description: View over Degree Audit Request Features ,  implementation_dba_data: APPS.IGS_DA_REQ_FTRS_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 , 

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

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