Search Results acc_classification_code

Overview

The IGS.IGP_AC_ACC_CLASSES table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Internet Global Services) product family. It functions as a junction table that manages the classification or categorization of system accounts. Its primary role is to associate an account with one or more classification codes, such as 'Faculty', 'Staff', 'Student', or 'External', and to optionally govern the temporal validity of that classification through an expiration date. This enables fine-grained access control and user segmentation based on account type within the application's security and functional modules.

Key Information Stored

The table's structure is designed to track classification assignments with full auditability. The most critical columns include:

• ACC_CLASSIFICATION_ID: A system-generated, unique sequence number serving as the primary key for each classification record.
• ACCOUNT_ID: A foreign key that references the IGP_AC_ACCOUNTS table, identifying the specific account being classified.
• ACC_CLASSIFICATION_CODE: A VARCHAR2(30) field storing the actual classification value (e.g., Faculty, Staff) that defines the account's role or type.
• ACCESS_EXPIRATION_DATE: A DATE column that controls the validity period of the assigned classification, allowing for automated de-provisioning or role changes.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Provide full audit trail for record creation and modifications.
• OBJECT_VERSION_NUMBER: Supports optimistic locking and data integrity in environments with concurrent access.

Common Use Cases and Queries

This table is central to reporting and administrative functions related to account management. A common operational query retrieves all current classifications for a specific account or set of accounts, often joining to the main accounts table for descriptive information. For access review and compliance, administrators frequently run reports to identify accounts with classifications that have expired or are nearing expiration based on the ACCESS_EXPIRATION_DATE. The table is also queried to list all accounts belonging to a specific classification, such as all 'Student' accounts, for bulk operations or security audits.

Sample Query: Find Active Classifications for an Account
SELECT acc_classification_code, access_expiration_date FROM igs.igp_ac_acc_classes WHERE account_id = :p_account_id AND (access_expiration_date IS NULL OR access_expiration_date >= SYSDATE);

Sample Query: List All Accounts with an Expired 'Staff' Classification
SELECT a.account_number, c.acc_classification_code, c.access_expiration_date FROM igs.igp_ac_acc_classes c, igs.igp_ac_accounts a WHERE c.account_id = a.account_id AND c.acc_classification_code = 'Staff' AND c.access_expiration_date < SYSDATE;

Related Objects

The IGP_AC_ACC_CLASSES table maintains a direct foreign key relationship with the core accounts table, establishing its dependency within the data model.

• Primary Key: IGP_AC_ACC_CLASSES_PK on the ACC_CLASSIFICATION_ID column.
• Foreign Key (References): The ACCOUNT_ID column is a foreign key that references the IGS.IGP_AC_ACCOUNTS table. This enforces referential integrity, ensuring every classification record is linked to a valid account.
• Additional Index: The non-unique index IGP_AC_ACC_CLASSES_U1 on (ACCOUNT_ID, ACC_CLASSIFICATION_CODE) optimizes queries that search by account and classification code.