SAE_ENRL_BE_VW

(SQL View)
 Index Back

Student Enroll Batch View

This table contains the most recent student enrollment batch event.

SELECT A.EMPLID , A.ACAD_CAREER , A.INSTITUTION , A.STRM , A.CLASS_NBR , A.ENRL_REQUEST_ID , A.ENRL_REQ_DETL_SEQ , A.PROCESS_INSTANCE , A.SAE_EVENT_DT ,CLS_TRGT.SAE_TARGET_ID ,TRGT.SAE_TARGET_VERSION ,TRGT.SAE_BATCHPROC_MODE , A.RUN_CNTL_ID , A.SAE_MODE FROM PS_SAE_ENRL_BEVNT A ,%Table(CLASS_TBL) CLS , %Table(SAE_CLS_TRGT_VW) CLS_TRGT , %Table(SAE_TARGET_TBL) TRGT WHERE A.SAE_EVENT_DT = ( SELECT MAX(B.SAE_EVENT_DT) FROM PS_SAE_ENRL_BEVNT B WHERE A.EMPLID = B.EMPLID AND A.ACAD_CAREER = B.ACAD_CAREER AND A.INSTITUTION = B.INSTITUTION AND A.STRM = B.STRM AND A.CLASS_NBR = B.CLASS_NBR AND A.ENRL_REQ_DETL_SEQ = ( SELECT MAX(C.ENRL_REQ_DETL_SEQ) FROM PS_SAE_ENRL_BEVNT C WHERE A.EMPLID = C.EMPLID AND A.ACAD_CAREER = C.ACAD_CAREER AND A.INSTITUTION = C.INSTITUTION AND A.STRM = C.STRM AND A.CLASS_NBR = C.CLASS_NBR AND A.SAE_EVENT_DT = C.SAE_EVENT_DT )) AND A.INSTITUTION = CLS.INSTITUTION AND A.STRM = CLS.STRM AND A.CLASS_NBR = CLS.CLASS_NBR AND CLS.CRSE_ID=CLS_TRGT.CRSE_ID AND CLS.CRSE_OFFER_NBR=CLS_TRGT.CRSE_OFFER_NBR AND CLS.STRM=CLS_TRGT.STRM AND CLS.SESSION_CODE=CLS_TRGT.SESSION_CODE AND CLS.CLASS_SECTION=CLS_TRGT.CLASS_SECTION AND CLS_TRGT.SAE_TARGET_ID = TRGT.SAE_TARGET_ID AND TRGT.SAE_TARGET_TYPE = 'WBSV'

# 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 ENRL_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Enrollment Request ID
7 ENRL_REQ_DETL_SEQ Number(6,0) INTEGER NOT NULL Enrollment Req Detail Sequence
8 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
9 SAE_EVENT_DT DateTime(26) TIMESTAMP Event Driven Timestamp
10 SAE_TARGET_ID Character(50) VARCHAR2(50) NOT NULL SAIP Target ID
11 SAE_TARGET_VERSION Character(4) VARCHAR2(4) NOT NULL Version
1.0=Version 1.0
1.5=Version 1.5
2.0=Version 2.0
2.0A=Version 2.0a
12 SAE_BATCHPROC_MODE Character(1) VARCHAR2(1) NOT NULL Enrollment Processing Mode
B=Send Enrollments in Bulk
E=Send Enrollments as Events
T=Events with Bulk Threshold
13 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
14 SAE_MODE Character(1) VARCHAR2(1) NOT NULL Operation Mode
A=Add
C=Change
D=Delete