SSR_AC_TOP_SVW (SQL View)	Index Back
Course Topics The Course Topics Table contains the course titles for variable topics courses. For example if a course called: "Topics in English Literature" (the Course Catalog Table title), the Course Topics Table would contain those various topics like "Chaucer" or "Milton".

SSR_AC_TOP_SVW

(SQL View)

Course Topics

The Course Topics Table contains the course titles for variable topics courses. For example if a course called: "Topics in English Literature" (the Course Catalog Table title), the Course Topics Table would contain those various topics like "Chaucer" or "Milton".

SELECT CRSE_ID ,EFFDT , CRS_TOPIC_ID , DESCR FROM PS_CRSE_TOPICS

Related Language Record: SSR_TOP_RLANGVW

Parent record: CRSE_CATALOG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CRSE_ID_SRCH Character(6) VARCHAR2(6) NOT NULL Course ID
Prompt Table: SSR_AC_OFFVW

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CRSE_ID_SRCH	Character(6)	VARCHAR2(6) NOT NULL	Course ID Prompt Table: SSR_AC_OFFVW
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	CRS_TOPIC_ID	Number(3,0)	SMALLINT NOT NULL	Course Topic ID
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description