SSR_HM_CSPL_VW

(SQL View)
 Index Back

Course Specialisations View

Course Admissions - Course Specialisations

SELECT DISTINCT ACAD_PROG.EMPLID , ACAD_PROG.ACAD_CAREER , ACAD_PROG.STDNT_CAR_NBR , ACAD_PROG.INSTITUTION , ACAD_PROG.ACAD_PROG , CASE WHEN AUS.SSR_DEST_PLAN= 'Y' THEN ACAD_PLAN.ACAD_PLAN ELSE ' ' END , CA.SSR_PROVIDER_TYPE , CASE WHEN AUS.SSR_DEST_PLAN= 'Y' THEN AUS.SSR_FLD_OF_EDUCATN ELSE AUS.SSR_SPECIALSATN_CD END , ACAD_PROG.ADMIT_TERM FROM PS_ACAD_PROG ACAD_PROG , PS_SSR_ACD_PRG_AUS PRGAUS , PS_ACAD_PLAN ACAD_PLAN , PS_SSR_ACD_PLN_AUS AUS , PS_SSR_CAREER_AUS CA , PS_SSR_ACADPRG_AUS STDPRG_AUS WHERE PRGAUS.INSTITUTION = ACAD_PROG.INSTITUTION AND PRGAUS.ACAD_PROG = ACAD_PROG.ACAD_PROG AND %EffdtCheck(SSR_ACD_PRG_AUS PRGAUS2, PRGAUS, %CURRENTDATEIN) AND CA.INSTITUTION = ACAD_PROG.INSTITUTION AND CA.ACAD_CAREER = ACAD_PROG.ACAD_CAREER AND %EffdtCheck(SSR_CAREER_AUS CA2, CA, %CURRENTDATEIN) AND ACAD_PLAN.EMPLID = ACAD_PROG.EMPLID AND ACAD_PLAN.ACAD_CAREER = ACAD_PROG.ACAD_CAREER AND ACAD_PLAN.STDNT_CAR_NBR = ACAD_PROG.STDNT_CAR_NBR AND ACAD_PLAN.EFFDT = ACAD_PROG.EFFDT AND ACAD_PLAN.EFFSEQ = ACAD_PROG.EFFSEQ AND AUS.INSTITUTION = ACAD_PROG.INSTITUTION AND AUS.ACAD_PLAN = ACAD_PLAN.ACAD_PLAN AND %EffdtCheck(SSR_ACD_PLN_AUS AUS2, AUS, %CURRENTDATEIN) AND ACAD_PROG.EMPLID = STDPRG_AUS.EMPLID AND ACAD_PROG.ACAD_CAREER = STDPRG_AUS.ACAD_CAREER AND ACAD_PROG.STDNT_CAR_NBR = STDPRG_AUS.STDNT_CAR_NBR AND ACAD_PROG.EFFDT = STDPRG_AUS.EFFDT AND ACAD_PROG.EFFSEQ = STDPRG_AUS.EFFSEQ AND STDPRG_AUS.SSR_HM_EXIT_AWRD <> 'Y' UNION SELECT DISTINCT ACAD_PROG.EMPLID , ACAD_PROG.ACAD_CAREER , ACAD_PROG.STDNT_CAR_NBR , ACAD_PROG.INSTITUTION , ACAD_PROG.ACAD_PROG , CASE WHEN AUS.SSR_DEST_PLAN= 'Y' THEN ACAD_PLAN.ACAD_PLAN ELSE ' ' END , CA.SSR_PROVIDER_TYPE , PRGAUS.SSR_FLD_OF_EDUCATN , ACAD_PROG.ADMIT_TERM FROM PS_ACAD_PROG ACAD_PROG , PS_SSR_ACD_PRG_AUS PRGAUS , PS_ACAD_PLAN ACAD_PLAN , PS_SSR_ACD_PLN_AUS AUS , PS_SSR_CAREER_AUS CA , PS_SSR_ACADPRG_AUS STDPRG_AUS WHERE PRGAUS.INSTITUTION = ACAD_PROG.INSTITUTION AND PRGAUS.ACAD_PROG = ACAD_PROG.ACAD_PROG AND %EffdtCheck(SSR_ACD_PRG_AUS PRGAUS2, PRGAUS, %CURRENTDATEIN) AND CA.INSTITUTION = ACAD_PROG.INSTITUTION AND CA.ACAD_CAREER = ACAD_PROG.ACAD_CAREER AND %EffdtCheck(SSR_CAREER_AUS CA2, CA, %CURRENTDATEIN) AND ACAD_PLAN.EMPLID = ACAD_PROG.EMPLID AND ACAD_PLAN.ACAD_CAREER = ACAD_PROG.ACAD_CAREER AND ACAD_PLAN.STDNT_CAR_NBR = ACAD_PROG.STDNT_CAR_NBR AND ACAD_PLAN.EFFDT = ACAD_PROG.EFFDT AND ACAD_PLAN.EFFSEQ = ACAD_PROG.EFFSEQ AND AUS.INSTITUTION = ACAD_PROG.INSTITUTION AND AUS.ACAD_PLAN = ACAD_PLAN.ACAD_PLAN AND %EffdtCheck(SSR_ACD_PLN_AUS AUS2, AUS, %CURRENTDATEIN) AND ACAD_PROG.EMPLID = STDPRG_AUS.EMPLID AND ACAD_PROG.ACAD_CAREER = STDPRG_AUS.ACAD_CAREER AND ACAD_PROG.STDNT_CAR_NBR = STDPRG_AUS.STDNT_CAR_NBR AND ACAD_PROG.EFFDT = STDPRG_AUS.EFFDT AND ACAD_PROG.EFFSEQ = STDPRG_AUS.EFFSEQ AND STDPRG_AUS.SSR_HM_EXIT_AWRD <> 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
5 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
6 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
7 SSR_PROVIDER_TYPE Character(4) VARCHAR2(4) NOT NULL Provider Type
HEP=Higher Education Provider
NA=Not Applicable
TAC=Tertiary Admission Centre
VET=Vocational Education&Training
8 SSR_SPECIAL_CD Character(6) VARCHAR2(6) NOT NULL Specialisation Code
9 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term