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."

JOBCODE_TBL

(SQL Table)

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."

Related Language Record: JOBCODE_LANG

# 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 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

7 DESCRLONG Long Character CLOB Long Description

8 JOB_FUNCTION Character(3) VARCHAR2(3) NOT NULL Job Function Code

9 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary SetID

10 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

11 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

12 STEP Number(2,0) SMALLINT NOT NULL Step

13 MANAGER_LEVEL Character(2) VARCHAR2(2) NOT NULL Manager Level
0=Chief Operating Officer
1=Director
2=Senior Officer
3=Vice President
4=Senior Manager
5=Mid-Level Manager
6=First-Line Manager
7=Supervisor
8=All Other Positions
9=Non-Manager
Default Value: 8

14 SURVEY_SALARY Number(8,0) INTEGER NOT NULL Survey Salary

15 SURVEY_JOB_CODE Character(8) VARCHAR2(8) NOT NULL Salary Survey Job Code

16 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code

17 RETRO_RATE Signed Number(8,4) DECIMAL(6,4) NOT NULL Retroactive Rate

18 RETRO_PERCENT Signed Number(8,4) DECIMAL(6,4) NOT NULL Retroactive Percent

19 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

20 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours

21 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period
Prompt Table: STDHRS_FREQ_VW

22 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly

23 WORKERS_COMP_CD Character(4) VARCHAR2(4) NOT NULL Workers' Comp Code

24 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
Prompt Table: JOB_FAMILY_TBL

25 JOB_KNOWHOW_POINTS Number(5,0) INTEGER NOT NULL Knowhow-Points

26 JOB_ACCNTAB_POINTS Number(5,0) INTEGER NOT NULL Accountability-Points

27 JOB_PROBSLV_POINTS Number(5,0) INTEGER NOT NULL Problem-Solving-Points

28 JOB_POINTS_TOTAL Number(5,0) INTEGER NOT NULL Total Points

29 JOB_KNOWHOW_PCT Number(5,1) DECIMAL(4,1) NOT NULL Knowhow-Percent

30 JOB_ACCNTAB_PCT Number(5,1) DECIMAL(4,1) NOT NULL Accountability-Percent

31 JOB_PROBSLV_PCT Number(5,1) DECIMAL(4,1) NOT NULL Problem-Solving-Percent

32 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary

33 DIRECTLY_TIPPED Character(1) VARCHAR2(1) NOT NULL Tipped
D=Directly Tipped
I=Indirectly Tipped
N=Not Tipped
Default Value: N

34 MED_CHKUP_REQ Character(1) VARCHAR2(1) NOT NULL Medical Checkup Required
Y/N Table Edit
Default Value: N

35 FLSA_STATUS Character(1) VARCHAR2(1) NOT NULL FLSA Status
A=Administrative
E=Executive
M=Management
N=Nonexempt
O=Outside Salesperson
P=Professional
X=No FLSA Required
Default Value: N

36 EEO1CODE Character(1) VARCHAR2(1) NOT NULL EEO-1 Job Category
Default Value: N

37 EEO4CODE Character(1) VARCHAR2(1) NOT NULL EEO-4 Job Category
Default Value: N

38 EEO5CODE Character(2) VARCHAR2(2) NOT NULL EEO-5 Job Category
Default Value: N

39 EEO6CODE Character(1) VARCHAR2(1) NOT NULL EEO-6 Job Category
Default Value: N

40 EEO_JOB_GROUP Character(4) VARCHAR2(4) NOT NULL EEO Job Group

41 US_SOC_CD Character(6) VARCHAR2(6) NOT NULL Standard Occupational Classif

42 IPEDSSCODE Character(1) VARCHAR2(1) NOT NULL IPEDS-S Job Category
Default Value: N

43 CAN_PAYEQ_JOB_CLS Character(3) VARCHAR2(3) NOT NULL Canadian Pay Equity Job Class

44 CAN_NOC_CD Character(10) VARCHAR2(10) NOT NULL National Occupational Classif

45 SEASONAL Character(1) VARCHAR2(1) NOT NULL Seasonal
Y/N Table Edit
Default Value: N

46 BPS_ACTIVITY_CD Character(6) VARCHAR2(6) NOT NULL BPS Activity

47 FUNCTION_CD Character(2) VARCHAR2(2) NOT NULL Function Code

48 BA_CD Character(3) VARCHAR2(3) NOT NULL BA Code

49 TECHNICAL Character(1) VARCHAR2(1) NOT NULL Technical
Y/N Table Edit

50 MED_SURV_REQ Character(1) VARCHAR2(1) NOT NULL Medical Surveillance Required
Y/N Table Edit
Default Value: N

51 EMP_CATEGRY_FRA Character(3) VARCHAR2(3) NOT NULL Employee Category

52 ACTIVITY_TYPE_FRA Character(3) VARCHAR2(3) NOT NULL Activity Type

53 INSEE_CD_FRA Character(4) VARCHAR2(4) NOT NULL INSEE Code

54 UK_SOC_CD Character(2) VARCHAR2(2) NOT NULL Standard Occupational Classif

55 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan

56 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series

57 TRN_PROGRAM Character(6) VARCHAR2(6) NOT NULL Training Program

58 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

59 GVT_FUNC_CLASS Character(2) VARCHAR2(2) NOT NULL Functional Class
Default Value: 00

60 GVT_POSN_TITLE_CD Character(4) VARCHAR2(4) NOT NULL Official Posn Title Code

61 GVT_OFFICIAL_DESCR Character(70) VARCHAR2(70) NOT NULL Official Position Title

62 GVT_ORG_TTL_CD Character(4) VARCHAR2(4) NOT NULL Organization Posn Title Cd

63 GVT_ORG_TTL_DESCR Character(70) VARCHAR2(70) NOT NULL Organization Position Title

64 GVT_PAY_BASIS Character(2) VARCHAR2(2) NOT NULL Pay Basis

65 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency

66 GVT_POI Character(4) VARCHAR2(4) NOT NULL Personnel Office ID

67 GVT_PAREN_TITLE Character(1) VARCHAR2(1) NOT NULL Parenthetical Title

68 GVT_OPM_CERT_NBR Character(8) VARCHAR2(8) NOT NULL OPM Certification Number

69 GVT_POSN_CLASS_STD Character(254) VARCHAR2(254) NOT NULL Position Classification Stds

70 GVT_POSN_SENS_CD Character(1) VARCHAR2(1) NOT NULL Sensitivity Code
Default Value: 1

71 GVT_IA_ACTIONS Character(1) VARCHAR2(1) NOT NULL IA Actions
Y/N Table Edit
Default Value: N

72 GVT_EXEC_FIN_DISCL Character(1) VARCHAR2(1) NOT NULL Executive Financial Disclosure
Y/N Table Edit
Default Value: N

73 GVT_EMP_FIN_INT Character(1) VARCHAR2(1) NOT NULL Employee Financial Interests
Y/N Table Edit
Default Value: N

74 GVT_PATCOB_CD Character(1) VARCHAR2(1) NOT NULL PATCOB Code

75 GVT_CLS_STANDARD Character(15) VARCHAR2(15) NOT NULL Classification Standard

76 GVT_CLASSIFIER_ID Character(11) VARCHAR2(11) NOT NULL Classifier's ID

77 GVT_DT_CLASSIFIED Date(10) DATE Date Classified
Default Value: %date

78 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2

79 GVT_FUND_SOURCE Character(1) VARCHAR2(1) NOT NULL Fund Source

80 GVT_LEO_POSITION Character(1) VARCHAR2(1) NOT NULL LEO/Fire Position

81 GVT_PERF_PLAN Character(8) VARCHAR2(8) NOT NULL Performance Plan

82 GVT_TARGET_GRADE Character(2) VARCHAR2(2) NOT NULL Target Grade

83 GVT_PI_UPD_IND Character(1) VARCHAR2(1) NOT NULL pi upd ind

84 ENCUMBER_INDC Character(1) VARCHAR2(1) NOT NULL Encumbrance Indicator
I=Encumber Immediately
N=No Encumbrance
R=Encumber on Requisition
Default Value: N

85 POSN_MGMT_INDC Character(1) VARCHAR2(1) NOT NULL Used by Position Mgmt?
Y/N Table Edit
Default Value: Y

86 EG_ACADEMIC_RANK Character(3) VARCHAR2(3) NOT NULL Academic Rank

87 EG_GROUP Character(6) VARCHAR2(6) NOT NULL Service Calculation Group

88 HP_STATS_DUTIES Character(2) VARCHAR2(2) NOT NULL Stats Can Duties
10=Teaching Only
20=Teaching & Othr Responsibility
30=Research

89 HP_STATS_RPT_FLAG Character(1) VARCHAR2(1) NOT NULL Stats Can Report Flag
B=Both Surveys
F=Full-Time Survey
N=Not Applicable
P=Part-Time Survey
Default Value: N

90 ENCUMB_SAL_OPTN Character(3) VARCHAR2(3) NOT NULL Encumber Salary Option
COM=Sum of Default Components
MAX=Salary Grade Maximum
MID=Salary Grade Midpoint
MIN=Salary Grade Minimum
STP=Salary Step
USR=User Specified Amount
Default Value: STP

91 ENCUMB_SAL_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Encumber Salary Amount

92 INAIL_CODE Character(11) VARCHAR2(11) NOT NULL INAIL Code

#	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	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	DESCRLONG	Long Character	CLOB	Long Description
8	JOB_FUNCTION	Character(3)	VARCHAR2(3) NOT NULL	Job Function Code
9	SETID_SALARY	Character(5)	VARCHAR2(5) NOT NULL	Salary SetID
10	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
11	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
12	STEP	Number(2,0)	SMALLINT NOT NULL	Step
13	MANAGER_LEVEL	Character(2)	VARCHAR2(2) NOT NULL	Manager Level 0=Chief Operating Officer 1=Director 2=Senior Officer 3=Vice President 4=Senior Manager 5=Mid-Level Manager 6=First-Line Manager 7=Supervisor 8=All Other Positions 9=Non-Manager Default Value: 8
14	SURVEY_SALARY	Number(8,0)	INTEGER NOT NULL	Survey Salary
15	SURVEY_JOB_CODE	Character(8)	VARCHAR2(8) NOT NULL	Salary Survey Job Code
16	UNION_CD	Character(3)	VARCHAR2(3) NOT NULL	Union Code
17	RETRO_RATE	Signed Number(8,4)	DECIMAL(6,4) NOT NULL	Retroactive Rate
18	RETRO_PERCENT	Signed Number(8,4)	DECIMAL(6,4) NOT NULL	Retroactive Percent
19	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
20	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
21	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period Prompt Table: STDHRS_FREQ_VW
22	COMP_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Compensation Frequency A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly
23	WORKERS_COMP_CD	Character(4)	VARCHAR2(4) NOT NULL	Workers' Comp Code
24	JOB_FAMILY	Character(6)	VARCHAR2(6) NOT NULL	Job Family Prompt Table: JOB_FAMILY_TBL
25	JOB_KNOWHOW_POINTS	Number(5,0)	INTEGER NOT NULL	Knowhow-Points
26	JOB_ACCNTAB_POINTS	Number(5,0)	INTEGER NOT NULL	Accountability-Points
27	JOB_PROBSLV_POINTS	Number(5,0)	INTEGER NOT NULL	Problem-Solving-Points
28	JOB_POINTS_TOTAL	Number(5,0)	INTEGER NOT NULL	Total Points
29	JOB_KNOWHOW_PCT	Number(5,1)	DECIMAL(4,1) NOT NULL	Knowhow-Percent
30	JOB_ACCNTAB_PCT	Number(5,1)	DECIMAL(4,1) NOT NULL	Accountability-Percent
31	JOB_PROBSLV_PCT	Number(5,1)	DECIMAL(4,1) NOT NULL	Problem-Solving-Percent
32	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary
33	DIRECTLY_TIPPED	Character(1)	VARCHAR2(1) NOT NULL	Tipped D=Directly Tipped I=Indirectly Tipped N=Not Tipped Default Value: N
34	MED_CHKUP_REQ	Character(1)	VARCHAR2(1) NOT NULL	Medical Checkup Required Y/N Table Edit Default Value: N
35	FLSA_STATUS	Character(1)	VARCHAR2(1) NOT NULL	FLSA Status A=Administrative E=Executive M=Management N=Nonexempt O=Outside Salesperson P=Professional X=No FLSA Required Default Value: N
36	EEO1CODE	Character(1)	VARCHAR2(1) NOT NULL	EEO-1 Job Category Default Value: N
37	EEO4CODE	Character(1)	VARCHAR2(1) NOT NULL	EEO-4 Job Category Default Value: N
38	EEO5CODE	Character(2)	VARCHAR2(2) NOT NULL	EEO-5 Job Category Default Value: N
39	EEO6CODE	Character(1)	VARCHAR2(1) NOT NULL	EEO-6 Job Category Default Value: N
40	EEO_JOB_GROUP	Character(4)	VARCHAR2(4) NOT NULL	EEO Job Group
41	US_SOC_CD	Character(6)	VARCHAR2(6) NOT NULL	Standard Occupational Classif
42	IPEDSSCODE	Character(1)	VARCHAR2(1) NOT NULL	IPEDS-S Job Category Default Value: N
43	CAN_PAYEQ_JOB_CLS	Character(3)	VARCHAR2(3) NOT NULL	Canadian Pay Equity Job Class
44	CAN_NOC_CD	Character(10)	VARCHAR2(10) NOT NULL	National Occupational Classif
45	SEASONAL	Character(1)	VARCHAR2(1) NOT NULL	Seasonal Y/N Table Edit Default Value: N
46	BPS_ACTIVITY_CD	Character(6)	VARCHAR2(6) NOT NULL	BPS Activity
47	FUNCTION_CD	Character(2)	VARCHAR2(2) NOT NULL	Function Code
48	BA_CD	Character(3)	VARCHAR2(3) NOT NULL	BA Code
49	TECHNICAL	Character(1)	VARCHAR2(1) NOT NULL	Technical Y/N Table Edit
50	MED_SURV_REQ	Character(1)	VARCHAR2(1) NOT NULL	Medical Surveillance Required Y/N Table Edit Default Value: N
51	EMP_CATEGRY_FRA	Character(3)	VARCHAR2(3) NOT NULL	Employee Category
52	ACTIVITY_TYPE_FRA	Character(3)	VARCHAR2(3) NOT NULL	Activity Type
53	INSEE_CD_FRA	Character(4)	VARCHAR2(4) NOT NULL	INSEE Code
54	UK_SOC_CD	Character(2)	VARCHAR2(2) NOT NULL	Standard Occupational Classif
55	GVT_PAY_PLAN	Character(2)	VARCHAR2(2) NOT NULL	Pay Plan
56	GVT_OCC_SERIES	Character(4)	VARCHAR2(4) NOT NULL	Occupational Series
57	TRN_PROGRAM	Character(6)	VARCHAR2(6) NOT NULL	Training Program
58	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
59	GVT_FUNC_CLASS	Character(2)	VARCHAR2(2) NOT NULL	Functional Class Default Value: 00
60	GVT_POSN_TITLE_CD	Character(4)	VARCHAR2(4) NOT NULL	Official Posn Title Code
61	GVT_OFFICIAL_DESCR	Character(70)	VARCHAR2(70) NOT NULL	Official Position Title
62	GVT_ORG_TTL_CD	Character(4)	VARCHAR2(4) NOT NULL	Organization Posn Title Cd
63	GVT_ORG_TTL_DESCR	Character(70)	VARCHAR2(70) NOT NULL	Organization Position Title
64	GVT_PAY_BASIS	Character(2)	VARCHAR2(2) NOT NULL	Pay Basis
65	GVT_SUB_AGENCY	Character(2)	VARCHAR2(2) NOT NULL	Sub-Agency
66	GVT_POI	Character(4)	VARCHAR2(4) NOT NULL	Personnel Office ID
67	GVT_PAREN_TITLE	Character(1)	VARCHAR2(1) NOT NULL	Parenthetical Title
68	GVT_OPM_CERT_NBR	Character(8)	VARCHAR2(8) NOT NULL	OPM Certification Number
69	GVT_POSN_CLASS_STD	Character(254)	VARCHAR2(254) NOT NULL	Position Classification Stds
70	GVT_POSN_SENS_CD	Character(1)	VARCHAR2(1) NOT NULL	Sensitivity Code Default Value: 1
71	GVT_IA_ACTIONS	Character(1)	VARCHAR2(1) NOT NULL	IA Actions Y/N Table Edit Default Value: N
72	GVT_EXEC_FIN_DISCL	Character(1)	VARCHAR2(1) NOT NULL	Executive Financial Disclosure Y/N Table Edit Default Value: N
73	GVT_EMP_FIN_INT	Character(1)	VARCHAR2(1) NOT NULL	Employee Financial Interests Y/N Table Edit Default Value: N
74	GVT_PATCOB_CD	Character(1)	VARCHAR2(1) NOT NULL	PATCOB Code
75	GVT_CLS_STANDARD	Character(15)	VARCHAR2(15) NOT NULL	Classification Standard
76	GVT_CLASSIFIER_ID	Character(11)	VARCHAR2(11) NOT NULL	Classifier's ID
77	GVT_DT_CLASSIFIED	Date(10)	DATE	Date Classified Default Value: %date
78	BARG_UNIT	Character(4)	VARCHAR2(4) NOT NULL	Bargaining Unit 1=Bargaining Unit 1 2=Bargaining Unit 2
79	GVT_FUND_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Fund Source
80	GVT_LEO_POSITION	Character(1)	VARCHAR2(1) NOT NULL	LEO/Fire Position
81	GVT_PERF_PLAN	Character(8)	VARCHAR2(8) NOT NULL	Performance Plan
82	GVT_TARGET_GRADE	Character(2)	VARCHAR2(2) NOT NULL	Target Grade
83	GVT_PI_UPD_IND	Character(1)	VARCHAR2(1) NOT NULL	pi upd ind
84	ENCUMBER_INDC	Character(1)	VARCHAR2(1) NOT NULL	Encumbrance Indicator I=Encumber Immediately N=No Encumbrance R=Encumber on Requisition Default Value: N
85	POSN_MGMT_INDC	Character(1)	VARCHAR2(1) NOT NULL	Used by Position Mgmt? Y/N Table Edit Default Value: Y
86	EG_ACADEMIC_RANK	Character(3)	VARCHAR2(3) NOT NULL	Academic Rank
87	EG_GROUP	Character(6)	VARCHAR2(6) NOT NULL	Service Calculation Group
88	HP_STATS_DUTIES	Character(2)	VARCHAR2(2) NOT NULL	Stats Can Duties 10=Teaching Only 20=Teaching & Othr Responsibility 30=Research
89	HP_STATS_RPT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Stats Can Report Flag B=Both Surveys F=Full-Time Survey N=Not Applicable P=Part-Time Survey Default Value: N
90	ENCUMB_SAL_OPTN	Character(3)	VARCHAR2(3) NOT NULL	Encumber Salary Option COM=Sum of Default Components MAX=Salary Grade Maximum MID=Salary Grade Midpoint MIN=Salary Grade Minimum STP=Salary Step USR=User Specified Amount Default Value: STP
91	ENCUMB_SAL_AMT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Encumber Salary Amount
92	INAIL_CODE	Character(11)	VARCHAR2(11) NOT NULL	INAIL Code