Results for “igs_pe_usr_aval_all”

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

Overview

IGS_PE_USR_AVAL_ALL is a table within the Oracle E-Business Suite IGS — Student System product family. In ETRM documentation for releases 12.1.1 and 12.2.2, the module is flagged as Obsolete, meaning it belongs to a legacy product line (Oracle Student System / Oracle Student Information System) that is no longer actively marketed or shipped. The table is described as containing "all the columns related to self service user activity setup for enrollment validations." In other words, it stores configuration records that govern how self-service users are validated during enrollment activity — specifying who may proceed, which person types are affected, and whether warnings or denials apply.

The documented primary key is IGS_PE_USR_AVAL_ALL_PK, defined on the surrogate column USR_ACT_VAL_ID. A unique constraint, IGS_PE_USR_AVAL_ALL_UK1 (also documented as unique index IGS_PE_USR_AVAL_ALL_U2), covers PERSON_TYPE, VALIDATION, and ORG_ID, establishing the business key of the record. Under the heuristic Data Vault classification supplied in the metadata, the table is assessed as satellite-leaning. This suggests a modeling treatment in which the table is regarded as a descriptive attribute satellite attached to a parent business entity or person-type hub, rather than as an independent hub or a transactional link.

Key Information Stored

The physical schema documented for 12.1.1 comprises thirteen columns. The most significant are:

• USR_ACT_VAL_ID — surrogate primary key; uniquely identifies each validation setup row. Referenced by IGS_PE_USR_AVAL_ALL_PK and unique index IGS_PE_USR_AVAL_ALL_U1.
• PERSON_TYPE — foreign key to IGS_PE_PERSON_TYPES; identifies the person category (for example, applicant, student, or staff) to which the validation rule applies.
• VALIDATION — the validation code or identifier describing the enrollment check being configured.
• ORG_ID — the operating unit or organization context, enabling multi-organization isolation of validation setup. Together with PERSON_TYPE and VALIDATION, it forms the business-key candidate IGS_PE_USR_AVAL_ALL_UK1 / U2.
• DENY_WARN — flag indicating whether a failed validation results in a denial or a warning.
• OVERRIDE_IND — indicates whether the self-service user is permitted to override the validation outcome.
• OVERRIDE_DT — the date associated with any override entitlement or expiration.
• STEP_OVERRIDE_LIMIT — the numeric limit on how many times an override action may be taken at a given enrollment step.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns recording row provenance and the responsible user session.

Common Use Cases and Queries

The table supports administrative reporting of self-service enrollment validation rules. Typical queries include retrieving all validations for an organization or person type:

• Rule lookup by organization: SELECT usr_act_val_id, person_type, validation, deny_warn, override_ind FROM igs_pe_usr_aval_all WHERE org_id = :p_org_id;
• Business-key resolution: SELECT * FROM igs_pe_usr_aval_all WHERE person_type = :p_type AND validation = :p_val AND org_id = :p_org_id;
• Override governance audit: filtering on OVERRIDE_IND = 'Y' and STEP_OVERRIDE_LIMIT to identify where users may bypass enrollment checks, then joining audit columns to FND_USER for change history.

These queries are useful for functional configuration reviews, migration validation between 12.1.1 and 12.2.2, and for reconciling validation setup against the person-type reference data.

Related Objects

The FK metadata documents one explicit relationship; related dependencies follow from the business key and product family:

• IGS_PE_PERSON_TYPES — referenced through IGS_PE_USR_AVAL_ALL.PERSON_TYPE. This is the principal parent/reference table, supplying the valid person-type values joined on PERSON_TYPE.
• IGS_PE_USR_AVAL_ALL_PK / IGS_PE_USR_AVAL_ALL_UK1 — the primary and unique constraints that define row identity and the business key (PERSON_TYPE, VALIDATION, ORG_ID).
• ORG_ID reference to HR_OPERATING_UNITS — the standard EBS organization context used to scope validation setup.
• FND_USER — related indirectly through CREATED_BY and LAST_UPDATED_BY for audit attribution.
• Other IGS_PE self-service validation and activity tables that share the USR_ACT_VAL_ID surrogate identifier, forming the wider enrollment validation configuration set.

Because the module is documented as obsolete and "not implemented in this database," teams should treat these relationships as reference metadata for migrations, historical data extraction, or decommissioning analysis rather than as an active runtime dependency.