Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT POT.ROWID ROW_ID
, POT.PROGRAM_OCCUPATIONAL_TITLE_ID PROGRAM_OCCUPATIONAL_TITLE_ID
, POT.PROGRAM_CODE PROGRAM_CODE
, POT.OCCUPATIONAL_TITLE_CODE OCCUPATIONAL_TITLE_CODE
, DOT.OCCUPATIONAL_TITLE OCCUPATIONAL_TITLE
, DOT.ALTERNATE_TITLE ALTERNATE_TITLE
, UV.TITLE PROGRAM_TITLE
, POT.CREATED_BY CREATED_BY
, POT.CREATION_DATE CREATION_DATE
, POT.LAST_UPDATED_BY LAST_UPDATED_BY
, POT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, POT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_OCCUP_TITLES POT
, IGS_PS_DIC_OCC_TITLS DOT
, IGS_PS_VER UV
WHERE POT.OCCUPATIONAL_TITLE_CODE = DOT.OCCUPATIONAL_TITLE_CODE
AND POT.PROGRAM_CODE = UV.COURSE_CD
AND UV.VERSION_NUMBER = 1