eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGS.IGS_ST_GVT_SPSHT_CHG

Object Details

Object Name:	IGS_ST_GVT_SPSHT_CHG
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_ST_GVT_SPSHT_CHG
Subobject Name:
Status:	VALID

IGS_ST_GVT_SPSHT_CHG contains changes made to data impacting on a previous government submission after the submission has been sent. These changes need to be reported.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_ST_GVT_SPSHT_CHG_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUBMISSION_YR SUBMISSION_NUMBER PERSON_ID COURSE_CD SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
SUBMISSION_YR	NUMBER	(4)	Yes	Higher education student data collection submission year
SUBMISSION_NUMBER	NUMBER	(1)	Yes	Higher education student data collection submission number
PERSON_ID	NUMBER	(15)	Yes	Uniquely identifies the student within the institution and that remains constant from year to year
COURSE_CD	VARCHAR2	(6)	Yes	Describes the program the student is studying
VERSION_NUMBER	NUMBER	(3)	Yes	Version number of the program being studied by the student as captured at the census date for the submission
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Unique identifier for govt_snapshot_change
CHANGED_UPDATE_WHO	VARCHAR2	(30)		Contains the Oracle username of the person who last updated the record that has been identified as changing
CHANGED_UPDATE_ON	DATE			Contains the date and time the record that was identified as changing was last updated
GOVT_SEMESTER	NUMBER	(1)		Identifies the Government semester that the student load being reported for a unit of study or part of a unit of study occurs. DETYA element 353. For example, 1 - semester 1, 2 - semester 2, 3 - summer school. Reported in the contribution liability status file.
UNIT_CD	VARCHAR2	(10)		Describes the unit code of the unit being studied by the student as captured at the census date for the Government submission. Reported in the student load file.
EFTSU	NUMBER	(7)		The Equivalent full time student unit value generated in a semester by a unit of study or a part of a unit of study for a particular stage of a particular program for a particular academic organizational unit and discipline group combination. Reported in the student load file.
HECS_PREXMT_EXIE	NUMBER	(4)		Contribution amount, prior to determination of exemption status, calculated for student load for non-work experience in industry components of a student program, that are counted for a semester. Reported in the Government liability status file.
HECS_AMOUNT_PAID	NUMBER	(4)		Amount that has been paid for the higher education contribution scheme liability for a semester. Reported in the contribution liability status file.
HECS_PAYMENT_OPTION	VARCHAR2	(10)		The institution-defined code that identifies, for an enrollment in a program, the exemption status for the higher education contribution scheme liability for a semester. This code maps to an equivalent Government value.
DIFFERENTIAL_HECS_IND	VARCHAR2	(1)		Describes if or not the contribution liability has been calculated through the differential contribution charging scale. Reported in the contribution liability status file.
CITIZENSHIP_CD	VARCHAR2	(10)		Indicates a student's citizenship and residence status. This institution-defined code maps to a Government citizenship or residence code.
PERM_RESIDENT_CD	VARCHAR2	(10)		An institution-defined code that identifies whether the student has permanent resident status or not. This code maps to an equivalent Government value.
PRIOR_DEGREE	VARCHAR2	(5)		Identifies if a student had commenced and completed a bachelor's degree program, and the last year that the student was enrolled in such a program.
PRIOR_POST_GRAD	VARCHAR2	(5)		Indicates if student had commenced and completed a higher doctorate, doctorate degree or other post-graduate program and the last year in which the student was enrolled in such a program, as described in the higher education student data collection.
OLD_UNIT_CD	VARCHAR2	(10)		Describes the unit code of the unit being studied by the student as captured at the census date for the Government submission. Reported in the student load file.
OLD_EFTSU	NUMBER	(7)		The Equivalent full time student unit value generated in a semester by a unit of study or a part of a unit of study for a particular stage of a particular program for a particular academic organizational unit and discipline group combination. Reported in the student load file.
OLD_HECS_PREXMT_EXIE	NUMBER	(4)		The HECS amount, prior to determination of exemption status, calculated for student load for non-work experience in industry components of a student program, that are counted for a semester. Reported in the contribution liability status file.
OLD_HECS_AMOUNT_PAID	NUMBER	(4)		The amount that has been paid for the higher education contribution scheme liability for a semester. Reported in the contribution liability status file.
OLD_HECS_PAYMENT_OPTION	VARCHAR2	(10)		Identifies, for an enrollment in a program, the exemption status for the higher education contribution scheme liability for a semester. This code maps to an equivalent Government value.
OLD_DIFFERENTIAL_HECS_IND	VARCHAR2	(1)		An indicator that describes if or not the contribution liability has been calculated through the differential contribution charging scale. Reported in the contribution liability status file.
OLD_CITIZENSHIP_CD	VARCHAR2	(10)		An institution-defined code indicating a student's citizenship and residence status. This institution-defined code maps to a Government citizenship or residence code.
OLD_PERM_RESIDENT_CD	VARCHAR2	(10)		Identifies whether the student has permanent resident status or not. This code maps to an equivalent Government value.
OLD_PRIOR_DEGREE	VARCHAR2	(5)		Identifies whether a student had commenced and completed a Bachelor's degree program, and the last year in which the student was enrolled in such a program.
OLD_PRIOR_POST_GRAD	VARCHAR2	(5)		Indicates if student had commenced and completed a higher doctorate, doctorate degree or other post-graduate program and the last year that the student was enrolled in such a program, as described in the higher education student data collection.
REPORTED_IND	VARCHAR2	(1)	Yes	Describes if or not the record has been included on a report
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
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SUBMISSION_YR
,      SUBMISSION_NUMBER
,      PERSON_ID
,      COURSE_CD
,      VERSION_NUMBER
,      SEQUENCE_NUMBER
,      CHANGED_UPDATE_WHO
,      CHANGED_UPDATE_ON
,      GOVT_SEMESTER
,      UNIT_CD
,      EFTSU
,      HECS_PREXMT_EXIE
,      HECS_AMOUNT_PAID
,      HECS_PAYMENT_OPTION
,      DIFFERENTIAL_HECS_IND
,      CITIZENSHIP_CD
,      PERM_RESIDENT_CD
,      PRIOR_DEGREE
,      PRIOR_POST_GRAD
,      OLD_UNIT_CD
,      OLD_EFTSU
,      OLD_HECS_PREXMT_EXIE
,      OLD_HECS_AMOUNT_PAID
,      OLD_HECS_PAYMENT_OPTION
,      OLD_DIFFERENTIAL_HECS_IND
,      OLD_CITIZENSHIP_CD
,      OLD_PERM_RESIDENT_CD
,      OLD_PRIOR_DEGREE
,      OLD_PRIOR_POST_GRAD
,      REPORTED_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_ST_GVT_SPSHT_CHG;

Dependencies

[top of page]

IGS.IGS_ST_GVT_SPSHT_CHG does not reference any database object

IGS.IGS_ST_GVT_SPSHT_CHG is referenced by following:

APPS: IGS_ST_GVT_SPSHT_CHG