[Home] [Help]
View: IGS_PE_USR_ADISC
Product: | IGS - Student System (Obsolete) |
Description: | Obsolete - Describes all the columns related to self service user activity setup for discontinuation date alias |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT UAD.ROWID ROW_ID
, UAD.USR_ACT_DISC_ID USR_ACT_DISC_ID
, UAD.PERSON_TYPE PERSON_TYPE
, UAD.ADMINISTRATIVE_UNIT_STATUS ADMINISTRATIVE_UNIT_STATUS
, AUS.DESCRIPTION DESCRIPTION
, UAD.DISC_DT_ALIAS DISC_DT_ALIAS
, CDV.DESCRIPTION DISC_DT_ALIAS_DESC
, UAD.CREATED_BY CREATED_BY
, UAD.CREATION_DATE CREATION_DATE
, UAD.LAST_UPDATED_BY LAST_UPDATED_BY
, UAD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UAD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PE_USR_ADISC_ALL UAD
, IGS_AD_ADM_UNIT_STAT AUS
, IGS_CA_DA_V CDV
WHERE UAD.ADMINISTRATIVE_UNIT_STATUS = AUS. ADMINISTRATIVE_UNIT_STATUS
AND UAD.DISC_DT_ALIAS = CDV.DT_ALIAS
AND (NVL (UAD.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_DISC_ID |
PERSON_TYPE |
ADMINISTRATIVE_UNIT_STATUS |
DESCRIPTION |
DISC_DT_ALIAS |
DISC_DT_ALIAS_DESC |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |