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_EN_STDNTPSHECSOP

Object Details

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

IGS_EN_STDNTPSHECSOP describes the HECS option that a student has chosen for a particular student program attempt.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_STDNTPSHECSOP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD START_DT
IGS_EN_STDNTPSHECSOP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	HECS_PAYMENT_OPTION
IGS_EN_STDNTPSHECSOP_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TAX_FILE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
COURSE_CD	VARCHAR2	(6)	Yes	Describes the program code of the student program attempt. A code used to identify the program in that the student is enrolled.
START_DT	DATE		Yes	Describes the date the HECS option is effective from.
END_DT	DATE			Describes the date the HECS option is no longer effective.
HECS_PAYMENT_OPTION	VARCHAR2	(10)	Yes	Describes the possible HECS payment options. For example, DEFERRED, UPFRONT, EXEMPT.
DIFFERENTIAL_HECS_IND	VARCHAR2	(1)	Yes	Indicator that specifies whether differential rates of HECS apply to the student's program attempt. Normally, each unit of study is allocated to one of three bands that determines the HECS rate for that unit. Setting the indicator means that differential HECS applies.
DIFF_HECS_IND_UPDATE_WHO	VARCHAR2	(30)		Describes the ORACLE username of the person who updated the differential HECS indicator from the default value.
DIFF_HECS_IND_UPDATE_ON	DATE			Describes the date the differential HECS indicator was changed from the default value.
OUTSIDE_AUS_RES_IND	VARCHAR2	(1)	Yes	Indicates whether the student is "an Australian permanent resident who will be resident outside Australia for the semester for a reason other than a requirement of the course". Collected through the HECS Payment Options Form.
NZ_CITIZEN_IND	VARCHAR2	(1)	Yes	Indicates whether the student is "a New Zealand citizen who, at enrollment, is commencing a program of study". Collected through the HECS Payment Options Form.
NZ_CITIZEN_LESS2YR_IND	VARCHAR2	(1)	Yes	Indicates whether the student is "a New Zealand citizen who, at enrolment, is continuing in a program of study that commenced prior to 1 January of the enrolment year and who has been resident in Australia for a continuous period of less than two years". Collected through the HECS Payment Options Form.
NZ_CITIZEN_NOT_RES_IND	VARCHAR2	(1)	Yes	Indicates whether the student is "a New Zealand citizen enrolling as an external student resident outside Australia". Collected through the HECS Payment Options Form.
SAFETY_NET_IND	VARCHAR2	(1)	Yes	Describes whether or not a student who has selected the up-front payment option has opted for the 'safety-net'. This will permit the institution to change the up-front option to the deferred option.
TAX_FILE_NUMBER	NUMBER	(9)		Describes the tax file number of the student.
TAX_FILE_NUMBER_COLLECTED_DT	DATE			Describes whether or not the tax file number has been collected.
TAX_FILE_INVALID_DT	DATE			Describes the date the institution was notified that the student supplied an invalid tax file number.
TAX_FILE_CERTIFICATE_NUMBER	NUMBER	(10)		Describes the certificate number sighted during the student's enrolment.
DIFF_HECS_IND_UPDATE_COMMENTS	VARCHAR2	(2000)		Provides comments describing why the differential HECS indicator was changed from the default value.
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 PERSON_ID
,      COURSE_CD
,      START_DT
,      END_DT
,      HECS_PAYMENT_OPTION
,      DIFFERENTIAL_HECS_IND
,      DIFF_HECS_IND_UPDATE_WHO
,      DIFF_HECS_IND_UPDATE_ON
,      OUTSIDE_AUS_RES_IND
,      NZ_CITIZEN_IND
,      NZ_CITIZEN_LESS2YR_IND
,      NZ_CITIZEN_NOT_RES_IND
,      SAFETY_NET_IND
,      TAX_FILE_NUMBER
,      TAX_FILE_NUMBER_COLLECTED_DT
,      TAX_FILE_INVALID_DT
,      TAX_FILE_CERTIFICATE_NUMBER
,      DIFF_HECS_IND_UPDATE_COMMENTS
,      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_EN_STDNTPSHECSOP;

Dependencies

[top of page]

IGS.IGS_EN_STDNTPSHECSOP does not reference any database object

IGS.IGS_EN_STDNTPSHECSOP is referenced by following:

APPS: IGS_EN_STDNTPSHECSOP