Search Results igs_pe_usr_adisc_all




Overview
Explore in AI Chat

Overview

The table IGS_PE_USR_ADISC_ALL is a historical data object within the Oracle E-Business Suite (EBS) Student System (IGS). As explicitly noted in its documentation, this table is marked as obsolete. Its intended role was to store configuration data related to self-service user activity setups for managing discontinuation date aliases. This would have involved linking specific person types and administrative unit statuses to rules or settings governing how discontinuation dates were handled within the student information system. Critically, the provided metadata states the table was "Not implemented in this database," indicating it may have been part of a design specification or an early version that was never deployed in production instances of EBS 12.1.1 or 12.2.2.

Key Information Stored

Based on the documented primary and foreign key structure, the table was designed to hold relationship data keyed by specific identifiers. The primary columns include USR_ACT_DISC_ID as a unique system identifier. The logical business key, defined by the UK1 unique key, consisted of PERSON_TYPE, ADMINISTRATIVE_UNIT_STATUS, and ORG_ID. This structure suggests the table's purpose was to define valid or configured combinations of a student or person type, a status within an administrative unit (like an academic department or school), and an operating unit (ORG_ID) for the purpose of discontinuation processes. The table did not contain the actual discontinuation dates but rather the setup rules for them.

Common Use Cases and Queries

Given its obsolete and unimplemented status, there are no active use cases for this table in a production EBS environment. In a historical or data migration context, one might query it only to confirm the absence of data or understand an old data model. A sample query to retrieve any legacy setup rules would follow the structure of its unique key:

  • SELECT usr_act_disc_id, person_type, administrative_unit_status, org_id FROM igs_pe_usr_adisc_all WHERE org_id = :p_org_id ORDER BY person_type;

Any reporting or business logic requiring discontinuation date alias configuration in implemented versions of EBS 12.1.1 or 12.2.2 would utilize alternative, active tables or setups within the Student System module.

Related Objects

The foreign key constraints documented for IGS_PE_USR_ADISC_ALL reveal its intended relationships within the obsolete IGS data model. It was designed to reference two key master tables:

  • IGS_AD_ADM_UNIT_STAT_ALL: This table likely stored the valid statuses for administrative units, providing the source values for the ADMINISTRATIVE_UNIT_STATUS column.
  • IGS_PE_PERSON_TYPES: This table defined the various categories of persons (e.g., prospective student, enrolled student, alumnus) within the system, providing the source values for the PERSON_TYPE column.

Since IGS_PE_USR_ADISC_ALL was not implemented, dependencies from other application objects such as views or APIs would not exist in a standard installation.

  • Table: IGS_PE_USR_ADISC_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PE_USR_ADISC_ALL,  object_name:IGS_PE_USR_ADISC_ALL,  status:VALID,  product: IGS - Student System ,  description: Obsolete - Contains all the columns related to self service user activity setup for discontinuation date alias ,  implementation_dba_data: IGS.IGS_PE_USR_ADISC_ALL , 

  • Table: IGS_PE_PERSON_TYPES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PE_PERSON_TYPES,  object_name:IGS_PE_PERSON_TYPES,  status:VALID,  product: IGS - Student System ,  description: Captures the different person types. This table is modified to capture the enrollment method type related to self service. ,  implementation_dba_data: IGS.IGS_PE_PERSON_TYPES , 

  • Table: IGS_AD_ADM_UNIT_STAT_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AD_ADM_UNIT_STAT_ALL,  object_name:IGS_AD_ADM_UNIT_STAT_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes user-defined administrative unit statuses that map to system-defined unit statues, which are system and manually applied ,  implementation_dba_data: IGS.IGS_AD_ADM_UNIT_STAT_ALL , 

  • View: IGS_PE_USR_ADISC 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PE_USR_ADISC,  object_name:IGS_PE_USR_ADISC,  status:VALID,  product: IGS - Student System ,  description: Obsolete - Describes all the columns related to self service user activity setup for discontinuation date alias ,  implementation_dba_data: APPS.IGS_PE_USR_ADISC ,