RS_ACCOMP_VW (SQL View)	Index Back
Qualification View This vies 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_VW

(SQL View)

Qualification View

This vies 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 , A.DESCR , A.DESCRSHORT , ' ' FROM %Table(ACCOMP_TBL) A , PSXLATITEM B 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'

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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

6 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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Rating Model