CM_ROLE_TAO (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.

CM_ROLE_TAO

(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.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Prompt Table: POSITION_DATA

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
Default Value: OPR_DEF_TBL_HR.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
Prompt Table: JOB_TASK_TBL

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 Prompt Table: POSITION_DATA
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 Default Value: OPR_DEF_TBL_HR.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 Prompt Table: JOB_TASK_TBL
6	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
7	EVAL_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Method of Evaluation