[Home] [Help]
View: IGS_PS_US_FLD_STUDY_V
Product: | IGS - Student System (Obsolete) |
Description: | This view describes the field of study details for unit set. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT UFS.ROWID ROW_ID
, UFS.UNIT_SET_CD
, UFS.VERSION_NUMBER
, FOS.FOS_TYPE_CODE
, FOS.FOS_TYPE_CODE_DESC
, UFS.FIELD_OF_STUDY
, FOS.DESCRIPTION
, UFS.CREATED_BY
, UFS.CREATION_DATE
, UFS.LAST_UPDATED_BY
, UFS.LAST_UPDATE_DATE
, UFS.LAST_UPDATE_LOGIN
FROM IGS_PS_US_FLD_STUDY UFS
, IGS_PS_FLD_OF_STUDY FOS
WHERE UFS.FIELD_OF_STUDY = FOS.FIELD_OF_STUDY
Columns
Name |
ROW_ID |
UNIT_SET_CD |
VERSION_NUMBER |
FOS_TYPE_CODE |
FOS_TYPE_CODE_DESC |
FIELD_OF_STUDY |
DESCRIPTION |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |