BLOCK_ENRL_VW

(SQL View)
 Index Back

Enrollment Request Detail Line

This View is populated by a scroll select in Block Enroll.

SELECT A.enrl_request_id , A.enrl_req_detl_seq , A.emplid , B.NAME , A.STRM , A.acad_career , A.institution , A.class_nbr , A.enrl_req_action , A.enrl_req_detl_stat FROM PS_ENRL_REQ_DETAIL A , PS_SCC_CUR_NAME_VW B WHERE A.EMPLID=B.EMPLID AND B.NAME_TYPE = 'PRI'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ENRL_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Enrollment Request ID
2 ENRL_REQ_DETL_SEQ Number(6,0) INTEGER NOT NULL Enrollment Req Detail Sequence
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 STRM Character(4) VARCHAR2(4) NOT NULL Term
6 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
7 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
8 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
9 ENRL_REQ_ACTION_BE Character(2) VARCHAR2(2) NOT NULL Enrollment Request Action
A=Add Grade
C=Change Grade
D=Drop
E=Enroll
F=Enroll from Wait List
M=Normal Maintenance
P=Change Wait List Position
Q=PERC - no drop action
QC=PERC - Drop if Conditional
QD=PERC - Drop Action
QN=PERC - Drop if Not Satisfied
R=Remove Grade
S=Swap Courses
W=Drop to Wait List
10 ENRL_REQ_DETL_STAT Character(1) VARCHAR2(1) NOT NULL Enrollment Req Detail Status
E=Errors found
M=Success/Messages
P=Pending
S=Success
X=Pending