Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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     AC541     AC542     AC550     AC551     AC62.1
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     HR217     HR220     HR511     HR514
HR515     HR521     HR54.1    HR55.2    HR650     HR70.1
HRCL.1    HRS1.1    HRSC.1    HS10.1    HS10.2    HS11.1
HS12.1    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     PA11.1    PA111
PA113     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     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
PA48.3    PA48.4    PA490     PA496     PA502     PA513
PA52.1    PA52.3    PA52.4    PA52.5    PA520     PA531
PA532     PA533     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    PA90.1
TR114     TR120     TR121     TR20.1    TR20.2    TR20.3
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     PR189     PR195
PR198     PR20.4    PR20.7    PR220     PR23.1    PR23.3
PR24.1    PR240     PR241     PR242     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    PR36.1    PR418     PR45.1    PR529
PR530     PR560     PR80.1    PR82.1    PR82.2    PR89.1
PRAN.1    PRSC.1    PRWC.1    UK102     TA146     TA147
TA175     TA195     TA199     TM240     TM245     TM470
UK120     UK60.1    UK70.1    HRLRD     HCJC.1    HR05.1

UPDATED BY

HR06.1    HR06.2    HR506     PA09.1    HR00.1    HR01.1
PBIP.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

JBC-COMPANY          Numeric 4                                   HR06.1  HR06.2
Company              The number that represents an               HR506
                     established company and is entered on
                     all functions.

JBC-JOB-CODE         Alpha 9                                     HR06.1  HR06.2
Code                 Contains the user-defined job code.         HR506   PA64.2
                                                                 PA65.2

JBC-DESCRIPTION      Alpha 30  (Lower Case)                      HR06.1  HR506
Description          Contains the job code description.          HS12.1  PA219
                                                                 PA242   PA311
                                                                 PA33.1  PA371
                                                                 PA64.2  PA65.2
                                                                 PA71.1  PA73.1
                                                                 PR131

JBC-RATE-OVERRIDE    Alpha 1                                     HR06.1  HR506
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         HR506
                     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            HR506
                     reporting and wage analysis.

JBC-END-SAL-RANGE    Signed 13.4                                 HR06.1  HR06.2
Maximum              Ending salary range used for EEO            HR506
                     reporting and wage analysis.

JBC-POINTS           Signed 7.2                                  HR06.1  HR506
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        HR506   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
Last Comment         Sequence number used for the last job
Sequence Number      code description line.

JBC-ACTIVE-FLAG      Alpha 1                                     HR06.1  HR506
Status               Indicates if the job code is active or
                     inactive.
                     A = Active
                     I = Inactive

JBC-ANNUAL-HOURS     Numeric 4                                   HR06.1  HR506
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            HR506
                     reporting purposes and wage analysis.

JBC-SCHEDULE         Alpha 9                                     HCOP.2  HR06.1
Schedule             Contains the grade range schedule           HR506
                     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         HR506
                     schedule associated with this job code.

JBC-EEO-SUB-CODE     Numeric 3                                   HR06.1  HR506
EEO Sub Code         Contains an extension of the EEO            PA311
                     category field.

JBC-EVAL-DATE        Numeric 8  (yyyymmdd)                       HR06.1  HR506
Evaluation Date      Indicates the last date the job code
                     was evaluated.

JBC-EXEMPT           Alpha 1                                     HR06.1  HR506
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     HR506
                     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  HR506
Workers Comp Class   Contains the workers' compensation
                     classification to which the job code is
                     assigned.

JBC-CA-WC-CLASS      Alpha 10                                    HR06.1  HR506
Ca Wc Class          Contains the Canadian Workers
                     Compensation classification to which the
                     job is assigned.

JBC-PAY-RATE         Signed 13.4                                 HR06.1  HR506
Rate                 Contains the pay rate defined for the
                     job code.

JBC-EXP-DIST-CO      Numeric 4                                   HR06.1  HR506
Exp Dist Co          Contains the general ledger expense
                     distribution company.

JBC-EXP-ACCT-UNIT    Alpha 15                                    HR06.1  HR506
Expense Accounting   Contains the general ledger expense
Unit                 accounting unit.

JBC-EXP-ACCOUNT      Numeric 6                                   HR06.1  HR506
Expense Account      Contains the general ledger expense
                     account.

JBC-EXP-SUB-ACCT     Numeric 4                                   HR06.1  HR506
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  HR506
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
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  HR506
Market Salary        Contains the market salary for the job
                     code.

JBC-MARKET-DATE      Numeric 8  (yyyymmdd)                       HR06.1  HR506
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      HR506
                     is recorded.

JBC-CURR-ND          Numeric 1                                   HR06.1  HR06.2
Currency Number of   Represents the number of decimals           HR506
Decimals             defined for the currency of the object.

JBC-BASE-PAY-RATE    Signed 13.4                                 HR06.1  HR506
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.       HR506

JBC-BASE-ND          Numeric 1                                   HR06.1  HR06.2
Base Number Of       The number of decimal positions defined     HR506
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             HR506
                     company's base currency.

JBC-BASE-MID-SAL     Signed 13.4                                 HR06.1  HR06.2
Base Mid Sal         Contains the midpoint pay in the            HR506
                     company's base currency.

JBC-BASE-END-SAL     Signed 13.4                                 HR06.1  HR06.2
Base End Sal         Contains the maximum pay in the             HR506
                     company's base currency.

JBC-BASE-MARKET      Signed 13.4                                 HR06.1  HR506
Base Market          Contains the market salary in the
                     company's base currency.

JBC-EFFECTIVE-DATE   Numeric 8  (yyyymmdd)                       HR06.1  HR506
Effective Date       Contains 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
Salary Class         Contains the salary class.                  HR506
                     H = Hourly
                     S = Salary

JBC-WEB-TYPE         Alpha 3                                     HR06.1  HR506
Web Type             1 = Physician
                     2 = Nurse

JBC-NOC              Alpha 10                                    HR06.1  HR506
Noc                  Contains the National Occupation Code
                     (NOC).

JBC-GENDER-CLASS     Alpha 1                                     HR06.1  HR506
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
Dir Ind Job          1 = Direct
                     2 = Indirect

JBC-OCCUP-GROUP      Alpha 2                                     HR06.1  HR506
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

                         JOBCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

JBCSET1   COMPANY                                                AC530   AC541
          JOB-CODE                                               AC542   AC550
                                                                 AC551   AC62.1
                                                                 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
                                                                 ...

JBCSET2   COMPANY       KeyChange                                HCJC.1  HR05.1
          JOB-CLASS
          JOB-CODE

JBCSET3   OBJ-ID        KeyChange

                         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

Noc            PCODES       Required

                            "NC"                 -> PCO-TYPE
                            JBC-NOC              -> PCO-CODE

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

                         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 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

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