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_STDNTLOAD

Object Details

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

IGS_ST_GVT_STDNTLOAD describes a students load details as captured at the census date for each government submission of the student load file.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_ST_GVT_STDNTLOAD_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUBMISSION_YR SUBMISSION_NUMBER PERSON_ID COURSE_CD GOVT_SEMESTER UNIT_CD SUA_CAL_TYPE SUA_CI_SEQUENCE_NUMBER TR_ORG_UNIT_CD TR_OU_START_DT DISCIPLINE_GROUP_CD GOVT_DISCIPLINE_GROUP_CD SUA_LOCATION_CD UNIT_CLASS
IGS_ST_GVT_STDNTLOAD_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD UNIT_CD SUA_CAL_TYPE SUA_CI_SEQUENCE_NUMBER SUA_LOCATION_CD UNIT_CLASS
IGS_ST_GVT_STDNTLOAD_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOVT_SEMESTER
IGS_ST_GVT_STDNTLOAD_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TR_ORG_UNIT_CD TR_OU_START_DT
IGS_ST_GVT_STDNTLOAD_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DISCIPLINE_GROUP_CD
IGS_ST_GVT_STDNTLOAD_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOVT_DISCIPLINE_GROUP_CD

Columns

Name	Datatype	Length	Mandatory	Comments
SUBMISSION_YR	NUMBER	(4)	Yes	Describes the reference year of the Government submission
SUBMISSION_NUMBER	NUMBER	(1)	Yes	Describes the Government submission number, for example, 1, 2 or 3.
PERSON_ID	NUMBER	(15)	Yes	Describes a code that uniquely identifies the student within the institution and remains constant from year to year. Reported in the student load file.
COURSE_CD	VARCHAR2	(6)	Yes	Identifies the program the student is studying. Reported in the student load file.
CRV_VERSION_NUMBER	NUMBER	(3)	Yes	Version number of the program being studied by the student as captured at the census date for the Government submission
GOVT_SEMESTER	NUMBER	(1)	Yes	Describes the code that identifies the semester that the student load being reported for a unit of study or part of a unit of study occurs. For example, 1 - semester 1, 2 - semester 2, 3 - summer school. Reported in the student load file.
UNIT_CD	VARCHAR2	(10)	Yes	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.
UV_VERSION_NUMBER	NUMBER	(3)	Yes	Describes the version number of the unit being studied by the student as captured at the census date for the Government submission.
SUA_CAL_TYPE	VARCHAR2	(10)	Yes	The calendar type of the student unit attempt that the Government submission is for.
SUA_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	The sequence number of the calendar instance of the student unit attempt that the Government submission is for.
TR_ORG_UNIT_CD	VARCHAR2	(30)	Yes	Describes the code that uniquely identifies an academic organizational unit within an institution. Reported in the student load file.
TR_OU_START_DT	DATE		Yes	Describes the date from that the organizational unit is effective
DISCIPLINE_GROUP_CD	VARCHAR2	(4)	Yes	The institution-defined code of the discipline group of the unit being studied by the student as captured at the census date for the Government submission. This code maps to an equivalent Government value. See Appendix E classification of higher dducation discipline groups, higher education student collection - technical documentation.
GOVT_DISCIPLINE_GROUP_CD	VARCHAR2	(4)	Yes	The discipline group of the unit being studied by the student as captured at the census date for the DETYA submission. Reported in the student load file.
INDUSTRIAL_IND	VARCHAR2	(1)	Yes	Describes if or not the effective full time student units value for a unit of study or part of a unit of study is generated by a work experience in industry component. Reported in the student load file.
EFTSU	NUMBER	(7)	Yes	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.
UNIT_COMPLETION_STATUS	NUMBER	(1)	Yes	Describes if a student has completed, failed, withdrawn from, will commence later in the year or is still in the process of completing a unit of study as captured at the census date for the Government submission. Reported in the student load file.
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 identifer of last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program
SUA_LOCATION_CD	VARCHAR2	(10)	Yes	Unit Section Location Code
UNIT_CLASS	VARCHAR2	(10)	Yes	Unit Section Unit Class

Query Text

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


SELECT SUBMISSION_YR
,      SUBMISSION_NUMBER
,      PERSON_ID
,      COURSE_CD
,      CRV_VERSION_NUMBER
,      GOVT_SEMESTER
,      UNIT_CD
,      UV_VERSION_NUMBER
,      SUA_CAL_TYPE
,      SUA_CI_SEQUENCE_NUMBER
,      TR_ORG_UNIT_CD
,      TR_OU_START_DT
,      DISCIPLINE_GROUP_CD
,      GOVT_DISCIPLINE_GROUP_CD
,      INDUSTRIAL_IND
,      EFTSU
,      UNIT_COMPLETION_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SUA_LOCATION_CD
,      UNIT_CLASS
FROM IGS.IGS_ST_GVT_STDNTLOAD;

Dependencies

[top of page]

IGS.IGS_ST_GVT_STDNTLOAD does not reference any database object

IGS.IGS_ST_GVT_STDNTLOAD is referenced by following:

APPS: IGS_ST_GVT_STDNTLOAD