[Home] [Help]
View: IGS_AD_UNIT_SETS_V
Product: | IGS - Student System (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AUS.ROWID ROW_ID
, AUS.UNIT_SET_ID
, AUS.PERSON_ID
, AUS.ADMISSION_APPL_NUMBER
, AUS.NOMINATED_COURSE_CD
, AUS.SEQUENCE_NUMBER
, AUS.UNIT_SET_CD
, AUS.VERSION_NUMBER
, EUS.TITLE
, AUS.RANK
, AUS.CREATED_BY
, AUS.CREATION_DATE
, AUS.LAST_UPDATED_BY
, AUS.LAST_UPDATE_DATE
, AUS.LAST_UPDATE_LOGIN FROM IGS_AD_UNIT_SETS AUS
, IGS_EN_UNIT_SET EUS
WHERE AUS.UNIT_SET_CD = EUS.UNIT_SET_CD AND AUS.VERSION_NUMBER = EUS.VERSION_NUMBER
Columns
Name |
ROW_ID |
UNIT_SET_ID |
PERSON_ID |
ADMISSION_APPL_NUMBER |
NOMINATED_COURSE_CD |
SEQUENCE_NUMBER |
UNIT_SET_CD |
VERSION_NUMBER |
TITLE |
RANK |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |