[Home] [Help]
View: IGS_EN_SEVIS_AUTH_V
Product: | IGS - Student System (Obsolete) |
Description: | Obsolete |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ESA.ROWID ROW_ID
, ESA.SEVIS_AUTHORIZATION_CD
, LKV.MEANING
, ESA.START_DT
, ESA.END_DT
, ESA.COMMENTS
, ESA.ELGB_OVERRIDE_ID
, ESA.CREATED_BY
, ESA.CREATION_DATE
, ESA.LAST_UPDATED_BY
, ESA.LAST_UPDATE_DATE
, ESA.LAST_UPDATE_LOGIN
, ESA.REQUEST_ID
, ESA.PROGRAM_APPLICATION_ID
, ESA.PROGRAM_ID
, ESA.PROGRAM_UPDATE_DATE
FROM IGS_EN_SEVIS_AUTH ESA
, IGS_LOOKUPS_VIEW LKV
WHERE LKV.LOOKUP_TYPE = 'IGS_EN_SEVIS_AUTH_CODES'
AND LKV.LOOKUP_CODE = ESA.SEVIS_AUTHORIZATION_CD
Columns
Name |
ROW_ID |
SEVIS_AUTHORIZATION_CD |
SEVIS_AUTH_CD_MEANING |
START_DT |
END_DT |
COMMENTS |
ELGB_OVERRIDE_ID |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |