[Home] [Help]
View: IGS_PS_FLD_OF_STUDY
Product: | IGS - Student System (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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.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_OF_STUDY_ALL TAB
, IGS_LOOKUP_VALUES US
WHERE TAB.FOS_TYPE_CODE = US.LOOKUP_CODE
AND US.LOOKUP_TYPE = 'PS_FOS_TYPE_CD'
Columns
Name |
ROW_ID |
FOS_TYPE_CODE |
FOS_TYPE_CODE_DESC |
FIELD_OF_STUDY |
DESCRIPTION |
GOVT_FIELD_OF_STUDY |
CLOSED_IND |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
ORG_ID |