Search Results igs_pe_statistics




Overview
Explore in AI Chat

Overview

The IGS_PE_STATISTICS table is a core entity within the Oracle E-Business Suite Student System (IGS) in versions 12.1.1 and 12.2.2. It serves as the central repository for storing demographic and statistical information collected about a person, which is critical for institutional reporting, government compliance, and student services. Its primary role is to maintain a historical record of a person's key statistical attributes, such as citizenship, indigenous status, and language, which can change over time. The table's design, with a composite primary key on PERSON_ID and START_DT, explicitly supports this temporal tracking, allowing the system to store multiple records for an individual with different effective date ranges.

Key Information Stored

The table stores a wide array of demographic data points linked to a person. The primary key consists of PERSON_ID, which links to the HZ_PARTIES table in the Trading Community Architecture (TCA) foundation, and START_DT, which marks the effective date of the statistical record. Critical foreign key columns define specific attributes by referencing dedicated code tables. These include ABORIG_TORRES_CD for Aboriginal and Torres Strait Islander status, CITIZENSHIP_CD, BIRTH_COUNTRY_CD, and PERM_RESIDENT_CD for permanent residency details. Location data is captured through columns like HOME_LOCATION_COUNTRY, TERM_LOCATION_COUNTRY, and HOME_LOCATION_POSTCODE. The HOME_LANGUAGE_CD column records the person's primary language. Each of these columns enforces data integrity and standardizes values through its respective foreign key constraint.

Common Use Cases and Queries

This table is fundamental for generating mandatory government statistical reports, such as those required for higher education data collection in regions like Australia. It is also queried for internal diversity reporting, enrollment analytics, and student support service targeting. A common reporting pattern involves joining the current effective record for a person to their primary biographical data. For example, to list all current students with specific demographic criteria, a query might join IGS_PE_STATISTICS to student enrollment tables via PERSON_ID, filtering for the most recent START_DT that is less than or equal to SYSDATE. Another typical use case is auditing changes in a student's citizenship or indigenous status over time by selecting all records for a given PERSON_ID ordered by START_DT. Data from this table is often surfaced through dedicated student information system forms and institutional reporting tools.

Related Objects

The IGS_PE_STATISTICS table has extensive relationships within the IGS schema, primarily as a consumer of reference data. The documented foreign key relationships are as follows:

  • HZ_PARTIES on column PERSON_ID: This is the foundational link to the person's master record in the TCA model.
  • IGS_PE_ABORG_TORESCD on column ABORIG_TORRES_CD: References codes for Aboriginal and Torres Strait Islander status.
  • IGS_ST_CITIZENSHP_CD on column CITIZENSHIP_CD: References valid citizenship codes.
  • IGS_PE_COUNTRY_CD on columns BIRTH_COUNTRY_CD, HOME_LOCATION_COUNTRY, and TERM_LOCATION_COUNTRY: References the country code lookup.
  • IGS_PE_LANGUAGE_CD on column HOME_LANGUAGE_CD: References the language code lookup.
  • IGS_PE_PERM_RES_CD on column PERM_RESIDENT_CD: References permanent residency status codes.
  • IGS_PE_SUBURB_POSTCD on column HOME_LOCATION_POSTCODE: References the postal code and suburb lookup table.

These relationships ensure that all statistical data adheres to institutional and governmental code standards.