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

RS_ROLE

(SQL Table)

Role Comps/Accomp Parent

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

Parent Record Of RS_ROLE_COMPS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

2 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
Prompt Table: JOB_FAMILY_TBL

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

4 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
Prompt Table: JOBCODE_TBL

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

6 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

7 EVAL_METHOD Character(1) VARCHAR2(1) NOT NULL Method of Evaluation

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
2	JOB_FAMILY	Character(6)	VARCHAR2(6) NOT NULL	Job Family Prompt Table: JOB_FAMILY_TBL
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
4	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
5	JOB_TASK	Character(6)	VARCHAR2(6) NOT NULL	Job Task
6	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
7	EVAL_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Method of Evaluation