DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGSFV_UC_FORM_QUALIFICATIONS

Object Details
Object Name: IGSFV_UC_FORM_QUALIFICATIONS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSFV_UC_FORM_QUALIFICATIONS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Full View for individual Form Qualifications


[View Source]

Columns
Name Datatype Length Mandatory Comments
UCAS_APPLICANT_NUMBER NUMBER (22) Yes Applicant Number
QUALIFICATION_IDENTIFIER NUMBER (15)
Qualification identifier
QUALIFICATION__TYPE VARCHAR2 (30)
Qualification type
AWARDING_BODY VARCHAR2 (10)
Awarding body
TITLE VARCHAR2 (100)
Title
GRADE VARCHAR2 (20)
Grade obtained
QUALIFICATION__DATE DATE

Qualification date
OSS_PERSON_IDENTIFIER NUMBER (15)
OSS Person Identifier
OSS_PERSON_NUMBER VARCHAR2 (30)
OSS Person Number
OSS_PERSON_NAME VARCHAR2 (360)
OSS Person Name
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
Query Text

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


SELECT UCAS_APPLICANT_NUMBER
,      QUALIFICATION_IDENTIFIER
,      QUALIFICATION__TYPE
,      AWARDING_BODY
,      TITLE
,      GRADE
,      QUALIFICATION__DATE
,      OSS_PERSON_IDENTIFIER
,      OSS_PERSON_NUMBER
,      OSS_PERSON_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_UC_FORM_QUALIFICATIONS;

Dependencies

[top of page]

APPS.IGSFV_UC_FORM_QUALIFICATIONS references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymIGS_UC_APPLICANTS
SynonymIGS_UC_FORM_QUALS

APPS.IGSFV_UC_FORM_QUALIFICATIONS is not referenced by any database object