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    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    HR14.1
HR15.1    HR155     HR170     HR206     HR211     HR217
HR220     HR511     HR514     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
PA08.1    PA08.2    PA08.3    PA11.1    PA111     PA120
PA149     PA16.1    PA170     PA171     PA172     PA19.1
PA202     PA208     PA211     PA219     PA23.1    PA231
PA233     PA241     PA242     PA248     PA249     PA259
PA262     PA263     PA272     PA290     PA295     PA296
PA31.1    PA311     PA33.1    PA341     PA345     PA360
PA37.1    PA370     PA371     PA372     PA390     PA391
PA393     PA402     PA41.1    PA42.1    PA48.3    PA48.4
PA502     PA513     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     TR120     TR121     TR20.1
TR20.2    TR20.3    TR22.1    TR500     HS01.1    HS34.1
HS35.1    HS36.1    PR03.1    PR128     PR13.1    PR13.5
PR13.6    PR13.8    PR131     PR132     PR134     PR136
PR195     PR20.4    PR20.7    PR220     PR23.1    PR23.3
PR24.1    PR278     PR282     PR295     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     PR530
PR82.1    PR82.2    PR89.1    PRAN.1    PRWC.1    UK102
TA175     TA195     TA199     TM240     TM245     TM470
UK120     UK60.1    UK70.1    HCJC.1    HR05.1

UPDATED BY

AC721     PA09.1    HR00.1    HR01.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

JBC-DESCRIPTION      Alpha 30  (Lower Case)                      AC721   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                                     AC721
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                                 AC721
Minimum              Contains the beginning salary range
                     used for EEO reporting and wage
                     analysis.

JBC-MID-SAL-RANGE    Signed 13.4                                 AC721
Midpoint             Middle salary range used for EEO
                     reporting and wage analysis.

JBC-END-SAL-RANGE    Signed 13.4                                 AC721
Maximum              Ending salary range used for EEO
                     reporting and wage analysis.

JBC-POINTS           Signed 7.2                                  AC721
Points               Contains the points associated with the
                     job code.

JBC-EEO-CAT          Alpha 2                                     AC721   HCOP.2
EEO Category         Contains the EEO category associated        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                                   AC721   PA09.1
Last Comment         Sequence number used for the last job
Sequence Number      code description line.

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

JBC-ANNUAL-HOURS     Numeric 4                                   AC721
Annual Hours         Contains the number of hours per year
                     defined for the job code.

JBC-JOB-CLASS        Alpha 3                                     AC530   AC721
Job Class            Contains the job class. Used for
                     reporting purposes and wage analysis.

JBC-SCHEDULE         Alpha 9                                     AC721   HCOP.2
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                                     AC721   HCOP.2
Grade                Contains the grade of a grade range
                     schedule associated with this job code.

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

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

JBC-EXEMPT           Alpha 1                                     AC721
Exempt               Indicates if the job is exempt from
                     overtime
                     N = No
                     Y = Yes

JBC-EFFECT-DATE      Numeric 8  (yyyymmdd)                       AC721
Effective Date       Indicates the effective date of the job
                     code salary range.

JBC-DESC-DATE        Numeric 8  (yyyymmdd)                       AC721   PA09.1
Job Description Date Contains the date the job code
                     description was last updated.

JBC-WC-CLASS         Alpha 4                                     AC721
Workers Comp Class   Contains the workers' compensation
                     classification to which the job code is
                     assigned.

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

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

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

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

JBC-EXP-ACCOUNT      Numeric 6                                   AC721
Expense Account      Contains the general ledger expense
                     account.

JBC-EXP-SUB-ACCT     Numeric 4                                   AC721
Expense Subaccount   Contains the expense subaccount from
                     the general ledger chart of accounts.

JBC-PROCESS-LEVEL    Alpha 5                                     AC721   PA09.1
Process Level        This field contains the process level,
                     which is the reporting hierarchy below
                     company.

JBC-DEPARTMENT       Alpha 5                                     AC721   PA09.1
Department           Contains the department in which the
                     job code is valid.

JBC-REPORTS-TO       Numeric 9                                   AC721   PA09.1
Reports To           Contains the employee number of the
                     person who supervises the employees
                     working in the job.

JBC-APPROVED-BY      Numeric 9                                   AC721   PA09.1
Approved By          Contains the employee number of the
                     individual who approved this job.

JBC-TIPPED           Alpha 1                                     AC721
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                                  AC721
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                                 AC721
Market Salary        Contains the market salary for the job
                     code.

JBC-MARKET-DATE      Numeric 8  (yyyymmdd)                       AC721
Market Date          Contains the date of the market salary.

JBC-CURRENCY-CODE    Alpha 5                                     AC721
Currency Code        Contains the currency in which the pay
                     is recorded.

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

JBC-BASE-PAY-RATE    Signed 13.4                                 AC721
Base Pay Rate        Contains the pay in company's base
                     currency.

JBC-BASE-CURRENCY    Alpha 5                                     AC721
Base Currency        Contains the company's base currency.

JBC-BASE-ND          Numeric 1                                   AC721
Base Number Of       The number of decimal positions defined
Decimals             for the company base currency.

JBC-BASE-BEG-SAL     Signed 13.4                                 AC721
Base Beg Sal         Contains the minimum pay in the
                     company's base currency.

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

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

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

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

JBC-WEB-TYPE         Alpha 3                                     AC721
Web Type             1 = Physician
                     2 = Nurse

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

JBC-GENDER-CLASS     Alpha 1
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
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
                                                                 AC721   BN100
                                                                 BN101   BN102
                                                                 BN103   BN105
                                                                 BN145   BN150
                                                                 BN232   BN242
                                                                 BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 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