[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This is a FORM view for program types form, which provides information about user defined program types. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT TAB.ROWID ROW_ID
, TAB.COURSE_TYPE COURSE_TYPE
, TAB.DESCRIPTION DESCRIPTION
, TAB.GOVT_COURSE_TYPE GOVT_COURSE_TYPE
, TAB.AWARD_COURSE_IND AWARD_COURSE_IND
, TAB.COURSE_TYPE_GROUP_CD COURSE_TYPE_GROUP_CD
, TAB.TAC_COURSE_LEVEL TAC_COURSE_LEVEL
, TAB.RESEARCH_TYPE_IND RESEARCH_TYPE_IND
, TAB.CLOSED_IND CLOSED_IND
, TAB.PRIMARY_AUTO_SELECT PRIMARY_AUTO_SELECT
, TAB.FIN_AID_PROGRAM_TYPE FIN_AID_PROGRAM_TYPE
, LV.MEANING
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.ORG_ID ORG_ID
, TAB.ENROLMENT_CAT ENROLMENT_CAT
FROM IGS_PS_TYPE TAB
, IGS_LOOKUP_VALUES LV
WHERE TAB.FIN_AID_PROGRAM_TYPE = LV.LOOKUP_CODE (+)
AND LV.LOOKUP_TYPE (+) = 'IGS_PS_FA_PROGRAM_TYPE'