JOBCODE – Job Code Parameters

System
Human Resources (HR)
Prefix
JBC
Primary key
COMPANY, JOB-CODE
Fields
58
Updated by
10 programs
Referenced by
326 programs

JOBCODE is the Job Code Parameters table in Lawson Human Resources (prefix JBC). It is indexed by COMPANY, JOB-CODE (JBCSET1); alternate indexes: JBCSET2 and JBCSET3. It is related 1:1 to EMPLOYEE, CUCODES, PRSYSTEM, DEPTCODE, GLMASTER and JOBCLASS and 1:M to JOBAUTH, PACOMMENTS, PATHFIND, PRSAGDTL, HISTERR, HROCCUPCD, HRHISTORY, PAJOBINTRS and 5 more. It is updated by HR00.1, HR01.1, HR06.1, HR06.2, HR506, HR710, LT101, LT111 and 2 more and referenced by AC62.1, BN100, BN101, BN102, BN103, BN105, BN145, BN150 and 318 more. The table has 58 fields, 3 indexes and 24 documented relations.

About JOBCODE

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.

Fields (58)

Column = COBOL field name without the JBC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#JBC-COMPANY PK
COMPANY
Numeric 4The number that represents an established company and is entered on all functions.HR06.1, HR06.2, HR506, LT101, LT111
#JBC-JOB-CODE PK
JOB_CODE
Alpha 9Contains the user-defined job code.HR06.1, HR06.2, HR506, LT101, LT111
#JBC-DESCRIPTION
DESCRIPTION
Alpha 60 (Lower Case)Contains the job code description.HR06.1, HR506, LT101, LT111, PA219, PA242, PA311, PA33.1 +3 more
#JBC-RATE-OVERRIDE
RATE_OVERRIDE
Alpha 1Indicates 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
BEG_SAL_RANGE
Signed 13.4Contains the beginning salary range used for EEO reporting and wage analysis.HR06.1, HR06.2, HR506, LT101, LT111
#JBC-MID-SAL-RANGE
MID_SAL_RANGE
Signed 13.4Middle salary range used for EEO reporting and wage analysis.HR06.1, HR06.2, HR506, LT101, LT111
#JBC-END-SAL-RANGE
END_SAL_RANGE
Signed 13.4Ending salary range used for EEO reporting and wage analysis.HR06.1, HR06.2, HR506, LT101, LT111
#JBC-POINTS
POINTS
Signed 7.2Contains the points associated with the job code.HR06.1, HR506, LT101, LT111
#JBC-EEO-CAT
EEO_CAT
Alpha 2Contains 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
LAST_CMT_SEQ
Numeric 4Sequence number used for the last job code description line.PA09.1
#JBC-ACTIVE-FLAG
ACTIVE_FLAG
Alpha 1Indicates if the job code is active or inactive.
  • A Active
  • I Inactive
HR06.1, HR206, HR506, LT101, LT111
#JBC-ANNUAL-HOURS
ANNUAL_HOURS
Signed 8.4Contains the number of hours per year defined for the job code.HR06.1, HR506, LT101, LT111
#JBC-JOB-CLASS SET2
JOB_CLASS
Alpha 3Contains the job class. Used for reporting purposes and wage analysis.HR06.1, HR506, LT101, LT111, ZH500
#JBC-SCHEDULE
SCHEDULE
Alpha 9Contains 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
PAY_GRADE
Alpha 3Contains the grade of a grade range schedule associated with this job code.HR06.1, HR506, LT101, LT111
#JBC-EEO-SUB-CODE
EEO_SUB_CODE
Numeric 3Contains an extension of the EEO category field.HR06.1, HR506, LT101, LT111, PA311
#JBC-EVAL-DATE
EVAL_DATE
Numeric 8 (yyyymmdd)Indicates the last date the job code was evaluated.HR06.1, HR506, LT101, LT111
#JBC-EXEMPT
EXEMPT
Alpha 1Indicates if the job is exempt from overtime
  • N No
  • Y Yes
HR06.1, HR506, LT101, LT111
#JBC-EFFECT-DATE
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
DESC_DATE
Numeric 8 (yyyymmdd)Contains the date the job code description was last updated.PA09.1
#JBC-WC-CLASS
WC_CLASS
Alpha 4Contains the workers' compensation classification to which the job code is assigned.HR06.1, HR506, LT101, LT111
#JBC-CA-WC-CLASS
CA_WC_CLASS
Alpha 10Contains the Canadian Workers Compensation classification to which the job is assigned.HR06.1, HR506, LT101, LT111
#JBC-PAY-RATE
PAY_RATE
Signed 13.4Contains the pay rate defined for the job code.HR06.1, HR506, LT101, LT111
#JBC-EXP-DIST-CO
EXP_DIST_CO
Numeric 4Contains the general ledger expense distribution company.HR06.1, HR506, LT101, LT111
#JBC-EXP-ACCT-UNIT
EXP_ACCT_UNIT
Alpha 15Contains the general ledger expense accounting unit.HR06.1, HR506, LT101, LT111
#JBC-EXP-ACCOUNT
EXP_ACCOUNT
Numeric 6Contains the general ledger expense account.HR06.1, HR506, LT101, LT111
#JBC-EXP-SUB-ACCT
EXP_SUB_ACCT
Numeric 4Contains the expense subaccount from the general ledger chart of accounts.HR06.1, HR506, LT101, LT111
#JBC-PROCESS-LEVEL
PROCESS_LEVEL
Alpha 5—PA09.1
#JBC-DEPARTMENT
DEPARTMENT
Alpha 5Contains the department in which the job code is valid.PA09.1
#JBC-REPORTS-TO
REPORTS_TO
Numeric 9Contains the employee number of the person who supervises the employees working in the job.PA09.1
#JBC-APPROVED-BY
APPROVED_BY
Numeric 9Contains the employee number of the individual who approved this job.PA09.1
#JBC-TIPPED
TIPPED
Alpha 1Indicates 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 SET3
OBJ_ID
Numeric 12Contains a system-assigned identifier that provides access to data in related files.HR06.1, HR506, LT101, LT111
#JBC-EEO-CAT-1
EEO_CAT_1
Derived——
#JBC-MARKET-SALARY
MARKET_SALARY
Signed 13.4Contains the market salary for the job code.HR06.1, HR506, LT101, LT111
#JBC-MARKET-DATE
MARKET_DATE
Numeric 8 (yyyymmdd)Contains the date of the market salary.HR06.1, HR506, LT101, LT111
#JBC-CURRENCY-CODE
CURRENCY_CODE
Alpha 5Contains the currency in which the pay is recorded.HR06.1, HR06.2, HR506, LT101, LT111
#JBC-CURR-ND
CURR_ND
Numeric 1The 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
BASE_PAY_RATE
Signed 13.4Contains the pay in company's base currency.HR06.1, HR506, LT101, LT111
#JBC-BASE-CURRENCY
BASE_CURRENCY
Alpha 5Contains the company's base currency.HR06.1, HR06.2, HR506, LT101, LT111
#JBC-BASE-ND
BASE_ND
Numeric 1The number of decimal positions defined for the company base currency.HR06.1, HR06.2, HR506, LT101, LT111
#JBC-BASE-BEG-SAL
BASE_BEG_SAL
Signed 13.4Contains the minimum pay in the company's base currency.HR06.1, HR06.2, HR506, LT101, LT111
#JBC-BASE-MID-SAL
BASE_MID_SAL
Signed 13.4Contains the midpoint pay in the company's base currency.HR06.1, HR06.2, HR506, LT101, LT111
#JBC-BASE-END-SAL
BASE_END_SAL
Signed 13.4Contains the maximum pay in the company's base currency.HR06.1, HR06.2, HR506, LT101, LT111
#JBC-BASE-MARKET
BASE_MARKET
Signed 13.4Contains the market salary in the company's base currency.HR06.1, HR506, LT101, LT111
#JBC-EFFECTIVE-DATE
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
SALARY_CLASS
Alpha 1Contains the salary class.
  • H Hourly
  • S Salary
HR06.1, HR06.2, HR506, LT101, LT111
#JBC-WEB-TYPE
WEB_TYPE
Alpha 3—
  • 1 Physician
  • 2 Nurse
HR06.1, HR506, LT101, LT111
#JBC-GENDER-CLASS
GENDER_CLASS
Alpha 1Designates 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
DIR_IND_JOB
Numeric 1—
  • 1 Direct
  • 2 Indirect
—
#JBC-OCCUP-GROUP
OCCUP_GROUP
Alpha 2Contains 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
TENURE_ELIG
Alpha 1" " = Not Applicable
  • N No
  • Y Yes
HR06.1, HR506, LT101, LT111
#JBC-HIGH-ED-CAT
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
HIGH_ED_SUBCAT
Alpha 4—HR06.1, HR506, LT101, LT111
#JBC-ACADEMIC-RANK
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
MIN_HIRE_AGE
Numeric 2——
#JBC-M3-FLAG
M3_FLAG
Alpha 1Indicator will govern which employees are created in M3.
  • 1 No
  • 2 Yes
HR06.1, HR506, LT101, LT111
#JBC-UPDATED-BY-LTM
UPDATED_BY_LTM
Alpha 1—
  • Y Yes
  • N No
—

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
JBCSET1
  1. COMPANY
  2. JOB-CODE
PrimaryAC62.1, BN100, BN101, BN102, BN103, BN105, BN145, BN150 +22 more (list truncated in source)
JBCSET2
  1. COMPANY
  2. JOB-CLASS
  3. JOB-CODE
