Results for “igs_pe_usr_aval”

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

Overview

IGS_PE_USR_AVAL is an APPS-owned, VALID database view within the IGS Student System product of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. The view describes all columns related to self-service user activity setup for enrollment validations. It is the reporting and integration surface used to expose the configuration that governs how a self-service user (typically a student or applicant) is permitted to progress through enrollment steps and how override behavior is applied at each validation point.

Functionally, the view answers the question of which person types are allowed, warned, or denied at a given enrollment step, and whether an override is possible. Because it resolves the coded validation value against human-readable lookup meanings, it is well suited to operational reporting, troubleshooting of self-service enrollment behavior, and downstream integration extracts that need descriptive rather than coded values. It is a secured (ORG_ID filtered) view, and access is restricted at runtime by the Multi-Org client information set for the session.

Underlying Base Objects

The view is defined over two base objects:

• IGS_PE_USR_AVAL_ALL — aliased as UAV. This is the multi-org enabled table that stores the actual self-service user activity validation setup, including the person type, validation code, deny/warn indicator, override flags, and step override limit.
• IGS_LOOKUP_VALUES — aliased as LKV. This is the standard IGS lookup values table, joined on LOOKUP_CODE = UAV.VALIDATION to translate the coded validation into its MEANING.

The join is constrained to lookup types 'ENROLMENT_STEP_TYPE_EXT' or 'ENROLMENT_OVR_STEP_TYPE' and excludes closed lookups (CLOSED_IND <> 'Y'). The WHERE clause also applies organization security by comparing the row's ORG_ID against the ORG_ID derived from USERENV('CLIENT_INFO'), defaulting to -99 when no client information is present. This means the row set returned depends on the operating unit context of the session.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_PE_USR_AVAL_ALL row, useful for direct row identification.
• USR_ACT_VAL_ID — the primary identifier for the self-service user activity validation setup record; the column the user searched for.
• PERSON_TYPE — the person type to which the validation rule applies.
• VALIDATION — the coded validation step, joined to the lookup.
• VAL_MEANING — the descriptive meaning of the validation step, drawn from IGS_LOOKUP_VALUES.
• DENY_WARN — indicates whether the validation denies progression or merely warns the user.
• OVERRIDE_IND — indicates whether an override is permitted for the validation.
• OVERRIDE_DT — the date associated with the override.
• STEP_OVERRIDE_LIMIT — the maximum number of step overrides permitted.
• ORG_ID — the operating unit that owns the row, used by the security predicate.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical uses include auditing enrollment validation setup by person type, confirming whether overrides are enabled for a step, and extracting descriptive validation data for reporting or reconciliation against self-service configuration.

Retrieve all validations for a given person type with descriptive meanings:

• SELECT usr_act_val_id, person_type, validation, val_meaning, deny_warn, override_ind FROM igs_pe_usr_aval WHERE person_type = :p_person_type;

Identify validations that deny progression but allow overrides:

• SELECT usr_act_val_id, validation, val_meaning, step_override_limit FROM igs_pe_usr_aval WHERE deny_warn = 'D' AND override_ind = 'Y';

Because the view enforces ORG_ID security through CLIENT_INFO, queries should be executed in a session with the correct operating unit context (or via a MOAC-aware tool) to return the intended rows. Note that only open lookups are surfaced, so validations tied to closed lookup codes will not appear.