SAE_INSTR_BE_VW

(SQL View)
 Index Back

Instructor Batch Event Table

This table contains instructor batch events used by the LMS interface process (SAIP) to generate events following batch program runs.

SELECT A.CRSE_ID , A.CRSE_OFFER_NBR , A.STRM , A.SESSION_CODE , A.CLASS_SECTION , A.CLASS_MTG_NBR , A.INSTR_ASSIGN_SEQ , A.EMPLID , A.PROCESS_INSTANCE , A.SAE_EVENT_DT , A.INSTR_ROLE ,CLS_TRGT.SAE_TARGET_ID ,TRGT.SAE_TARGET_VERSION ,TRGT.SAE_BATCHPROC_MODE , A.RUN_CNTL_ID , A.SAE_MODE FROM PS_SAE_INSTR_BEVNT A , %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_INSTR_BEVNT B WHERE A.CRSE_ID = B.CRSE_ID AND A.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND A.STRM = B.STRM AND A.SESSION_CODE = B.SESSION_CODE AND A.CLASS_SECTION = B.CLASS_SECTION AND A.CLASS_MTG_NBR = B.CLASS_MTG_NBR AND A.INSTR_ASSIGN_SEQ = B.INSTR_ASSIGN_SEQ AND A.EMPLID = B.EMPLID ) AND A.CRSE_ID = CLS_TRGT.CRSE_ID AND A.CRSE_OFFER_NBR = CLS_TRGT.CRSE_OFFER_NBR AND A.STRM = CLS_TRGT.STRM AND A.SESSION_CODE = CLS_TRGT.SESSION_CODE AND A.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 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
2 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
3 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: TERM_TBL

4 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

Prompt Table: SESSION_TBL

5 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
6 CLASS_MTG_NBR Number(2,0) SMALLINT NOT NULL Class Meeting Pattern Nbr
7 INSTR_ASSIGN_SEQ Number(3,0) SMALLINT NOT NULL Class/Instructor Assign Seq #
8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
9 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
10 SAE_EVENT_DT DateTime(26) TIMESTAMP Event Driven Timestamp
11 INSTR_ROLE Character(4) VARCHAR2(4) NOT NULL Instructor Role
PI=Primary Instructor
SI=Secondary Instructor
TA=Teaching Assistant

Default Value: PI

12 SAE_TARGET_ID Character(50) VARCHAR2(50) NOT NULL SAIP Target ID
13 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
14 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
15 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
16 SAE_MODE Character(1) VARCHAR2(1) NOT NULL Operation Mode
A=Add
C=Change
D=Delete