[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_EN_STDNT_PS_HECS_OPTION_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_EN_STDNT_PS_HECS_OPTION_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| PERSON_ID | NUMBER | (15) | Yes | Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value. |
| COURSE_CD | VARCHAR2 | (6) | Yes | This field describes the course code of the student course attempt.DEETYA element reference 307. |
| START_DT | DATE | Yes | This field describes the date the HECS option is effective from. | |
| END_DT | DATE | This field describes the date the HECS option is no longer effective. | ||
| HECS_PAYMENT_OPTION | VARCHAR2 | (10) | Yes | This field describes the possible HECS payment options. Examples- DEFERRED, UPFRONT, EXEMPT. |
| DIFFERENTIAL_HECS_IND | VARCHAR2 | (1) | Yes | An indicator which specifies whether differential rates of HECS apply to the student's course attempt. Normally, each unit of study is allocated to one of three bands which determines theHECS rate for that unit. Setting the indicator ticked means that differential HECS applies. |
| DIFF_HECS_IND_UPDATE_WHO | VARCHAR2 | (30) | This field describes the oracle username of the person who updated the differential HECS indicator from the default value. | |
| DIFF_HECS_IND_UPDATE_ON | DATE | This field describes the date the differential HECS indicator was changed from the default value. | ||
| OUTSIDE_AUS_RES_IND | VARCHAR2 | (1) | Yes | Indicates whether the student is "an Australian permanent resident who will be resident outside Australia for the semester for a reason other than a requirement of the course". Collected through the HECS Payment Options Form. |
| NZ_CITIZEN_IND | VARCHAR2 | (1) | Yes | Indicates whether the student is "a New Zealand citizen who, at enrolment, is commencing a course of study". Collected through the HECS Payment Options Form. |
| NZ_CITIZEN_LESS2YR_IND | VARCHAR2 | (1) | Yes | Indicates whether the student is "a New Zealand citizen who, at enrolment, is continuing in a course of study which commenced prior to 1 January of the enrolment year and who has been resident inAustralia for a continuous period of less than two years". Collected through the HECS Payment Options Form. |
| NZ_CITIZEN_NOT_RES_IND | VARCHAR2 | (1) | Yes | Indicates whether the student is "a New Zealand citizen enrolling as an external student resident outside Australia". Collected through the HECS Payment Options Form. |
| SAFETY_NET_IND | VARCHAR2 | (1) | Yes | This field describes whether or not a student who has selected the up-front payment option has opted for the 'safety-net'. This will permit the institution to change the up-front option to the deferredoption if for some reason the student cannot make the up-front payment by the due date. |
| TAX_FILE_NUMBER | VARCHAR2 | (9) | This field describes the tax file number of the student. | |
| TAX_FILE_NUMBER_COLLECTED_DT | DATE | This field describes whether or not the tax file number has been collected. | ||
| TAX_FILE_INVALID_DT | DATE | This field describes the date the institution was notified that the student supplied an invalid tax file number. | ||
| TAX_FILE_CERTIFICATE_NUMBER | NUMBER | (10) | This field describes the certificate number sighted during the student's enrolment. | |
| DIFF_HECS_IND_UPDATE_COMMENTS | VARCHAR2 | (2000) | This field provides comments describing why the differential HECS indicator was changed from the default value. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.IGS_EN_STDNT_PS_HECS_OPTION_V;
APPS
IGS_EN_STDNTPSHECSOP
APPS
IGS_EN_VAL_SCHO
- show dependent code
|
|
|
|