KeyChangeHCJC.1, HR05.1, PA210
JBCSET3
  1. OBJ-ID
KeyChangeHR710, HR93.6

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
EMPLOYEECUCODESPRSYSTEMDEPTCODEGLMASTERJOBCLASSJOBAUTHPACOMMENTSPATHFINDPRSAGDTLHISTERRHROCCUPCDHRHISTORYPAJOBINTRSJOBRELATEPAJOBREQPRSAGHEADHRPOSUSDWCCLASSJOBCODE

One to one (9) — lookups and parents

RelationTableRulesConditionField map
Approved ByEMPLOYEERequiredWhen JBC-APPROVED-BY != Zeroes
JBC-COMPANY→EMP-COMPANY
JBC-APPROVED-BY→EMP-EMPLOYEE
Base CurrencyCUCODESRequiredWhen (JBC-CURRENCY-CODE != Spaces)
JBC-BASE-CURRENCY→CUC-CURRENCY-CODE
CompanyPRSYSTEMRequired
JBC-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen (JBC-CURRENCY-CODE != Spaces)
JBC-CURRENCY-CODE→CUC-CURRENCY-CODE
DepartmentDEPTCODERequiredWhen JBC-DEPARTMENT != Spaces
JBC-COMPANY→DPT-COMPANY
JBC-PROCESS-LEVEL→DPT-PROCESS-LEVEL
JBC-DEPARTMENT→DPT-DEPARTMENT
Expense AcctGLMASTERRequiredWhen JBC-EXP-ACCT-UNIT != Spaces Or JBC-EXP-ACCOUNT != Zeroes Or JBC-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 ClassJOBCLASSRequiredWhen JBC-JOB-CLASS != Spaces
JBC-COMPANY→JCL-COMPANY
JBC-JOB-CLASS→JCL-JOB-CLASS
Process LevelPRSYSTEMRequiredWhen JBC-PROCESS-LEVEL != Spaces
JBC-COMPANY→PRS-COMPANY
JBC-PROCESS-LEVEL→PRS-PROCESS-LEVEL
Reports ToEMPLOYEERequiredWhen JBC-REPORTS-TO != Zeroes
JBC-COMPANY→EMP-COMPANY
JBC-REPORTS-TO→EMP-EMPLOYEE

One to many (15) — child tables

RelationTableRulesConditionField map
App Job AuthJOBAUTHDelete Restricted
JBC-COMPANY→JBA-COMPANY
1→JBA-EMP-APP
JBC-JOB-CODE→JBA-JOB-CODE
—→JBA-POSITION
—→JBA-EMPLOYEE
DescriptionPACOMMENTSDelete 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 AuthJOBAUTHDelete Restricted
JBC-COMPANY→JBA-COMPANY
Zeroes→JBA-EMP-APP
JBC-JOB-CODE→JBA-JOB-CODE
—→JBA-POSITION
—→JBA-EMPLOYEE
EmployeesPATHFINDDelete Restricted
JBC-COMPANY→PTF-COMPANY
19→PTF-FLD-NBR
JBC-JOB-CODE→PTF-FLD-VALUE
—→PTF-EMPLOYEE
—→PTF-POS-LEVEL
GradePRSAGDTLValid 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 ErrHISTERRDelete 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 CodeHROCCUPCDDelete Cascades
JBC-COMPANY→HOP-COMPANY
JBC-JOB-CODE→HOP-JOB-CODE
—→HOP-COUNTRY-CODE
—→HOP-OCCUPTN-CODE
HrhistoryHRHISTORYDelete 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 InterestPAJOBINTRSDelete Cascades
JBC-COMPANY→PJI-COMPANY
JBC-JOB-CODE→PJI-JOB-CODE
Spaces→PJI-POSITION
—→PJI-EMP-APP
—→PJI-EMPLOYEE
Job RelationsJOBRELATEDelete 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
RequisitionPAJOBREQ
JBC-COMPANY→PJR-COMPANY
JBC-JOB-CODE→PJR-JOB-CODE
—→PJR-REQUISITION
SchedulePRSAGHEADValid When JBC-SCHEDULE != Spaces
JBC-COMPANY→SGH-COMPANY
"G"→SGH-INDICATOR
JBC-SCHEDULE→SGH-SCHEDULE
—→SGH-EFFECT-DATE
User FieldsHRPOSUSD
JBC-COMPANY→HPD-COMPANY
"2"→HPD-TYPE
JBC-OBJ-ID→HPD-OBJ-ID
—→HPD-EFFECT-DATE
—→HPD-FIELD-KEY
Wc ClassWCCLASSValid 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 CaWCCLASSValid 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

Programs

Updated by (10)

Referenced by (326)