[Home] [Help]
View: IGS_EN_PIG_S_SETUP_V
Product: | IGS - Student System (Obsolete) |
Description: | Person ID Group Enrollment Step Setup View |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PIGES.ROWID
, PIGES.GROUP_ID
, PIGES.S_ENROLMENT_STEP_TYPE
, LKUPS.MEANING
, LKUPS.STEP_GROUP_TYPE
, PIGES.NOTIFICATION_FLAG
, PIGES.CREATED_BY
, PIGES.CREATION_DATE
, PIGES.LAST_UPDATED_BY
, PIGES.LAST_UPDATE_DATE
, PIGES.LAST_UPDATE_LOGIN
FROM IGS_EN_PIG_S_SETUP PIGES
, IGS_LOOKUPS_VIEW LKUPS
WHERE LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE_EXT'
AND LOOKUP_CODE = S_ENROLMENT_STEP_TYPE
Columns
Name |
ROW_ID |
GROUP_ID |
S_ENROLMENT_STEP_TYPE |
ENROLMENT_STEP_MEANING |
STEP_GROUP_TYPE |
NOTIFICATION_FLAG |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |