Results for “home_location_postcode”
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:
- 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.
-
PACKAGE: APPS.IGS_EN_VAL_SP 12.1.1
-
TABLE: IGS.IGS_PE_STATISTICS 12.1.1
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.