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_PS_FAC_CAL_INST_V

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

View Text

SELECT PEV.PERSON_ID INSTRUCTOR_ID
, PEV.PERSON_NUMBER PERSON_NUMBER
, PEV.FULL_NAME INSTRUCTOR_NAME
, PEV.BIRTH_DATE BIRTH_DT
, PEV.GENDER SEX
, CI.CAL_TYPE CAL_TYPE
, CI.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CI.ALTERNATE_CODE ALTERNATE_CD
, CI.START_DT START_DT
, CI.END_DT END_DT
, PEV.CREATED_BY CREATED_BY
, PEV.CREATION_DATE CREATION_DATE
, PEV.LAST_UPDATED_BY LAST_UPDATED_BY
, PEV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PEV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_CA_INST CI
, IGS_PE_PERSON_BASE_V PEV
, IGS_PS_USEC_TCH_RESP USR
, IGS_PS_UNIT_OFR_OPT_ALL UOO
WHERE PEV.PERSON_ID=USR.INSTRUCTOR_ID
AND USR.UOO_ID=UOO.UOO_ID
AND UOO.CAL_TYPE=CI.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER=CI.SEQUENCE_NUMBER
AND UOO.UOO_ID = ( SELECT MAX(UOO1.UOO_ID)
FROM IGS_PS_USEC_TCH_RESP USR1
, IGS_PS_UNIT_OFR_OPT_ALL UOO1
WHERE UOO1.UOO_ID = USR1.UOO_ID
AND USR1.INSTRUCTOR_ID = USR.INSTRUCTOR_ID
AND UOO.CAL_TYPE = UOO1.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = UOO1.CI_SEQUENCE_NUMBER )

Columns

Name
INSTRUCTOR_ID
PERSON_NUMBER
INSTRUCTOR_NAME
BIRTH_DT
SEX
CAL_TYPE
SEQUENCE_NUMBER
ALTERNATE_CD
START_DT
END_DT
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN