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_GVT_STDNT_LBL

Object Details

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

IGS_ST_GVT_STDNT_LBL describes a student's liability details as captured at the census date for each government submission of the student liability file.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_ST_GVT_STDNT_LBL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUBMISSION_YR SUBMISSION_NUMBER PERSON_ID COURSE_CD GOVT_SEMESTER
IGS_ST_GVT_STDNT_LBL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOVT_SEMESTER
IGS_ST_GVT_STDNT_LBL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	HECS_PAYMENT_OPTION
IGS_ST_GVT_STDNT_LBL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOVT_HECS_PAYMENT_OPTION

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 numbe, 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. Reported in the contribution liability status file.
COURSE_CD	VARCHAR2	(6)	Yes	Identifies the program the student is studying. Reported in the contribution liability status file.
VERSION_NUMBER	NUMBER	(3)	Yes	Version number of the program being studied by the student as captured at the census date for the Government submission.
GOVT_SEMESTER	NUMBER	(1)	Yes	Identifies the Government semester in which the student load being reported for a unit of study or part of a unit of study occurs. For example, 1 - semester 1, 2 - semester 2, 3 - summer school. Reported in the contribution liability status file.
HECS_PAYMENT_OPTION	VARCHAR2	(10)	Yes	Institution-defined code that identifies, for an enrollment in a program, the exemption status for the higher education contribution scheme liability for a semester. This code maps to an equivalent Government value.
GOVT_HECS_PAYMENT_OPTION	VARCHAR2	(10)	Yes	Code that identifies, for an enrollment in a program, the exemption status for the higher education contribution scheme liability for a semester. Reported in the contribution liability status file.
TOTAL_EFTSU	NUMBER	(7)	Yes	The aggregated effective full time student units value generated in a semester for student load for all types of units of study or parts of units of study that relate to the student program, and that are counted for the semester. Reported in the contribution liability status file.
INDUSTRIAL_EFTSU	NUMBER	(7)	Yes	The aggregated effective full time student units value generated in a semester for student load for all work experience in industry components that relate to the student program, and that are counted for that semester. Reported in the contribution liability status file.
HECS_PREXMT_EXIE	NUMBER	(4)	Yes	The contribution amount, prior to determination of exemption status, calculated for student load for non work experience in industry components of a student program, that are counted for a semester. Reported in the contribution liability status file.
HECS_AMOUNT_PAID	NUMBER	(4)	Yes	The amount that has been paid for thehHigher education contribution scheme liability for a semester. Reported in the contribution liability status file.
TUITION_FEE	NUMBER	(5)	Yes	The tution fee charged in respect of an amount of effective full time student units being reported. Reported in the contribution liability status file.
DIFFERENTIAL_HECS_IND	VARCHAR2	(1)	Yes	Describes if or not the contribution liability has been calculated through the differential HECS charging scale. Reported in the contribution liability status file.
BIRTH_DT	DATE			Day, month and year of birth of the student
SEX	VARCHAR2	(1)	Yes	Identifies the sex of the student
CITIZENSHIP_CD	VARCHAR2	(10)	Yes	An institution-defined code indicating a student's citizenship and residence status. This institution-defined code maps to a Government citizenship or residence code.
GOVT_CITIZENSHIP_CD	NUMBER	(1)	Yes	Code indicating a student's citizenship and residence status
PERM_RESIDENT_CD	VARCHAR2	(10)	Yes	Institution-defined code that 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
COMMENCEMENT_DT	DATE		Yes	Date that the student commenced the current program attempt for the first time
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
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

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


SELECT SUBMISSION_YR
,      SUBMISSION_NUMBER
,      PERSON_ID
,      COURSE_CD
,      VERSION_NUMBER
,      GOVT_SEMESTER
,      HECS_PAYMENT_OPTION
,      GOVT_HECS_PAYMENT_OPTION
,      TOTAL_EFTSU
,      INDUSTRIAL_EFTSU
,      HECS_PREXMT_EXIE
,      HECS_AMOUNT_PAID
,      TUITION_FEE
,      DIFFERENTIAL_HECS_IND
,      BIRTH_DT
,      SEX
,      CITIZENSHIP_CD
,      GOVT_CITIZENSHIP_CD
,      PERM_RESIDENT_CD
,      GOVT_PERM_RESIDENT_CD
,      COMMENCEMENT_DT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      PROGRAM_ID
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_ST_GVT_STDNT_LBL;

Dependencies

[top of page]

IGS.IGS_ST_GVT_STDNT_LBL does not reference any database object

IGS.IGS_ST_GVT_STDNT_LBL is referenced by following:

APPS: IGS_ST_GVT_STDNT_LBL