SSR_BR_HMCMP_VW

(SQL View)
 Index Back

Home Campus nld view for org

Home Campus View for selecting changed acad org.

SELECT DISTINCT A.INSTITUTION ,A.ACAD_PROG ,A.EFFDT ,A.CAMPUS ,A.ACAD_ORG ,A.SCC_BRINCD_NLD FROM PS_SCC_HM_CAMP_NLD A WHERE A.ACAD_ORG <> ( SELECT DISTINCT B.ACAD_ORG FROM PS_SCC_HM_CAMP_NLD B WHERE A.INSTITUTION = B.INSTITUTION AND A.ACAD_PROG = B.ACAD_PROG AND A.CAMPUS = B.CAMPUS AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_SCC_HM_CAMP_NLD B1 WHERE A.INSTITUTION = B1.INSTITUTION AND A.ACAD_PROG = B1.ACAD_PROG AND A.CAMPUS = B1.CAMPUS AND B1.EFFDT < A.EFFDT ))

# 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 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

Prompt Table: ACAD_PROG_TBL

3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

Default Value: OPR_DEF_TBL_CS.CAMPUS

Prompt Table: CAMPUS_TBL

5 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization

Prompt Table: ACAD_ORG_TBL

6 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode