Search Results org_agency_id




Overview
Explore in AI Chat

Overview

The IGS_OR_ORG_ACCR_DTLS table is a core data structure within the Oracle E-Business Suite, specifically in the IGS (Oracle Higher Education) product family for versions 12.1.1 and 12.2.2. It functions as the master repository for recording and managing the accreditation statuses of organizational entities. Accreditation is a critical process in the education sector, where external agencies formally recognize an institution or its specific programs. This table enables the system to track which accrediting bodies have granted status to an organizational structure, the nature of that status, and the period of its validity. Its role is to maintain a historical and current record of institutional compliance and recognition, which is essential for academic operations, reporting, and regulatory adherence.

Key Information Stored

The table stores the intersection of an organizational entity, an accrediting agency, and a specific status over a defined time period. The primary key is a composite of five columns, ensuring a unique record for each status granted by an agency to an organization starting on a specific date. Key data columns include:

Common Use Cases and Queries

This table is central to accreditation reporting and validation processes. A common operational use case is generating a report of all currently active accreditations for an institution's audit. Another is to validate the accreditation status of a specific program or campus during student enrollment or course scheduling. Sample SQL patterns include querying for active records for a given agency or finding all accreditations for a specific organizational unit. For instance, to find all active accreditation details for a specific organizational structure, one might use:

SELECT org_agency_id, org_accr_status, start_date, end_date
FROM igs.igs_or_org_accr_dtls
WHERE org_structure_id = :p_org_id
AND org_structure_type = :p_org_type
AND sysdate BETWEEN start_date AND NVL(end_date, sysdate+1);

Reporting use cases often involve joining this table to lookup values for status descriptions and agency names to produce human-readable compliance reports.

Related Objects

The table's integrity is enforced through defined relationships with other key entities in the IGS schema. Based on the provided relationship data:

  • Primary Key: IGS_OR_ORG_ACCR_DETAILS_PK on (ORG_STRUCTURE_ID, ORG_STRUCTURE_TYPE, ORG_AGENCY_ID, ORG_ACCR_STATUS, START_DATE).
  • Foreign Key (Reference): The ORG_ACCR_STATUS column references a lookup table, likely named IGS_OR_ORG_ACCR_STAT, which contains the valid list of status codes (e.g., ACTIVE, INACTIVE).
  • Foreign Key (Reference): The ORG_STRUCTURE_ID column references the IGS_AD_LOCATION_ALL table, linking the accreditation detail to a specific physical or logical location within the institution's hierarchy.

Furthermore, the dependency information indicates that an APPS synonym exists for this table, and it is referenced by other objects within the application, highlighting its role as a foundational data source for accreditation-related functionality.