ZBD_JOBCODE_TBL

(SQL Table)
Index Back

Job Codes

Use JOBCODE_TBL to record information about the job assignments in your company. Assign a job code to each job. Data includes description, salary grade, standard hours, and salary survey equivalents. You can create multiple JOBCODE_TBL records for a job code, each with a unique effective date.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
7 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
8 STEP Number(2,0) SMALLINT NOT NULL Step
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

10 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
11 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period
12 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary
13 BD_DFLT_SAL_VAL Character(20) VARCHAR2(20) NOT NULL Default Value
14 BD_DFLT_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Budgets User Can Override
15 SURVEY_SALARY Number(8,0) INTEGER NOT NULL Survey Salary
16 BD_USER_OVERID_FLG Character(1) VARCHAR2(1) NOT NULL Budgets User Can Override
17 BD_POS_BNFT_OPTN Character(1) VARCHAR2(1) NOT NULL Position Benefit Options
P=Default Percent of Salary
V=Default Value
18 BD_DFLT_BNFT_VAL Character(20) VARCHAR2(20) NOT NULL Default Value
19 BD_BNFT_MULT Character(1) VARCHAR2(1) NOT NULL Multiple Benefit Values
20 BD_DFLT_BNFT_OVRD Character(1) VARCHAR2(1) NOT NULL Budgets User Can Override
21 BD_DFLT_BNFT_AMT Number(8,0) INTEGER NOT NULL Default Amount
22 BD_DFLT_BNFT_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Default Percent of Salary
23 BD_USER_BNFT_OVRD Character(1) VARCHAR2(1) NOT NULL Budgets User Can Override