Search Results igs_pe_persenc_effct




Overview
Explore in AI Chat

Overview

The IGS_PE_PERSENC_EFFCT table is a core data entity within the Oracle E-Business Suite's now-obsolete Student System (IGS) module. It serves as the central repository for recording the specific administrative effects or sanctions imposed on a student as a consequence of an active encumbrance. An encumbrance is a formal restriction or hold placed on a student's record, often due to disciplinary, financial, or academic reasons. This table details the concrete manifestations of those restrictions, such as exclusions from specific courses, suppression of academic transcripts, or limitations on funding eligibility. Its primary role is to enforce and track the operational impact of encumbrances on a student's academic journey within the system.

Key Information Stored

The table's structure is designed to uniquely identify an effect within the context of a specific person and encumbrance. Its composite primary key is critical for this linkage. Key columns include the PERSON_ID, ENCUMBRANCE_TYPE, and PEN_START_DT, which together reference the parent encumbrance record in IGS_PE_PERS_ENCUMB. The S_ENCMB_EFFECT_TYPE defines the category of the effect (e.g., 'COURSE_EXCLUSION', 'TRANSCRIPT_SUPPRESSION'), linking to the IGS_EN_ENCMB_EFCTTYP table. The PEE_START_DT and SEQUENCE_NUMBER provide further granularity to manage multiple effects of the same type. Additional columns, such as RESTRICTED_ATTENDANCE_TYPE, store effect-specific parameters, linking to tables like IGS_EN_ATD_TYPE_ALL to define which attendance modes are restricted.

Common Use Cases and Queries

A primary use case is generating reports to audit active student sanctions or to validate business rules during academic processes like course enrollment or transcript generation. For instance, a process checking if a student can enroll in a course would query this table for active 'COURSE_EXCLUSION' effects. A common SQL pattern involves joining to the person and encumbrance tables to get a full context.

  • Sample Query: To find all active course exclusion effects for a student: SELECT * FROM IGS_PE_PERSENC_EFFCT pee JOIN IGS_PE_PERS_ENCUMB pen ON pee.person_id = pen.person_id AND pee.encumbrance_type = pen.encumbrance_type AND pee.pen_start_dt = pen.start_dt WHERE pee.person_id = :stu_id AND pee.s_encmb_effect_type = 'COURSE_EXCLUSION' AND SYSDATE BETWEEN pen.start_dt AND NVL(pen.expiry_dt, SYSDATE+1);
  • Administrative staff use this data to manage holds, while system batch jobs reference it to automatically enforce restrictions in related modules.

Related Objects

IGS_PE_PERSENC_EFFCT maintains extensive foreign key relationships, acting as a parent table for several specific exclusion subtypes and as a child to master definition tables. The documented relationships are:

These child tables store additional attributes specific to each effect type, creating a normalized model where IGS_PE_PERSENC_EFFCT holds the common header information.

  • Table: IGS_PE_PERSENC_EFFCT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PE_PERSENC_EFFCT,  object_name:IGS_PE_PERSENC_EFFCT,  status:VALID,  product: IGS - Student System ,  description: This entity describes the effects which are imposed on a person (or one or their courses) as part on an encumbrance. eg. course exclusion, suppression of transcript. ,  implementation_dba_data: IGS.IGS_PE_PERSENC_EFFCT , 

  • Table: IGS_PE_FUND_EXCL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PE_FUND_EXCL,  object_name:IGS_PE_FUND_EXCL,  status:VALID,  product: IGS - Student System ,  description: Person Hold Effect Fund Exclusion Details. ,  implementation_dba_data: IGS.IGS_PE_FUND_EXCL , 

  • Table: IGS_PE_PERS_UNT_EXCL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PE_PERS_UNT_EXCL,  object_name:IGS_PE_PERS_UNT_EXCL,  status:VALID,  product: IGS - Student System ,  description: This entity describes a unit which a student has been excluded from. ,  implementation_dba_data: IGS.IGS_PE_PERS_UNT_EXCL , 

  • Table: IGS_PE_UNT_SET_EXCL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PE_UNT_SET_EXCL,  object_name:IGS_PE_UNT_SET_EXCL,  status:VALID,  product: IGS - Student System ,  description: This entity describes a unit set which a student has been excluded from. ,  implementation_dba_data: IGS.IGS_PE_UNT_SET_EXCL , 

  • Table: IGS_PE_CRS_GRP_EXCL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PE_CRS_GRP_EXCL,  object_name:IGS_PE_CRS_GRP_EXCL,  status:VALID,  product: IGS - Student System ,  description: This entity describes a course group from which a person has been excluded. ,  implementation_dba_data: IGS.IGS_PE_CRS_GRP_EXCL , 

  • Table: IGS_EN_ENCMB_EFCTTYP 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_ENCMB_EFCTTYP,  object_name:IGS_EN_ENCMB_EFCTTYP,  status:VALID,  product: IGS - Student System ,  description: This entity describes the encumbrance effects recognized by the system, and available for application to a student. e.g. Suppression of transcript, maximum enrollment load restriction. ,  implementation_dba_data: IGS.IGS_EN_ENCMB_EFCTTYP , 

  • Table: IGS_PE_UNT_REQUIRMNT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PE_UNT_REQUIRMNT,  object_name:IGS_PE_UNT_REQUIRMNT,  status:VALID,  product: IGS - Student System ,  description: Describes units that are required to be studied by the student as part of a hold ,  implementation_dba_data: IGS.IGS_PE_UNT_REQUIRMNT , 

  • View: IGSBV_PERSON_HOLD_EFFECTS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_PERSON_HOLD_EFFECTS,  object_name:IGSBV_PERSON_HOLD_EFFECTS,  status:VALID,  product: IGS - Student System ,  description: contains the effects which are imposed on a person (or one or their courses) as part on a hold. eg. course exclusion, suppression of transcript. ,  implementation_dba_data: APPS.IGSBV_PERSON_HOLD_EFFECTS , 

  • Table: IGS_PE_COURSE_EXCL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PE_COURSE_EXCL,  object_name:IGS_PE_COURSE_EXCL,  status:VALID,  product: IGS - Student System ,  description: This entity defines a course which a student has been excluded from. e.g. block admission to a course for an applicant. ,  implementation_dba_data: IGS.IGS_PE_COURSE_EXCL , 

  • Table: IGS_PE_PERS_ENCUMB 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PE_PERS_ENCUMB,  object_name:IGS_PE_PERS_ENCUMB,  status:VALID,  product: IGS - Student System ,  description: This entity describes the encumbrances placed on an applicant/student e.g. overdue parking fines, unpaid fees, failure to return library books. ,  implementation_dba_data: IGS.IGS_PE_PERS_ENCUMB , 

  • Table: IGS_EN_ATD_TYPE_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_ATD_TYPE_ALL,  object_name:IGS_EN_ATD_TYPE_ALL,  status:VALID,  product: IGS - Student System ,  description: Describes available university program attendance types ,  implementation_dba_data: IGS.IGS_EN_ATD_TYPE_ALL , 

  • View: IGSFV_PERSON_HOLD_EFFECTS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PERSON_HOLD_EFFECTS,  object_name:IGSFV_PERSON_HOLD_EFFECTS,  status:VALID,  product: IGS - Student System ,  description: This entity describes the effects which are imposed on a person (or one or their courses) as part on a hold. e.g. course exclusion, suppression of transcript. ,  implementation_dba_data: APPS.IGSFV_PERSON_HOLD_EFFECTS ,