Lawson Insight Technical Documentation

                             SIDEPTDTL FILE

REFERENCED BY

HR11.1    HR11.2    HR511     HR650     PA02.1    PA100
PA102     PA13.1    PA13.2    PA502     PA513     PA52.1
PA52.3    PA52.4    PA52.5    PR110     PR113     PR120
PR13.1    PR13.5    PR13.6    PR13.8

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SDD-COMPANY            Numeric 4
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

SDD-PROCESS-LEVEL      Alpha 5
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

SDD-DEPARTMENT         Alpha 5
Element: Department    Contains the department.

SDD-INTG-FLAG          Alpha 1
Element: Intg Flag

                         SIDEPTDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SDDSET1   COMPANY                                                HR11.1  HR11.2
          PROCESS-LEVEL                                          HR511   HR650
          DEPARTMENT                                             PA02.1  PA100
                                                                 PA102   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

                         SIDEPTDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sidepthd       SIDEPTHD     Required

                            SDD-COMPANY          -> SDH-COMPANY

                         SIDEPTDTL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       EMPLOYEE

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