Search Results org_structure_id




Overview
Explore in AI Chat

Overview

The table IGS_OR_ORG_ACCR_DTLS is a core data entity within the Oracle E-Business Suite Student System (IGS) modules, including versions 12.1.1 and 12.2.2. It serves as the primary repository for storing detailed accreditation records pertaining to organizational structures within an educational institution. Accreditation is a critical process for validating the quality and standards of academic programs, departments, or entire institutions. This table's role is to maintain a historical and current record of accreditation statuses, the accrediting agencies involved, and the specific organizational units being assessed, thereby supporting compliance reporting, academic auditing, and institutional planning.

Key Information Stored

The table's structure is designed to uniquely identify an accreditation record for a specific organizational entity. Its composite primary key and critical columns are central to its function.

  • ORG_STRUCTURE_ID: A foreign key, typically referencing IGS_AD_LOCATION_ALL, that identifies the specific organizational unit (e.g., a campus, school, or department) undergoing accreditation.
  • ORG_STRUCTURE_TYPE: A critical classifier that defines the category or level of the organizational structure identified by ORG_STRUCTURE_ID, such as 'CAMPUS', 'COLLEGE', or 'PROGRAM'. This column directly addresses the user's search context.
  • ORG_AGENCY_ID: Identifies the external accrediting body or agency responsible for the evaluation.
  • ORG_ACCR_STATUS: A foreign key to IGS_OR_ORG_ACCR_STAT, storing the current accreditation status (e.g., 'Accredited', 'Probation', 'Applied').
  • START_DATE: The effective date when the given accreditation status became active for the specified organization and agency.

Common Use Cases and Queries

This table is essential for generating institutional accreditation reports and ensuring data integrity for academic operations. A common use case involves auditing the accreditation status of all organizational units of a specific type. For instance, an administrator may need to list all accredited academic programs. A typical query pattern would be:

SELECT org_structure_id, org_agency_id, org_accr_status, start_date
FROM igs.igs_or_org_accr_dtls
WHERE org_structure_type = 'PROGRAM'
AND org_accr_status = 'ACCREDITED'
AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);

Another frequent operational need is to track the accreditation history for a specific department or school, which involves querying this table by ORG_STRUCTURE_ID and ordering records by START_DATE to see the progression of status changes over time.

Related Objects

IGS_OR_ORG_ACCR_DTLS is integrally linked to other key entities in the Student System schema, primarily through foreign key relationships.

  • IGS_OR_ORG_ACCR_STAT: Provides the valid list of status codes (e.g., 'APPLIED', 'ACCREDITED') referenced by the ORG_ACCR_STATUS column, ensuring data validation.
  • IGS_AD_LOCATION_ALL: The table that defines the physical and logical organizational structures (locations) referenced by ORG_STRUCTURE_ID. This relationship ties accreditation details to the actual institutional hierarchy.

Additionally, this table is likely referenced by various student system forms, reports, and APIs that manage accreditation lifecycles, though these are not explicitly listed in the provided metadata.