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_STUD_CONTEXT_V

Product:	IGS - Student System (Obsolete)
Description:	Stores the student program attempt context information
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
, 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)
, IGS_EN_PRC_LOAD.ENRP_GET_PRG_LOAD_CP(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 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
APPLIED_MIN_CP
APPLIED_MAX_CP
INST_ATTENDANCE
INST_CP
PRIMARY_PRG_TITLE
SECONDARY_PRG_TITLE
YEAR_OF_PROGRAM
PRIMARY_PROGRAM_TYP
PROGRAM_CP