Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PREMPWKPAT


                            PREMPWKPAT FILE

REFERENCED BY

TM260     TM265     UK87.1

UPDATED BY

HR125     UK34.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WKE-COMPANY            Numeric 4                                 UK34.1
Element: Company Hr

WKE-EMPLOYEE           Numeric 9                                 UK34.1
Element: Employee      Contains the employee number. Each
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

WKE-PATTERN-CODE       Alpha 3                                   UK34.1
Element: Pattern Code

WKE-PATT-EFF-FROM      Numeric 8  (yyyymmdd)                     UK34.1
Element: Patt Eff From

WKE-WEEK-NBR           Numeric 2                                 UK34.1
Element: Week Nbr

WKE-EFF-DATE-TO        Numeric 8  (yyyymmdd)                     UK34.1
Element: Eff Date To

WKE-SUN-DETL           Signed 4.2                                UK34.1
Element: Sun Detl

WKE-MON-DETL           Signed 4.2                                UK34.1
Element: Mon Detl

WKE-TUE-DETL           Signed 4.2                                UK34.1
Element: Tue Detl

WKE-WED-DETL           Signed 4.2                                UK34.1
Element: Wed Detl

WKE-THU-DETL           Signed 4.2                                UK34.1
Element: Thu Detl

WKE-FRI-DETL           Signed 4.2                                UK34.1
Element: Fri Detl

WKE-SAT-DETL           Signed 4.2                                UK34.1
Element: Sat Detl

                         PREMPWKPAT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WKESET1   COMPANY                                                HR125   PA115
          EMPLOYEE                                               UK34.1  TM260
          PATT-EFF-FROM                                          TM265

WKESET3   PATTERN-CODE  KeyChange                                UK87.1
          WEEK-NBR
          COMPANY
          EMPLOYEE
          PATT-EFF-FROM

                         PREMPWKPAT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       EMPLOYEE     Required

                            WKE-COMPANY         -> EMP-COMPANY
                            WKE-EMPLOYEE        -> EMP-EMPLOYEE

Prwkpat        PRWKPAT      Required

                            WKE-PATTERN-CODE    -> WKP-PATTERN-CODE

Prwkpatdtl     PRWKPATDTL   Required

                            WKE-PATTERN-CODE    -> WKD-PATTERN-CODE
                            WKE-WEEK-NBR        -> WKD-WEEK-NBR