RS_QUA_LNG_VW (SQL View)	Index Back
Qualification View - Lng This view is intended to join all the system competency and accomplishments to use in the qualification search. This view does not include flexible factors.

RS_QUA_LNG_VW

(SQL View)

Qualification View - Lng

This view is intended to join all the system competency and accomplishments to use in the qualification search. This view does not include flexible factors.

SELECT 'CMP' , ' ' , B.COMPETENCY , A.LANGUAGE_CD , A.DESCR , A.DESCRSHORT , B.RATING_MODEL FROM PS_COMPETENCY_TBL B , PS_COMPETENCY_LANG A WHERE A.COMPETENCY = B.COMPETENCY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RS_QUALIF_TYPE Character(3) VARCHAR2(3) NOT NULL Qulaiifcation Types for SO
ANY=Any Type
ATT=Attribute
CMP=Competency
DEG=Degree
FAC=Other
LIC=License
LNG=Language
MEM=Membership

2 RS_ATTRIBUTE_ID Character(10) VARCHAR2(10) NOT NULL This field is used to uniquely identify an attribute of an assignment or project. An attribute may be captured on the service order and/or may be captured as an assignment preference by the worker.

3 RS_QUALIF_VALUE Character(10) VARCHAR2(10) NOT NULL Code

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

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

6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

7 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RS_QUALIF_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Qulaiifcation Types for SO ANY=Any Type ATT=Attribute CMP=Competency DEG=Degree FAC=Other LIC=License LNG=Language MEM=Membership
2	RS_ATTRIBUTE_ID	Character(10)	VARCHAR2(10) NOT NULL	This field is used to uniquely identify an attribute of an assignment or project. An attribute may be captured on the service order and/or may be captured as an assignment preference by the worker.
3	RS_QUALIF_VALUE	Character(10)	VARCHAR2(10) NOT NULL	Code
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Rating Model