VIEW: APPS.IGS_EN_SS_STUD_CONTEXT_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')