SSR_CRSE_RDVWLN (SQL View)	Index Back
Requirement Designation RLView This record is a related language view of the requirement designation that is valid for a specific course id.

SSR_CRSE_RDVWLN

(SQL View)

Requirement Designation RLView

This record is a related language view of the requirement designation that is valid for a specific course id.

SELECT A.CRSE_ID , A.RQMNT_DESIGNTN , B.LANGUAGE_CD , B.DESCR FROM PS_CRSE_CATALOG A , PS_RQMNT_DESIG_LNG B WHERE A.RQMNT_DESIGNTN = B.RQMNT_DESIGNTN AND B.EFFDT = ( SELECT MAX (B1.EFFDT) FROM PS_RQMNT_DESIG_TBL B1 WHERE B.RQMNT_DESIGNTN = B1.RQMNT_DESIGNTN AND B1.EFFDT <= %CurrentDateIn)

Related Language Record for SSR_CRSE_RD_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

2 RQMNT_DESIGNTN Character(4) VARCHAR2(4) NOT NULL This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CRSE_ID	Character(6)	VARCHAR2(6) NOT NULL	Course ID
2	RQMNT_DESIGNTN	Character(4)	VARCHAR2(4) NOT NULL	This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description