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]

VIEW: APPS.IGSFV_UC_EXP_QUAL_SUMMARIES

Object Details

Object Name:	IGSFV_UC_EXP_QUAL_SUMMARIES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_UC_EXP_QUAL_SUMMARIES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Full View for summary of qualifications attained by this applicant

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EXPECTED_QUAL_SUMMARY_ID	NUMBER		Yes	Expected qualification summary identifier
OSS_PERSON_IDENTIFIER	NUMBER	(15)	Yes	OSS Person Identifier
EXPECTED_GCE	NUMBER	(1)		Expected CGE
EXPECTED_VCE	NUMBER	(1)		Expected VCE
WINTER_A_LEVELS	NUMBER	(1)		Winter A Levels
PREVIOUS_A_LEVELS	NUMBER	(1)		Previous A Level
PREVIOUS_AS_LEVELS	NUMBER	(1)		Previous AS Level
SQA_CANDIDATE_FLAG	VARCHAR2	(1)		SQA Candidate
QUAL_BTEC_FLAG	VARCHAR2	(1)		BTEC Indicator
QUAL_IB_FLAG	VARCHAR2	(1)		IB Indicator
QUAL_ILC_FLAG	VARCHAR2	(1)		ILC Indicator
QUAL_AILC_FLAG	VARCHAR2	(1)		AICE Indicator
KEY_SKILLS_FLAG	VARCHAR2	(1)		Key Skills Indicator
RECORD_OF_ACHEIVEMENT_FLAG	VARCHAR2	(1)		ROA Indicator
MANUAL_QUAL_CHECK	VARCHAR2	(1)		Manual Check Required
OTHER_EXAMINATION_QUAL_FLAG	VARCHAR2	(1)		OEQ Indicator
PREVIOUS_OTHER_EXAM_QUAL_FLAG	VARCHAR2	(1)		Previous OEQ
VOCATIONAL_QUAL_INDICATOR	VARCHAR2	(1)		Vocational Qualification Indicator
SEQ_UPDATED_DATE	DATE		Yes	Sequence Updated Date
OSS_PERSON_NUMBER	VARCHAR2	(30)		OSS Person Number
OSS_PERSON_NAME	VARCHAR2	(360)		OSS Person Name
OTHER_EXAMINATION_QUAL_DESC	VARCHAR2	(300)		OEQ Description
PREVIOUS_OTHER_EXAM_QUAL_DESC	VARCHAR2	(300)		Previous OEQ Description
VOCATIONAL_QUAL_DESCRIPTION	VARCHAR2	(240)		Vocational Qualification Description
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

Query Text

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


SELECT EXPECTED_QUAL_SUMMARY_ID
,      OSS_PERSON_IDENTIFIER
,      EXPECTED_GCE
,      EXPECTED_VCE
,      WINTER_A_LEVELS
,      PREVIOUS_A_LEVELS
,      PREVIOUS_AS_LEVELS
,      SQA_CANDIDATE_FLAG
,      QUAL_BTEC_FLAG
,      QUAL_IB_FLAG
,      QUAL_ILC_FLAG
,      QUAL_AILC_FLAG
,      KEY_SKILLS_FLAG
,      RECORD_OF_ACHEIVEMENT_FLAG
,      MANUAL_QUAL_CHECK
,      OTHER_EXAMINATION_QUAL_FLAG
,      PREVIOUS_OTHER_EXAM_QUAL_FLAG
,      VOCATIONAL_QUAL_INDICATOR
,      SEQ_UPDATED_DATE
,      OSS_PERSON_NUMBER
,      OSS_PERSON_NAME
,      OTHER_EXAMINATION_QUAL_DESC
,      PREVIOUS_OTHER_EXAM_QUAL_DESC
,      VOCATIONAL_QUAL_DESCRIPTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.IGSFV_UC_EXP_QUAL_SUMMARIES;

Dependencies

[top of page]

APPS.IGSFV_UC_EXP_QUAL_SUMMARIES references the following:

APPS: HZ_PARTIES; IGS_HE_CODE_VALUES; IGS_UC_EXP_QUAL_SUM; IGS_UC_REF_CODES

APPS.IGSFV_UC_EXP_QUAL_SUMMARIES is not referenced by any database object