HCR_JOBCD_TSK_I (SQL View)	Index Back
Job Code Task Tbl Control 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.

HCR_JOBCD_TSK_I

(SQL View)

Job Code Task Tbl Control

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.

SELECT A.SETID , A.JOBCODE , A.SETID_LOCATION , A.LOCATION , A.EFFDT FROM PS_JOBCD_TASK_TBL A

# 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
Prompt Table: JOBCODE_TBL

3 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SETID_TBL

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

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

#	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 Prompt Table: JOBCODE_TBL
3	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL
4	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: SET_LOC_VW
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date