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_EN_SS_SCHEDULE_DISP_V

Product:	IGS - Student System (Obsolete)
Description:	This view shows all the program attempts with additional details like applicable min/max cp, year of program unit set etc. used to display in schedule page.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SCA.PERSON_ID
, SCA.COURSE_CD PROGRAM_CD
, SCA.VERSION_NUMBER
, PV.COURSE_TYPE CAREER
, IGS_EN_SPA_TERMS_API.GET_SPAT_ATT_TYPE(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_EN_SPA_TERMS_API.GET_SPAT_ATT_TYPE_DESC(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_EN_SPA_TERMS_API.GET_SPAT_ATT_MODE(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_EN_SPA_TERMS_API.GET_SPAT_ATT_MODE_DESC(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_EN_SPA_TERMS_API.GET_SPAT_LOCATION(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_EN_SPA_TERMS_API.GET_SPAT_LOCATION_DESC(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, CIR.SUB_CAL_TYPE
, CIR.SUB_CI_SEQUENCE_NUMBER
, CI1.DESCRIPTION TERM_DESCRIPTION
, CI1.START_DT
, CIR.SUP_CAL_TYPE
, CIR.SUP_CI_SEQUENCE_NUMBER
, CI2.DESCRIPTION ACADEMIC_DESCRIPTION
, DECODE((SELECT 'Y'
FROM IGS_EN_SU_ATTEMPT SUA
WHERE SUA.PERSON_ID = SCA.PERSON_ID
AND SUA.COURSE_CD = SCA.COURSE_CD
AND SUA.UNIT_ATTEMPT_STATUS = 'UNCONFIRM'
AND ROWNUM = 1
AND (SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER) IN(SELECT TEACH_CAL_TYPE
, TEACH_CI_SEQUENCE_NUMBER
FROM IGS_CA_LOAD_TO_TEACH_V
WHERE LOAD_CAL_TYPE = CI1.CAL_TYPE
AND LOAD_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER))
, 'Y'
, 'Y'
, 'N') UNCONF_SUA
, IGS_EN_ELGBL_PROGRAM.GET_APPLIED_MIN_CP(SCA.PERSON_ID
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER
, SCA.COURSE_CD
, SCA.VERSION_NUMBER)
, IGS_EN_ELGBL_PROGRAM.GET_APPLIED_MAX_CP(SCA.PERSON_ID
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER
, SCA.COURSE_CD
, SCA.VERSION_NUMBER)
, IGS_EN_PRC_LOAD.ENRP_GET_INST_ATTENDANCE(SCA.PERSON_ID
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_EN_PRC_LOAD.ENRP_GET_INST_CP(SCA.PERSON_ID
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_SS_ENR_DETAILS.GET_PRI_PRG_TITLE(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_SS_ENR_DETAILS.GET_SEC_PRG_TITLE(SCA.PERSON_ID
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_SS_ENR_DETAILS.GET_STUD_YOP_UNIT_SET(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_EN_SPA_TERMS_API.GET_SPAT_PRIMARY_PRG(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
FROM IGS_EN_STDNT_PS_ATT SCA
, IGS_PS_VER PV
, IGS_CA_INST_REL CIR
, IGS_CA_INST CI1
, IGS_CA_INST CI2
, IGS_CA_TYPE CT
WHERE SCA.COURSE_CD = PV.COURSE_CD
AND SCA.VERSION_NUMBER = PV.VERSION_NUMBER
AND SCA.CAL_TYPE = CIR.SUP_CAL_TYPE
AND CIR.SUB_CAL_TYPE = CI1.CAL_TYPE
AND CIR.SUB_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER
AND CIR.SUB_CAL_TYPE = CT.CAL_TYPE
AND CT.S_CAL_CAT = 'LOAD'
AND CI1.SS_DISPLAYED = 'Y'
AND CIR.SUP_CAL_TYPE = CI2.CAL_TYPE
AND CIR.SUP_CI_SEQUENCE_NUMBER = CI2.SEQUENCE_NUMBER
AND SCA.COURSE_ATTEMPT_STATUS IN ('ENROLLED'
, 'INACTIVE'
, 'INTERMIT')

Columns

Name
PERSON_ID
PROGRAM_CD
VERSION_NUMBER
PROGRAM_TYPE
ATTENDANCE_TYPE
ATTENDANCE_TYPE_DESC
ATTENDANCE_MODE
ATTENDANCE_MODE_DESC
LOCATION_CD
LOCATION_CD_DESC
TERM_CAL_TYPE
TERM_SEQUENCE_NUMBER
TERM_DESCRIPTION
TERM_START_DT
ACAD_CAL_TYPE
ACAD_SEQUENCE_NUMBER
ACADEMIC_DESCRIPTION
UNCONFORM_SUA
APPLIED_MIN_CP
APPLIED_MAX_CP
INST_ATTENDANCE
INST_CP
PRIMARY_PRG_TITLE
SECONDARY_PRG_TITLE
YEAR_OF_PROGRAM
PRIMARY_PROGRAM_TYPE