[Home] [Help]
View: IGSBV_UC_FORM_QUALIFICATIONS
Product: | IGS - Student System (Obsolete) |
Description: | Base View for individual Form Qualifications |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT FO.APP_NO UCAS_APPLICANT_NUMBER
, FO.QUAL_ID QUALIFICATION_IDENTIFIER
, FO.QUAL_TYPE QUALIFICATION_TYPE
, FO.AWARD_BODY AWARDING_BODY
, FO.TITLE TITLE
, FO.GRADE GRADE
, FO.QUAL_DATE QUALFICATION_DATE
, FT1.OSS_PERSON_ID OSS_PERSON_IDENTIFIER
, FO.CREATED_BY CREATED_BY
, FO.CREATION_DATE CREATION_DATE
, FO.LAST_UPDATED_BY LAST_UPDATED_BY
, FO.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_UC_FORM_QUALS FO
, IGS_UC_APPLICANTS FT1
WHERE FO.APP_NO = FT1.APP_NO WITH READ ONLY
Columns
Name |
UCAS_APPLICANT_NUMBER |
QUALIFICATION_IDENTIFIER |
QUALIFICATION_TYPE |
AWARDING_BODY |
TITLE |
GRADE |
QUALIFICATION_DATE |
OSS_PERSON_IDENTIFIER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |