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_AP_AWARD_YEAR_V

Product:	IGF - Financial Aid (Obsolete)
Description:	Award Years
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CI.ROW_ID ROW_ID
, CI.CAL_TYPE CAL_TYPE
, CI.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CI.START_DT START_DT
, CI.END_DT END_DT
, CI.CAL_STATUS CAL_STATUS
, CI.ALTERNATE_CODE ALTERNATE_CODE
, CI.SUP_CAL_STATUS_DIFFER_IND SUP_CAL_STATUS_DIFFER_IND
, CI.PRIOR_CI_SEQUENCE_NUMBER PRIOR_CI_SEQUENCE_NUMBER
, CI.ORG_ID ORG_ID
, CI.CREATED_BY CREATED_BY
, CI.CREATION_DATE CREATION_DATE
, CI.LAST_UPDATED_BY LAST_UPDATED_BY
, CI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CI.DESCRIPTION CAL_DESCRIPTION
, BM.AWARD_YEAR_STATUS_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_AWARD_YEAR_STATUS'
, BM.AWARD_YEAR_STATUS_CODE)
, BM.PELL_PARTICIPANT_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_COD_PARTICIPANT_TYPE'
, BM.PELL_PARTICIPANT_CODE)
, BM.DL_PARTICIPANT_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_COD_PARTICIPANT_TYPE'
, BM.DL_PARTICIPANT_CODE)
, BM.PUBLISH_IN_SS_FLAG
FROM IGS_CA_INST CI
, IGF_AP_BATCH_AW_MAP_ALL BM
WHERE BM.CI_CAL_TYPE = CI.CAL_TYPE
AND BM.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER

Columns

Name
ROW_ID
CAL_TYPE
SEQUENCE_NUMBER
START_DT
END_DT
CAL_STATUS
ALTERNATE_CODE
SUP_CAL_STATUS_DIFFER_IND
PRIOR_CI_SEQUENCE_NUMBER
ORG_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CAL_DESCRIPTION
AWARD_YEAR_STATUS_CODE
AWARD_YEAR_STATUS_DESC
PELL_PARTICIPANT_CODE
PELL_PARTICIPANT_DESC
DL_PARTICIPANT_CODE
DL_PARTICIPANT_DESC
PUBLISH_IN_SS_FLAG