BD_JOBCODES

(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

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SETID_TBL

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 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary
12 BD_DFLT_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Budgets User Can Override
13 BD_DFLT_SAL_VAL Character(20) VARCHAR2(20) NOT NULL Default Value
14 SURVEY_SALARY Number(8,0) INTEGER NOT NULL Survey Salary

Default Value: 0

15 BD_USER_OVERID_FLG Character(1) VARCHAR2(1) NOT NULL Budgets User Can Override
16 BD_POS_BNFT_OPTN Character(1) VARCHAR2(1) NOT NULL Position Benefit Options
P=Default Percentage
V=Default Value

Default Value: V

17 BD_DFLT_BNFT_VAL Character(20) VARCHAR2(20) NOT NULL Default Value

Prompt Table: GL_ACCOUNT_TBL

18 BD_BNFT_MULT Character(1) VARCHAR2(1) NOT NULL Multiple Benefit Values
19 BD_DFLT_BNFT_OVRD Character(1) VARCHAR2(1) NOT NULL Budgets User Can Override
20 BD_DFLT_BNFT_AMT Number(11,2) DECIMAL(10,2) NOT NULL Default Amount

Default Value: 0

21 BD_DFLT_BNFT_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Default Percent of Salary

Default Value: 0

22 BD_USER_BNFT_OVRD Character(1) VARCHAR2(1) NOT NULL Budgets User Can Override
23 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period
24 MIN_RT_ANNUAL Number(19,3) DECIMAL(18,3) NOT NULL Minimum Annual Rate
25 MID_RT_ANNUAL Number(19,3) DECIMAL(18,3) NOT NULL Midpoint Annual Rate
26 MAX_RT_ANNUAL Number(19,3) DECIMAL(18,3) NOT NULL Maximum Annual Rate