[Home] [Help]
View: IGF_AW_FISAP_SECTION_II_V
Product: | IGF - Financial Aid (Obsolete) |
Description: | Stores the count of the Students, who have their FISAP Income between the income ranges as specified in the FISAP Reporting |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT A.ROWID
, A.CATEGORY_ID
, A.FISAP_SECTION
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE
, IGF_AW_GEN_002.GET_SECTIONII_STDNT ( A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE
, 'FALSE')
, 'N'
FROM IGF_AW_FISAP_REPSET A
, IGF_AW_FI_INC_LEVEL B
WHERE A.CATEGORY_ID = B.CATEGORY_ID
AND A.FISAP_SECTION ='SECTION_II' UNION SELECT A.ROWID
, A.CATEGORY_ID
, A.FISAP_SECTION
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0
, IGF_AW_GEN_002.GET_SECTIONII_STDNT ( A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0
, 'TRUE')
, 'Y'
FROM IGF_AW_FISAP_REPSET A
WHERE A.FISAP_SECTION = 'SECTION_II'
Columns
Name |
ROW_ID |
CATEGORY_ID |
FISAP_SECTION |
DEPEND_STAT |
CLASS_STANDING |
CI_CAL_TYPE |
CI_SEQUENCE_NUMBER |
MINVALUE |
MAXVALUE |
STUDENT_COUNT |
AUTO_EFC |