SSR_HE_CSESS_VW

(SQL View)
 Index Back

Course Session ID view


SELECT A.INSTITUTION , A.SSR_HE_CSESS_ID , A.ACAD_PLAN , '' , A.ACAD_LOAD_APPR , A.SSR_HE_YEARPRG , A.SSR_HE_OFSTRM , A.SSR_HE_OFSTSESN , A.CAMPUS , A.SSR_HE_YRTERM , A.SSR_HE_YRSESSN , A.SSR_HE_COHORT FROM PS_SSR_HE_PLNOFRYR A WHERE A.EFFDT=( SELECT MAX(A1.EFFDT) FROM PS_SSR_HE_PLNOFRYR A1 WHERE A1.INSTITUTION=A.INSTITUTION AND A1.ACAD_PLAN=A.ACAD_PLAN AND A1.ACAD_LOAD_APPR=A.ACAD_LOAD_APPR AND A1.SSR_HE_YEARPRG=A.SSR_HE_YEARPRG AND A1.EFFDT<=%CurrentDateIn) AND A.SSR_HE_OFSTRM<>' ' UNION SELECT A.INSTITUTION , A.SSR_HE_CSESS_ID , A.ACAD_PLAN , A.ACAD_SUB_PLAN , A.ACAD_LOAD_APPR , A.SSR_HE_YEARPRG , A.SSR_HE_OFSTRM , A.SSR_HE_OFSTSESN , A.CAMPUS , A.SSR_HE_YRTERM , A.SSR_HE_YRSESSN , A.SSR_HE_COHORT FROM PS_SSR_HE_SPLNOYR A WHERE A.EFFDT=( SELECT MAX(A1.EFFDT) FROM PS_SSR_HE_SPLNOYR A1 WHERE A1.INSTITUTION=A.INSTITUTION AND A1.ACAD_PLAN=A.ACAD_PLAN AND A1.ACAD_SUB_PLAN=A.ACAD_SUB_PLAN AND A1.ACAD_LOAD_APPR=A.ACAD_LOAD_APPR AND A1.SSR_HE_YEARPRG=A.SSR_HE_YEARPRG AND A1.EFFDT<=%CurrentDateIn) AND A.SSR_HE_OFSTRM<>' '

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

Prompt Table: INSTITUTION_TBL

2 SSR_HE_CSESS_ID Character(50) VARCHAR2(50) NOT NULL Course Session ID
3 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
4 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan
5 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
B=Vocational Coaching (NLD)
D=Dual (NLD)
E=Part-time Vocational Tr (NLD)
F=Full-Time
O=Vocational Training (NLD)
P=Part-Time
6 SSR_HE_YEARPRG Number(2,0) SMALLINT NOT NULL Year of Program
7 SSR_HE_OFSTRM Character(4) VARCHAR2(4) NOT NULL Offering Start Term
8 SSR_HE_OFSTSESN Character(3) VARCHAR2(3) NOT NULL Offering Start Session
9 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
10 SSR_HE_YRTERM Character(4) VARCHAR2(4) NOT NULL Year Term
11 SSR_HE_YRSESSN Character(4) VARCHAR2(4) NOT NULL Year Session
12 SSR_HE_COHORT Character(12) VARCHAR2(12) NOT NULL Cohort