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_UC_EXP_QUAL_SUM

Object Details

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

The expected qualification summary table will hold the qualifications attained by this applicant

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_UC_EXP_QUAL_SUM_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXP_QUAL_SUM_ID
IGS_UC_EXP_QUAL_SUM_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EXP_QUAL_SUM_ID	NUMBER		Yes	Expected qualification summary identifier(Sequence generated)
PERSON_ID	NUMBER	(15)	Yes	Person Identifier
EXP_GCE	NUMBER	(1)		Expected CGE
EXP_VCE	NUMBER	(1)		Expected VCE
WINTER_A_LEVELS	NUMBER	(1)		Winter A Levels
PREV_A_LEVELS	NUMBER	(1)		Previous A Level
PREV_AS_LEVELS	NUMBER	(1)		Previous AS Level
SQA	VARCHAR2	(1)		SQA Candidate
BTEC	VARCHAR2	(1)		BTEC Indicator
IB	VARCHAR2	(1)		IB Indicator
ILC	VARCHAR2	(1)		ILC Indicator
AILC	VARCHAR2	(1)		AICE Indicator
KSI	VARCHAR2	(1)		Key Skills Indicator
ROA	VARCHAR2	(1)		ROA Indicator
MANUAL	VARCHAR2	(1)		Manual Check Required
OEQ	VARCHAR2	(1)		OEQ Indicator
PREV_OEQ	VARCHAR2	(1)		Previous OEQ
VQI	VARCHAR2	(1)		Vocational Qualification Indicator
SEQ_UPDATED_DATE	DATE		Yes	Sequence Updated Date
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column

Query Text

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


SELECT EXP_QUAL_SUM_ID
,      PERSON_ID
,      EXP_GCE
,      EXP_VCE
,      WINTER_A_LEVELS
,      PREV_A_LEVELS
,      PREV_AS_LEVELS
,      SQA
,      BTEC
,      IB
,      ILC
,      AILC
,      KSI
,      ROA
,      MANUAL
,      OEQ
,      PREV_OEQ
,      VQI
,      SEQ_UPDATED_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_UC_EXP_QUAL_SUM;

Dependencies

[top of page]

IGS.IGS_UC_EXP_QUAL_SUM does not reference any database object

IGS.IGS_UC_EXP_QUAL_SUM is referenced by following:

APPS: IGS_UC_EXP_QUAL_SUM