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_AWD_LD_CAL_V

Product:	IGF - Financial Aid (Obsolete)
Description:	Retrieves all the load calendars that fall within an award year
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AW.ROW_ID
, AW.CAL_TYPE
, AW.SEQUENCE_NUMBER
, AW.ALTERNATE_CODE
, AW.START_DT
, AW.END_DT
, LD.CAL_TYPE
, LD.SEQUENCE_NUMBER
, LD.ALTERNATE_CODE
, LD.START_DT
, LD.END_DT
FROM IGS_CA_INST AW
, IGS_CA_INST LD
, IGS_CA_TYPE LD_T
, IGS_CA_TYPE AW_T
, IGS_CA_INST_REL REL
WHERE REL.SUP_CAL_TYPE=AW.CAL_TYPE
AND REL.SUP_CI_SEQUENCE_NUMBER=AW.SEQUENCE_NUMBER
AND REL.SUB_CAL_TYPE=LD.CAL_TYPE
AND REL.SUB_CI_SEQUENCE_NUMBER=LD.SEQUENCE_NUMBER
AND AW.CAL_TYPE = AW_T.CAL_TYPE
AND AW_T.S_CAL_CAT='AWARD'
AND LD.CAL_TYPE = LD_T.CAL_TYPE
AND LD_T.S_CAL_CAT='LOAD'

Columns

Name
ROW_ID
AW_CAL_TYPE
AW_SEQUENCE_NUMBER
AW_ALTERNATE_CODE
AW_START_DT
AW_END_DT
LD_CAL_TYPE
LD_SEQUENCE_NUMBER
LD_ALTERNATE_CODE
LD_START_DT
LD_END_DT