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_ST_GOVT_STDNT_EN

Object Details

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

IGS_ST_GOVT_STDNT_EN describes a students enrollment details as captured at the census date for each submission of the student enrollment file to the government.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_ST_GOVT_STDNT_EN_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUBMISSION_YR SUBMISSION_NUMBER PERSON_ID COURSE_CD
IGS_ST_GOVT_STDNT_EN_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ABORIG_TORRES_CD
IGS_ST_GOVT_STDNT_EN_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOVT_ATTENDANCE_TYPE
IGS_ST_GOVT_STDNT_EN_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD
IGS_ST_GOVT_STDNT_EN_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BASIS_FOR_ADMISSION_TYPE
IGS_ST_GOVT_STDNT_EN_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOVT_BASIS_FOR_ADMISSION_TYPE
IGS_ST_GOVT_STDNT_EN_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOVT_ABORIG_TORRES_CD
IGS_ST_GOVT_STDNT_EN_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CITIZENSHIP_CD
IGS_ST_GOVT_STDNT_EN_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOVT_CITIZENSHIP_CD
IGS_ST_GOVT_STDNT_EN_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERM_RESIDENT_CD
IGS_ST_GOVT_STDNT_EN_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOVT_PERM_RESIDENT_CD
IGS_ST_GOVT_STDNT_EN_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTENDANCE_MODE
IGS_ST_GOVT_STDNT_EN_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOVT_ATTENDANCE_MODE
IGS_ST_GOVT_STDNT_EN_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTENDANCE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
SUBMISSION_YR	NUMBER	(4)	Yes	Describes the reference year of the government submission
SUBMISSION_NUMBER	NUMBER	(1)	Yes	Describes the government submission number; for example,1, 2, or 3.
PERSON_ID	NUMBER	(15)	Yes	Uniquely identifies the student within the institution and that remains constant from year to year. Government element 313.
COURSE_CD	VARCHAR2	(6)	Yes	Identifies the program the student is studying. Government element 307.
VERSION_NUMBER	NUMBER	(3)	Yes	Version number of the program that the student is studying
BIRTH_DT	DATE			The day, month and year of birth of the student. Government element 314.
SEX	VARCHAR2	(1)	Yes	Identifies the sex of the student. Government element 315.
ABORIG_TORRES_CD	VARCHAR2	(10)	Yes	Institution-defined code that identifies if or not the student identifies herself or himself as being of Australian Aboriginal or Torres Strait Islander descent. This institution-defined code maps to a Government code. See Government element 316.
GOVT_ABORIG_TORRES_CD	NUMBER	(1)	Yes	Describes if or not the student identifies herself or himself as being of Australian Aboriginal or Torres Strait Islander descent. Government element 316. For example, 1- Aboriginal or Torres/Strait Islander descent, 2 - Not Aboriginal or Torres Strait Islander descent, 9 - No information.
CITIZENSHIP_CD	VARCHAR2	(10)	Yes	Institution-defined code indicating a student's citizenship and residence status. This institution-defined code maps to a government citizenship or residence code. See Government element 358.
GOVT_CITIZENSHIP_CD	NUMBER	(1)	Yes	Indicats a student's citizenship and residence status
PERM_RESIDENT_CD	VARCHAR2	(10)	Yes	Identifies if the student has permanent resident status or not. This code maps to an equivalent government value.
GOVT_PERM_RESIDENT_CD	NUMBER	(1)	Yes	Identifies if the student has permanent resident status or not
HOME_LOCATION	VARCHAR2	(10)	Yes	Institution-defined code describing overseas country code of a student's permanent home address. This code maps to an equivalent government value.
GOVT_HOME_LOCATION	VARCHAR2	(4)	Yes	The postcode or overseas country code of a student's permanent home residence.
TERM_LOCATION	VARCHAR2	(10)	Yes	The postcode or overseas country code for the residence in which the student lives during the semester or term, as most advised prior to the reference date. This institution-defined code maps to an equivalent Government value.
GOVT_TERM_LOCATION	VARCHAR2	(4)	Yes	Thepostcode or overseas country code for the residence in which the student lives during the semester or term, as most recently advised prior to the reference date.
BIRTH_COUNTRY_CD	VARCHAR2	(10)	Yes	An institution-defined code representing the country of birth of a student. This institution-defined code maps to a Government country code.
GOVT_BIRTH_COUNTRY_CD	VARCHAR2	(4)	Yes	Describes the birth country code for the student enrollment
YR_ARRIVAL	VARCHAR2	(4)	Yes	The year that a student not born in Australia first arrived in Australia.
HOME_LANGUAGE_CD	VARCHAR2	(10)	Yes	An institution-defined code indicating use of language other than English at the student's permanent home residence. This code maps to an equivalent Government value.
GOVT_HOME_LANGUAGE_CD	NUMBER	(2)	Yes	Indicates use of language other than English at the student's permanent home residence
PRIOR_UG_INST	VARCHAR2	(10)	Yes	Indicates for a student commencing a postgraduate program the institution that the undergraduate work was undertaken. This institution-defined code maps to an equivalent Government value.
GOVT_PRIOR_UG_INST	VARCHAR2	(30)	Yes	Indicates for a student commencing a postgraduate program the institution that the undergraduate work was undertaken
PRIOR_OTHER_QUAL	VARCHAR2	(5)	Yes	Identifies whether a student had commenced and completed some other qualification or certificate of attainment or competence, and the last year the requirements for the qualification or certification were completed.
PRIOR_POST_GRAD	VARCHAR2	(5)	Yes	Identifies whether a student had commenced and completed a higher doctorate, doctorate, masters degree or other postgraduate program, and the last year that the student was enrolled in such a program.
PRIOR_DEGREE	VARCHAR2	(5)	Yes	Identifies whether a student had commenced and completed a Bachelor's degree program, and the last year that the student was enrolled in such a program.
PRIOR_SUBDEG_NOTAFE	VARCHAR2	(5)	Yes	Identifies whether a student has commenced and completed a Diploma or Associate Diploma program done at a university, teachers' college, institute of technology, institute of advanced education, institute of tertiary education or some other institution, and the last year that the student was enrolled in such a program.
PRIOR_SUBDEG_TAFE	VARCHAR2	(5)	Yes	Identifies whether a student had commenced and completed a Diploma or Associate Diploma program done at a technical college, and the last year that the student was enrolled in such a program.
PRIOR_SECED_TAFE	VARCHAR2	(5)	Yes	Identifies whether a student had commenced and completed the final year of secondary education at a college, technical college, evening school, evening college, institute of technology, institute of advanced education or institute of tertiary education, and the year that the student completed the final year of secondary education.
PRIOR_SECED_SCHOOL	VARCHAR2	(5)	Yes	Identifies whether a student had commenced and completed the final year of secondary education at a high school, technical school, secondary school or secondary college, and the year that the student completed the final year of secondary education.
PRIOR_TAFE_AWARD	VARCHAR2	(5)	Yes	Identifies whether a student had commenced and completed an award program that is other than a Diploma or Associate Diploma program and the last year in which the student was enrolled in such a program.
PRIOR_STUDIES_EXEMPTION	NUMBER	(2)	Yes	Identifies the extent to that the advanced standing exemption or status from the program's total requirements over all its stages were granted by the reference date of the first year of enrollment in the program.
EXEMPTION_INSTITUTION_CD	VARCHAR2	(30)	Yes	Indicates the institution or type of institution where the studies for that the advanced standing, that is exemption, was granted were undertaken. This institution-defined code maps to an equivalent Government value.
GOVT_EXEMPTION_INSTITUTION_CD	VARCHAR2	(30)	Yes	Indicates the institution or type of institution if the studies for the advanced standing, that is the exemption, was granted were undertaken.
ATTENDANCE_MODE	VARCHAR2	(2)	Yes	Identifies an institution defined mode of attendance by that the student undertakes the program. This institution defined code maps to a Government attendance mode.
GOVT_ATTENDANCE_MODE	VARCHAR2	(1)	Yes	Describes the attendance mode by that the student undertakes a program
ATTENDANCE_TYPE	VARCHAR2	(2)	Yes	Identifies an institution defined type of attendance based on the student's load in the reference year. This institution defined code maps to a Government attendance type.
GOVT_ATTENDANCE_TYPE	VARCHAR2	(1)	Yes	Identifies whether a student is classified as being a full-time or part-time student, based on their student load in the reference year.
COMMENCEMENT_DT	DATE		Yes	Date that the student commenced the current program attempt for the first time
MAJOR_COURSE	NUMBER	(1)	Yes	Indicatesf whether or not the student is concurrently enrolled in more than one higher education program within the institution and if so whether the program is the major program or the minor program.
TERTIARY_ENTRANCE_SCORE	NUMBER	(6)	Yes	Describes the student's score from school
BASIS_FOR_ADMISSION_TYPE	VARCHAR2	(10)	Yes	An institution-defined code describing the main criterion used by the institution in granting the student admission to the current program. This institution-defined code maps to a Government defined basis for admission.
GOVT_BASIS_FOR_ADMISSION_TYPE	VARCHAR2	(2)	Yes	Identifies the main criterion used by the institution in granting the student admission to the current program.
GOVT_DISABILITY	VARCHAR2	(8)	Yes	Indicates the student's responses to the Government special need information questions
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
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program

