SSR_AMSS_SRCHVW

(SQL View)
 Index Back

AM SS Search Record


SELECT %Substring(X.FIELDVALUE,1,1) , XR.CLASS_SECTION , A.SSR_AC_CONTX_TYPE , A.INSTITUTION , A.SSR_ACTIVITY_ID , R.SSR_ACTIVITY_ID , IT.DESCR50 FROM PS_SSR_AC_CONTEXT D , PS_SSR_ACTIVITY A , PS_SSR_ACTIVITY R , PS_SSR_ACMCONT_ITM IT , PSXLATITEM X , PS_SSR_ACT_XREF XR WHERE IT.SSR_ACTIVITY_ID = R.SSR_ACTIVITY_ID AND IT.INSTITUTION = R.INSTITUTION AND D.SSR_AC_CONTX_TYPE = A.SSR_AC_CONTX_TYPE AND X.FIELDNAME = 'SSR_ACSS_MODE' AND A.INSTITUTION = R.INSTITUTION AND (A.SSR_AC_CONTENT_TP = '1000' OR A.SSR_AC_CONTENT_TP = '2000') AND XR.SSR_ACTIVITY_ID = R.SSR_ACTIVITY_ID UNION SELECT %Substring(X.FIELDVALUE,1,1) , ' ' , A.SSR_AC_CONTX_TYPE , A.INSTITUTION , A.SSR_ACTIVITY_ID , R.SSR_ACTIVITY_ID , IT.DESCR50 FROM PS_SSR_AC_CONTEXT D , PS_SSR_ACTIVITY A , PS_SSR_ACTIVITY R , PS_SSR_ACMCONT_ITM IT , PSXLATITEM X WHERE IT.SSR_ACTIVITY_ID = R.SSR_ACTIVITY_ID AND IT.INSTITUTION = R.INSTITUTION AND D.SSR_AC_CONTX_TYPE = A.SSR_AC_CONTX_TYPE AND X.FIELDNAME = 'SSR_ACSS_MODE' AND A.INSTITUTION = R.INSTITUTION AND A.SSR_AC_CONTENT_TP = '4000'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSR_ACSS_MODE Character(1) VARCHAR2(1) NOT NULL Activity Mode
M=Manage Activities
R=Roster Mode
2 SSR_ACM_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
3 SSR_AC_CONTX_TYPE Character(4) VARCHAR2(4) NOT NULL Academic Content Context Type
CRSE=Coursework

Default Value: CRSE

4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
5 SSR_ACTY_ID_SRCH Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
6 SSR_ACTY_ID_REL Character(11) VARCHAR2(11) NOT NULL Related Activity
7 SSR_AC_RG_DESCR50 Character(50) VARCHAR2(50) NOT NULL Content Registry Description