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
Company              The company number represents an
                     established company and is entered on
                     all function codes.


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


SDD-DEPARTMENT       Alpha 5
Department           Contains the department.

SDD-INTG-FLAG        Alpha 1
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