SAD_UC_APDCS_VW

(SQL View)
 Index Back

Apply decision course view


SELECT A.SAD_UC_INST , A.SAD_UC_COURSE , B.SAD_UC_LONGNAME , A.SAD_UC_SITE , A.SAD_UC_STUDY_MODE , B.SAD_UC_CYCLE FROM PS_SAD_UC_ACOURSE A , PS_SAD_UC_ACOURSE2 B WHERE B.INSTITUTION = A.INSTITUTION AND B.SAD_UC_INST = A.SAD_UC_INST AND B.SAD_UC_COURSE = A.SAD_UC_COURSE AND B.SAD_UC_SITE = A.SAD_UC_SITE AND B.SAD_UC_STUDY_MODE = A.SAD_UC_STUDY_MODE AND B.SAD_UC_CYCLE>=NVL(( SELECT C.SAD_UC_CYCLE FROM PS_SAD_UC_CONFIG C WHERE C.INSTITUTION=A.INSTITUTION), 0) ORDER BY B.SAD_UC_CYCLE DESC, A.SAD_UC_INST, A.SAD_UC_COURSE, A.SAD_UC_SITE, A.SAD_UC_STUDY_MODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SAD_UC_INST Character(3) VARCHAR2(3) NOT NULL Provider Code
2 SAD_UC_COURSE Character(4) VARCHAR2(4) NOT NULL Course
3 SAD_UC_LONGNAME Character(100) VARCHAR2(100) NOT NULL Course Name
4 SAD_UC_SITE Character(5) VARCHAR2(5) NOT NULL Site Code
5 SAD_UC_STUDY_MODE Character(10) VARCHAR2(10) NOT NULL Study Mode
6 SAD_UC_CYCLE Number(4,0) SMALLINT NOT NULL Cycle