|
|
JOBCODE FILE
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 BS13.1 BS14.1 BS15.1 BS32.1 ET530
ET700 ETI2.1 HCDL.1 HCEM.1 HCHP.1 HAP3.1
HEP4.1 HJBC.1 HPOS.1 HPQC.1 HPRS.1 HR11.1
HR11.2 HR14.1 HR15.1 HR155 HR170 HR206
HR211 HR217 HR22.1 HR220 HR222 HR511
HR514 HR515 HR521 HR54.1 HR55.2 HR70.1
HRCL.1 HRS1.1 HRSC.1 HS10.1 HS10.2 HS208
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 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
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 TR201 TR21.1 TR22.1
TR26.1 TR500 HS01.1 HS34.1 HS35.1 HS36.1
PR03.1 PR110 PR113 PR120 PR128 PR13.1
PR13.5 PR13.6 PR13.8 PR130 PR131 PR132
PR134 PR136 PR140 PR160 PR180 PR189
PR195 PR197 PR198 PR20.4 PR20.7 PR220
PR23.1 PR23.3 PR24.1 PR278 PR282 PR29.1
PR295 PR296 PR30.1 PR32.2 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR35.9 PR36.1 PR418 PR45.1 PR529
PR530 PR560 PR80.1 PR80.2 PR82.1 PR82.2
PR89.1 PRAN.1 UK102 UK560 SN60.3 SN60.4
SN80.2 SN80.3 SNEM.1 SNHC.1 TA146 TA147
TA175 TA195 TA199 TM240 TM245 TM470
HRLRD HCJC.1 HR05.1
UPDATED BY
HR06.1 HR06.2 HR506 HR710 PA09.1 HR00.1
HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
JBC-COMPANY Numeric 4 HR06.1 HR06.2
Element: Company Hr The number that represents an HR506
established company and is entered on
all functions.
JBC-JOB-CODE Alpha 9 HR06.1 HR06.2
Element: Code Contains the user-defined job code. HR506
JBC-DESCRIPTION Alpha 30 (Lower Case) HR06.1 HR506
Element: Description Contains the job code description. PA219 PA242
PA311 PA33.1
PA371 PA71.1
PR131
JBC-RATE-OVERRIDE Alpha 1 HR06.1 HR506
Element: Rate Override 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
JBC-BEG-SAL-RANGE Signed 13.4 HR06.1 HR06.2
Element: Minimum Contains the beginning salary range HR506
used for EEO reporting and wage
analysis.
JBC-MID-SAL-RANGE Signed 13.4 HR06.1 HR06.2
Element: Midpoint Middle salary range used for EEO HR506
reporting and wage analysis.
JBC-END-SAL-RANGE Signed 13.4 HR06.1 HR06.2
Element: Maximum Ending salary range used for EEO HR506
reporting and wage analysis.
JBC-POINTS Signed 7.2 HR06.1 HR506
Element: Points Contains the points associated with the
job code.
JBC-EEO-CAT Alpha 2 HR06.1 HR506
Element: Eeo Cat Contains the EEO category associated HR710 PA311
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
10 = Officials and Managers
11 = Trainee
20 = Professionals
21 = Trainee
30 = Technicians
31 = Trainee
40 = Sales Workers
41 = Trainee
50 = Office and Clerical
51 = Trainee
60 = Craft Workers (Skilled)
61 = Trainee
70 = Operatives (Semi-skilled)
72 = Trainee
80 = Laborers (Unskilled)
82 = Trainee
90 = Service Workers
92 = Trainee
99 = Not Applicable
JBC-LAST-CMT-SEQ Numeric 4 PA09.1
Element: Last Cmt Seq Sequence number used for the last job
code description line.
JBC-ACTIVE-FLAG Alpha 1 HR06.1 HR206
Element: Status Indicates if the job code is active or HR506
inactive.
A = Active
I = Inactive
JBC-ANNUAL-HOURS Numeric 4 HR06.1 HR506
Element: Annual Hours Contains the number of hours per year
defined for the job code.
JBC-JOB-CLASS Alpha 3 HR06.1 HR506
Element: Job Class Contains the job class. Used for
reporting purposes and wage analysis.
JBC-SCHEDULE Alpha 9 HR06.1 HR506
Element: Schedule Contains the grade range schedule
associated with the job code. A grade
range schedule is used for wage
analysis.
JBC-PAY-GRADE Alpha 3 HR06.1 HR506
Element: Grade Contains the grade of a grade range
schedule associated with this job code.
JBC-EEO-SUB-CODE Numeric 3 HR06.1 HR506
Element: Eeo Sub Code Contains an extension of the EEO PA311
category field.
JBC-EVAL-DATE Numeric 8 (yyyymmdd) HR06.1 HR506
Element: Eval Date Indicates the last date the job code
was evaluated.
JBC-EXEMPT Alpha 1 HR06.1 HR506
Element: Exempt Indicates if the job is exempt from
overtime
N = No
Y = Yes
JBC-EFFECT-DATE Numeric 8 (yyyymmdd) HR06.1 HR06.2
Element: Effect Date Indicates the effective date of the job HR506
code salary range.
JBC-DESC-DATE Numeric 8 (yyyymmdd) PA09.1
Element: Desc Date Contains the date the job code
description was last updated.
JBC-WC-CLASS Alpha 4 HR06.1 HR506
Element: Workers Comp CContains the workers' compensation
classification to which the job code is
assigned.
JBC-CA-WC-CLASS Alpha 10 HR06.1 HR506
Element: Ca Wc Class Contains the Canadian Workers
Compensation classification to which the
job is assigned.
JBC-PAY-RATE Signed 13.4 HR06.1 HR506
Element: Rate Contains the pay rate defined for the
job code.
JBC-EXP-DIST-CO Numeric 4 HR06.1 HR506
Element: Company Contains the general ledger expense
distribution company.
JBC-EXP-ACCT-UNIT Alpha 15 HR06.1 HR506
Element: Acct Unit Contains the general ledger expense
accounting unit.
JBC-EXP-ACCOUNT Numeric 6 HR06.1 HR506
Element: Account Contains the general ledger expense
account.
JBC-EXP-SUB-ACCT Numeric 4 HR06.1 HR506
Element: Expense SubaccContains the expense subaccount from
the general ledger chart of accounts.
JBC-PROCESS-LEVEL Alpha 5 PA09.1
Element: Process Lev Hr
JBC-DEPARTMENT Alpha 5 PA09.1
Element: Department Contains the department in which the
job code is valid.
JBC-REPORTS-TO Numeric 9 PA09.1
Element: Reports To Contains the employee number of the
person who supervises the employees
working in the job.
JBC-APPROVED-BY Numeric 9 PA09.1
Element: Approved By Contains the employee number of the
individual who approved this job.
JBC-TIPPED Alpha 1 HR06.1 HR506
Element: Tipped Indicates if this is a tippable
position.
C = Tipped job - Tax Credit
N = Not a tipped job
T = Tipped job - No Tax
JBC-OBJ-ID Numeric 12 HR06.1 HR506
Element: Obj Id Contains a system-assigned identifier
that provides access to data in related
files.
JBC-EEO-CAT-1 Derived
Element: Eeo Cat 1
JBC-MARKET-SALARY Signed 13.4 HR06.1 HR506
Element: Pay Range Contains the market salary for the job
code.
JBC-MARKET-DATE Numeric 8 (yyyymmdd) HR06.1 HR506
Element: Market Date Contains the date of the market salary.
JBC-CURRENCY-CODE Alpha 5 HR06.1 HR06.2
Element: Currency Code Contains the currency in which the pay HR506
is recorded.
JBC-CURR-ND Numeric 1 HR06.1 HR06.2
Element: Acct Nd The number of decimals assigned to a HR506
particular account as determined by the
account currency.
JBC-BASE-PAY-RATE Signed 13.4 HR06.1 HR506
Element: Pay Range Contains the pay in company's base
currency.
JBC-BASE-CURRENCY Alpha 5 HR06.1 HR06.2
Element: Base Currency Contains the company's base currency. HR506
JBC-BASE-ND Numeric 1 HR06.1 HR06.2
Element: Base Nd The number of decimal positions defined HR506
for the company base currency.
JBC-BASE-BEG-SAL Signed 13.4 HR06.1 HR06.2
Element: Pay Range Contains the minimum pay in the HR506
company's base currency.
JBC-BASE-MID-SAL Signed 13.4 HR06.1 HR06.2
Element: Pay Range Contains the midpoint pay in the HR506
company's base currency.
JBC-BASE-END-SAL Signed 13.4 HR06.1 HR06.2
Element: Pay Range Contains the maximum pay in the HR506
company's base currency.
JBC-BASE-MARKET Signed 13.4 HR06.1 HR506
Element: Pay Range Contains the market salary in the
company's base currency.
JBC-EFFECTIVE-DATE Numeric 8 (yyyymmdd) HR06.1 HR506
Element: Effective DateContains the date the job code takes
effect. This is the date the job code
will be logged to history.
JBC-SALARY-CLASS Alpha 1 HR06.1 HR06.2
Element: Salary Class Contains the salary class. HR506
H = Hourly
S = Salary
JBC-WEB-TYPE Alpha 3 HR06.1 HR506
Element: Web Type 1 = Physician
2 = Nurse
JBC-GENDER-CLASS Alpha 1 HR06.1 HR506
Element: Gender Class Designates if a job code is primarily
male, female, or gender neutral.
" " = Not Applicable
1 = Female
2 = Male
3 = Gender Neutral
JBC-DIR-IND-JOB Numeric 1
Element: Dir Ind Job 1 = Direct
2 = Indirect
JBC-OCCUP-GROUP Alpha 2 HR06.1 HR506
Element: Occup Group 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
JBC-TENURE-ELIG Alpha 1 HR06.1 HR506
Element: Tenure Elig N = No
Y = Yes
" " = Not Applicable
JBC-HIGH-ED-CAT Numeric 2 HR06.1 HR506
Element: High Ed Cat 01 = Exec;Admin;Mgr
02 = Faculty
03 = Other Professionals
04 = Clerical;Secretarial
05 = Technical;Paraprofessional
06 = Skilled Craft Workers
07 = Service;Maintenance
JBC-HIGH-ED-SUBCAT Alpha 3 HR06.1 HR506
Element: High Ed Subcat
JBC-ACADEMIC-RANK Alpha 1 HR06.1 HR506
Element: Academic Rank 1 = Professor
2 = Associate Professor
3 = Assistant Professor
4 = Instructor
5 = Lecturer
6 = Other Instructional Staff
JOBCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
JBCSET1 COMPANY AC62.1 BN100
JOB-CODE 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 BS13.1
BS14.1 BS15.1
BS32.1 ET530
...
JBCSET2 COMPANY KeyChange HCJC.1 HR05.1
JOB-CLASS PA210
JOB-CODE
JBCSET3 OBJ-ID KeyChange HR710
JOBCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
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 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 RELATED
NAME 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
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
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
|
