SSR_IAM_STENRVW (SQL View)	Index Back
Student Enrollment Table View This Student Enrollment view is used to extract key enrollment information from the graded component into the enrollment section. This is done to facilitate maintenance transactions from the enrollment section only.

SSR_IAM_STENRVW

(SQL View)

Student Enrollment Table View

This Student Enrollment view is used to extract key enrollment information from the graded component into the enrollment section. This is done to facilitate maintenance transactions from the enrollment section only.

SELECT A.EMPLID , A.ACAD_CAREER , A.INSTITUTION , A.STRM , A.CLASS_NBR , A.STDNT_ENRL_STATUS , B.CRSE_ID , B.CRSE_OFFER_NBR , B.SESSION_CODE , B.ASSOCIATED_CLASS , B.CLASS_SECTION , C.SSR_ACTIVITY_ID , A.LAST_UPD_DT_STMP , A.LAST_UPD_TM_STMP FROM PS_STDNT_ENRL A , PS_CLASS_TBL B , PS_SSR_ACT_XREF C WHERE B.STRM = A.STRM AND B.CLASS_NBR = A.CLASS_NBR AND C.CRSE_ID = B.CRSE_ID AND C.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND C.STRM = B.STRM AND C.SESSION_CODE = B.SESSION_CODE AND C.ASSOCIATED_CLASS = B.ASSOCIATED_CLASS AND C.CLASS_SECTION = B.CLASS_SECTION

# 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

3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

4 STRM Character(4) VARCHAR2(4) NOT NULL Term
Prompt Table: TERM_TBL

5 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
Prompt Table: CLASS_TBL_VW

6 STDNT_ENRL_STATUS Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
D=Dropped
E=Enrolled
W=Waiting

7 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

8 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr

9 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
1=Regular Academic Session
10W=10 Week
12W=Twelve Week
4W1=Four Week - First
4W2=Four Week - Second
4W3=Four Week - Third
4W4=Four Week - Fourth
6W1=Six Week - First
6W2=Six Week - Second
8W1=Eight Week - First
8W2=Eight Week - Second
A11=Medical Period 1, 4 Weeks
A12=Medical Period 1, 8 Weeks
A13=Medical Pd 1, 12 Weeks
A21=Medical Period 2, 4 Weeks
A22=Medical Period 2, 8 Weeks
A23=Medical Period 2, 12 Week
FYR=Full Year
MIN=Mini Session
OEE=Open Entry/Open Exit
SM1=Semester 1
SM2=Semester 2

10 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class

11 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section

12 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID

13 LAST_UPD_DT_STMP Date(10) DATE Last Update Date Stamp

14 LAST_UPD_TM_STMP Time(15) TIMESTAMP Last Update Time Stamp

#	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
3	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
4	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term Prompt Table: TERM_TBL
5	CLASS_NBR	Number(5,0)	INTEGER NOT NULL	Class Nbr Prompt Table: CLASS_TBL_VW
6	STDNT_ENRL_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Student Enrollment Status D=Dropped E=Enrolled W=Waiting
7	CRSE_ID	Character(6)	VARCHAR2(6) NOT NULL	Course ID
8	CRSE_OFFER_NBR	Number(2,0)	SMALLINT NOT NULL	Course Offering Nbr
9	SESSION_CODE	Character(3)	VARCHAR2(3) NOT NULL	Session 1=Regular Academic Session 10W=10 Week 12W=Twelve Week 4W1=Four Week - First 4W2=Four Week - Second 4W3=Four Week - Third 4W4=Four Week - Fourth 6W1=Six Week - First 6W2=Six Week - Second 8W1=Eight Week - First 8W2=Eight Week - Second A11=Medical Period 1, 4 Weeks A12=Medical Period 1, 8 Weeks A13=Medical Pd 1, 12 Weeks A21=Medical Period 2, 4 Weeks A22=Medical Period 2, 8 Weeks A23=Medical Period 2, 12 Week FYR=Full Year MIN=Mini Session OEE=Open Entry/Open Exit SM1=Semester 1 SM2=Semester 2
10	ASSOCIATED_CLASS	Number(4,0)	SMALLINT NOT NULL	Associated Class
11	CLASS_SECTION	Character(4)	VARCHAR2(4) NOT NULL	Class Section
12	SSR_ACTIVITY_ID	Character(11)	VARCHAR2(11) NOT NULL	Academic Activity ID
13	LAST_UPD_DT_STMP	Date(10)	DATE	Last Update Date Stamp
14	LAST_UPD_TM_STMP	Time(15)	TIMESTAMP	Last Update Time Stamp