Search Results tax_file_number




Overview
Explore in AI Chat

Overview

APPS.IGS_EN_STDNT_PS_HECS_OPTION_V is a reporting view in the Oracle E-Business Suite Student System (the IGS schema prefix denotes the Student Information / Higher Education components of Oracle EBS). It exposes the Higher Education Contribution Scheme (HECS) payment options and related Australian student contribution attributes that a student has elected for a given course enrolment period. HECS is the Australian government income-contingent loan scheme for higher education, and the underlying enrolment records captured here drive fee assessment, government reporting, and student financial obligations.

The view is defined over a single base table, IGS_EN_STDNTPSHECSOP (Student Person HECS Option), and is intended primarily for read-only reporting, concurrent program extract logic, and integration with external Australian government reporting (for example, the Department of Education and Training student data submissions). Because they are views, they isolate consumers from the physical column layout and apply lightweight transformation logic at query time, making them stable integration points across EBS 12.1.1 and 12.2.2.

Underlying Base Objects

The ETRM metadata documents no referenced base objects other than the driving table named directly in the view text:

  • IGS_EN_STDNTPSHECSOP — aliased as SCHO in the view definition. All columns exposed by the view originate from this single table.

The view is a straightforward projection with no documented joins to person, course, or term tables, meaning it stores denormalised key identifiers (PERSON_ID, COURSE_CD) rather than resolving them. Callers typically join outward to PER_ALL_PEOPLE_F, course version tables, or calendar/term tables themselves. Only one expression is transformed: the TAX_FILE_NUMBER column is wrapped in a DECODE that returns 999999999 whenever the stored tax file number is non-null, and NULL when it is null.

Key Columns

Common Use Cases and Queries

The primary uses are eligibility reporting, HECS option audits, and government extracts. A typical query retrieving masked tax file status with student identity is:

SELECT person_id, course_cd, start_dt, end_dt,
       hecs_payment_option, tax_file_number,
       tax_file_number_collected_dt, safety_net_ind
FROM   apps.igs_en_stdnt_ps_hecs_option_v
WHERE  person_id = :p_person_id;

Because the view masks the tax file number, a consumer seeking to confirm whether a TFN is on file — without accessing the protected value — can test the masked output:

SELECT person_id,
       CASE WHEN tax_file_number IS NULL THEN 'NOT SUPPLIED'
            ELSE 'SUPPLIED (MASKED)' END AS tfn_status
FROM   apps.igs_en_stdnt_ps_hecs_option_v;

Analysts auditing option changes over time commonly select the differential HECS audit columns, and reporting teams frequently join PERSON_ID and COURSE_CD to person and course views to produce eligible-student listings. Any attempt to retrieve the actual tax file number must query the base table IGS_EN_STDNTPSHECSOP directly, subject to the appropriate security and data-privacy controls governing that sensitive attribute.