SSR_MP_TERM_VW

(SQL View)
 Index Back

Term View


SELECT ITEM.EMPLID , ITEM.INSTITUTION , ITEM.SSR_APT_INSTANCE , ITEM.SSR_ITEM_ID , SCHD.SESSION_CODE , TERM.STRM , TERM.DESCR , TERM.DESCRSHORT FROM PS_SSR_APT_ITEM ITEM , PS_SSR_APT_SCHD SCHD , PS_TERM_TBL TERM , PS_SSR_APT_HDR HDR , PS_SSR_APT_ATT ATT WHERE ATT.EMPLID = ITEM.EMPLID AND ATT.INSTITUTION = ITEM.INSTITUTION AND ATT.SSR_APT_INSTANCE = ITEM.SSR_APT_INSTANCE AND ATT.SSR_APT_ITEM_SEQ = ITEM.SSR_APT_ITEM_SEQ AND ATT.ATTEMPT_NBR = ( SELECT MAX(ATT_B.ATTEMPT_NBR) FROM PS_SSR_APT_ATT ATT_B WHERE ATT.EMPLID = ATT_B.EMPLID AND ATT.INSTITUTION = ATT_B.INSTITUTION AND ATT.SSR_APT_INSTANCE = ATT_B.SSR_APT_INSTANCE AND ATT.SSR_APT_ITEM_SEQ = ATT_B.SSR_APT_ITEM_SEQ) AND SCHD.EMPLID = ITEM.EMPLID AND SCHD.INSTITUTION = ITEM.INSTITUTION AND SCHD.SSR_APT_INSTANCE = ITEM.SSR_APT_INSTANCE AND SCHD.SSR_APT_ITEM_SEQ = ITEM.SSR_APT_ITEM_SEQ AND SCHD.ATTEMPT_NBR = ATT.ATTEMPT_NBR AND SCHD.SSR_SEQ_NBR = ( SELECT MAX(SCHD_B.SSR_SEQ_NBR) FROM PS_SSR_APT_SCHD SCHD_B WHERE SCHD.EMPLID = SCHD_B.EMPLID AND SCHD.INSTITUTION = SCHD_B.INSTITUTION AND SCHD.SSR_APT_INSTANCE = SCHD_B.SSR_APT_INSTANCE AND SCHD.SSR_APT_ITEM_SEQ = SCHD_B.SSR_APT_ITEM_SEQ AND SCHD.ATTEMPT_NBR = SCHD_B.ATTEMPT_NBR) AND HDR.EMPLID = ITEM.EMPLID AND HDR.INSTITUTION = ITEM.INSTITUTION AND HDR.SSR_APT_INSTANCE = ITEM.SSR_APT_INSTANCE AND TERM.INSTITUTION = ITEM.INSTITUTION AND TERM.ACAD_CAREER = HDR.ACAD_CAREER AND TERM.STRM = SCHD.STRM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
3 SSR_APT_INSTANCE Number(3,0) SMALLINT NOT NULL Academic Progress Tracker Instance Number
4 SSR_ITEM_ID Character(11) VARCHAR2(11) NOT NULL Academic Item ID
5 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
6 STRM Character(4) VARCHAR2(4) NOT NULL Term
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description