SSR_SUBJONLY_VW (SQL View)	Index Back
Subject View This Subject Table view should be used as the prompt table for Subject if it is in a search record. Effective Status is not in the view so inactive Subjects will be included in the list of valid values.

SSR_SUBJONLY_VW

(SQL View)

Subject View

This Subject Table view should be used as the prompt table for Subject if it is in a search record. Effective Status is not in the view so inactive Subjects will be included in the list of valid values.

SELECT DISTINCT subject , effdt , descr FROM PS_SUBJECT_TBL

Related Language Record: SSR_SUBJONLY_LV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SUBJECT	Character(8)	VARCHAR2(8) NOT NULL	Subject Area
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description