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_PE_TEACH_PERIODS_V

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

View Text

SELECT TP.ROWID ROW_ID
, TP.TEACHING_PERIOD_ID
, TP.PERSON_ID
, NULL PERSON_NUMBER
, CI.ALTERNATE_CODE
, TP.TEACH_PERIOD_RESID_STAT_CD
, CC.MEANING RES_STATUS_DESC
, TO_DATE(NULL) START_DATE
, TO_DATE(NULL) END_DATE
, TP.CAL_TYPE
, TP.SEQUENCE_NUMBER
, TP.CREATED_BY
, TP.CREATION_DATE
, TP.LAST_UPDATED_BY
, TP.LAST_UPDATE_DATE
, TP.LAST_UPDATE_LOGIN
, CI.DESCRIPTION CALENDAR_DESC
, CAL_CAT.MEANING CALENDAR_CATEGORY
FROM IGS_PE_TEACH_PERIODS_ALL TP
, IGS_CA_INST_ALL CI
, IGS_LOOKUP_VALUES CC
, IGS_CA_TYPE TYP
, IGS_LOOKUP_VALUES CAL_CAT
WHERE CC.LOOKUP_CODE = TP.TEACH_PERIOD_RESID_STAT_CD
AND CC.LOOKUP_TYPE='PE_TEA_PER_RES'
AND CI.SEQUENCE_NUMBER = TP.SEQUENCE_NUMBER
AND CI.CAL_TYPE = TP.CAL_TYPE
AND TYP.CAL_TYPE = CI.CAL_TYPE
AND CAL_CAT.LOOKUP_TYPE = 'CAL_CAT'
AND CAL_CAT.LOOKUP_CODE = TYP.S_CAL_CAT

Columns

Name
ROW_ID
TEACHING_PERIOD_ID
PERSON_ID
PERSON_NUMBER
ALTERNATE_CODE
TEACH_PERIOD_RESID_STAT_CD
RES_STATUS_DESC
START_DATE
END_DATE
CAL_TYPE
SEQUENCE_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CALENDAR_DESC
CALENDAR_CATEGORY