Query Text

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


SELECT SUBMISSION_YR
,      SUBMISSION_NUMBER
,      PERSON_ID
,      COURSE_CD
,      VERSION_NUMBER
,      BIRTH_DT
,      SEX
,      ABORIG_TORRES_CD
,      GOVT_ABORIG_TORRES_CD
,      CITIZENSHIP_CD
,      GOVT_CITIZENSHIP_CD
,      PERM_RESIDENT_CD
,      GOVT_PERM_RESIDENT_CD
,      HOME_LOCATION
,      GOVT_HOME_LOCATION
,      TERM_LOCATION
,      GOVT_TERM_LOCATION
,      BIRTH_COUNTRY_CD
,      GOVT_BIRTH_COUNTRY_CD
,      YR_ARRIVAL
,      HOME_LANGUAGE_CD
,      GOVT_HOME_LANGUAGE_CD
,      PRIOR_UG_INST
,      GOVT_PRIOR_UG_INST
,      PRIOR_OTHER_QUAL
,      PRIOR_POST_GRAD
,      PRIOR_DEGREE
,      PRIOR_SUBDEG_NOTAFE
,      PRIOR_SUBDEG_TAFE
,      PRIOR_SECED_TAFE
,      PRIOR_SECED_SCHOOL
,      PRIOR_TAFE_AWARD
,      PRIOR_STUDIES_EXEMPTION
,      EXEMPTION_INSTITUTION_CD
,      GOVT_EXEMPTION_INSTITUTION_CD
,      ATTENDANCE_MODE
,      GOVT_ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      GOVT_ATTENDANCE_TYPE
,      COMMENCEMENT_DT
,      MAJOR_COURSE
,      TERTIARY_ENTRANCE_SCORE
,      BASIS_FOR_ADMISSION_TYPE
,      GOVT_BASIS_FOR_ADMISSION_TYPE
,      GOVT_DISABILITY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_ST_GOVT_STDNT_EN;

Dependencies

[top of page]

IGS.IGS_ST_GOVT_STDNT_EN does not reference any database object

IGS.IGS_ST_GOVT_STDNT_EN is referenced by following:

APPS: IGS_ST_GOVT_STDNT_EN