eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGS.IGS_PE_STATISTICS

Object Details

Object Name:	IGS_PE_STATISTICS
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_PE_STATISTICS
Subobject Name:
Status:	VALID

IGS_PE_STATISTICS describes the statistical information collected about a person, for example, aboriginal & torres strait islander indicator.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PE_STATISTICS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID START_DT
IGS_PE_STATISTICS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ABORIG_TORRES_CD
IGS_PE_STATISTICS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CITIZENSHIP_CD
IGS_PE_STATISTICS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERM_RESIDENT_CD

Columns

Name	Datatype	Length	Mandatory	Comments
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
PERSON_ID	NUMBER	(15)	Yes	Describes the ID that uniquely identifies a person
START_DT	DATE		Yes	Describes the date from that the statistical information collected about a person is effective
END_DT	DATE			Describes the date the statistical information collected about a person is no longer effective
ABORIG_TORRES_CD	VARCHAR2	(10)		Describes the Australian Aboriginal or Torres Strait Islander status of the student, as described in the Higher Education Student Data Collection DETYA 1997, Element No. 316.
CITIZENSHIP_CD	VARCHAR2	(10)		Describes the Citizenship or Residence status in Australia of the student. One of the set of Government-defined Citizenship/Residency codes described in the Higher Education Student Data Collection DETYA 1997, Element No. 358.
BIRTH_COUNTRY_CD	VARCHAR2	(10)		Describes the student's Country of Birth. One of the set of Government-defined country codes described in the Higher Education Student Data Collection DETYA 1997, Element No. 346.
HOME_LANGUAGE_CD	VARCHAR2	(10)		Describes whether the student speaks a language other than English at their permanent home residence and gives the language code. One of the set of Government-defined language codesdescribed in the Higher Education Student Data Collection DETYA 1997, Element No. 348.
TERM_LOCATION_POSTCODE	NUMBER	(4)		Describes the Australian Postcode of a student's Permanent Home Residence as described in the Higher Education Student Data Collection DETYA 1997, Element No. 319.
TERM_LOCATION_COUNTRY	VARCHAR2	(10)		Describes the overseas Country code of a student's Permanent Home Residence as described in the Higher Education Student Data Collection DETYA 1997, Element No. 319.
HOME_LOCATION_POSTCODE	NUMBER	(4)		Describes the Australian Postcode of a student's Permanent Home Residence as described in the Higher Education Student Data Collection DETYA 1997, Element No. 320.
HOME_LOCATION_COUNTRY	VARCHAR2	(10)		Describes the overseas Country code of a student's Permanent Home Residence as described in the Higher Education Student Data Collection DETYA 1997, Element No. 320.
YR_ARRIVAL	VARCHAR2	(4)		Describes the year in which a student who was not born in Australia first arrived in Australia, as described in Higher Education Student Data Collection DETYA 1997, Element No. 347.
PRIOR_UG_INST	VARCHAR2	(30)		Identifies, for a student commencing postgraduate work, the institution at which the undergraduate work was done, as described in Higher Education Student Data Collection DETYA 1997, Element No. 356.
PRIOR_OTHER_QUAL	VARCHAR2	(5)		Indicates whether the student had completed some other qualification or certificate of attainment or competence and the year in which the requirements were met, as described in the Higher Education Student Data Collection DETYA 1997
PRIOR_POST_GRAD	VARCHAR2	(5)		Indicates whether student had commenced and completed a Higher Doctorate, Doctorate degree or other post-graduate program and the last year in which the student was enrolled in such a program
PRIOR_DEGREE	VARCHAR2	(5)		Indicates whether the student had commenced and completed a Bachelor degree program and the last year in which the student was enrolled in such a program, as described in the Higher EducationStudent Data Collection DETYA 1997, Element No. 360.
PRIOR_SUBDEG_NOTAFE	VARCHAR2	(5)		Indicates whether student had commenced and completed a Diploma or Associate Diploma program at an institution other than a TAFE and the last year in which the student was enrolled in such a program
PRIOR_SUBDEG_TAFE	VARCHAR2	(5)		Indicates whether student had commenced and completed a Diploma or Associate Diploma program at a TAFE and the last year in which the student was enrolled in such a program, as described in the Higher Education Student Data Collection DETYA 1997, Element No. 362.
PRIOR_SECED_TAFE	VARCHAR2	(5)		Indicates whether student had completed the final year of secondary schooling at a TAFE college, CAE. and the year in which study was completed, as described in the Higher Education Student Data Collection DETYA 1997, Element No. 364.
PRIOR_TAFE_AWARD	VARCHAR2	(5)		Indicates whether student had commenced and completed a program other than a Diploma or an Associate Diploma at a TAFE and the last year in which the student was enrolled in such a program, as described in the Higher Education Student Data Collection DETYA 1997, Element No. 363.
PRIOR_SECED_SCHOOL	VARCHAR2	(5)		Indicates whether student had completed the final year of secondary schooling at a high school, technical school, secondary school or secondary college and the year in which study was completed, as described in the Higher Education Student Data Collection DETYA 1997, Element No. 365.
PERM_RESIDENT_CD	VARCHAR2	(10)		Describes the permanent residence status of the student. One of a set of Government-defined Permanent Resident codes described in the Higher Education Student Data CollectionDETYA 1997, Element No. 390.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PERSON_ID
,      START_DT
,      END_DT
,      ABORIG_TORRES_CD
,      CITIZENSHIP_CD
,      BIRTH_COUNTRY_CD
,      HOME_LANGUAGE_CD
,      TERM_LOCATION_POSTCODE
,      TERM_LOCATION_COUNTRY
,      HOME_LOCATION_POSTCODE
,      HOME_LOCATION_COUNTRY
,      YR_ARRIVAL
,      PRIOR_UG_INST
,      PRIOR_OTHER_QUAL
,      PRIOR_POST_GRAD
,      PRIOR_DEGREE
,      PRIOR_SUBDEG_NOTAFE
,      PRIOR_SUBDEG_TAFE
,      PRIOR_SECED_TAFE
,      PRIOR_TAFE_AWARD
,      PRIOR_SECED_SCHOOL
,      PERM_RESIDENT_CD
FROM IGS.IGS_PE_STATISTICS;

Dependencies

[top of page]

IGS.IGS_PE_STATISTICS does not reference any database object

IGS.IGS_PE_STATISTICS is referenced by following:

APPS: IGS_PE_STATISTICS