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_PR_SDT_PROG_PRD_V

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

View Text

SELECT SCA.ROWID
, SCA.PERSON_ID
, SCA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CAT.DESCRIPTION
, ACAD_CI.ALTERNATE_CODE
, ACAD_CI.ALTERNATE_CODE || '/' || CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, IGS_PR_GEN_005.IGS_PR_GET_SCPM_VALUE(SCA.PERSON_ID
, SCA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, 'COURSE-GPA') GPA_COURSE
, IGS_PR_GEN_005.IGS_PR_GET_SCPM_VALUE(SCA.PERSON_ID
, SCA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, 'PERIOD-GPA') GPA_PERIOD
, IGS_PR_GEN_005.IGS_PR_GET_SCPM_VALUE(SCA.PERSON_ID
, SCA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, 'COURSE-WAM') WAM_COURSE
, IGS_PR_GEN_005.IGS_PR_GET_SCPM_VALUE(SCA.PERSON_ID
, SCA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, 'PERIOD-WAM') WAM_PERIOD
, SCA.CREATED_BY
, SCA.CREATION_DATE
, SCA.LAST_UPDATED_BY
, SCA.LAST_UPDATE_DATE
, SCA.LAST_UPDATE_LOGIN
FROM IGS_EN_STDNT_PS_ATT SCA
, IGS_CA_INST CI
, IGS_CA_INST ACAD_CI
, IGS_CA_INST_REL ACAD_CIR
, IGS_CA_TYPE ACAD_CAT
, IGS_CA_TYPE CAT
, IGS_CA_STAT CS
WHERE CAT.S_CAL_CAT = 'PROGRESS'
AND CI.CAL_TYPE = CAT.CAL_TYPE
AND CI.CAL_STATUS = CS.CAL_STATUS
AND CS.S_CAL_STATUS <> 'PLANNED'
AND ACAD_CIR.SUB_CAL_TYPE = CI.CAL_TYPE
AND ACAD_CIR.SUB_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND ACAD_CIR.SUP_CAL_TYPE = ACAD_CAT.CAL_TYPE
AND ACAD_CAT.S_CAL_CAT = 'ACADEMIC'
AND ACAD_CI.CAL_TYPE = ACAD_CIR.SUP_CAL_TYPE
AND ACAD_CI.SEQUENCE_NUMBER = ACAD_CIR.SUP_CI_SEQUENCE_NUMBER
AND (EXISTS (SELECT 'X'
FROM IGS_EN_SU_ATTEMPT SUA
, IGS_CA_INST_REL CIR
WHERE SUA.PERSON_ID = SCA.PERSON_ID
AND SUA.COURSE_CD = SCA.COURSE_CD
AND CIR.SUP_CAL_TYPE = CI.CAL_TYPE
AND CIR.SUP_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND CIR.SUB_CAL_TYPE = SUA.CAL_TYPE
AND CIR.SUB_CI_SEQUENCE_NUMBER = SUA.CI_SEQUENCE_NUMBER) OR EXISTS (SELECT 'X'
FROM IGS_AS_SC_ATMPT_ENR SCAE
, IGS_CA_INST_REL ENR_CIR
WHERE SCAE.PERSON_ID = SCA.PERSON_ID
AND SCAE.COURSE_CD = SCA.COURSE_CD
AND SCAE.CAL_TYPE = ENR_CIR.SUB_CAL_TYPE
AND SCAE.CI_SEQUENCE_NUMBER = ENR_CIR.SUB_CI_SEQUENCE_NUMBER
AND ACAD_CI.CAL_TYPE = ENR_CIR.SUP_CAL_TYPE
AND ACAD_CI.SEQUENCE_NUMBER = ENR_CIR.SUP_CI_SEQUENCE_NUMBER
AND CI.END_DT > SYSDATE))

Columns

Name
ROW_ID
PERSON_ID
COURSE_CD
PRG_CAL_TYPE
PRG_CI_SEQUENCE_NUMBER
ALTERNATE_CODE
DESCRIPTION
ACAD_ALTERNATE_CODE
PRG_PERIOD
START_DT
END_DT
GPA_COURSE
GPA_PERIOD
WAM_COURSE
WAM_PERIOD
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN