eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGF_AW_FISAP_SECTION_VI_V

Product:	IGF - Financial Aid (Obsolete)
Description:	This entity is used to derive the count of the Students as well as the sum of their disbursed amounts for Campus Based Funds for the section VI of FISAP Reporting
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT A.ROWID
, A.CATEGORY_ID
, A.FISAP_SECTION
, 'NON_PROFESSIONAL'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'NON_PROFESSIONAL'
, 'PRK'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'NON_PROFESSIONAL'
, 'PRK'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'NON_PROFESSIONAL'
, 'FSEOG'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'NON_PROFESSIONAL'
, 'FSEOG'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'NON_PROFESSIONAL'
, 'FWS'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'NON_PROFESSIONAL'
, 'FWS'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'NON_PROFESSIONAL'
, 'UNDUPL'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, B.MINVALUE
, B.MAXVALUE)
FROM IGF_AW_FISAP_REPSET A
, IGF_AW_FI_INC_LEVEL B
WHERE A.CATEGORY_ID = B.CATEGORY_ID
AND A.FISAP_SECTION ='SECTION_VI' UNION SELECT A.ROWID
, 0
, 'SECTION_VI'
, 'PROFESSIONAL'
, 'I'
, '3'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'PROFESSIONAL'
, 'PRK'
, 'I'
, '3'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'PROFESSIONAL'
, 'PRK'
, 'I'
, '3'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'PROFESSIONAL'
, 'FSEOG'
, 'I'
, '3'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'PROFESSIONAL'
, 'FSEOG'
, 'I'
, '3'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'PROFESSIONAL'
, 'FWS'
, 'I'
, '3'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND( 'PROFESSIONAL'
, 'FWS'
, 'I'
, '3'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'PROFESSIONAL'
, 'UNDUPL'
, 'I'
, '3'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
FROM IGF_AW_FISAP_REPSET A
WHERE A.FISAP_SECTION = 'SECTION_VI' UNION SELECT A.ROWID
, 0
, 'SECTION_VI'
, 'AUTO_ZERO'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'AUTO_ZERO'
, 'PRK'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'AUTO_ZERO'
, 'PRK'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'AUTO_ZERO'
, 'FSEOG'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'AUTO_ZERO'
, 'FSEOG'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'AUTO_ZERO'
, 'FWS'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'AUTO_ZERO'
, 'FWS'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'AUTO_ZERO'
, 'UNDUPL'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
FROM IGF_AW_FISAP_REPSET A
WHERE A.FISAP_SECTION = 'SECTION_VI' UNION SELECT A.ROWID
, 0
, 'SECTION_VI'
, 'LESS_THAN_FULL_TIME'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'LESS_THAN_FULL_TIME'
, 'PRK'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'LESS_THAN_FULL_TIME'
, 'PRK'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'LESS_THAN_FULL_TIME'
, 'FSEOG'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'LESS_THAN_FULL_TIME'
, 'FSEOG'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'LESS_THAN_FULL_TIME'
, 'FWS'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_FUND ( 'LESS_THAN_FULL_TIME'
, 'FWS'
, 'B'
, 'GRAD_UGRAD'
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
, IGF_AW_GEN_002.GET_SECTIONVI_STDNT ( 'LESS_THAN_FULL_TIME'
, 'UNDUPL'
, A.DEPEND_STAT
, A.CLASS_STANDING
, A.CI_CAL_TYPE
, A.CI_SEQUENCE_NUMBER
, 0
, 0)
FROM IGF_AW_FISAP_REPSET A
WHERE A.FISAP_SECTION = 'SECTION_VI'

Columns

Name
ROW_ID
CATEGORY_ID
FISAP_SECTION
REC_TYPE
DEPEND_STAT
CLASS_STANDING
CI_CAL_TYPE
CI_SEQUENCE_NUMBER
MINVALUE
MAXVALUE
FED_PERKINS_STD_COUNT
FED_PERKINS_FUND_TOTAL
FSEOG_STD_COUNT
FSEOG_FUND_TOTAL
FWS_STD_COUNT
FWS_FUND_TOTAL
UNDUPLICATED_STD_COUNT