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.

[Home] [Help]

View: IGS_EN_STDNT_PS_HECS_OPTION_V

Product:	IGS - Student System (Obsolete)
Description:	This view is used to provide protection of the tax file number.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SCHO.ROWID
, SCHO.PERSON_ID
, SCHO.COURSE_CD
, SCHO.START_DT
, SCHO.END_DT
, SCHO.HECS_PAYMENT_OPTION
, SCHO.DIFFERENTIAL_HECS_IND
, SCHO.DIFF_HECS_IND_UPDATE_WHO
, SCHO.DIFF_HECS_IND_UPDATE_ON
, SCHO.OUTSIDE_AUS_RES_IND
, SCHO.NZ_CITIZEN_IND
, SCHO.NZ_CITIZEN_LESS2YR_IND
, SCHO.NZ_CITIZEN_NOT_RES_IND
, SCHO.SAFETY_NET_IND
, DECODE(TAX_FILE_NUMBER
, NULL
, NULL
, 999999999)
, SCHO.TAX_FILE_NUMBER_COLLECTED_DT
, SCHO.TAX_FILE_INVALID_DT
, SCHO.TAX_FILE_CERTIFICATE_NUMBER
, SCHO.DIFF_HECS_IND_UPDATE_COMMENTS
, SCHO.CREATED_BY
, SCHO.CREATION_DATE
, SCHO.LAST_UPDATED_BY
, SCHO.LAST_UPDATE_DATE
, SCHO.LAST_UPDATE_LOGIN
FROM IGS_EN_STDNTPSHECSOP SCHO

Columns

Name
ROW_ID
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