SCC_STDADVHS_VW

(SQL View)
 Index Back

Student Advisor History View

View is used to see the Advisors to whom students are assigned.

SELECT A.EMPLID ,A.INSTITUTION ,A.ADVISOR_ROLE ,A.STDNT_ADVISOR_NBR ,A.ACAD_PROG ,A.ADVISOR_ID ,A.ACAD_CAREER ,A.ACAD_PLAN ,A.APPROVE_ENRLMT ,A.APPROVE_GRAD ,A.GRAD_APPROVED ,A.COMMITTEE_ID ,A.COMM_PERS_CD FROM PS_STDNT_ADVR_HIST A WHERE A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_STDNT_ADVR_HIST A2 WHERE A2.EMPLID = A.EMPLID AND A2.INSTITUTION = A.INSTITUTION AND A2.ADVISOR_ROLE = A.ADVISOR_ROLE AND A2.STDNT_ADVISOR_NBR = A.STDNT_ADVISOR_NBR AND A2.EFFDT <= %CurrentDateIn)

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

Prompt Table: STDNT_ADVISOR

3 ADVISOR_ROLE Character(4) VARCHAR2(4) NOT NULL Advisor Role
ADVR=Advisor
QEC=Qualifying Exam Committee
THES=Thesis Committee
4 STDNT_ADVISOR_NBR Number(2,0) SMALLINT NOT NULL Student Advisor Number
5 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

Prompt Table: ACAD_PROG_P_VW

6 ADVISOR_ID Character(11) VARCHAR2(11) NOT NULL This field is used to identify advisors assigned to a student.
7 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

Prompt Table: STDNT_CAREER

8 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

Prompt Table: ACAD_PLAN_VW

9 APPROVE_ENRLMT Character(1) VARCHAR2(1) NOT NULL Must Approve Enrollment

Y/N Table Edit

10 APPROVE_GRAD Character(1) VARCHAR2(1) NOT NULL Must Approve Graduation

Y/N Table Edit

11 GRAD_APPROVED Character(1) VARCHAR2(1) NOT NULL Graduation Approved

Y/N Table Edit

12 COMMITTEE_ID Character(6) VARCHAR2(6) NOT NULL Committee

Prompt Table: COMMITTEE

13 COMM_PERS_CD Character(1) VARCHAR2(1) NOT NULL Advised by Committee

Y/N Table Edit