Results for “igs_en_stdntpshecsop_u1”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS.IGS_EN_STDNTPSHECSOP is a transactional table within the Oracle E-Business Suite Student System (IGS) schema that records the Higher Education Contribution Scheme (HECS) payment option elected by a student for a specific student program attempt. In the Australian higher education model, HECS (now encompassed within the Higher Education Loan Program, HELP) governs how students contribute to the cost of their study. Each row in this table captures the effective election for a student identified by PERSON_ID, within a program identified by COURSE_CD, from a given START_DT. The table stores not only the chosen payment option but also a range of supporting attributes covering differential HECS treatment, New Zealand citizen status, residency declarations, safety net eligibility, and tax file number (TFN) capture.

From a data modeling perspective, the heuristic Data Vault classification for this object is link, mined from its foreign key structure. It associates parties (HZ_PARTIES via PERSON_ID), student program attempts, and the HECS payment option reference, making it a natural intersection between those entities. This classification should be treated as a modeling suggestion rather than a definitive architectural statement. The table resides in the APPS_TS_TX_DATA tablespace and carries the FND Design Data reference IGS.IGS_EN_STDNTPSHECSOP.

Key Information Stored

The business key of the table is defined by the unique index IGS_EN_STDNTPSHECSOP_U1 over PERSON_ID, COURSE_CD, and START_DT. Together these form the primary key IGS_EN_STDNTPSHECSOP_PK. PERSON_ID is a sequence-generated person identifier and foreign key to HZ_PARTIES; COURSE_CD identifies the student's program; and START_DT establishes the effective-from date for the election. The companion column END_DT records when the option ceases to be effective, allowing historical tracking of changes over a student's enrolment.

• HECS_PAYMENT_OPTION — the elected payment method, such as DEFERRED, UPFRONT, or EXEMPT; referenced by index IGS_EN_STDNTPSHECSOP_N1 and a foreign key to IGS_FI_HECS_PAY_OPTN.
• DIFFERENTIAL_HECS_IND — indicates whether differential HECS bands apply to the program attempt.
• DIFF_HECS_IND_UPDATE_WHO / DIFF_HECS_IND_UPDATE_ON — audit of who changed the differential indicator from its default and when.
• OUTSIDE_AUS_RES_IND — flags an Australian permanent resident who will reside outside Australia for the semester.
• NZ_CITIZEN_IND, NZ_CITIZEN_LESS2YR_IND, NZ_CITIZEN_NOT_RES_IND — capture New Zealand citizen status and related duration/residency conditions affecting eligibility.
• SAFETY_NET_IND — records safety net entitlement.
• TAX_FILE_NUMBER, TAX_FILE_NUMBER_COLLECTED_DT, TAX_FILE_INVALID_DT, TAX_FILE_CERTIFICATE_NUMBER — TFN capture, its collection date, invalidation date, and certificate reference; the TFN is indexed by IGS_EN_STDNTPSHECSOP_N2.
• Audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID) — standard EBS WHO columns and concurrent request tracking.

Common Use Cases and Queries

Typical reporting needs include identifying the current HECS option for a student, auditing changes over time, and reconciling deferred versus upfront elections for billing and government reporting. A representative query for the effective option on a given date is:

• SELECT person_id, course_cd, hecs_payment_option FROM igs.igs_en_stdntpshecsop WHERE person_id = :p AND start_dt <= :as_of AND (end_dt IS NULL OR end_dt > :as_of);
• Grouping by HECS_PAYMENT_OPTION to produce cohort counts for a semester population.
• Querying by TAX_FILE_NUMBER (index N2) to reconcile TFN records against government submissions.

Because the table is date-effective, historical reporting should always filter on the START_DT/END_DT window rather than assuming a single current row.

Related Objects

The foreign key relationships documented for this table anchor it to several core objects. The most significant are:

• IGS.IGS_EN_STDNT_PS_ATT_ALL — student program attempt; joined on PERSON_ID, the parent of the enrolment context.
• IGS.IGS_FI_HECS_PAY_OPTN — HECS payment option reference; joined on HECS_PAYMENT_OPTION.
• HZ_PARTIES — the party master from which PERSON_ID derives.
• Indexes IGS_EN_STDNTPSHECSOP_U1, N1, and N2 support unique key enforcement and lookups by HECS option and TFN.

These relationships make the table a central point for HECS/HELP compliance and student financial reporting within the Student System.