RS_ACCOMP_LVW (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_ACCOMP_LVW

(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 %Substring(B.FIELDVALUE,1,3) , ' ' , A.ACCOMPLISHMENT , C.LANGUAGE_CD , C.DESCR , C.DESCRSHORT , ' ' FROM PS_ACCOMP_TBL A , PSXLATITEM B , PS_ACCOMP_TBL_LANG C WHERE (A.ACCOMP_CATEGORY = 'LIC' OR A.ACCOMP_CATEGORY = 'LNG' OR A.ACCOMP_CATEGORY = 'MEM' ) AND B.FIELDNAME = 'ACCOMP_CATEGORY' AND A.ACCOMP_CATEGORY = B.FIELDVALUE AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEM BB WHERE BB.FIELDNAME = B.FIELDNAME AND BB.FIELDVALUE = B.FIELDVALUE) AND B.EFF_STATUS = 'A' AND A.ACCOMPLISHMENT = C.ACCOMPLISHMENT

# 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