VIEW: APPS.IGS_EN_STDNT_PS_HECS_OPTION_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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