RS_ROLE_TASK_VW (SQL View)	Index Back
Role Comps/Accomp Parent CM_ROLE is the parent record to CM_ROLE_COMPS and CM_ROLE_ACCOMPS that define the positions, jobcodes, job tasks, and job families profiled in the Competency Management Module.

RS_ROLE_TASK_VW

(SQL View)

Role Comps/Accomp Parent

CM_ROLE is the parent record to CM_ROLE_COMPS and CM_ROLE_ACCOMPS that define the positions, jobcodes, job tasks, and job families profiled in the Competency Management Module.

SELECT SETID , JOB_TASK FROM %Table(RS_ROLE) A WHERE A.JOB_TASK <> ' ' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM %Table(RS_ROLE) A1 WHERE A.SETID = A1.SETID AND A.JOB_TASK = A1.JOB_TASK AND A1.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

2 JOB_TASK Character(6) VARCHAR2(6) NOT NULL Job Task

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
2	JOB_TASK	Character(6)	VARCHAR2(6) NOT NULL	Job Task