Results for “prior_ug_inst”

11 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PE_STATISTICS is a table in the IGS (Student System) product schema of Oracle E-Business Suite, documented as VALID in both release 12.1.1 and 12.2.2. It stores statistical and demographic information collected about a person — for example, the Aboriginal and Torres Strait Islander indicator — and is therefore a core reference for regulatory, equity, and reporting requirements in institutions that use Oracle Student System. Each row represents a dated snapshot of a person's statistical attributes, with the combination of PERSON_ID and START_DT defining the effective period of the record.

Under the heuristic Data Vault classification mined from its foreign key structure, this table is modelled as a link. It connects a person (via HZ_PARTIES) to a set of coded reference entities such as country, language, citizenship, permanent residency, and Aboriginal/Torres Strait Islander codes. In practice it also behaves as a satellite, since it carries descriptive, time-varying attributes (START_DT, END_DT) around the person hub.

Key Information Stored

The table contains 27 documented columns. Its primary key, IGS_PE_STATISTICS_PK, is the composite (PERSON_ID, START_DT), and a unique index IGS_PE_STATISTICS_U1 covers the same pair — making (PERSON_ID, START_DT) the business-key candidate rather than a generated surrogate. The most significant columns are:

Common Use Cases and Queries

Typical uses include equity reporting, government statistical returns, admissions assessment, and student cohort analysis. A common pattern resolves the current valid record for a person:

  • Filter on PERSON_ID and an effective date: WHERE PERSON_ID = :p AND :eff BETWEEN START_DT AND NVL(END_DT, TO_DATE('4712-12-31','YYYY-MM-DD')).
  • Join coded lookups to obtain descriptions, e.g. IGS_PE_ABORG_TORESCD for the Aboriginal/Torres Strait indicator.
  • Aggregate counts of citizenship or permanent residency for enrolment statistics.
  • Reconcile prior-education columns against admissions records for articulation analysis.

Related Objects

  • HZ_PARTIES — person master; joined on PERSON_ID.
  • IGS_PE_ABORG_TORESCD — joined on ABORIG_TORRES_CD.
  • IGS_ST_CITIZENSHP_CD — joined on CITIZENSHIP_CD.
  • IGS_PE_COUNTRY_CD — joined on BIRTH_COUNTRY_CD, HOME_LOCATION_COUNTRY, and TERM_LOCATION_COUNTRY.
  • IGS_PE_LANGUAGE_CD — joined on HOME_LANGUAGE_CD.
  • IGS_PE_PERM_RES_CD — joined on PERM_RESIDENT_CD.
  • IGS_PE_SUBURB_POSTCD — joined on HOME_LOCATION_POSTCODE.