[Home] [Help]
View: IGS_EN_SVS_AUTH_CAL_V
Product: | IGS - Student System (Obsolete) |
Description: | SEVIS Authorization Calendars |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SAC.ROWID
, SAC.SEVIS_AUTH_ID
, SAC.CAL_TYPE
, SAC.CI_SEQUENCE_NUMBER
, CI.DESCRIPTION CI_DESCRIPTION
, CI.START_DT
, CI.END_DT
, SAC.CREATED_BY
, SAC.CREATION_DATE
, SAC.LAST_UPDATED_BY
, SAC.LAST_UPDATE_DATE
, SAC.LAST_UPDATE_LOGIN
FROM IGS_EN_SVS_AUTH_CAL SAC
, IGS_CA_INST CI
WHERE CI.CAL_TYPE = SAC.CAL_TYPE
AND CI.SEQUENCE_NUMBER = SAC.CI_SEQUENCE_NUMBER
Columns
Name |
ROW_ID |
SEVIS_AUTH_ID |
CAL_TYPE |
CI_SEQUENCE_NUMBER |
CI_DESCRIPTION |
START_DT |
END_DT |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |