Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              EMPSUMM FILE

                     Employee Year-To-Date Tip Pay

This file contains the year-to-date shortfall, shortfall allocations,
reported tips and gross receipts totals for each employee for every allocation
level where the employee worked. You can print the information in this file in
a report using TP100 (Shortfall Allocation Calculation) and TP220 (Shortfall
Allocation Report). TP100 creates this file.

REFERENCED BY

PR297     PR298     PR299

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


ESM-PROCESS-LEVEL    Alpha 5
Process Level        Contains the process level.

ESM-DEPARTMENT       Alpha 5
Department           Contains the department.

ESM-SHIFT            Numeric 1
Shift                Contains the shift number associated
                     with the pay.

ESM-EMPLOYEE         Numeric 9
Employee             Contains the employee number . The
                     employee number is used to correlate all
                     of the information related to that
                     person.

ESM-PAYROLL-YEAR     Numeric 4
Current Payroll Year Contains the payroll year in which the
                     allocation was taken.


ESM-LST-CALC-DATE    Numeric 8  (yyyymmdd)
Lst Calc Date        Contains the last calculation date. The
                     system date defaults when the allocation
                     summary is created.

ESM-STATUS           Numeric 1
Status               This field displays the status of the
                     transaction.


ESM-HM-PROC-LEV      Alpha 5
Home Process Level   Contains the process level in which the
                     tips were reported.

ESM-HM-DEPT          Alpha 5
Home Department      Contains the department in which the
                     tips were reported.

ESM-ALLOC-METHOD     Alpha 1
Allocation Method    Contains the value that determines if
                     the allocation method used is based on G
                     (Individual Gross Receipts) or H (Hours
                     Worked).

ESM-YTD-RCPT         Signed 13.2
Year-to-date         Contains the year-to-date receipts.
Receipts

ESM-YTD-HOURS        Signed 13.2
Year-to-date Hours   Contains the year-to-date hours.

ESM-YTD-RPT-TIPS     Signed 13.2
Year-to-date         Contains the year-to-date reported tips.
Reported Tips

ESM-YTD-SHORTFALL    Signed 13.2
Year-to-date Tips    Contains the year-to-date tips
Shortfall            shortfall.

ESM-YTD-SF-ALLOC     Signed 13.2
Year-to-date         Contains the year-to-date shortfall
Shortfall Alloc      allocation.

ESM-YTD-IND-TIPS     Signed 13.2
Ytd Ind Tips         Contains the year-to-date indirect tips.

ESM-CURRENCY-CODE    Alpha 5
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).


ESM-CURR-ND          Numeric 1
Currency Number of   Represents the number of decimals
Decimals             defined for the currency of the object.

                         EMPSUMM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ESMSET1   COMPANY
          PROCESS-LEVEL
          DEPARTMENT
          SHIFT
          EMPLOYEE
          PAYROLL-YEAR
          LST-CALC-DATE

ESMSET2   COMPANY
          EMPLOYEE
          LST-CALC-DATE
          PROCESS-LEVEL
          DEPARTMENT
          SHIFT

ESMSET3   COMPANY                                                PR297   PR298
          PAYROLL-YEAR                                           PR299
          EMPLOYEE
          PROCESS-LEVEL
          DEPARTMENT
          SHIFT

ESMSET4   COMPANY       KeyChange
          EMPLOYEE
          HM-PROC-LEV
          HM-DEPT
          PAYROLL-YEAR
          PROCESS-LEVEL
          DEPARTMENT

                         EMPSUMM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            ESM-COMPANY          -> PRS-COMPANY  (PRSSET1)
                            Spaces               -> PRS-PROCESS-LEVEL

Department     DEPTCODE     Required
                            When ESM-DEPARTMENT != Spaces

                            ESM-COMPANY          -> DPT-COMPANY
                            ESM-PROCESS-LEVEL    -> DPT-PROCESS-LEVEL
                            ESM-DEPARTMENT       -> DPT-DEPARTMENT

Employee       EMPLOYEE     Required

                            ESM-COMPANY          -> EMP-COMPANY
                            ESM-EMPLOYEE         -> EMP-EMPLOYEE

Hm Department  DEPTCODE     Required
                            When ESM-HM-DEPT != Spaces

                            ESM-COMPANY          -> DPT-COMPANY
                            ESM-HM-PROC-LEV      -> DPT-PROCESS-LEVEL
                            ESM-HM-DEPT          -> DPT-DEPARTMENT

Hm Proc Lev    PRSYSTEM     Required
                            When ESM-HM-PROC-LEV != Spaces

                            ESM-COMPANY          -> PRS-COMPANY
                            ESM-HM-PROC-LEV      -> PRS-PROCESS-LEVEL

Process Level  PRSYSTEM     Required

                            ESM-COMPANY          -> PRS-COMPANY
                            ESM-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

Tpparam        TPPARAM      Required

                            ESM-COMPANY          -> TPP-COMPANY
                            ESM-PROCESS-LEVEL    -> TPP-PROCESS-LEVEL
                            ESM-DEPARTMENT       -> TPP-DEPARTMENT
                            ESM-SHIFT            -> TPP-SHIFT

                         EMPSUMM FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Tip Pay        TIPPAY       Delete Restricted

                            ESM-COMPANY          -> TIP-COMPANY
                            ESM-PROCESS-LEVEL    -> TIP-TIP-PROC-LEV
                            ESM-DEPARTMENT       -> TIP-TIP-DEPART
                            ESM-SHIFT            -> TIP-SHIFT
                            ESM-EMPLOYEE         -> TIP-EMPLOYEE
                                                    TIP-WRK-END-DATE
                                                    TIP-SEQ-NBR