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.

  • 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

    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    3 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
    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 Set ID

    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