Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             DEPTCODE FILE

                               Department

Contains information about user-defined department codes. Departments are the
lowest level for expensing and reporting in the Lawson Payroll system. HR02.1
(Department) is the primary program that updates this file. Departments are
optional.

REFERENCED BY

AC541     AC542     BN100     BN101     BN102     BN103
BN105     BN145     BN150     BN231     BN232     BN238
BN240     BN245     BN246     BN335     HCCP.1    HCOP.1
HCOP.2    HDPT.1    HR12.1    HR14.1    HR15.1    HR155
HR170     HR202     HR211     HR213     HR217     HR220
HR511     HR514     HR54.1    HR55.2    HR650     HR70.1
HRS1.1    HRSC.1    HS11.1    PA06.1    PA09.1    PA11.1
PA149     PA16.1    PA170     PA171     PA172     PA202
PA206     PA208     PA211     PA212     PA213     PA214
PA215     PA216     PA217     PA218     PA219     PA220
PA221     PA222     PA224     PA225     PA242     PA248
PA249     PA259     PA271     PA272     PA290     PA294
PA300     PA302     PA305     PA310     PA311     PA315
PA320     PA325     PA330     PA335     PA340     PA345
PA350     PA355     PA360     PA370     PA371     PA372
PA391     PA402     PA42.1    PA490     PA502     PA513
PA53.1    PA532     PA54.1    PA59.1    PA590     PA66.2
PA66.3    PA71.1    PA73.1    PA80.1    PA80.2    PA90.1
PA93.4    PA94.1    TR22.1    TR500     HS20.1    HS21.1
HS36.1    PR03.1    PR04.1    PR128     PR13.1    PR13.5
PR13.6    PR13.8    PR131     PR132     PR134     PR136
PR137     PR139     PR141     PR142     PR195     PR204
PR212     PR214     PR226     PR229     PR23.1    PR23.3
PR247     PR260     PR270     PR275     PR276     PR277
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    PR38.1    PR39.2
PR45.1    PR530     PR560     PR82.1    PR82.2    UK102
TA170     TA175     TA260     TA265     TA290     TM240
TM245     TM250     TM255     TM470     TM52.1    TM70.1
TM71.1    UK120     UK60.1    UK70.1    PA341     HS01.1
HS34.1

UPDATED BY

HR02.1    HR00.1    HR01.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

DPT-COMPANY          Numeric 4                                   HR02.1
Company              Contains the number that represents an
                     established company and is entered on
                     all functions.

DPT-PROCESS-LEVEL    Alpha 5                                     HR02.1
Process Level        Contains the process level to which
                     this department belongs.

DPT-DEPARTMENT       Alpha 5                                     HR02.1
Department           Contains the department.

DPT-NAME             Alpha 30  (Lower Case)                      BN245   HR02.1
Name                 Contains the name or description of the     PA218   PA242
                     department.                                 PA71.1  PA73.1
                                                                 PA80.1  PA80.2
                                                                 PR131   PR142

DPT-DEP-DIST-CO      Numeric 4                                   HR02.1
Dep Dist Co          Contains the department's payroll
                     distribution company.

DPT-DEP-ACCT-UNIT    Alpha 15                                    HR02.1
Department Account   Contains the department's payroll
Unit                 expense accounting unit.

DPT-DEP-ACCOUNT      Numeric 6                                   HR02.1
Department Account   Contains the department's payroll
                     expense account number.

DPT-DEP-SUB-ACCT     Numeric 4                                   HR02.1
Department           Contains the department's payroll
Subaccount           expense subaccount number.

DPT-SEC-LVL          Numeric 1                                   HR02.1
Sec Lvl              Contains the default security level for
                     the department.

DPT-SEC-LOCATION     Alpha 10                                    HR02.1
Sec Location         Contains the default security location
                     for the department.

DPT-SEGMENT-FLAG     Alpha 1                                     HR02.1
Segment Flag         Identifies the user analysis
                     values included on payroll expense
                     transactions.

                         DEPTCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DPTSET1   COMPANY                                                AC541   AC542
          PROCESS-LEVEL                                          BN100   BN101
          DEPARTMENT                                             BN102   BN103
                                                                 BN105   BN145
                                                                 BN150   BN231
                                                                 BN232   BN238
                                                                 BN240   BN245
                                                                 BN246   BN335
                                                                 HCCP.1  HCOP.1
                                                                 HCOP.2  HDPT.1
                                                                 HR00.1  HR01.1
                                                                 HR02.1  HR12.1
                                                                 HR14.1  HR15.1
                                                                 HR155   HR170
                                                                 HR202   HR211
                                                                 ...

DPTSET2   COMPANY                                                BN231   BN232
          DEPARTMENT                                             BN238   BN246
          PROCESS-LEVEL                                          HR211   HR213
                                                                 HR511   HR650
                                                                 PA171   PA172
                                                                 PA202   PA211
                                                                 PA212   PA214
                                                                 PA215   PA216
                                                                 PA217   PA218
                                                                 PA219   PA220
                                                                 PA221   PA222
                                                                 PA224   PA225
                                                                 PA259   PA271
                                                                 PA272   PA290
                                                                 PA300   PA305
                                                                 ...

                         DEPTCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            DPT-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Deptsegblk     DEPTSEGBLK   Not Required

                            DPT-COMPANY          -> DSG-COMPANY
                            DPT-PROCESS-LEVEL    -> DSG-PROCESS-LEVEL
                            DPT-DEPARTMENT       -> DSG-DEPARTMENT

Expense Acct   GLMASTER     Required

                            DPT-DEP-DIST-CO      -> GLM-COMPANY
                            DPT-DEP-ACCT-UNIT    -> GLM-ACCT-UNIT
                            DPT-DEP-ACCOUNT      -> GLM-ACCOUNT
                            DPT-DEP-SUB-ACCT     -> GLM-SUB-ACCOUNT

Process Level  PRSYSTEM     Required

                            DPT-COMPANY          -> PRS-COMPANY
                            DPT-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

                         DEPTCODE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Assn Resource  PAASSIGNED   Delete Cascades

                            DPT-COMPANY          -> PAA-COMPANY
                            DPT-PROCESS-LEVEL    -> PAA-PROCESS-LEVEL
                            DPT-DEPARTMENT       -> PAA-DEPARTMENT
                                                    PAA-JOB-CODE
                                                    PAA-POSITION

Budget         PABUDGET     Delete Cascades

                            DPT-COMPANY          -> PAB-COMPANY
                            DPT-PROCESS-LEVEL    -> PAB-PROCESS-LEVEL
                            DPT-DEPARTMENT       -> PAB-DEPARTMENT
                                                    PAB-JOB-CODE
                                                    PAB-EFFECT-DATE
                                                    PAB-POSITION

Employee       EMPLOYEE     Delete Restricted

                            DPT-COMPANY          -> EMP-COMPANY
                            DPT-PROCESS-LEVEL    -> EMP-PROCESS-LEVEL
                            DPT-DEPARTMENT       -> EMP-DEPARTMENT
                                                    EMP-EMPLOYEE

Position       PAPOSITION   Delete Cascades

                            DPT-COMPANY          -> POS-COMPANY
                            DPT-PROCESS-LEVEL    -> POS-PROCESS-LEVEL
                            DPT-DEPARTMENT       -> POS-DEPARTMENT
                                                    POS-POSITION
                                                    POS-EFFECT-DATE