Search Results usr_act_disc_id




Overview
Explore in AI Chat

Overview

The IGS_PE_USR_ADISC_ALL table is a configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle's student system) product family. Its primary role is to manage the setup rules for user self-service activities related to student discontinuation dates. The table stores mappings that define which date alias (DISC_DT_ALIAS) should be used for a given combination of a person's type (PERSON_TYPE) and their administrative unit status (ADMINISTRATIVE_UNIT_STATUS) within a specific operating unit (ORG_ID). This configuration is critical for automating and standardizing the process of recording discontinuation events across the student lifecycle. The documentation explicitly marks this table as "Obsolete," indicating it is part of a legacy data model that may be superseded in future releases, though it remains valid and in use in the specified versions.

Key Information Stored

The table's structure is designed to enforce unique configuration rules through its primary and unique keys. The most critical columns include:

  • USR_ACT_DISC_ID: The primary key, a system-generated unique identifier for each configuration record.
  • PERSON_TYPE: Defines the category of person (e.g., a specific student type) to which the rule applies.
  • ADMINISTRATIVE_UNIT_STATUS: The status of the person within an administrative unit (e.g., college, department).
  • DISC_DT_ALIAS: The key business data; the specific date alias (a short code representing a type of date) to be used for discontinuation given the above criteria.
  • ORG_ID: The operating unit identifier, enabling the setup to be specific to an instance's multi-org structure.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): For auditing and tracking record changes.

The unique constraint IGS_PE_USR_ADISC_ALL_U2 on PERSON_TYPE, ADMINISTRATIVE_UNIT_STATUS, and ORG_ID ensures no duplicate rules are defined for the same operational context.

Common Use Cases and Queries

This table is primarily referenced by application logic to determine the correct discontinuation date field to populate when a user performs a self-service action that changes a student's status. A common reporting use case is to audit or review the configured discontinuation rules across the institution. Sample queries include:

  • Retrieving All Configuration Rules for an OU:
    SELECT PERSON_TYPE, ADMINISTRATIVE_UNIT_STATUS, DISC_DT_ALIAS
    FROM IGS.IGS_PE_USR_ADISC_ALL
    WHERE ORG_ID = :p_org_id
    ORDER BY PERSON_TYPE;
  • Identifying the Date Alias for a Specific Scenario:
    SELECT DISC_DT_ALIAS
    FROM IGS.IGS_PE_USR_ADISC_ALL
    WHERE PERSON_TYPE = 'UNDERGRADUATE'
    AND ADMINISTRATIVE_UNIT_STATUS = 'ACTIVE'
    AND ORG_ID = :p_org_id;
  • Full Record Extraction: As provided in the ETRM documentation, the standard SELECT statement includes all columns for data migration or comprehensive analysis.

Related Objects

Based on the provided dependency information, the IGS_PE_USR_ADISC_ALL table is a standalone reference table. It does not have foreign key constraints referencing other objects. However, it is referenced by an object in the APPS schema named IGS_PE_USR_ADISC_ALL. This is typically a public synonym (APPS.IGS_PE_USR_ADISC_ALL) that points to the underlying IGS table, providing a standard access point for EBS applications and custom code. The table's design, with ORG_ID and unique business key columns, suggests it is joined to person/student master data and organizational tables indirectly via application logic, using the configured DISC_DT_ALIAS to update the appropriate date field in a student's record.