Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

JOBCODE


                              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     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    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
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     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     PA534     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    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     PR160     PR180     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     PR82.1    PR82.2
PRAN.1    PRSC.1    PRWC.1    UK102     TA146     TA147
TA175     TA195     TA199     TM240     TM245     TM470
TP01.1    TP135     TP140     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
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.        HS12.1  PA219
                                                                 PA242   PA311
                                                                 PA33.1  PA371
                                                                 PA71.1  PR131
                                                                 TP135

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 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                                 PA09.1
Last Comment           Sequence number used for the last job
Sequence Number        code description line.

JBC-ACTIVE-FLAG        Alpha 1                                   HR06.1  HR506
Element: Status        Indicates if the job code is active or
                       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: Evaluation DatIndicates 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: Effective DateIndicates the effective date of the job   HR506
                       code salary range.

JBC-DESC-DATE          Numeric 8  (yyyymmdd)                     PA09.1
Element: Job DescriptioContains 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: Accounting UniContains 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 HrThis field contains the process level,
                       which is the reporting hierarchy below
                       company.

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
Object                 Contains a system-assigned identifier
Identification         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
Account Currency       Represents the number of decimals         HR506
Code                   defined for the currency of the object.

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
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
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   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  HCDL.1
                                                                 HCEM.1  HCHP.1
                                                                 ...

JBCSET2   COMPANY       KeyChange                                HCJC.1  HR05.1
          JOB-CLASS                                              PA210
          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

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