This is the full view, which describes the Field of Study with details unit code, version number, unit title, field of study and field of study description
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 , UNV.TITLE UNIT_TITLE , FL.DESCRIPTION FIELD_OF_STUDY_DESCRIPTION , UN.CREATED_BY , UN.CREATION_DATE , UN.LAST_UPDATED_BY , UN.LAST_UPDATE_DATE FROM IGS_PS_UNIT_FLD_STDY UN , IGS_PS_FLD_OF_STUDY_ALL FL , IGS_PS_UNIT_VER_ALL UNV WHERE UN.UNIT_CODE = UNV.UNIT_CD AND UN.VERSION_NUMBER = UNV.VERSION_NUMBER AND UN.FIELD_OF_STUDY = FL.FIELD_OF_STUDY WITH READ ONLY