AVPRPSSTFVW2LNG (SQL View)	Index Back
Purposes for staff Selects only the purposes that are valid for staff members.

AVPRPSSTFVW2LNG

(SQL View)

Purposes for staff

Selects only the purposes that are valid for staff members.

SELECT A.PURPOSE_CD , A.EFFDT ,A.LANGUAGE_CD , A.DESCR FROM PS_AV_PRPS_LNG A ,PS_AV_PRPS_TBL B WHERE B.STAFF_FLAG = 'Y' AND A.PURPOSE_CD=B.PURPOSE_CD AND A.EFFDT=B.EFFDT

Related Language Record for AV_PRPS_STF_VW2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PURPOSE_CD Character(3) VARCHAR2(3) NOT NULL Role

2 EFFDT Date(10) DATE Effective Date

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	PURPOSE_CD	Character(3)	VARCHAR2(3) NOT NULL	Role
2	EFFDT	Date(10)	DATE	Effective Date
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description