[Home] [Help]
View: IGSBV_UNIT_FIELD_OF_STUDIES
Product: | IGS - Student System (Obsolete) |
Description: | This is the base view, which describes the Unit Field Of Study with details unit code, version number and field of study |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT UN.UNIT_FIELD_OF_STUDY_ID
, UN.UNIT_CODE
, UN.VERSION_NUMBER
, UN.FIELD_OF_STUDY
, UN.CREATED_BY
, UN.CREATION_DATE
, UN.LAST_UPDATED_BY
, UN.LAST_UPDATE_DATE
FROM IGS_PS_UNIT_FLD_STDY UN WITH READ ONLY
Columns
Name |
UNIT_FIELD_OF_STUDY_ID |
UNIT_CODE |
VERSION_NUMBER |
FIELD_OF_STUDY |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |