Results for “attr_value”

2 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS_SC_USR_ATT_VALS table is a core data object within the Oracle E-Business Suite Student System (IGS) product family. Its documented purpose is to store information related to Security User Attribute Values that are associated with the user attributes defined in the system. In practical terms, this table acts as the assignment mechanism that binds a specific attribute value to a specific application user, enabling attribute-driven security and personalization within the Student System module.

The object is owned by the IGS schema and is documented as VALID in both the 12.1.1 and 12.2.2 releases. It is a physical database table with eight documented columns. The ETRM metadata classifies the object heuristically as a link table in Data Vault modeling terms. This classification is derived from the foreign key structure, which shows the table resolving relationships between independent entities rather than acting as a standalone hub or a descriptive satellite. Readers should treat this classification as a modeling suggestion rather than a prescriptive design constraint.

Key Information Stored

The table stores the intersection of users, user attributes, and the values assigned to those attributes. The following columns carry the substantive business meaning:

  • USER_ATTRIB_ID — Identifies the user attribute definition to which a value is being assigned. This column participates in the primary key and references IGS_SC_USR_ATTRIBS.
  • USER_ID** — Identifies the application user receiving the attribute value. This column participates in the primary key and references FND_USER.
  • ATTR_VALUE** — Holds the actual attribute value assigned to the user for the given attribute definition. This column completes the primary key.
  • CREATION_DATE, CREATED_BY — Standard Oracle EBS audit columns capturing when and by whom the row was inserted.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN** — Standard audit columns recording the most recent modification, the modifying user, and the login context of that change.

The primary key is documented as IGS_SC_USR_ATT_VALS_PK, composed of USER_ATTRIB_ID, USER_ID, and ATTR_VALUE. The unique index IGS_SC_USR_ATT_VALS_PK is also documented as a business-key candidate over USER_ID, USER_ATTRIB_ID, and ATTR_VALUE, confirming that no duplicate combination of user, attribute, and value may exist. The table does not employ a single-column surrogate key beyond the composite primary key; the three business columns together serve as the unique identifier.

Common Use Cases and Queries

Typical scenarios involve retrieving the attribute values that drive security decisions for a given user, or auditing which users hold a particular attribute value.

  • Resolving a user's security profile: join IGS_SC_USR_ATT_VALS to FND_USER on USER_ID and to IGS_SC_USR_ATTRIBS on USER_ATTRIB_ID to enumerate all attributes and values for a user.
  • Attribute-based reporting: query ATTR_VALUE distribution to determine how many users are assigned a given attribute value.
  • Audit and reconciliation: review CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE to trace when attribute assignments changed and by whom.

A representative query pattern:

SELECT u.user_name, a.attribute_name, v.attr_value FROM igs_sc_usr_att_vals v, fnd_user u, igs_sc_usr_attribs a WHERE v.user_id = u.user_id AND v.user_attrib_id = a.user_attrib_id AND u.user_name = :p_user;

Related Objects

The FK metadata identifies the tables on which this object depends:

  • FND_USER — referenced via IGS_SC_USR_ATT_VALS.USER_ID; supplies the application user identity.
  • IGS_SC_USR_ATTRIBS — referenced via IGS_SC_USR_ATT_VALS.USER_ATTRIB_ID; defines the user attribute being valued.

These two parent tables are the principal related objects. Any view, concurrent program, or API that surfaces user attribute assignments in the Student System will depend on IGS_SC_USR_ATT_VALS as the linking table between them.