SSR_STU_ACAD_VW

(SQL View)
 Index Back

Student Academic Program Stack


SELECT pr.EMPLID , pr.ACAD_CAREER , pr.STDNT_CAR_NBR , pr.EFFDT , pr.EFFSEQ , pr.INSTITUTION , pr.ACAD_PROG , pr.ACAD_LOAD_APPR , pl.PLAN_SEQUENCE , pl.ACAD_PLAN , sp.ACAD_SUB_PLAN , pr.ADMIT_TERM , pr.PROG_STATUS , pr.SSR_APT_INSTANCE FROM PS_ACAD_PROG pr JOIN PS_ACAD_PLAN pl ON pr.EMPLID = pl.EMPLID AND pr.ACAD_CAREER = pl.ACAD_CAREER AND pr.STDNT_CAR_NBR = pl.STDNT_CAR_NBR AND pr.EFFDT = pl.EFFDT AND pr.EFFSEQ = pl.EFFSEQ LEFT OUTER JOIN PS_ACAD_SUBPLAN sp ON pl.EMPLID = sp.EMPLID AND pl.ACAD_CAREER = sp.ACAD_CAREER AND pl.STDNT_CAR_NBR = sp.STDNT_CAR_NBR AND pl.EFFDT = sp.EFFDT AND pl.EFFSEQ = sp.EFFSEQ AND pl.ACAD_PLAN = sp.ACAD_PLAN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
7 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
8 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
9 PLAN_SEQUENCE Number(2,0) SMALLINT NOT NULL Plan Sequence
10 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

Prompt Table: ACAD_PLAN

11 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan

Prompt Table: ACAD_SUBPLN_TBL

12 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term
13 PROG_STATUS Character(4) VARCHAR2(4) NOT NULL Academic Program Status
AC=Active in Program
AD=Admitted
AP=Applicant
CM=Completed Program
CN=Cancelled
DC=Discontinued
DE=Deceased
DM=Dismissed
LA=Leave of Absence
PM=Prematriculant
SP=Suspended
WT=Waitlisted
14 SSR_APT_INSTANCE Number(3,0) SMALLINT NOT NULL Academic Progress Tracker Instance Number