Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

EMPSUMM


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

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

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

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

ESM-EMPLOYEE           Numeric 9
Element: 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
Element: Current PayrolContains the payroll year in which the
                       allocation was taken.

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

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

ESM-HM-PROC-LEV        Alpha 5
Element: Home Process LContains the process level in which the
                       tips were reported.

ESM-HM-DEPT            Alpha 5
Element: Home DepartmenContains the department in which the
                       tips were reported.

ESM-ALLOC-METHOD       Alpha 1
Element: Allocation MetContains 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
Element: Year-to-date HContains 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
Element: Ytd Ind Tips  Contains the year-to-date indirect tips.

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

ESM-CURR-ND            Numeric 1
Account Currency
Code

                         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