[Home] [Help]
View: IGS_PE_USR_AVAL
Product: | IGS - Student System (Obsolete) |
Description: | Describes all the columns related to self service user activity setup for enrollment validations |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT UAV.ROWID ROW_ID
, UAV.USR_ACT_VAL_ID USR_ACT_VAL_ID
, UAV.PERSON_TYPE PERSON_TYPE
, UAV.VALIDATION VALIDATION
, LKV.MEANING VAL_MEANING
, UAV.DENY_WARN
, UAV.OVERRIDE_IND
, UAV.OVERRIDE_DT
, UAV.ORG_ID
, UAV.STEP_OVERRIDE_LIMIT
, UAV.CREATED_BY CREATED_BY
, UAV.CREATION_DATE CREATION_DATE
, UAV.LAST_UPDATED_BY LAST_UPDATED_BY
, UAV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UAV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PE_USR_AVAL_ALL UAV
, IGS_LOOKUP_VALUES LKV
WHERE LKV.LOOKUP_CODE = UAV.VALIDATION
AND ( LKV.LOOKUP_TYPE = 'ENROLMENT_STEP_TYPE_EXT' OR LKV.LOOKUP_TYPE = 'ENROLMENT_OVR_STEP_TYPE')
AND LKV.CLOSED_IND <> 'Y'
AND (NVL (UAV.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99) )
Columns
Name |
ROW_ID |
USR_ACT_VAL_ID |
PERSON_TYPE |
VALIDATION |
VAL_MEANING |
DENY_WARN |
OVERRIDE_IND |
OVERRIDE_DT |
ORG_ID |
STEP_OVERRIDE_LIMIT |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |