Search Results matr_sequence_number

Overview

The IGS_PE_STAT_DETAILS table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically architected for the Oracle Student Management (formerly Campus Solutions) product family under the IGS schema. Its primary function is to store historical and current statistical details pertaining to a person, typically a student, within the institution's system. The table is designed to track time-sensitive attributes by utilizing effective dating columns (EFFECTIVE_START_DATE, EFFECTIVE_END_DATE), allowing for a longitudinal view of a person's demographic and administrative status over time. Its role is integral to student profiling, compliance reporting, and eligibility determinations, such as in-state tuition status.

Key Information Stored

The table's columns can be categorized into several key data areas. The primary identifier is PERSON_ID, which links to the core person record. Temporal validity is managed through EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. A significant portion of the table's original design has been marked obsolete in later versions, including fields for religion (RELIGION_ID), residence (RESID_STAT_ID, STATE_OF_RESIDENCE), and socio-economic status (SOCIO_ECO_ID). The user's search for "socio_eco_cd" aligns with the obsolete SOCIO_ECO_ID column, which was intended to hold a foreign key identifier for socio-economic classification. Active and commonly used columns include IN_STATE_TUITION (a flag), TUITION_ST_DATE, TUITION_END_DATE for managing residency-based tuition eligibility, and academic term identifiers for matriculation (MATR_CAL_TYPE, MATR_SEQUENCE_NUMBER), initial admittance, and most recent admittance.

Common Use Cases and Queries

This table supports critical operational and reporting needs. A primary use case is verifying a student's eligibility for in-state tuition rates during a specific academic period. Another is generating historical reports on student demographics or admission trends based on matriculation terms. Common SQL queries often involve joining to the PERSON or PARTY tables and filtering by effective date ranges to find the active record for a given point in time.

• Finding a student's current in-state tuition status:
  SELECT person_id, in_state_tuition, tuition_st_date, tuition_end_date FROM igs.igs_pe_stat_details WHERE person_id = :p_person_id AND SYSDATE BETWEEN effective_start_date AND NVL(effective_end_date, SYSDATE);
• Identifying all students with a specific matriculation term:
  SELECT person_id FROM igs.igs_pe_stat_details WHERE matr_cal_type = :p_cal_type AND matr_sequence_number = :p_seq_num;

Related Objects

The table's main relationship is defined by its primary key. The UNIQUE index IGS_PE_STAT_DETAILS_U1 on PERSON_ID suggests a one-to-one relationship with a core person table, likely IGS_PE_PERSON. The obsolete foreign key columns (e.g., SOCIO_ECO_ID, RELIGION_ID, FURTHER_EDUCATION_ID) would have historically referenced corresponding lookup tables within the IGS schema, though these relationships may be inactive in standard deployments. The table is also a likely source for various student information views and is accessed by APIs within the Student Management modules for creating and updating person statistical profiles.