[Home] [Help]
View: IGS_UC_ADM_SYSTEMS_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | List of the UCAS System details. - OBSOLETE |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT ADM.ROWID ROW_ID
, ADM.SYSTEM_ID
, LV.MEANING NAME
, LV.DESCRIPTION
, LV.LOOKUP_CODE UCAS_SYSTEM_CODE
, ADM.UCAS_SECURITY_KEY
, ADM.MARVIN_SEQ
, ADM.CLEARING_FLAG
, ADM.EXTRA_FLAG
, ADM.CVNAME_FLAG
, ADM.CREATION_DATE
, ADM.CREATED_BY
, ADM.LAST_UPDATE_LOGIN
, ADM.LAST_UPDATED_BY
, ADM.LAST_UPDATE_DATE
FROM IGS_UC_ADM_SYSTEMS ADM
, IGS_LOOKUPS_VIEW LV
WHERE ADM.UCAS_SYSTEM_CODE = LV.LOOKUP_CODE
AND LV.LOOKUP_TYPE = 'IGS_UC_ADM_SYS_TYP'
Columns
| Name |
| ROW_ID |
| SYSTEM_ID |
| NAME |
| DESCRIPTION |
| UCAS_SYSTEM_CODE |
| UCAS_SECURITY_KEY |
| MARVIN_SEQ |
| CLEARING_FLAG |
| EXTRA_FLAG |
| CVNAME_FLAG |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_LOGIN |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |