Results for “igs_pe_statistics”
50+ 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:
- PERSON_ID — identifies the individual; joins to HZ_PARTIES.
- START_DT / END_DT — effective dating that bounds the validity of the statistical record.
- ABORIG_TORRES_CD — Aboriginal and Torres Strait Islander indicator (foreign key to IGS_PE_ABORG_TORESCD).
- CITIZENSHIP_CD — citizenship status (foreign key to IGS_ST_CITIZENSHP_CD).
- BIRTH_COUNTRY_CD — country of birth (foreign key to IGS_PE_COUNTRY_CD).
- PERM_RESIDENT_CD — permanent residency indicator (foreign key to IGS_PE_PERM_RES_CD).
- HOME_LANGUAGE_CD — language spoken at home (foreign key to IGS_PE_LANGUAGE_CD).
- HOME_LOCATION_POSTCODE / HOME_LOCATION_COUNTRY — residence geography.
- TERM_LOCATION_POSTCODE / TERM_LOCATION_COUNTRY — in-term location geography.
- YR_ARRIVAL — year of arrival in the country.
- PRIOR_* columns (e.g., PRIOR_UG_INST, PRIOR_DEGREE, PRIOR_TAFE_AWARD, PRIOR_SECED_SCHOOL) — prior education and institution history.
- Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
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_TORESCDfor 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.
-
This entity describes the statistical information collected about a person. eg. Aboriginal & Torres Strait Islander Indicator.
-
TABLE: IGS.IGS_PE_STATISTICS 12.1.1
-
Table: IGS_PE_STATISTICS 12.2.2
This entity describes the statistical information collected about a person. eg. Aboriginal & Torres Strait Islander Indicator.
Not implemented in this database·Explore IGS module →
-
Table: IGS_PE_COUNTRY_CD 12.2.2
This entity describes the available list of user-defined country codes.
Not implemented in this database·Explore IGS module →
-
Table: IGS_PE_SUBURB_POSTCD 12.2.2
This entity is information obtained from Australia Post mapping suburbs to postcodes and will be loaded and updated annually. The data supplied is, as yet, undefined.
Not implemented in this database·Explore IGS module →
-
PACKAGE: APPS.IGS_EN_VAL_SP 12.1.1
-
PACKAGE: APPS.IGS_EN_VAL_CNC 12.1.1
-
PACKAGE: APPS.IGS_EN_VAL_LC 12.1.1
-
PACKAGE: APPS.IGS_OR_VAL_INS 12.1.1
-
Table: IGS_PE_PERM_RES_CD 12.2.2
This entity describes the permanent residence code
Not implemented in this database·Explore IGS module →
-
Table: IGS_ST_CITIZENSHP_CD 12.2.2
This entity describes the available user defined citizenship codes.
Not implemented in this database·Explore IGS module →
-
Table: IGS_PE_LANGUAGE_CD 12.2.2
This entity describes the available list of user-defined language codes.
Not implemented in this database·Explore IGS module →
-
Table: IGS_PE_ABORG_TORESCD 12.2.2
This entity describes the available user-defined list of aboriginal and torres strait islander codes.
Not implemented in this database·Explore IGS module →
-
PACKAGE: APPS.IGS_ST_GEN_002 12.1.1
-
PACKAGE: APPS.IGS_ST_GEN_003 12.1.1