OPR_SKL_PR_VW (SQL View)	Index Back
Operator Skills Preference Vw Operator Skill Preference View - Allows each operator to select a set of skillcodes that they frequently use for skill searches. Joined with the SKIILS_DETAIL record to obtain the skill descriptions.

OPR_SKL_PR_VW

(SQL View)

Operator Skills Preference Vw

Operator Skill Preference View - Allows each operator to select a set of skillcodes that they frequently use for skill searches. Joined with the SKIILS_DETAIL record to obtain the skill descriptions.

SELECT A.OPRID ,A.RS_TYPE ,A.SKILLCODE ,B.SKILL FROM PS_OPR_SKL_PR_TBL A ,PS_FO_SKILLS_DETL B WHERE A.SKILLCODE = B.SKILLCODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RS_TYPE Character(6) VARCHAR2(6) NOT NULL Skill Type
Prompt Table: FO_SKILLS_HDR

3 SKILLCODE Character(10) VARCHAR2(10) NOT NULL Skill Code

4 SKILL Character(75) VARCHAR2(75) NOT NULL Target Skill

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RS_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Skill Type Prompt Table: FO_SKILLS_HDR
3	SKILLCODE	Character(10)	VARCHAR2(10) NOT NULL	Skill Code
4	SKILL	Character(75)	VARCHAR2(75) NOT NULL	Target Skill