[Home] [Help]
View: IGS_PR_SCA_US_V
Product: | IGS - Student System (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SCA.PERSON_ID
, SCA.COURSE_CD
, US.UNIT_SET_CD
, US.VERSION_NUMBER
, SCA.COO_ID
, SCA.CAL_TYPE
, SCA.VERSION_NUMBER
, US.START_DT
, US.REVIEW_DT
, US.EXPIRY_DT
, US.END_DT
, US.UNIT_SET_STATUS
, US.UNIT_SET_CAT
, SUBSTR(IGS_EN_GEN_008.ENRP_GET_US_TITLE(US.UNIT_SET_CD
, US.VERSION_NUMBER
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, SCA.CAL_TYPE
, NULL
, NULL)
, 1
, 90)
, US.SHORT_TITLE
, US.ABBREVIATION
FROM IGS_EN_STDNT_PS_ATT SCA
, IGS_EN_UNIT_SET US
WHERE EXISTS (SELECT COURSE_CD FROM IGS_PS_OFR_OPT_UNIT_SET_V COOUSV
, IGS_EN_UNIT_SET_STAT USS WHERE COOUSV.COO_ID = SCA.COO_ID AND COOUSV.UNIT_SET_CD = US.UNIT_SET_CD AND COOUSV.US_VERSION_NUMBER = US.VERSION_NUMBER
AND COOUSV.UNIT_SET_STATUS = USS.UNIT_SET_STATUS
AND USS.S_UNIT_SET_STATUS = 'ACTIVE') OR EXISTS (SELECT COURSE_CD FROM IGS_AS_SU_SETATMPT SUSA WHERE SUSA.PERSON_ID = SCA.PERSON_ID AND SUSA.COURSE_CD = SCA.COURSE_CD AND SUSA.UNIT_SET_CD = US.UNIT_SET_CD AND SUSA.US_VERSION_NUMBER = US.VERSION_NUMBER)
Columns
Name |
PERSON_ID |
COURSE_CD |
UNIT_SET_CD |
US_VERSION_NUMBER |
COO_ID |
CAL_TYPE |
CRV_VERSION_NUMBER |
START_DT |
REVIEW_DT |
EXPIRY_DT |
END_DT |
UNIT_SET_STATUS |
UNIT_SET_CAT |
TITLE |
SHORT_TITLE |
ABBREVIATION |