[Home] [Help]
View: IGS_AD_QUAL_TYPE_V
Product: | IGS - Student System (Obsolete) |
Description: | This will be the base view for new window qualcode in IGSAD037 form |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AQC.ROWID
, AQC.ADMISSION_CAT
, AQC.S_ADMISSION_PROCESS_TYPE
, AQC.QUALIFYING_TYPE_CODE
, FLV.MEANING
, FLV.DESCRIPTION
, AQC.CLOSED_FLAG
, AQC.CREATED_BY
, AQC.CREATION_DATE
, AQC.LAST_UPDATED_BY
, AQC.LAST_UPDATE_DATE
, AQC.LAST_UPDATE_LOGIN
FROM IGS_AD_QUAL_TYPE AQC
, IGS_LOOKUP_VALUES FLV
WHERE FLV.LOOKUP_TYPE='IGS_AD_QUAL_TYPE'
AND FLV.LOOKUP_CODE = AQC.QUALIFYING_TYPE_CODE
Columns
Name |
ROW_ID |
ADMISSION_CAT |
S_ADMISSION_PROCESS_TYPE |
QUALIFYING_TYPE_CODE |
MEANING |
DESCRIPTION |
CLOSED_FLAG |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |