RF_WRKRCMP_S_VW (SQL View)	Index Back
Worker Competencies Search This is a view on RB_COMPETENCIES used for Worker configurable search. This view does not have EVALUATION_ID or Effective Date as a key because they are no longer being used. Workers do not have multiple "sets" of competencies keyed by date or evaluation.

RF_WRKRCMP_S_VW

(SQL View)

Worker Competencies Search

This is a view on RB_COMPETENCIES used for Worker configurable search. This view does not have EVALUATION_ID or Effective Date as a key because they are no longer being used. Workers do not have multiple "sets" of competencies keyed by date or evaluation.

SELECT A.PERSON_ID , A.COMPETENCY , C.DESCR , B.SYNCID FROM PS_RB_COMPETENCIES A , PS_RB_WORKER B , PS_COMPETENCY_TBL C WHERE A.PERSON_ID = B.PERSON_ID AND A.COMPETENCY = C.COMPETENCY

Related Language Record: RF_WRKRCMP_SLVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
Prompt Table: RD_PERSON

2 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency - this field is brought over from HRMS
Prompt Table: COMPETENCY_TBL

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

4 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RD_PERSON
2	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency - this field is brought over from HRMS Prompt Table: COMPETENCY_TBL
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.