|
|
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
AC530 AC731 BN100 BN101 BN102 BN103
BN105 BN145 BN150 BN232 BN242 BN245
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN320
BN350 BN45.1 BN531 BN65.1 BN71.1 BN72.1
BS13.1 BS14.1 BS15.1 BS32.1 HCEM.1 HCOP.1
HCOP.2 HJBC.1 HR11.1 HR11.2 HR14.1 HR15.1
HR155 HR170 HR206 HR211 HR511 HR514
HR521 HR54.1 HR55.2 HR70.1 HRS1.1 HRSC.1
HS10.1 HS11.1 HS12.1 HS14.1 HS15.1 PA02.1
PA08.1 PA08.2 PA08.3 PA100 PA102 PA11.1
PA111 PA115 PA120 PA13.1 PA13.2 PA149
PA16.1 PA170 PA171 PA172 PA19.1 PA20.1
PA202 PA208 PA21.1 PA211 PA219 PA22.1
PA23.1 PA231 PA233 PA24.1 PA241 PA242
PA248 PA249 PA259 PA262 PA263 PA272
PA290 PA295 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 PA48.3 PA48.4
PA502 PA513 PA52.1 PA52.3 PA52.4 PA52.5
PA520 PA531 PA532 PA533 PA54.1 PA570
PA59.1 PA590 PA62.1 PA63.1 PA64.1 PA64.2
PA65.1 PA65.2 PA66.3 PA71.1 PA73.1 PA80.2
PA90.1 TR114 TR121 TR21.1 TR22.1 TR500
HS01.1 HS34.1 HS35.1 PR03.1 PR110 PR120
PR128 PR13.1 PR131 PR132 PR134 PR136
PR137 PR140 PR150 PR195 PR199 PR20.4
PR20.7 PR220 PR23.1 PR23.3 PR24.1 PR278
PR295 PR30.1 PR32.1 PR32.2 PR33.1 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR36.1 PR37.1 PR45.1 PR530
PR80.1 PR82.1 PR82.2 PR85.1 PR89.1 PRAN.1
PRWC.1 UK102 UK330 TA175 TA195 TA199
TM240 TM245 TM470 UK120 UK60.1 UK70.1
HCJC.1 HR05.1
UPDATED BY
HR06.1 HR06.2 HR700 PA09.1 HR00.1 HR01.1
PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
JBC-COMPANY Numeric 4 HR06.1 HR06.2
Company The number that represents an
established company and is entered on
all functions.
JBC-JOB-CODE Alpha 9 HR06.1 HR06.2
Code Contains the user-defined job code. PA64.2 PA65.2
JBC-DESCRIPTION Alpha 30 (Lower Case) HR06.1 HS12.1
Description Contains the job code description. PA219 PA242
PA311 PA33.1
PA371 PA64.2
PA65.2 PA71.1
PA73.1 PR131
JBC-RATE-OVERRIDE Alpha 1 HR06.1
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
Minimum Contains the beginning salary range
used for EEO reporting and wage
analysis.
JBC-MID-SAL-RANGE Signed 13.4 HR06.1 HR06.2
Midpoint Middle salary range used for EEO
reporting and wage analysis.
JBC-END-SAL-RANGE Signed 13.4 HR06.1 HR06.2
Maximum Ending salary range used for EEO
reporting and wage analysis.
JBC-POINTS Signed 5.2 HR06.1
Points Contains the points associated with the
job code.
JBC-EEO-CAT Alpha 2 HCOP.2 HR06.1
EEO Category Contains the EEO category associated PA311
with the job code.
1 = Official Administrator
2 = Professional
3 = Technician
4 = Protective Service
5 = Para-Professionals
6 = Office and Clerical
7 = Skilled Craft
8 = 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 = Operators (Semi-skilled)
72 = Trainee
80 = Laborers (Unskilled)
82 = Trainee
90 = Service Workers
92 = Trainee
JBC-LAST-CMT-SEQ Numeric 4 PA09.1
Last Comment Sequence number used for the last job
Sequence Number code description line.
JBC-ACTIVE-FLAG Alpha 1 HR06.1
Status Indicates if the job code is active or
inactive.
A = Active
I = Inactive
JBC-ANNUAL-HOURS Numeric 4 HR06.1
Annual Hours Contains the number of hours per year
defined for the job code.
JBC-JOB-CLASS Alpha 3 AC530 HR06.1
Job Class Contains the job class. Used for
reporting purposes and wage analysis.
JBC-SCHEDULE Alpha 9 HCOP.2 HR06.1
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 HCOP.2 HR06.1
Grade Contains the grade of a grade range
schedule associated with this job code.
JBC-EEO-SUB-CODE Numeric 3 HR06.1 PA311
EEO Sub Code Contains an extension of the EEO
category field.
JBC-EVAL-DATE Numeric 8 (yyyymmdd) HR06.1
Evaluation Date Indicates the last date the job code
was evaluated.
JBC-EXEMPT Alpha 1 HR06.1
Exempt Indicates if the job is exempt from
overtime
N = No
Y = Yes
JBC-EFFECT-DATE Numeric 8 (yyyymmdd) HR06.1 HR06.2
Effective Date Indicates the effective date of the job
code salary range.
JBC-DESC-DATE Numeric 8 (yyyymmdd) PA09.1
Job Description Date Contains the date the job code
description was last updated.
JBC-WC-CLASS Alpha 4 HR06.1
Workers Comp Class Contains the workers' compensation
classification to which the job code is
assigned.
JBC-PAY-RATE Signed 13.4 HR06.1
Rate Contains the pay rate defined for the
job code.
JBC-EXP-DIST-CO Numeric 4 HR06.1
Exp Dist Co Contains the general ledger expense
distribution company.
JBC-EXP-ACCT-UNIT Alpha 15 HR06.1
Expense Accounting Contains the general ledger expense
Unit accounting unit.
JBC-EXP-ACCOUNT Numeric 6 HR06.1
Expense Account Contains the general ledger expense
account.
JBC-EXP-SUB-ACCT Numeric 4 HR06.1
Expense Subaccount Contains the expense subaccount from
the general ledger chart of accounts.
JBC-PROCESS-LEVEL Alpha 5 PA09.1
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
JBC-DEPARTMENT Alpha 5 PA09.1
Department Contains the department in which the
job code is valid.
JBC-REPORTS-TO Numeric 9 PA09.1
Reports To Contains the employee number of the
person who supervises the employees
working in the job.
JBC-APPROVED-BY Numeric 9 PA09.1
Approved By Contains the employee number of the
individual who approved this job.
JBC-TIPPED Alpha 1 HR06.1
Tipped Indicates if this is a tippable
position.
C = Tipped Position - Tax Credit
N = Not A Tipped Position
T = Tipped Position - No Tax
JBC-OBJ-ID Numeric 12 HR06.1
Object Contains a system-assigned identifier
Identification that provides access to data in related
files.
JBC-EEO-CAT-1 Derived
Eeo Cat 1
JBC-MARKET-SALARY Signed 13.4 HR06.1
Market Salary Contains the market salary for the job
code.
JBC-MARKET-DATE Numeric 8 (yyyymmdd) HR06.1
Market Date Contains the date of the market salary.
JBC-CURRENCY-CODE Alpha 5 HR06.1 HR06.2
Currency Code Contains the currency in which the pay HR700
is recorded.
JBC-CURR-ND Numeric 1 HR06.1 HR06.2
Currency Number of Represents the number of decimals HR700
Decimals defined for the currency of the object.
JBC-BASE-PAY-RATE Signed 13.4 HR06.1 HR700
Base Pay Rate Contains the pay in company's base
currency.
JBC-BASE-CURRENCY Alpha 5 HR06.1 HR06.2
Base Currency Contains the company's base currency. HR700
JBC-BASE-ND Numeric 1 HR06.1 HR06.2
Base Number Of The number of decimal positions defined HR700
Decimals for the company base currency.
JBC-BASE-BEG-SAL Signed 13.4 HR06.1 HR06.2
Base Beg Sal Contains the minimum pay in the HR700
company's base currency.
JBC-BASE-MID-SAL Signed 13.4 HR06.1 HR06.2
Base Mid Sal Contains the midpoint pay in the HR700
company's base currency.
JBC-BASE-END-SAL Signed 13.4 HR06.1 HR06.2
Base End Sal Contains the maximum pay in the HR700
company's base currency.
JBC-BASE-MARKET Signed 13.4 HR06.1 HR700
Base Market Contains the market salary in the
company's base currency.
JBC-EFFECTIVE-DATE Numeric 8 (yyyymmdd) HR06.1
Effective Date Contains the date the job code takes
effect. This is the date the job code
will be logged to history.
JBC-WEB-TYPE Alpha 3 HR06.1
Web Type 1 = Physician
2 = Nurse
JOBCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
JBCSET1 COMPANY AC530 AC731
JOB-CODE BN100 BN101
BN102 BN103
BN105 BN145
BN150 BN232
BN242 BN245
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN350 BN45.1
BN531 BN65.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HCEM.1 HCOP.1
...
JBCSET2 COMPANY KeyChange HCJC.1 HR05.1
JOB-CLASS
JOB-CODE
JBCSET3 OBJ-ID KeyChange HR700
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
Grade PRSAGDTL Required
When JBC-PAY-GRADE != Spaces
JBC-COMPANY -> SGD-COMPANY
JBC-SCHEDULE -> SGD-SCHEDULE
JBC-PAY-GRADE -> SGD-PAY-GRADE
Zeroes -> SGD-PAY-STEP
Zeroes -> SGD-EFFECT-DATE
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
Schedule PRSAGHEAD Required
When JBC-SCHEDULE != Spaces
JBC-COMPANY -> SGH-COMPANY
"P" -> SGH-INDICATOR
JBC-SCHEDULE -> SGH-SCHEDULE
Zeroes -> SGH-EFFECT-DATE
Wc Class WCCLASS Required
When JBC-WC-CLASS != Spaces
JBC-COMPANY -> WCC-COMPANY
JBC-WC-CLASS -> WCC-WC-CLASS
Spaces -> WCC-WC-STATE
Spaces -> WCC-PROCESS-LEVEL
Zeroes -> WCC-EFFECT-DATE
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
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
Job Relations JOBRELATE Delete Restricted
JBC-COMPANY -> JBR-COMPANY
JBC-JOB-CODE -> JBR-JOB-CODE
JBR-POSITION
JBR-TYPE
JBR-PERS-CODE
JBR-SUBJECT-CODE
|