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: IGS_HE_FTE_CAL_PRD_V

Product:	IGS - Student System (Obsolete)
Description:	Stores FTE calculation period
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT A.ROWID ROW_ID
, A.FTE_CAL_TYPE FTE_CAL_TYPE
, A.FTE_SEQUENCE_NUM FTE_SEQUENCE_NUM
, B.ALTERNATE_CODE FTE_CAL_NAME
, B.START_DT FTE_START_DT
, B.END_DT FTE_END_DT
, A.TEACH_CAL_TYPE TEACH_CAL_TYPE
, A.TEACH_SEQUENCE_NUM TEACH_SEQUENCE_NUM
, C.ALTERNATE_CODE TEACH_CAL_NAME
, C.START_DT TEACH_START_DT
, C.END_DT TEACH_END_DT
, A.CREATED_BY CREATED_BY
, A.CREATION_DATE CREATION_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_HE_FTE_CAL_PRD A
, IGS_CA_INST B
, IGS_CA_INST C
WHERE A.FTE_CAL_TYPE=B.CAL_TYPE
AND A.FTE_SEQUENCE_NUM=B.SEQUENCE_NUMBER
AND A.TEACH_CAL_TYPE=C.CAL_TYPE
AND A.TEACH_SEQUENCE_NUM=C.SEQUENCE_NUMBER

Columns

Name
ROW_ID
FTE_CAL_TYPE
FTE_SEQUENCE_NUM
FTE_CAL_NAME
FTE_START_DT
FTE_END_DT
TEACH_CAL_TYPE
TEACH_SEQUENCE_NUM
TEACH_CAL_NAME
TEACH_START_DT
TEACH_END_DT
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN