eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_GE_S_LOG_ENTRY_V

Product:	IGS - Student System (Obsolete)
Description:	Represents the S_LOG_ENTRY table with the key seperated into fields.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SLE.CREATION_DT
, SLE.S_LOG_TYPE
, SLE.SEQUENCE_NUMBER
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 1
, '|') FIELD_1
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 2
, '|') FIELD_2
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 3
, '|') FIELD_3
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 4
, '|') FIELD_4
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 5
, '|') FIELD_5
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 6
, '|') FIELD_6
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 7
, '|') FIELD_7
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 8
, '|') FIELD_8
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 9
, '|') FIELD_9
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 10
, '|') FIELD_10
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 11
, '|') FIELD_11
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 12
, '|') FIELD_12
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 13
, '|') FIELD_13
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 14
, '|') FIELD_14
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 15
, '|') FIELD_15
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 16
, '|') FIELD_16
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 17
, '|') FIELD_17
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 18
, '|') FIELD_18
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 19
, '|') FIELD_19
, IGS_GE_GEN_002.GENP_GET_DELIMIT_STR(SLE.KEY
, 20
, '|') FIELD_20
, SLE.MESSAGE_NAME
, SLE.TEXT
, SLE.CREATED_BY
, SLE.CREATION_DATE
, SLE.LAST_UPDATED_BY
, SLE.LAST_UPDATE_DATE
, SLE.LAST_UPDATE_LOGIN
FROM IGS_GE_S_LOG_ENTRY SLE

Columns

Name
CREATION_DT
S_LOG_TYPE
SEQUENCE_NUMBER
FIELD_1
FIELD_2
FIELD_3
FIELD_4
FIELD_5
FIELD_6
FIELD_7
FIELD_8
FIELD_9
FIELD_10
FIELD_11
FIELD_12
FIELD_13
FIELD_14
FIELD_15
FIELD_16
FIELD_17
FIELD_18
FIELD_19
FIELD_20
TEXT
MESSAGE_NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN