Search Results diff_hecs_ind_update_on

Overview

The view IGS_EN_STDNT_PS_HECS_OPTION_V is a reporting and integration object within the Oracle E-Business Suite Student System (IGS) product family. In the ETRM 12.2.2 metadata it is classified under IGS — Student System (Obsolete), indicating that the object belongs to a legacy area of the application that is no longer actively maintained or shipped in current implementations. The view presents Higher Education Contribution Scheme (HECS) payment election data for a student's program or course attempt, together with the associated Higher Education Loan Program (HELP) reporting attributes required for Australian government statistical and taxation submissions.

The defining characteristic of this view is its explicit purpose: to provide protection of the tax file number. Rather than exposing the stored tax file number directly, the view applies a DECODE expression that returns a masked value of 999999999 whenever a tax file number exists, and NULL when it does not. This makes the view suitable for consumption by reports, extracts, and interfaces that must confirm whether a tax file number has been supplied without disclosing the number itself. The view is documented as not implemented in the reference database, meaning it is a metadata definition rather than a deployed object in that environment.

Underlying Base Objects

The view text identifies a single source object: IGS_EN_STDNTPSHECSOP. This base table stores student HECS payment option records, keyed at the level of a person, course, and enrolment period. No additional referenced base objects are documented in the ETRM metadata, and the view performs no joins — every column is projected directly from the base table, with the sole transformation being the tax file number masking via DECODE.

The relationship is therefore strictly one-to-one. Each row in IGS_EN_STDNTPSHECSOP produces exactly one row in the view, so row counts, filtering behaviour, and ordering characteristics of the view mirror those of the underlying table. Because the view does not restrict rows by date, status, or institution, any date-range or active-record filtering must be applied by the consuming query.

Key Columns

• ROW_ID — the row identifier of the underlying base table record, useful for joins back to IGS_EN_STDNTPSHECSOP or DML operations against it.
• PERSON_ID — the student or person identifier, forming the primary linkage to person, party, and student records elsewhere in the Student System.
• COURSE_CD, START_DT, END_DT — the course version and the effective period of the HECS payment option election.
• HECS_PAYMENT_OPTION — the elected payment option for the student's contribution liability.
• DIFFERENTIAL_HECS_IND — indicates whether the student is liable for the differential HECS rate, typically relevant to pre-1997 or transitional arrangements.
• DIFF_HECS_IND_UPDATE_WHO, DIFF_HECS_IND_UPDATE_ON — audit attributes recording who changed the differential HECS indicator and when.
• DIFF_HECS_IND_UPDATE_COMMENTS — free-text comments explaining the change to the differential HECS indicator. This is the column most closely associated with the search term diff_hecs_ind_update_comments.
• OUTSIDE_AUS_RES_IND, NZ_CITIZEN_IND, NZ_CITIZEN_LESS2YR_IND, NZ_CITIZEN_NOT_RES_IND, SAFETY_NET_IND — residency, citizenship, and safety net status indicators that determine contribution liability and reporting treatment.
• TAX_FILE_NUMBER — masked to 999999999 when present, otherwise NULL.
• TAX_FILE_NUMBER_COLLECTED_DT, TAX_FILE_INVALID_DT, TAX_FILE_CERTIFICATE_NUMBER — tax file number collection, invalidation, and certificate reference data.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle WHO columns for audit and reconciliation.

Common Use Cases and Queries

The view is typically used in Australian HELP/HECS reporting extracts and in internal reconciliation of payment option elections, where disclosure of the tax file number must be prevented. A representative query follows.

• Identify differential HECS indicator changes with audit justification:

  SELECT person_id, course_cd, start_dt, end_dt,
         differential_hecs_ind,
         diff_hecs_ind_update_who,
         diff_hecs_ind_update_on,
         diff_hecs_ind_update_comments
  FROM   igs_en_stdnt_ps_hecs_option_v
  WHERE  diff_hecs_ind_update_on >= :p_from_date
  ORDER  BY diff_hecs_ind_update_on;

• Confirm tax file number presence without disclosing it:

  SELECT person_id, course_cd, tax_file_number
  FROM   igs_en_stdnt_ps_hecs_option_v
  WHERE  tax_file_number IS NOT NULL;

• Extract current residency and safety net attributes for a reporting period:

  SELECT person_id, course_cd, hecs_payment_option,
         outside_aus_res_ind, nz_citizen_ind, safety_net_ind
  FROM   igs_en_stdnt_ps_hecs_option_v
  WHERE  :p_report_date BETWEEN start_dt AND end_dt;

Because the object is documented as obsolete and not implemented in the reference database, consumers should confirm its availability in the target environment and, where absent, query IGS_EN_STDNTPSHECSOP directly while reproducing the tax file number masking logic in the query itself.