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_CAL_REL_V

Product:	IGF - Financial Aid (Obsolete)
Description:	Stores the relationships between calendar instances
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CREL.ROW_ID
, CREL.CREL_ID
, CREL.CR_CAL_TYPE
, CREL.CR_SEQUENCE_NUMBER
, CR_CI.ALTERNATE_CODE
, CR_CI.START_DT
, CR_CI.END_DT
, CREL.CR_CAL_TYPE
, CREL.SC_SEQUENCE_NUMBER
, SC_CI.ALTERNATE_CODE
, SC_CI.START_DT
, SC_CI.END_DT
, CREL.ACTIVE
, CREL.CREATED_BY
, CREL.CREATION_DATE
, CREL.LAST_UPDATED_BY
, CREL.LAST_UPDATE_DATE
, CREL.LAST_UPDATE_LOGIN
FROM IGF_AW_CAL_REL CREL
, IGS_CA_INST CR_CI
, IGS_CA_INST SC_CI
WHERE CREL.CR_CAL_TYPE = CR_CI.CAL_TYPE
AND CREL.CR_SEQUENCE_NUMBER = CR_CI.SEQUENCE_NUMBER
AND CREL.CR_CAL_TYPE = SC_CI.CAL_TYPE
AND CREL.SC_SEQUENCE_NUMBER = SC_CI.SEQUENCE_NUMBER

Columns

Name
ROW_ID
CREL_ID
CR_CAL_TYPE
CR_SEQUENCE_NUMBER
CR_ALTERNATE_CODE
CR_START_DT
CR_END_DT
SC_CAL_TYPE
SC_SEQUENCE_NUMBER
SC_ALTERNATE_CODE
SC_START_DT
SC_END_DT
ACTIVE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN