SSR_AC_ITEMPCVW (SQL View)	Index Back
Activity Types Parent Counter Keeps a count of the possible parent content items. This is used in the Activity Manager component.

SSR_AC_ITEMPCVW

(SQL View)

Activity Types Parent Counter

Keeps a count of the possible parent content items. This is used in the Activity Manager component.

SELECT SSR_AC_CONTX_TYPE , SSR_AC_CONTENT_TP , COUNT(*) FROM PS_SSR_ACXITEMTPVW WHERE SSR_AC_CNT_TP_PAR <> ' ' GROUP BY SSR_AC_CONTX_TYPE , SSR_AC_CONTENT_TP UNION SELECT SSR_AC_CONTX_TYPE , SSR_AC_CONTENT_TP , 0 FROM PS_SSR_ACXITEMTPVW WHERE SSR_AC_CNT_TP_PAR = ' ' GROUP BY SSR_AC_CONTX_TYPE , SSR_AC_CONTENT_TP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SSR_AC_CONTX_TYPE Character(4) VARCHAR2(4) NOT NULL Academic Content Context Type
CRSE=Coursework
Default Value: CRSE

2 SSR_AC_CTP_SRCH Character(20) VARCHAR2(20) NOT NULL Academic Content Type

3 SSR_COUNTER Number(9,0) DECIMAL(9) NOT NULL This field is used by the view to create the SR enrollment cubes

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SSR_AC_CONTX_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Academic Content Context Type CRSE=Coursework Default Value: CRSE
2	SSR_AC_CTP_SRCH	Character(20)	VARCHAR2(20) NOT NULL	Academic Content Type
3	SSR_COUNTER	Number(9,0)	DECIMAL(9) NOT NULL	This field is used by the view to create the SR enrollment cubes