Search Results igs_sc_usr_att_vals_pk

Overview

The IGS_SC_USR_ATT_VALS table is a core data repository within the Oracle E-Business Suite (EBS) Student System (IGS). It functions as the central storage mechanism for user-specific security attribute values. In the context of EBS security and the Student System's data access controls, this table enables the association of dynamic, user-defined attribute values to individual users. These attributes, defined in the related IGS_SC_USR_ATTRIBS table, are used to create granular, attribute-based security rules and data partitioning within the application, often controlling access to specific student records, academic programs, or organizational data based on a user's profile.

Key Information Stored

The table's structure is designed to link a user, an attribute definition, and a specific value. The primary key is a composite of three columns, ensuring a unique combination for each user-attribute-value assignment. The critical columns are:

• USER_ATTRIB_ID: A foreign key referencing IGS_SC_USR_ATTRIBS. This identifies the specific security attribute (e.g., "Institution", "Faculty", "Department") for which a value is being stored.
• USER_ID: A foreign key referencing FND_USER. This links the attribute value to a specific EBS application user.
• ATTR_VALUE: The actual data value assigned to the user for the specified attribute (e.g., "BUS" for a Business department code). This column, combined with the USER_ATTRIB_ID and USER_ID, forms the table's primary key.

Common Use Cases and Queries

This table is primarily accessed for user security validation and reporting on security assignments. A common operational use case is an application function or a view using a Security Profile (VPD - Virtual Private Database) that queries this table to filter data a user can see based on their assigned attribute values. For system administration, queries are used to audit or manage user security settings. A typical pattern retrieves all attribute values for a specific user:

SELECT uav.attr_value, ua.attrib_name FROM igs_sc_usr_att_vals uav, igs_sc_usr_attribs ua WHERE uav.user_attrib_id = ua.user_attrib_id AND uav.user_id = 1234;

Conversely, to find all users assigned a specific attribute value (e.g., for a departmental report):

SELECT fu.user_name FROM igs_sc_usr_att_vals uav, fnd_user fu WHERE uav.user_id = fu.user_id AND uav.user_attrib_id = 100 AND uav.attr_value = 'ENG';

Related Objects

IGS_SC_USR_ATT_VALS is a child table in two key relationships within the EBS data model, as documented by its foreign keys:

• FND_USER: The foundational EBS table storing all application users. The relationship is maintained via the IGS_SC_USR_ATT_VALS.USER_ID column referencing FND_USER.USER_ID. This ensures attribute values are tied to valid user accounts.
• IGS_SC_USR_ATTRIBS: The parent table defining the security attributes themselves. The relationship is through the IGS_SC_USR_ATT_VALS.USER_ATTRIB_ID column referencing IGS_SC_USR_ATTRIBS.USER_ATTRIB_ID. This ensures every stored value corresponds to a valid, predefined attribute.

These relationships are critical for maintaining referential integrity and for any join operation required to translate ID values into human-readable user names and attribute descriptions for reporting and application logic.