SAE_CLASS_BE_VW

(SQL View)
 Index Back

SELECT BEVNT.CRSE_ID , BEVNT.CRSE_OFFER_NBR , BEVNT.STRM ,BEVNT.SESSION_CODE ,BEVNT.CLASS_SECTION ,BEVNT.INSTITUTION ,CLS.ACAD_ORG ,ACAD_TRGT.SAE_TARGET_ID ,TRGT.SAE_TARGET_VERSION ,TRGT.SAE_CLSBAT_PRCMODE AS SAE_BATCHPROC_MODE ,BEVNT.SAE_EVENT_DT ,BEVNT.SAE_MODE ,BEVNT.PROCESS_INSTANCE ,BEVNT.RUN_CNTL_ID FROM %Table(SAE_CLASS_BEVNT) BEVNT , %Table(CLASS_TBL) CLS , %Table(SAE_DEPT_VW) DEPT , %Table(SAE_ACADORG_EXT) ACADORG , %Table(SAE_TARGET_TBL) TRGT ,%Table(sae_acad_target) ACAD_TRGT WHERE BEVNT.CRSE_ID = CLS.CRSE_ID AND BEVNT.CRSE_OFFER_NBR = CLS.CRSE_OFFER_NBR AND BEVNT.STRM = CLS.STRM AND BEVNT.SESSION_CODE = CLS.SESSION_CODE AND BEVNT.CLASS_SECTION = CLS.CLASS_SECTION AND CLS.INSTITUTION = ACADORG.INSTITUTION AND CLS.ACAD_ORG = ACADORG.ACAD_ORG AND ACADORG.SAE_DEF_INCLUDE= 'Y' AND CLS.INSTITUTION = DEPT.INSTITUTION AND CLS.ACAD_ORG = DEPT.ACAD_ORG AND CLS.INSTITUTION = ACAD_TRGT.INSTITUTION AND CLS.ACAD_ORG = ACAD_TRGT.ACAD_ORG AND ACAD_TRGT.SAE_TARGET_ID = TRGT.SAE_TARGET_ID AND TRGT.SAE_TARGET_TYPE = 'WBSV' AND %EffdtCheck(SAE_ACAD_TARGET ACAD_TARGET, ACAD_TRGT, %CurrentDateIn) AND ACAD_TRGT.EFF_STATUS = 'A'

# 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
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
5 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
6 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
7 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
8 SAE_TARGET_ID Character(50) VARCHAR2(50) NOT NULL SAIP Target ID
9 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
10 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
11 SAE_EVENT_DT DateTime(26) TIMESTAMP Event Driven Timestamp
12 SAE_MODE Character(1) VARCHAR2(1) NOT NULL Operation Mode
A=Add
C=Change
D=Delete
13 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
14 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID