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_AD_TER_EDU

Object Details

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

IGS_AD_TER_EDU describes tertiary education details from other institutions. This information is used when assessing applicants to a program and in evaluation of advanced standing.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_TER_EDU_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID SEQUENCE_NUMBER
IGS_AD_TER_EDU_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FIELD_OF_STUDY
IGS_AD_TER_EDU_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COUNTRY_CD
IGS_AD_TER_EDU_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TERTIARY_EDU_LVL_QUAL
IGS_AD_TER_EDU_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TERTIARY_EDU_LVL_COMP
IGS_AD_TER_EDU_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	HONOURS_LEVEL
IGS_AD_TER_EDU_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INSTITUTION_CD
IGS_AD_TER_EDU_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LANGUAGE_COMPONENT
IGS_AD_TER_EDU_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LANGUAGE_OF_TUITION

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Contains the institution-defined number that uniquely identifies a person
SEQUENCE_NUMBER	NUMBER	(6)	Yes	The system-generated number used to uniquely identify a tertiary education record for a student
TERTIARY_EDU_LVL_COMP	VARCHAR2	(10)	Yes	An institution-defined level of completion code that indicates the completion status of previous tertiary education identified by an applicant.
EXCLUSION_IND	VARCHAR2	(1)	Yes	Indicates whether the student has ever been refused enrollment in this program
INSTITUTION_CD	VARCHAR2	(30)		The unique code for an institution.
INSTITUTION_NAME	VARCHAR2	(90)		Origin of previous tertiary education if institution code is unknown, for example, Princeton University
ENROLMENT_FIRST_YR	NUMBER	(4)		First year of enrollment in this tertiary education program
ENROLMENT_LATEST_YR	NUMBER	(4)		Last year of enrollment in this tertiary education program
COURSE_CD	VARCHAR2	(10)		The program code of the issuing institution
COURSE_TITLE	VARCHAR2	(72)		The program title of the issuing institution
FIELD_OF_STUDY	VARCHAR2	(10)		The unique identifier for the institution-defined field of study.
LANGUAGE_COMPONENT	VARCHAR2	(10)		A language that is a significant component of the program studied.
STUDENT_ID	VARCHAR2	(15)		Identification number at the previous tertiary institution
EQUIV_FULL_TIME_YRS_ENR	NUMBER	(4)		Equivalent full-time years enrolled in this program
TERTIARY_EDU_LVL_QUAL	VARCHAR2	(10)		An institution-defined code used to quantify previous tertiary education identified by the applicant.
QUALIFICATION	VARCHAR2	(20)		Describes the name of the qualification, for example, B.A
HONOURS_LEVEL	VARCHAR2	(3)		Honors level granted to a graduating student, for example, 'H1'-First Class Honors
LEVEL_OF_ACHIEVEMENT_TYPE	VARCHAR2	(10)		Level of achievement for the tertiary education program
GRADE_POINT_AVERAGE	NUMBER	(5)		Describes the grade point average for the tertiary education program
LANGUAGE_OF_TUITION	VARCHAR2	(10)		Describes the language of tuition for the program studied
STATE_CD	VARCHAR2	(3)		Australian state where the tertiary education program was studied
COUNTRY_CD	VARCHAR2	(10)		Identifies the institution-defined code for a country
NOTES	VARCHAR2	(2000)		Large text field used to record miscellaneous details or comments about the student's tertiary education
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 PERSON_ID
,      SEQUENCE_NUMBER
,      TERTIARY_EDU_LVL_COMP
,      EXCLUSION_IND
,      INSTITUTION_CD
,      INSTITUTION_NAME
,      ENROLMENT_FIRST_YR
,      ENROLMENT_LATEST_YR
,      COURSE_CD
,      COURSE_TITLE
,      FIELD_OF_STUDY
,      LANGUAGE_COMPONENT
,      STUDENT_ID
,      EQUIV_FULL_TIME_YRS_ENR
,      TERTIARY_EDU_LVL_QUAL
,      QUALIFICATION
,      HONOURS_LEVEL
,      LEVEL_OF_ACHIEVEMENT_TYPE
,      GRADE_POINT_AVERAGE
,      LANGUAGE_OF_TUITION
,      STATE_CD
,      COUNTRY_CD
,      NOTES
,      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_AD_TER_EDU;

Dependencies

[top of page]

IGS.IGS_AD_TER_EDU does not reference any database object

IGS.IGS_AD_TER_EDU is referenced by following:

APPS: IGS_AD_TER_EDU