JOBCODE

Job Code Parameters

Contains information about user-defined job codes. The Lawson Payroll system uses job codes to determine an employee's rate of pay. The Lawson Personnel Administration system uses job codes for EEO reporting, salary range analysis reporting, and staffing purposes. Job codes are optional in both systems.

REFERENCED BY
AC62.1 BN100 BN101 BN102 BN103 BN105
BN145 BN150 BN232 BN242 BN245 BN305
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN320
BN350 BN45.1 BN531 BN65.1 BN66.1 BN71.1
BN72.1 BS10.1 BS12.1 BS13.1 BS14.1 BS15.1
BS32.1 ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2
ZB32.3 HCDL.1 HCEM.1 HCHP.1 HAP3.1 HCRE.1
HEP4.1 HJBC.1 HLTM.1 HPOS.1 HPQC.1 HPRS.1
HR11.1 HR11.2 HR11.4 HR14.1 HR15.1 HR15.3
HR155 HR156 HR170 HR206 HR211 HR217
HR22.1 HR220 HR222 HR28.1 HR51.2 HR51.3
HR51.4 HR51.6 HR51.8 HR511 HR514 HR515
HR52.2 HR52.3 HR52.4 HR52.6 HR521 HR54.1
HR55.2 HR70.1 HR93.6 HRCL.1 HRS1.1 HRSC.1
HS10.1 HS10.2 HS208 LT11.5 LT13.5 PR521
ZH156 ZH230 ZH500 ZH510 ZH568 EXI2.1
EXI4.1 LP100 LP101 LP130 LP180 LP251
LP260 LP262 LP32.1 LP32.2 LP32.3 LP53.1
LP553 LP554 LP80.1 HS11.1 HS11.2 HS12.1
HS12.2 HS13.1 HS13.2 HS14.1 HS15.1 HS50.1
HS50.2 HS50.5 HS51.1 HS51.2 HS52.1 HS52.2
PA02.1 PA08.1 PA08.2 PA08.3 PA100 PA102
PA103 PA11.1 PA113 PA115 PA120 PA13.1
PA13.2 PA13.3 PA149 PA16.1 PA170 PA171
PA172 PA19.1 PA20.1 PA202 PA208 PA21.1
PA210 PA211 PA219 PA22.1 PA223 PA23.1
PA231 PA233 PA24.1 PA241 PA242 PA248
PA249 PA259 PA262 PA263 PA27.1 PA272
PA28.1 PA290 PA295 PA296 PA31.1 PA311
PA33.1 PA34.1 PA341 PA345 PA35.1 PA36.1
PA360 PA37.1 PA370 PA371 PA372 PA38.1
PA390 PA391 PA392 PA393 PA402 PA41.1
PA42.1 PA42.3 PA48.3 PA48.4 PA490 PA495
PA496 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PA520 PA53.1 PA531 PA532 PA533
PA535 PA54.1 PA570 PA59.1 PA590 PA594
PA62.1 PA63.1 PA64.1 PA64.2 PA65.1 PA65.2
PA66.3 PA71.1 PA73.1 PA80.2 PA82.1 PA90.1
TR114 TR120 TR121 TR20.1 TR20.2 TR20.3
TR20.4 TR201 TR21.1 TR22.1 TR26.1 TR500
ZE532 HS01.1 HS34.1 HS35.1 HS36.1 PR03.1
PR110 PR113 PR12.6 PR120 PR128 PR13.1
PR13.5 PR13.6 PR13.8 PR13.9 PR131 PR132
PR134 PR135 PR136 PR137 PR140 PR189
PR195 PR197 PR198 PR20.4 PR20.7 PR220
PR23.1 PR23.3 PR24.1 PR278 PR282 PR29.1
PR295 PR296 PR30.1 PR30.2 PR32.1 PR32.2
PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR35.9 PR36.1
PR36.4 PR37.1 PR418 PR45.1 PR512 PR529
PR530 PR560 PR582 PR80.1 PR80.4 PR82.1
PR82.2 PR89.1 PRAN.1 PRAT.1 UK102 ZP296
SN60.3 SN60.4 SN80.2 SN80.3 SNEM.1 SNHC.1
TA147 TA175 TM240 TM245 TM470 HRLRD
HCJC.1 HR05.1


UPDATED BY
HR06.1 HR06.2 HR506 HR710 LT101 LT111
PA09.1 HR00.1 HR01.1 PA95.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
JBC-COMPANY
Element: Company Hr		Numeric 4
The number that represents an established company and is entered on all functions.
HR06.1 HR06.2
HR506 LT101
LT111
JBC-JOB-CODE
Element: Code		Alpha 9
Contains the user-defined job code.
HR06.1 HR06.2
HR506 LT101
LT111
JBC-DESCRIPTION
Element: Description 60		Alpha 60 (Lower Case)
Contains the job code description.
HR06.1 HR506
LT101 LT111
PA219 PA242
PA311 PA33.1
PA371 PA71.1
PR131
JBC-RATE-OVERRIDE
Element: Rate Override		Alpha 1
Indicates if a pay rate below the employee's normal rate is allowed.
N = Cannot Pay Below Normal Rate
Y = Allow Pay Below Normal Rate
HR06.1 HR506
LT101 LT111
JBC-BEG-SAL-RANGE
Element: Minimum		Signed 13.4
Contains the beginning salary range used for EEO reporting and wage analysis.
HR06.1 HR06.2
HR506 LT101
LT111
JBC-MID-SAL-RANGE
Element: Midpoint		Signed 13.4
Middle salary range used for EEO reporting and wage analysis.
HR06.1 HR06.2
HR506 LT101
LT111
JBC-END-SAL-RANGE
Element: Maximum		Signed 13.4
Ending salary range used for EEO reporting and wage analysis.
HR06.1 HR06.2
HR506 LT101
LT111
JBC-POINTS
Element: Points		Signed 7.2
Contains the points associated with the job code.
HR06.1 HR506
LT101 LT111
JBC-EEO-CAT
Element: Eeo Cat		Alpha 2
Contains the EEO category associated with the job code.
01 = Official Administrator
02 = Professional
03 = Technician
04 = Protective Service
05 = Para-Professionals
06 = Office and Clerical
07 = Skilled Craft
08 = Service / Maintenance
12 = Exec/Sr Lvl Officials and Mgrs
13 = Trainee Exec/Sr Lvl Off & Mgrs
14 = First/Mid-Lvl Official and Mgr
15 = Trainee 1st/Mid-Lvl Off & Mgrs
16 = Officials & Admin & Mgrs
17 = Principals
18 = Assist Principal Teaching
19 = Assist Principal nonTeaching
20 = Professionals
21 = Trainee Professionals
22 = Elementary Classroom Teachers
23 = Secondary Classroom Teachers
24 = Other Classroom Teachers
25 = Guidance
26 = Psychological
27 = Librarian & Audio Visual Staff
28 = Consultants & Super of Instr
29 = Other Professional Staff
30 = Technicians
31 = Trainee Technicians
32 = Teachers Aid
33 = Technicians
34 = Clerical & Secretarial Staff
35 = Service Workers
36 = Skilled Crafts
37 = Laborers & Unskilled
40 = Sales Workers
41 = Trainee Sales Workers
50 = Administrative Support Workers
51 = Trainee Admin Support Workers
60 = Craft Workers
61 = Trainee Craft Workers
70 = Operatives
72 = Trainee Operatives
80 = Laborers and Helpers
82 = Trainee Laborers and Helpers
90 = Service Workers
92 = Trainee Service Workers
HR06.1 HR506
HR710 LT101
LT111 PA311
JBC-LAST-CMT-SEQ
Element: Last Cmt Seq		Numeric 4
Sequence number used for the last job code description line.
PA09.1
JBC-ACTIVE-FLAG
Element: Status		Alpha 1
Indicates if the job code is active or inactive.
A = Active
I = Inactive
HR06.1 HR206
HR506 LT101
LT111
JBC-ANNUAL-HOURS
Element: Annual Hours		Signed 8.4
Contains the number of hours per year defined for the job code.
HR06.1 HR506
LT101 LT111
JBC-JOB-CLASS
Element: Job Class		Alpha 3
Contains the job class. Used for reporting purposes and wage analysis.
HR06.1 HR506
LT101 LT111
ZH500
JBC-SCHEDULE
Element: Schedule		Alpha 9
Contains the grade range schedule associated with the job code. A grade range schedule is used for wage analysis.
HR06.1 HR506
LT101 LT111
JBC-PAY-GRADE
Element: Grade		Alpha 3
Contains the grade of a grade range schedule associated with this job code.
HR06.1 HR506
LT101 LT111
JBC-EEO-SUB-CODE
Element: Eeo Sub Code		Numeric 3
Contains an extension of the EEO category field.
HR06.1 HR506
LT101 LT111
PA311
JBC-EVAL-DATE
Element: Eval Date		Numeric 8 (yyyymmdd)
Indicates the last date the job code was evaluated.
HR06.1 HR506
LT101 LT111
JBC-EXEMPT
Element: Exempt		Alpha 1
Indicates if the job is exempt from overtime
N = No
Y = Yes
HR06.1 HR506
LT101 LT111
JBC-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
Indicates the effective date of the job code salary range.
HR06.1 HR06.2
HR506 LT101
LT111
JBC-DESC-DATE
Element: Desc Date		Numeric 8 (yyyymmdd)
Contains the date the job code description was last updated.
PA09.1
JBC-WC-CLASS
Element: Workers Comp Class		Alpha 4
Contains the workers' compensation classification to which the job code is assigned.
HR06.1 HR506
LT101 LT111
JBC-CA-WC-CLASS
Element: Ca Wc Class		Alpha 10
Contains the Canadian Workers Compensation classification to which the job is assigned.
HR06.1 HR506
LT101 LT111
JBC-PAY-RATE
Element: Rate		Signed 13.4
Contains the pay rate defined for the job code.
HR06.1 HR506
LT101 LT111
JBC-EXP-DIST-CO
Element: Company		Numeric 4
Contains the general ledger expense distribution company.
HR06.1 HR506
LT101 LT111
JBC-EXP-ACCT-UNIT
Element: Acct Unit		Alpha 15
Contains the general ledger expense accounting unit.
HR06.1 HR506
LT101 LT111
JBC-EXP-ACCOUNT
Element: Account		Numeric 6
Contains the general ledger expense account.
HR06.1 HR506
LT101 LT111
JBC-EXP-SUB-ACCT
Element: Expense Subaccount		Numeric 4
Contains the expense subaccount from the general ledger chart of accounts.
HR06.1 HR506
LT101 LT111
JBC-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
PA09.1
JBC-DEPARTMENT
Element: Department		Alpha 5
Contains the department in which the job code is valid.
PA09.1
JBC-REPORTS-TO
Element: Reports To		Numeric 9
Contains the employee number of the person who supervises the employees working in the job.
PA09.1
JBC-APPROVED-BY
Element: Approved By		Numeric 9
Contains the employee number of the individual who approved this job.
PA09.1
JBC-TIPPED
Element: Tipped		Alpha 1
Indicates if this is a tippable position.
C = Tipped job - Tax Credit
N = Not a tipped job
T = Tipped job - No Tax
HR06.1 HR506
LT101 LT111
JBC-OBJ-ID
Element: Obj Id		Numeric 12
Contains a system-assigned identifier that provides access to data in related files.
HR06.1 HR506
LT101 LT111
JBC-EEO-CAT-1
Element: Eeo Cat 1		Derived
JBC-MARKET-SALARY
Element: Pay Range		Signed 13.4
Contains the market salary for the job code.
HR06.1 HR506
LT101 LT111
JBC-MARKET-DATE
Element: Market Date		Numeric 8 (yyyymmdd)
Contains the date of the market salary.
HR06.1 HR506
LT101 LT111
JBC-CURRENCY-CODE
Element: Currency Code		Alpha 5
Contains the currency in which the pay is recorded.
HR06.1 HR06.2
HR506 LT101
LT111
JBC-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
HR06.1 HR06.2
HR506 LT101
LT111
JBC-BASE-PAY-RATE
Element: Pay Range		Signed 13.4
Contains the pay in company's base currency.
HR06.1 HR506
LT101 LT111
JBC-BASE-CURRENCY
Element: Base Currency		Alpha 5
Contains the company's base currency.
HR06.1 HR06.2
HR506 LT101
LT111
JBC-BASE-ND
Element: Base Nd		Numeric 1
The number of decimal positions defined for the company base currency.
HR06.1 HR06.2
HR506 LT101
LT111
JBC-BASE-BEG-SAL
Element: Pay Range		Signed 13.4
Contains the minimum pay in the company's base currency.
HR06.1 HR06.2
HR506 LT101
LT111
JBC-BASE-MID-SAL
Element: Pay Range		Signed 13.4
Contains the midpoint pay in the company's base currency.
HR06.1 HR06.2
HR506 LT101
LT111
JBC-BASE-END-SAL
Element: Pay Range		Signed 13.4
Contains the maximum pay in the company's base currency.
HR06.1 HR06.2
HR506 LT101
LT111
JBC-BASE-MARKET
Element: Pay Range		Signed 13.4
Contains the market salary in the company's base currency.
HR06.1 HR506
LT101 LT111
JBC-EFFECTIVE-DATE
Element: Effective Date		Numeric 8 (yyyymmdd)
Contains the date the job code takes effect. This is the date the job code will be logged to history.
HR06.1 HR506
LT101 LT111
JBC-SALARY-CLASS
Element: Salary Class		Alpha 1
Contains the salary class.
H = Hourly
S = Salary
HR06.1 HR06.2
HR506 LT101
LT111
JBC-WEB-TYPE
Element: Web Type		Alpha 3

1 = Physician
2 = Nurse
HR06.1 HR506
LT101 LT111
JBC-GENDER-CLASS
Element: Gender Class		Alpha 1
Designates if a job code is primarily male, female, or gender neutral.
" " = Not Applicable
1 = Female
2 = Male
3 = Gender Neutral
HR06.1 HR506
LT101 LT111
JBC-DIR-IND-JOB
Element: Dir Ind Job		Numeric 1

1 = Direct
2 = Indirect
JBC-OCCUP-GROUP
Element: Occup Group		Alpha 2
Contains the occupational group. Used in Canadian workforce analysis.
01 = Senior Managers
02 = Middle and Other Managers
03 = Professionals
04 = Semi-Professionals/Technicians
05 = Supervisors
06 = Supervisors/Crafts and Trades
07 = Administrators/Senior Clerical
08 = Skilled Sales/Service
09 = Skilled Crafts/Trades
10 = Clerical
11 = Intermediate Sales/Service
12 = Semi-Skilled Manual
13 = Other Sales/Service
14 = Other Manual
99 = Not Applicable
HR06.1 HR506
LT101 LT111
JBC-TENURE-ELIG
Element: Tenure Elig		Alpha 1

N = No
Y = Yes
" " = Not Applicable
HR06.1 HR506
LT101 LT111
JBC-HIGH-ED-CAT
Element: High Ed Cat		Numeric 2

01 = Exec;Admin;Mgr
02 = Faculty
03 = Other Professionals
04 = Clerical;Secretarial
05 = Technical;Paraprofessional
06 = Skilled Craft Workers
07 = Service;Maintenance
HR06.1 HR506
LT101 LT111
JBC-HIGH-ED-SUBCAT
Element: High Ed Subca4		Alpha 4
HR06.1 HR506
LT101 LT111
JBC-ACADEMIC-RANK
Element: Academic Rank		Alpha 1

1 = Professor
2 = Associate Professor
3 = Assistant Professor
4 = Instructor
5 = Lecturer
6 = Other Instructional Staff
HR06.1 HR506
LT101 LT111
JBC-MIN-HIRE-AGE
Element: Min Hire Age		Numeric 2
JBC-M3-FLAG
Element: M3 Flag		Alpha 1
Indicator will govern which employees are created in M3.
1 = No
2 = Yes
HR06.1 HR506
LT101 LT111
JBC-UPDATED-BY-LTM
Element: Updated By Ltm		Alpha 1

Y = Yes
N = No


JOBCODE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
JBCSET1 COMPANY
JOB-CODE
...
AC62.1 BN100
BN101 BN102
BN103 BN105
BN145 BN150
BN232 BN242
BN245 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN350 BN45.1
BN531 BN65.1
BN66.1 BN71.1
BN72.1 BS10.1
BS12.1 BS13.1
BS14.1 BS15.1
JBCSET2 COMPANY
JOB-CLASS
JOB-CODE
KeyChange
HCJC.1 HR05.1
PA210
JBCSET3 OBJ-ID
KeyChange
HR710 HR93.6


JOBCODE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Approved By EMPLOYEE Required
When JBC-APPROVED-BY !=Zeroes
JBC-COMPANY->EMP-COMPANY
JBC-APPROVED-BY->EMP-EMPLOYEE
Base Currency CUCODES Required
When (JBC-CURRENCY-CODE !=Spaces )
JBC-BASE-CURRENCY->CUC-CURRENCY-CODE
Company PRSYSTEM Required
JBC-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Currency CUCODES Required
When (JBC-CURRENCY-CODE !=Spaces )
JBC-CURRENCY-CODE->CUC-CURRENCY-CODE
Department DEPTCODE Required
When JBC-DEPARTMENT !=Spaces
JBC-COMPANY->DPT-COMPANY
JBC-PROCESS-LEVEL->DPT-PROCESS-LEVEL
JBC-DEPARTMENT->DPT-DEPARTMENT
Expense Acct GLMASTER Required
When JBC-EXP-ACCT-UNIT !=Spaces
OrJBC-EXP-ACCOUNT !=Zeroes
OrJBC-EXP-SUB-ACCT !=Zeroes
JBC-COMPANY->GLM-COMPANY
JBC-EXP-ACCT-UNIT->GLM-ACCT-UNIT
JBC-EXP-ACCOUNT->GLM-ACCOUNT
JBC-EXP-SUB-ACCT->GLM-SUB-ACCOUNT
Job Class JOBCLASS Required
When JBC-JOB-CLASS !=Spaces
JBC-COMPANY->JCL-COMPANY
JBC-JOB-CLASS->JCL-JOB-CLASS
Process Level PRSYSTEM Required
When JBC-PROCESS-LEVEL !=Spaces
JBC-COMPANY->PRS-COMPANY
JBC-PROCESS-LEVEL->PRS-PROCESS-LEVEL
Reports To EMPLOYEE Required
When JBC-REPORTS-TO !=Zeroes
JBC-COMPANY->EMP-COMPANY
JBC-REPORTS-TO->EMP-EMPLOYEE


JOBCODE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
App Job Auth JOBAUTH Delete Restricted
JBC-COMPANY->JBA-COMPANY
1->JBA-EMP-APP
JBC-JOB-CODE->JBA-JOB-CODE
  JBA-POSITION
  JBA-EMPLOYEE
Description PACOMMENTS Delete Cascades
JBC-COMPANY->PAC-COMPANY
2->PAC-EMP-APP
"JD"->PAC-CMT-TYPE
Zeroes->PAC-EMPLOYEE
JBC-JOB-CODE->PAC-JOB-CODE
Spaces->PAC-ACTION-CODE
Zeroes->PAC-LN-NBR
  PAC-SEQ-NBR
  PAC-DATE
Emp Job Auth JOBAUTH Delete Restricted
JBC-COMPANY->JBA-COMPANY
Zeroes->JBA-EMP-APP
JBC-JOB-CODE->JBA-JOB-CODE
  JBA-POSITION
  JBA-EMPLOYEE
Employees PATHFIND Delete Restricted
JBC-COMPANY->PTF-COMPANY
19->PTF-FLD-NBR
JBC-JOB-CODE->PTF-FLD-VALUE
  PTF-EMPLOYEE
  PTF-POS-LEVEL
Grade PRSAGDTL
Valid When (JBC-SCHEDULE !=Spaces )
And(JBC-PAY-GRADE !=Spaces )
JBC-COMPANY->SGD-COMPANY
JBC-SCHEDULE->SGD-SCHEDULE
JBC-PAY-GRADE->SGD-PAY-GRADE
  SGD-PAY-STEP
  SGD-EFFECT-DATE
Hist Err HISTERR Delete Cascades
JBC-COMPANY->HER-COMPANY
Zeroes->HER-EMPLOYEE
JBC-OBJ-ID->HER-OBJ-ID
  HER-EFFECT-DATE
  HER-ACTION-CODE
  HER-ACTION-NBR
  HER-FLD-NBR
  HER-SEQ-NBR
Hr Occup Code HROCCUPCD Delete Cascades
JBC-COMPANY->HOP-COMPANY
JBC-JOB-CODE->HOP-JOB-CODE
  HOP-COUNTRY-CODE
  HOP-OCCUPTN-CODE
Hrhistory HRHISTORY Delete Cascades
JBC-COMPANY->HRH-COMPANY
Zeroes->HRH-EMPLOYEE
JBC-OBJ-ID->HRH-OBJ-ID
  HRH-FLD-NBR
  HRH-POS-LEVEL
  HRH-BEG-DATE
  HRH-SEQ-NBR
Job Interest PAJOBINTRS Delete Cascades
JBC-COMPANY->PJI-COMPANY
JBC-JOB-CODE->PJI-JOB-CODE
Spaces->PJI-POSITION
  PJI-EMP-APP
  PJI-EMPLOYEE
Job Relations JOBRELATE Delete Cascades
JBC-COMPANY->JBR-COMPANY
Spaces->JBR-PROCESS-LEVEL
JBC-JOB-CODE->JBR-JOB-CODE
  JBR-POSITION
  JBR-TYPE
  JBR-PERS-CODE
  JBR-SUBJECT-CODE
Requisition PAJOBREQ
JBC-COMPANY->PJR-COMPANY
JBC-JOB-CODE->PJR-JOB-CODE
  PJR-REQUISITION
Schedule PRSAGHEAD
Valid When JBC-SCHEDULE !=Spaces
JBC-COMPANY->SGH-COMPANY
"G"->SGH-INDICATOR
JBC-SCHEDULE->SGH-SCHEDULE
  SGH-EFFECT-DATE
User Fields HRPOSUSD
JBC-COMPANY->HPD-COMPANY
"2"->HPD-TYPE
JBC-OBJ-ID->HPD-OBJ-ID
  HPD-EFFECT-DATE
  HPD-FIELD-KEY
Wc Class WCCLASS
Valid When JBC-WC-CLASS !=Spaces
JBC-COMPANY->WCC-COMPANY
JBC-WC-CLASS->WCC-WC-CLASS
Spaces->WCC-CA-WC-CLASS
  WCC-COUNTRY-CODE
  WCC-WC-STATE
  WCC-PROCESS-LEVEL
  WCC-EFFECT-DATE
Wc Class Ca WCCLASS
Valid When JBC-CA-WC-CLASS !=Spaces
JBC-COMPANY->WCC-COMPANY
Spaces->WCC-WC-CLASS
JBC-CA-WC-CLASS->WCC-CA-WC-CLASS
  WCC-COUNTRY-CODE
  WCC-WC-STATE
  WCC-PROCESS-LEVEL
  WCC-EFFECT-DATE

File created: Thu Jun 09 02:16:26 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.