[Home] [Help]
View: IGSFV_FIELDS_OF_STUDY
Product: | IGS - Student System (Obsolete) |
Description: | This is the full view which describes university set of fields of study. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT FOS.FIELD_OF_STUDY
, FOS.DESCRIPTION
, FOS.GOVT_FIELD_OF_STUDY
, FOS.CLOSED_IND
, RE.DESCRIPTION
, FOS.CREATED_BY
, FOS.CREATION_DATE
, FOS.LAST_UPDATED_BY
, FOS.LAST_UPDATE_DATE
FROM IGS_PS_FLD_OF_STUDY_ALL FOS
, IGS_RE_GV_FLD_OF_SDY RE
WHERE FOS.GOVT_FIELD_OF_STUDY = RE.GOVT_FIELD_OF_STUDY WITH READ ONLY
Columns
Name |
FIELD_OF_STUDY |
FIELD_OF_STUDY_DESCRIPTION |
GOVT_FIELD_OF_STUDY |
CLOSED_INDICATOR |
GOVT_FIELD_OF_STUDY_DESC |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |