SAD_UC_ACROF_VW

(SQL View)
 Index Back

Apply Used in Courses View

Apply Used in Courses View

SELECT A.INSTITUTION , A.SAD_UC_INST , A.SAD_UC_COURSE , A.SAD_UC_SITE , A.SAD_UC_STUDY_MODE , B.SAD_UC_CYCLE , B.SAD_UC_OFFER2_CD , 'Y' 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 = ( SELECT MAX(B1.SAD_UC_CYCLE) FROM PS_SAD_UC_ACOURSE2 B1 WHERE B1.INSTITUTION = B.INSTITUTION AND B1.SAD_UC_INST = B.SAD_UC_INST AND B1.SAD_UC_COURSE = B.SAD_UC_COURSE AND B1.SAD_UC_SITE = B.SAD_UC_SITE AND B1.SAD_UC_STUDY_MODE = B.SAD_UC_STUDY_MODE) AND B.SAD_UC_OFFER2_CD <> ' ' UNION SELECT A.INSTITUTION , A.SAD_UC_INST , A.SAD_UC_COURSE , A.SAD_UC_SITE , A.SAD_UC_STUDY_MODE , B.SAD_UC_CYCLE , C.SAD_UC_OFFER2_CD , 'N' FROM PS_SAD_UC_ACOURSE A , PS_SAD_UC_ACOURSE2 B , PS_SAD_UC_ACRS_OFF C 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 = ( SELECT MAX(B1.SAD_UC_CYCLE) FROM PS_SAD_UC_ACOURSE2 B1 WHERE B1.INSTITUTION = B.INSTITUTION AND B1.SAD_UC_INST = B.SAD_UC_INST AND B1.SAD_UC_COURSE = B.SAD_UC_COURSE AND B1.SAD_UC_SITE = B.SAD_UC_SITE AND B1.SAD_UC_STUDY_MODE = B.SAD_UC_STUDY_MODE) AND C.INSTITUTION = B.INSTITUTION AND C.SAD_UC_INST = B.SAD_UC_INST AND C.SAD_UC_COURSE = B.SAD_UC_COURSE AND C.SAD_UC_SITE = B.SAD_UC_SITE AND C.SAD_UC_STUDY_MODE = B.SAD_UC_STUDY_MODE AND C.SAD_UC_CYCLE = B.SAD_UC_CYCLE AND (B.SAD_UC_OFFER2_CD = ' ' OR B.SAD_UC_OFFER2_CD <> C.SAD_UC_OFFER2_CD)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

2 SAD_UC_INST Character(3) VARCHAR2(3) NOT NULL Provider Code
3 SAD_UC_COURSE Character(4) VARCHAR2(4) NOT NULL Course Code
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 UCAS Cycle
7 SAD_UC_OFFER2_CD Character(10) VARCHAR2(10) NOT NULL Offer Code
8 SAD_UC_DEFAULT Character(1) VARCHAR2(1) NOT NULL Default Flag

Y/N Table Edit