SSR_AM_ROOT_VW

(SQL View)
 Index Back

Activity Root Extension

Activity Root Extension Record

SELECT A.INSTITUTION , A.STRM , A.CLASS_NBR , E.SSR_ACTIVITY_ID FROM PS_CLASS_TBL A , PS_SSR_ACT_XREF C ,PS_SSR_ACTIVITY D , PS_SSR_ACT_ROOTEXT E WHERE C.CRSE_ID = A.CRSE_ID AND C.CRSE_OFFER_NBR = A.CRSE_OFFER_NBR AND C.STRM = A.STRM AND C.SESSION_CODE = A.SESSION_CODE AND C.ASSOCIATED_CLASS = A.ASSOCIATED_CLASS AND C.CLASS_SECTION = A.CLASS_SECTION AND E.SSR_ACT_STATUS = 'C' AND ((D.SSR_ACTIVTY_ID_LNK = C.SSR_ACTIVITY_ID AND E.SSR_ACTIVITY_ID = D.SSR_ACTIVTY_ID_PAR) OR (D.SSR_ACTIVITY_ID = C.SSR_ACTIVITY_ID AND E.SSR_ACTIVITY_ID = D.SSR_ACTIVITY_ID))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

2 STRM Character(4) VARCHAR2(4) NOT NULL Term
3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
4 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID

Prompt Table: SSR_ACT_ROOTEXT