STDNT_CAR_SE_VW (SQL View)	Index Back
Student Career Sequence View This Student Career Sequence Table view is used to check if Student Career should be deleted if the last Academic Program row is deleted in the Student Academic Program Panels.

STDNT_CAR_SE_VW

(SQL View)

Student Career Sequence View

This Student Career Sequence Table view is used to check if Student Career should be deleted if the last Academic Program row is deleted in the Student Academic Program Panels.

select emplid, acad_career, stdnt_car_nbr from PS_STDNT_CAR_SEQ

# 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
Prompt Table: STDNT_CAREER_VW

3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr

#	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 Prompt Table: STDNT_CAREER_VW
3	STDNT_CAR_NBR	Number(3,0)	SMALLINT NOT NULL	Student Career Nbr