[Home] [Help] [Dependency Information]
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 |
A Business Intelligence System view
Full View for summary of qualifications attained by this applicant
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 |
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;
APPS.IGSFV_UC_EXP_QUAL_SUMMARIES is not referenced by any database object
|
|
|