Lawson Insight Technical Documentation

                            DEPTSEGBLK FILE

                        Department Segment Block

REFERENCED BY

BN150     HR202     PR128     PR130     PR131     PR132
PR134     PR136     PR29.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    PR45.1    PR529     PR530
PR560     PR82.1    UK102     TA147     TP135

UPDATED BY

HR02.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DSG-COMPANY            Numeric 4                                 HR02.1
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

DSG-PROCESS-LEVEL      Alpha 5                                   HR02.1
Element: Process Lev HrThis field contains the process level,
                       which is the reporting hierarchy below
                       company.

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

DSG-SEGMENT-BLOCK      Alpha 103                                 HR02.1
Element: User Analysis This field identifies the user analysis
                       values included in the transaction.

                       You can either type up to four values
                       or use Define (F6) to open the User
                       Analysis Entry subform. Use this subform
                       to select the user analysis values you
                       want to include in the transaction. If
                       you choose to type values, use commas to
                       separate them. For example:
                       value1,value2,value3,value4

                       There are three conditions that affect
                       how you can select user analysis values.
                       See the User Analysis Entry form help or
                       the Strategic Ledger procedures manual
                       for additional information.

                         DEPTSEGBLK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DSGSET1   COMPANY                                                BN150   HR02.1
          PROCESS-LEVEL                                          HR202   PR128
          DEPARTMENT                                             PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR29.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
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR82.1  UK102
                                                                 TA147   TP135

                         DEPTSEGBLK FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Department     DEPTCODE     Required

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