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

BN100     BN101     BN102     BN103     BN105     BN145
BN150     BN230     BN231     BN232     BN234     BN238
BN240     BN242     BN245     BN246     BN320     BN335
HCCP.1    HCDL.1    HAP3.1    HDPT.1    HEP4.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    HR70.1    HRS1.1    HRSC.1    HS11.1    PA02.1
PA06.1    PA09.1    PA100     PA102     PA103     PA11.1
PA113     PA13.1    PA13.2    PA149     PA16.1    PA170
PA171     PA172     PA20.1    PA202     PA206     PA208
PA21.1    PA210     PA211     PA212     PA213     PA214
PA215     PA216     PA217     PA218     PA219     PA22.1
PA220     PA221     PA222     PA223     PA224     PA225
PA227     PA24.1    PA242     PA248     PA249     PA259
PA27.1    PA271     PA272     PA290     PA292     PA294
PA302     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    PA42.3
PA495     PA502     PA513     PA52.1    PA52.2    PA52.3
PA52.4    PA52.5    PA520     PA53.1    PA532     PA534
PA535     PA54.1    PA570     PA59.1    PA590     PA66.2
PA66.3    PA71.1    PA73.1    PA80.1    PA80.2    PA82.1
PA90.1    PA92.2    PA93.4    PA94.1    TR21.1    TR22.1
TR222     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     PR141     PR142
PR160     PR180     PR204     PR212     PR214     PR223
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    PR35.9    PR36.1    PR37.1    PR38.1    PR39.2
PR45.1    PR529     PR530     PR560     PR82.1    PR82.2
PRSC.1    UK102     UK141     UK183     UK184     UK201
UK277     TA147     TA170     TA175     TA260     TA265
TA290     TM240     TM245     TM250     TM255     TM260
TM265     TM470     TM570     TM70.1    TM71.1    TP00.3
TP00.4    TP10.1    TP100     TP115     TP120     TP125
TP130     TP135     TP140     TP20.1    TP20.2    TP20.3
TP200     TP210     TP220     TP230     TP231     TP30.1
TP30.2    TP40.1    TP40.2    HRLRD     PA341     HS01.1
HS34.1    TM52.1

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

DPT-PROCESS-LEVEL      Alpha 5                                   HR02.1
Element: Process Lev HrContains 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   HR02.1
Element: Name          Contains the name or description of the   PA218   PA242
                       department.                               PA71.1  PA80.1
                                                                 PA80.2  PR131
                                                                 PR142   TP135
                                                                 TP140

DPT-DEP-DIST-CO        Numeric 4                                 HR02.1  PA52.5
Element: Company       Contains the department's payroll
                       distribution company.

DPT-DEP-ACCT-UNIT      Alpha 15                                  HR02.1  PA52.5
Element: Accounting UniContains the department's payroll
                       expense accounting unit.

DPT-DEP-ACCOUNT        Numeric 6                                 HR02.1  PA52.5
Element: Account       Contains the department's payroll
                       expense account number.

DPT-DEP-SUB-ACCT       Numeric 4                                 HR02.1  PA52.5
Element: Subaccount    Contains the department's payroll
                       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
Element: Status        The Active flag of the credit card
                       type.
                       A = Active
                       I = Inactive

DPT-USER-ID            Alpha 10  (Lower Case)                    HR02.1
Element: User          Contains the user ID of the person who
                       last changed this record.

DPT-DATE-STAMP         Numeric 8  (yyyymmdd)                     HR02.1
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
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                                                BN100   BN101
          PROCESS-LEVEL                                          BN102   BN103
          DEPARTMENT                                             BN105   BN145
                                                                 BN150   BN230
                                                                 BN231   BN232
                                                                 BN234   BN238
                                                                 BN240   BN242
                                                                 BN245   BN246
                                                                 BN320   BN335
                                                                 HCCP.1  HCDL.1
                                                                 HAP3.1  HDPT.1
                                                                 HEP4.1  HPOS.1
                                                                 HPQC.1  HPRS.1
                                                                 HR00.1  HR01.1
                                                                 HR02.1  HR11.1
                                                                 ...

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

                         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

Paencumber     PAENCUMBER   Delete Restricted

                            DPT-COMPANY          -> PEN-COMPANY
                            Spaces               -> PEN-POSITION
                            DPT-PROCESS-LEVEL    -> PEN-PROCESS-LEVEL
                            DPT-DEPARTMENT       -> PEN-DEPARTMENT
                                                    PEN-JOB-CODE
                                                    PEN-EMPLOYEE
                                                    PEN-GLT-OBJ-ID
                                                    PEN-ATN-OBJ-ID

Position       PAPOSITION   Delete Cascades

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