[Home] [Help]
View: IGS_PS_FIELD_STUDY_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | The entity holds information about field of study |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT PFS.ROWID
, PFS.COURSE_CD
, PFS.VERSION_NUMBER
, FOS.FOS_TYPE_CODE
, FOS.FOS_TYPE_CODE_DESC
, PFS.FIELD_OF_STUDY
, PFS.MAJOR_FIELD_IND
, PFS.PERCENTAGE
, PFS.CREATED_BY
, PFS.CREATION_DATE
, PFS.LAST_UPDATED_BY
, PFS.LAST_UPDATE_DATE
, PFS.LAST_UPDATE_LOGIN
FROM IGS_PS_FIELD_STUDY PFS
, IGS_PS_FLD_OF_STUDY FOS
WHERE FOS.FIELD_OF_STUDY = PFS.FIELD_OF_STUDY
Columns
| Name |
| ROW_ID |
| COURSE_CD |
| VERSION_NUMBER |
| FOS_TYPE_CODE |
| FOS_TYPE_CODE_DESC |
| FIELD_OF_STUDY |
| MAJOR_FIELD_IND |
| PERCENTAGE |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |