[Home] [Help]
View: IGS_UC_IVSTARH_V
Product: | IGS - Student System (Obsolete) |
Description: | This view selects the HESA statistics information for the FTUG system as well as the other Small Systems - OBSOLETE |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT UCAS.APPNO
, UCAS.TIMESTAMP
, UCAS.ETHNIC
, UCAS.SOCIALCLASS
, UCAS.POCCEDUCHANGEDATE
, UCAS.POCC
, UCAS.POCCTEXT
, UCAS.LASTEDUCATION
, UCAS.EDUCATIONLEAVEDATE
, UCAS.LEA
, UCAS.SOCIALECONOMIC
, SSYS.DEPENDANTS
, SSYS.MARRIED
FROM IGS_UC_MV_IVSTARH UCAS
, IGS_UC_SS_IVSTARH SSYS
WHERE UCAS.APPNO = SSYS.APPNO UNION ALL SELECT UCAS.APPNO
, UCAS.TIMESTAMP
, UCAS.ETHNIC
, UCAS.SOCIALCLASS
, UCAS.POCCEDUCHANGEDATE
, UCAS.POCC
, UCAS.POCCTEXT
, UCAS.LASTEDUCATION
, UCAS.EDUCATIONLEAVEDATE
, UCAS.LEA
, UCAS.SOCIALECONOMIC
, TO_NUMBER(NULL)
, NULL
FROM IGS_UC_MV_IVSTARH UCAS
WHERE NOT EXISTS ( SELECT 1
FROM IGS_UC_SS_IVSTARH SSYS
WHERE UCAS.APPNO = SSYS.APPNO )
Columns
Name |
APPNO |
TIMESTAMP |
ETHNIC |
SOCIALCLASS |
POCCEDUCHANGEDATE |
POCC |
POCCTEXT |
LASTEDUCATION |
EDUCATIONLEAVEDATE |
LEA |
SOCIALECONOMIC |
DEPENDANTS |
MARRIED |