JOBCD_TASK_DEFN (SQL Table)	Index Back
Job Code Task Definition This record is one of several that enable you to define a set of tasks related to a job. This functionality can be found in the Regulatory Requirements and Recruitment modules. Use JOB_TASK_TBL to define a job task and to assign a code to the task. You must define a job task on this record before entering the task on JOBCD_TASK_DEFN. Use JOBCD_TASK_TBL to identify a job code for which you're setting up job tasks. You must create this record before entering job tasks on JOBCD_TASK_DEFN. Use JOBCD_TASK_DEFN to specify the particular tasks associated with the job code. This record is subordinate to JOBCD_TASK_TBL.

JOBCD_TASK_DEFN

(SQL Table)

Job Code Task Definition

This record is one of several that enable you to define a set of tasks related to a job. This functionality can be found in the Regulatory Requirements and Recruitment modules. Use JOB_TASK_TBL to define a job task and to assign a code to the task. You must define a job task on this record before entering the task on JOBCD_TASK_DEFN. Use JOBCD_TASK_TBL to identify a job code for which you're setting up job tasks. You must create this record before entering job tasks on JOBCD_TASK_DEFN. Use JOBCD_TASK_DEFN to specify the particular tasks associated with the job code. This record is subordinate to JOBCD_TASK_TBL.

Parent record: JOBCD_TASK_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SET_VLD_HR_02

2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

3 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID

4 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
Prompt Table: SET_LOC_CURR_VW

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

6 SETID_JOBTASK Character(5) VARCHAR2(5) NOT NULL Job Task SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SETID_TBL

7 JOB_TASK Character(6) VARCHAR2(6) NOT NULL Job Task
Prompt Table: SET_JOBTASK_VW

8 IMPORTANCE Character(1) VARCHAR2(1) NOT NULL Importance
E=Essential
M=Marginal

9 FREQUENCY_PERFORM Character(1) VARCHAR2(1) NOT NULL Frequency of Performance
D=Daily
H=Hourly
M=Monthly
W=Weekly
Y=Yearly

10 CONSEQUENCE Character(1) VARCHAR2(1) NOT NULL Consequence
1=Very Minor
2=Minor
3=Quite Serious
4=Serious
5=Very Serious

11 PCT_TIME_SPENT Number(6,2) DECIMAL(5,2) NOT NULL Percent of Time Spent

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_VLD_HR_02
2	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
3	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
4	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: SET_LOC_CURR_VW
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
6	SETID_JOBTASK	Character(5)	VARCHAR2(5) NOT NULL	Job Task SetID Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL
7	JOB_TASK	Character(6)	VARCHAR2(6) NOT NULL	Job Task Prompt Table: SET_JOBTASK_VW
8	IMPORTANCE	Character(1)	VARCHAR2(1) NOT NULL	Importance E=Essential M=Marginal
9	FREQUENCY_PERFORM	Character(1)	VARCHAR2(1) NOT NULL	Frequency of Performance D=Daily H=Hourly M=Monthly W=Weekly Y=Yearly
10	CONSEQUENCE	Character(1)	VARCHAR2(1) NOT NULL	Consequence 1=Very Minor 2=Minor 3=Quite Serious 4=Serious 5=Very Serious
11	PCT_TIME_SPENT	Number(6,2)	DECIMAL(5,2) NOT NULL	Percent of Time Spent