[Home] [Help]
View: IGF_GR_TUITION_FEES_V
| Product: | IGF - Financial Aid (Obsolete) |
|---|
| Description: | Stores the start and end range amounts of low tuition fee codes |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT TUFEE.ROWID
, TUFEE. LT_FEES_CODE
, TUFEE.MIN_RANGE_AMT
, TUFEE.MAX_RANGE_AMT
, TUFEE.CAL_TYPE
, TUFEE.SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.ALTERNATE_CODE
, TUFEE.CREATED_BY
, TUFEE.CREATION_DATE
, TUFEE.LAST_UPDATED_BY
, TUFEE.LAST_UPDATE_DATE
, TUFEE.LAST_UPDATE_LOGIN
FROM IGF_GR_TUITION_FEES TUFEE
, IGS_CA_INST CI
WHERE TUFEE.CAL_TYPE = CI.CAL_TYPE
AND TUFEE.SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
Columns
| Name |
| ROW_ID |
| LT_FEES_CODE |
| MIN_RANGE_AMT |
| MAX_RANGE_AMT |
| CAL_TYPE |
| SEQUENCE_NUMBER |
| START_DT |
| END_DT |
| ALTERNATE_CODE |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |