[Home] [Help]
View: IGS_PS_USEC_SP_FEES_V
Product: | IGS - Student System (Obsolete) |
Description: | Special fees for a unit section |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT USCF.ROWID ROW_ID
, USCF.USEC_SP_FEES_ID
, USCF.UOO_ID
, USCF.FEE_TYPE
, FEE.DESCRIPTION FEE_TYPE_DESC
, USCF.SP_FEE_AMT
, USCF.CLOSED_FLAG
, USCF.CREATED_BY
, USCF.CREATION_DATE
, USCF.LAST_UPDATED_BY
, USCF.LAST_UPDATE_DATE
, USCF.LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_SP_FEES USCF
, IGS_FI_FEE_TYPE_ALL FEE
WHERE USCF.FEE_TYPE = FEE.FEE_TYPE
Columns
Name |
ROW_ID |
USEC_SP_FEES_ID |
UOO_ID |
FEE_TYPE |
FEE_TYPE_DESC |
SP_FEE_AMT |
CLOSED_FLAG |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |