SSR_SS_SRD_A2

(SQL View)
 Index Back

Enrollment Request Detail Line


SELECT a.ENRL_REQUEST_ID , a.ENRL_REQ_DETL_SEQ , a.EMPLID , a.ACAD_CAREER , a.INSTITUTION , a.STRM , a.CLASS_NBR_CHG_TO , c.CLASS_NBR , c.CLASS_TYPE , b.SUBJECT , b.CATALOG_NBR , b.CLASS_SECTION , a.ENRL_REQ_ACTION , a.UNT_TAKEN , a.GRADING_BASIS_ENRL , a.CLASS_PRMSN_NBR , a.CLASS_NBR_CHG_TO , a.DROP_CLASS_IF_ENRL , a.RELATE_CLASS_NBR_1 , a.RELATE_CLASS_NBR_2 , a.WAIT_LIST_OKAY , a.INSTRUCTOR_ID , a.RQMNT_DESIGNTN , a.RQMNT_DESIGNTN_OPT , a.START_DT , a.ACAD_PROG , a.ENRL_REQ_DETL_STAT , a.OPRID , a.DTTM_STAMP_SEC FROM PS_ENRL_REQ_DETAIL a , PS_CLASS_TBL_VW b , PS_CLASS_TBL_VW c WHERE a.INSTITUTION = b.INSTITUTION AND a.STRM = b.STRM AND a.CLASS_NBR_CHG_TO = b.CLASS_NBR AND b.AUTO_ENROLL_SECT_2 <> ' ' AND b.CRSE_ID = c.CRSE_ID AND b.CRSE_OFFER_NBR = c.CRSE_OFFER_NBR AND b.STRM = c.STRM AND b.SESSION_CODE = c.SESSION_CODE AND b.AUTO_ENROLL_SECT_2 = c.CLASS_SECTION

# 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

Prompt Table: PEOPLE_SRCH

4 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

5 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

6 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: STDNT_CARTRM_VW

7 CLASS_NBR_REQ Number(5,0) INTEGER NOT NULL Class Nbr
8 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

Prompt Table: %EDITTABLE

9 CLASS_TYPE Character(1) VARCHAR2(1) NOT NULL Class Type
E=Enrollment Section
N=Non-Enrollment Section
10 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
11 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
12 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
13 ENRL_REQ_ACTION Character(2) VARCHAR2(2) NOT NULL Enrollment Request Action
A=Add Grade
C=Change Grade
D=Drop
E=Enroll
M=Normal Maintenance
P=Change Wait List Position
R=Remove Grade
S=Swap Courses
W=Drop to Wait List
14 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
15 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis

Prompt Table: %EDITTABLE2

16 CLASS_PRMSN_NBR Number(6,0) INTEGER NOT NULL Class Permission Nbr
17 CLASS_NBR_CHG_TO Number(5,0) INTEGER NOT NULL Change to Class Nbr

Prompt Table: %EDITTABLE4

18 DROP_CLASS_IF_ENRL Number(5,0) INTEGER NOT NULL Drop This Class if Enrolled

Prompt Table: CLASS_TBL_S2_VW

19 RELATE_CLASS_NBR_1 Number(5,0) INTEGER NOT NULL Related Class Number 1

Prompt Table: CLASS_TBL_RE_V2

20 RELATE_CLASS_NBR_2 Number(5,0) INTEGER NOT NULL Related Class Number 2

Prompt Table: CLASS_TBL_RE_V2

21 WAIT_LIST_OKAY Character(1) VARCHAR2(1) NOT NULL Wait List Okay

Y/N Table Edit

Default Value: OPR_DEF_TBL_CS.WAIT_LIST_OKAY

22 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID

Prompt Table: %EDITTABLE3

23 RQMNT_DESIGNTN Character(4) VARCHAR2(4) NOT NULL This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.

Prompt Table: RQMNT_DESIG_TBL

24 RQMNT_DESIGNTN_OPT Character(1) VARCHAR2(1) NOT NULL Requirement Designation Option
N=No
Y=Yes

Default Value: N

25 START_DT Date(10) DATE Start Date
26 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

Default Value: STDNT_CAR_TERM.ACAD_PROG_PRIMARY

Prompt Table: SSR_ACPRG_AC_VW

27 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

Default Value: P

28 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
29 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.