SSR_APT_SEQ_VW

(SQL View)
 Index Back

APT Seq / Sched View


SELECT ITEM.EMPLID , ITEM.INSTITUTION , ITEM.SSR_APT_INSTANCE , ITEM.SSR_ITEM_ID , ITEM.SSR_APT_ITEM_SEQ , ATT.ATTEMPT_NBR , SCHD.SSR_SEQ_NBR , SCHD.SSR_ATT_PRGRS_LVL FROM PS_SSR_APT_ITEM ITEM , PS_SSR_APT_ATT ATT , PS_SSR_APT_SCHD SCHD WHERE ITEM.EMPLID = ATT.EMPLID AND ITEM.INSTITUTION = ATT.INSTITUTION AND ITEM.SSR_APT_INSTANCE = ATT.SSR_APT_INSTANCE AND ITEM.SSR_APT_ITEM_SEQ = ATT.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 = ATT.EMPLID AND SCHD.INSTITUTION = ATT.INSTITUTION AND SCHD.SSR_APT_INSTANCE = ATT.SSR_APT_INSTANCE AND SCHD.SSR_APT_ITEM_SEQ = ATT.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_B.INSTITUTION = SCHD.INSTITUTION AND SCHD_B.EMPLID = SCHD.EMPLID AND SCHD_B.SSR_APT_INSTANCE = SCHD.SSR_APT_INSTANCE AND SCHD_B.SSR_APT_ITEM_SEQ = SCHD.SSR_APT_ITEM_SEQ AND SCHD_B.ATTEMPT_NBR = SCHD.ATTEMPT_NBR)

# 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 SSR_APT_ITEM_SEQ Number(6,0) INTEGER NOT NULL APT Item Seq
6 ATTEMPT_NBR Number(3,0) SMALLINT NOT NULL Attempt Nbr
7 SSR_SEQ_NBR Number(4,0) SMALLINT NOT NULL Sequence Number
8 SSR_ATT_PRGRS_LVL Character(2) VARCHAR2(2) NOT NULL Progress Level
00=00-Newly Added
20=20-Planned
40=40-In Progress
60=60-Completed
80=80-Dropped