Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT TAB.ROWID ROW_ID
, TAB.FOS_TYPE_CODE FOS_TYPE_CODE
, US.MEANING FOS_TYPE_CODE_DESC
, TAB.FIELD_OF_STUDY FIELD_OF_STUDY
, TAB.HIST_START_DT HIST_START_DT
, TAB.HIST_END_DT HIST_END_DT
, TAB.HIST_WHO HIST_WHO
, TAB.DESCRIPTION DESCRIPTION
, TAB.GOVT_FIELD_OF_STUDY GOVT_FIELD_OF_STUDY
, TAB.CLOSED_IND CLOSED_IND
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.ORG_ID ORG_ID
FROM IGS_PS_FLD_STDY_HIST_ALL TAB
, IGS_LOOKUP_VALUES US
WHERE TAB.FOS_TYPE_CODE = US.LOOKUP_CODE
AND US.LOOKUP_TYPE = 'PS_FOS_TYPE_CD'