SSR_ACADSPLN_VW

(SQL View)
 Index Back

Degree Program Processing View

This view is used by SRGRDDRV.sqr for graduation processing.

SELECT SPLN.EMPLID , SPLN.ACAD_CAREER , SPLN.STDNT_CAR_NBR , SPLN.EFFDT , SPLN.EFFSEQ , SPLN.ACAD_PLAN , SPLN.ACAD_SUB_PLAN , SPLN.DECLARE_DT , SPLN.REQ_TERM , SPTBL.ACAD_SUBPLAN_TYPE , SPTBL.DIPLOMA_DESCR , SPTBL.TRNSCR_DESCR , SPTBL.DIPLOMA_PRINT_FL , SPTBL.TRNSCR_PRINT_FL FROM PS_ACAD_SUBPLAN SPLN ,PS_ACAD_SUBPLN_TBL SPTBL WHERE SPTBL.ACAD_PLAN = SPLN.ACAD_PLAN AND SPTBL.ACAD_SUB_PLAN = SPLN.ACAD_SUB_PLAN AND SPTBL.EFFDT = ( SELECT MAX(SPTBL2.EFFDT) FROM PS_ACAD_SUBPLN_TBL SPTBL2 WHERE SPTBL2.INSTITUTION = SPTBL.INSTITUTION AND SPTBL2.ACAD_PLAN = SPTBL.ACAD_PLAN AND SPTBL2.ACAD_SUB_PLAN = SPTBL.ACAD_SUB_PLAN AND SPTBL2.EFFDT <= SPLN.EFFDT)

# 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 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
6 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
7 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan
8 DECLARE_DT Date(10) DATE Declare Date
9 REQ_TERM Character(4) VARCHAR2(4) NOT NULL Requirement Term
10 ACAD_SUBPLAN_TYPE Character(3) VARCHAR2(3) NOT NULL Academic Sub-Plan Type
CON=Concentration
EMP=Emphasis
MIN=Minor
OPT=Option
SPC=Specialization
TRK=Track
11 DIPLOMA_DESCR Character(100) VARCHAR2(100) NOT NULL Diploma Description
12 TRNSCR_DESCR Character(100) VARCHAR2(100) NOT NULL Transcript Description
13 DIPLOMA_PRINT_FL Character(1) VARCHAR2(1) NOT NULL Print on Diploma
14 TRNSCR_PRINT_FL Character(1) VARCHAR2(1) NOT NULL Print on Transcript