[Home] [Help]
View: IGSBV_HR_ED_PR_CATEGORIZATIONS
Product: | IGS - Student System (Obsolete) |
Description: | This is the base view which describes the categories that are applied to a program. There can be multiple categories for each program. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CAT1.COURSE_CD
, CAT1.VERSION_NUMBER
, CAT1.COURSE_CAT
, PSV.TITLE
, CAT2.DESCRIPTION
, CAT1.CREATED_BY
, CAT1.CREATION_DATE
, CAT1.LAST_UPDATED_BY
, CAT1.LAST_UPDATE_DATE
FROM IGS_PS_CATEGORISE_ALL CAT1
, IGS_PS_CAT CAT2
, IGS_PS_VER_ALL PSV
WHERE CAT1.COURSE_CAT = CAT2.COURSE_CAT
AND CAT1.COURSE_CD = PSV.COURSE_CD
AND CAT1.VERSION_NUMBER = PSV.VERSION_NUMBER WITH READ ONLY
Columns
Name |
PROGRAM_CODE |
VERSION_NUMBER |
PROGRAM_CATEGORY |
PROGRAM_TITLE |
PROGRAM_CATEGORY_DESCRIPTION |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |