[Home] [Help]
View: IGSFV_ADM_FEE_CAT
Product: | IGS - Student System (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT IFF.FEE_CAT
, IFC.DESCRIPTION
, IFF.ADMISSION_CAT
, AC.DESCRIPTION
, '_LA:IFF.DFLT_CAT_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, IFF.CREATED_BY
, IFF.CREATION_DATE
, IFF.LAST_UPDATED_BY
, IFF.LAST_UPDATE_DATE
FROM IGS_FI_FEE_CAT_MAP IFF
, IGS_FI_FEE_CAT_ALL IFC
, IGS_AD_CAT_ALL AC
WHERE IFF.ADMISSION_CAT = AC.ADMISSION_CAT
AND IFF.FEE_CAT = IFC.FEE_CAT(+) WITH READ ONLY
Columns
Name |
FEE_CATEGORY |
FEE_CATEGORY_DESC |
ADMISSION_CATEGORY |
ADMISSION_CATEGORY_DESC |
"_LA:DFLT_CAT_IND" |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |