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.

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
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
JBCSET1COMPANY, JOB-CODEPrimaryAC62.1, BN100, BN101, BN102, BN103, BN105, BN145, BN150 +22 more (list truncated in source)
JBCSET2COMPANY, JOB-CLASS, JOB-CODEKeyChangeHCJC.1, HR05.1, PA210
JBCSET3OBJ-IDKeyChangeHR710, HR93.6

Relations

One to one (9) — lookups and parents

RelationTableRulesConditionField map
Approved ByEMPLOYEERequiredWhen JBC-APPROVED-BY != ZeroesJBC-COMPANY → EMP-COMPANY, JBC-APPROVED-BY → EMP-EMPLOYEE
Base CurrencyCUCODESRequiredWhen (JBC-CURRENCY-CODE != Spaces)JBC-BASE-CURRENCY → CUC-CURRENCY-CODE
CompanyPRSYSTEMRequiredJBC-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen (JBC-CURRENCY-CODE != Spaces)JBC-CURRENCY-CODE → CUC-CURRENCY-CODE
DepartmentDEPTCODERequiredWhen JBC-DEPARTMENT != SpacesJBC-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 != ZeroesJBC-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 != SpacesJBC-COMPANY → JCL-COMPANY, JBC-JOB-CLASS → JCL-JOB-CLASS
Process LevelPRSYSTEMRequiredWhen JBC-PROCESS-LEVEL != SpacesJBC-COMPANY → PRS-COMPANY, JBC-PROCESS-LEVEL → PRS-PROCESS-LEVEL
Reports ToEMPLOYEERequiredWhen JBC-REPORTS-TO != ZeroesJBC-COMPANY → EMP-COMPANY, JBC-REPORTS-TO → EMP-EMPLOYEE

One to many (15) — child tables

RelationTableRulesConditionField map
App Job AuthJOBAUTHDelete RestrictedJBC-COMPANY → JBA-COMPANY, 1 → JBA-EMP-APP, JBC-JOB-CODE → JBA-JOB-CODE, → JBA-POSITION, → JBA-EMPLOYEE
DescriptionPACOMMENTSDelete CascadesJBC-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 RestrictedJBC-COMPANY → JBA-COMPANY, Zeroes → JBA-EMP-APP, JBC-JOB-CODE → JBA-JOB-CODE, → JBA-POSITION, → JBA-EMPLOYEE
EmployeesPATHFINDDelete RestrictedJBC-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 CascadesJBC-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 CascadesJBC-COMPANY → HOP-COMPANY, JBC-JOB-CODE → HOP-JOB-CODE, → HOP-COUNTRY-CODE, → HOP-OCCUPTN-CODE
HrhistoryHRHISTORYDelete CascadesJBC-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 CascadesJBC-COMPANY → PJI-COMPANY, JBC-JOB-CODE → PJI-JOB-CODE, Spaces → PJI-POSITION, → PJI-EMP-APP, → PJI-EMPLOYEE
Job RelationsJOBRELATEDelete CascadesJBC-COMPANY → JBR-COMPANY, Spaces → JBR-PROCESS-LEVEL, JBC-JOB-CODE → JBR-JOB-CODE, → JBR-POSITION, → JBR-TYPE, → JBR-PERS-CODE, → JBR-SUBJECT-CODE
RequisitionPAJOBREQJBC-COMPANY → PJR-COMPANY, JBC-JOB-CODE → PJR-JOB-CODE, → PJR-REQUISITION
SchedulePRSAGHEADValid When JBC-SCHEDULE != SpacesJBC-COMPANY → SGH-COMPANY, "G" → SGH-INDICATOR, JBC-SCHEDULE → SGH-SCHEDULE, → SGH-EFFECT-DATE
User FieldsHRPOSUSDJBC-COMPANY → HPD-COMPANY, "2" → HPD-TYPE, JBC-OBJ-ID → HPD-OBJ-ID, → HPD-EFFECT-DATE, → HPD-FIELD-KEY
Wc ClassWCCLASSValid When JBC-WC-CLASS != SpacesJBC-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 != SpacesJBC-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)