[Home] [Help]
View: IGSBV_UNIT_SET_FLD_OF_STUDIES
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | This is the base view which describes the field of studies for unit set |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT UFS.UNIT_SET_CD
, UFS.VERSION_NUMBER
, US.TITLE
, UFS.FIELD_OF_STUDY
, FOS.DESCRIPTION
, UFS.CREATED_BY
, UFS.CREATION_DATE
, UFS.LAST_UPDATED_BY
, UFS.LAST_UPDATE_DATE
FROM IGS_PS_US_FLD_STUDY UFS
, IGS_EN_UNIT_SET_ALL US
, IGS_PS_FLD_OF_STUDY FOS
WHERE UFS.UNIT_SET_CD=US. UNIT_SET_CD
AND UFS.VERSION_NUMBER =US.VERSION_NUMBER
AND UFS.FIELD_OF_STUDY = FOS. FIELD_OF_STUDY WITH READ ONLY
Columns
| Name |
| UNIT_SET_CODE |
| UNIT_SET_VERSION_NUMBER |
| UNIT_SET_TITLE |
| FIELD_OF_STUDY |
| FIELD_OF_STUDY_DESCRIPTION |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |