Lawson Insight Technical Documentation

                              PRWKPAT FILE

REFERENCED BY

UK34.1    TM260     TM265

UPDATED BY

UK87.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WKP-PATTERN-CODE       Alpha 3                                   UK87.1
Element: Pattern Code

WKP-PATTERN-DESC       Alpha 20                                  UK87.1
Element: Pattern Desc

WKP-WEEKS-IN-PATT      Numeric 3                                 UK87.1
Element: Weeks In Patt

                         PRWKPAT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WKPSET1   PATTERN-CODE                                           UK34.1  UK87.1
                                                                 TM260   TM265

                         PRWKPAT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Prempwkpat     PREMPWKPAT   Delete Cascades

                            WKP-PATTERN-CODE    -> WKE-PATTERN-CODE
                                                   WKE-WEEK-NBR
                                                   WKE-COMPANY
                                                   WKE-EMPLOYEE
                                                   WKE-PATT-EFF-FROM

Prwkpatdtl     PRWKPATDTL   Delete Cascades

                            WKP-PATTERN-CODE    -> WKD-PATTERN-CODE
                                                   WKD-WEEK-NBR