Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

DEPTCODE


                             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     BN230     BN231     BN232
BN238     BN240     BN242     BN245     BN246     BN320
BN335     HCCP.1    HCOP.1    HCOP.2    FC202     HDPT.1
HGLM.1    HPOS.1    HPQC.1    HPRS.1    HR11.1    HR11.2
HR12.1    HR14.1    HR15.1    HR155     HR170     HR202
HR211     HR213     HR217     HR220     HR511     HR514
HR515     HR54.1    HR55.2    HR650     HR70.1    HRS1.1
HRSC.1    ZR651     HS11.1    PA02.1    PA06.1    PA09.1
PA100     PA102     PA11.1    PA113     PA13.1    PA13.2
PA149     PA16.1    PA170     PA171     PA172     PA20.1
PA202     PA206     PA208     PA21.1    PA211     PA212
PA213     PA214     PA215     PA216     PA217     PA218
PA219     PA22.1    PA220     PA221     PA222     PA224
PA225     PA227     PA24.1    PA242     PA248     PA249
PA259     PA27.1    PA271     PA272     PA290     PA294
PA300     PA302     PA305     PA310     PA311     PA315
PA320     PA325     PA330     PA335     PA34.1    PA340
PA345     PA35.1    PA350     PA355     PA36.1    PA360
PA370     PA371     PA372     PA38.1    PA391     PA402
PA42.1    PA490     PA502     PA513     PA52.1    PA52.2
PA52.3    PA52.4    PA52.5    PA520     PA53.1    PA532
PA54.1    PA570     PA59.1    PA590     PA66.2    PA66.3
PA71.1    PA73.1    PA80.1    PA80.2    PA90.1    PA93.4
PA94.1    TR207     TR21.1    TR22.1    TR26.1    TR500
HS20.1    HS21.1    HS36.1    PR03.1    PR04.1    PR110
PR113     PR120     PR128     PR13.1    PR13.5    PR13.6
PR13.8    PR130     PR131     PR132     PR134     PR136
PR137     PR139     PR140     PR141     PR142     PR160
PR180     PR189     PR195     PR204     PR212     PR214
PR226     PR229     PR23.1    PR23.3    PR247     PR260
PR270     PR275     PR276     PR277     PR29.1    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
PR529     PR530     PR560     PR80.1    PR80.2    PR82.1
PR82.2    PRSC.1    UK102     UK13.1    UK141     UK183
UK184     UK201     UK277     UK560     TA147     TA170
TA175     TA260     TA265     TA290     TM240     TM245
TM250     TM255     TM260     TM265     TM470     TM570
TM70.1    TM71.1    UK120     UK60.1    UK70.1    FCLRD
HRLRD     PA341     HS01.1    HS34.1    TM52.1

UPDATED BY

HR02.1    HR702     HR00.1    HR01.1    PBIP.1    PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

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

DPT-DEP-DIST-CO        Numeric 4                                 HR02.1
Element: 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
Element: Department AccContains 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
Element: Sec Lvl       Contains the default security level for
                       the department.

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

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

DPT-ACTIVE-FLAG        Alpha 1                                   HR02.1  HR702
Element: Status        The Active flag of the credit card
                       type.
                       A = Active
                       I = Inactive

DPT-USER-ID            Alpha 10  (Lower Case)                    HR02.1  HR702
Element: User

DPT-DATE-STAMP         Numeric 8  (yyyymmdd)                     HR02.1  HR702
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

DPT-TIME-STAMP         Numeric 6  (hhmmss)                       HR02.1  HR702
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

                         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   BN230
                                                                 BN231   BN232
                                                                 BN238   BN240
                                                                 BN242   BN245
                                                                 BN246   BN320
                                                                 BN335   HCCP.1
                                                                 HCOP.1  HCOP.2
                                                                 FC202   HDPT.1
                                                                 HGLM.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR00.1  HR01.1
                                                                 ...

DPTSET2   COMPANY                                                BN231   BN232
          DEPARTMENT                                             BN238   BN246
          PROCESS-LEVEL                                          FC202   HR11.1
                                                                 HR11.2  HR211
                                                                 HR213   HR511
                                                                 HR650   ZR651
                                                                 PA02.1  PA100
                                                                 PA102   PA13.1
                                                                 PA13.2  PA171
                                                                 PA172   PA202
                                                                 PA211   PA212
                                                                 PA214   PA215
                                                                 PA216   PA217
                                                                 PA218   PA219
                                                                 PA220   PA221
                                                                 ...

                         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