EMPSUMM – Employee Year-To-Date Tip Pay

System
Payroll (PR)
Prefix
ESM
Primary key
COMPANY, PROCESS-LEVEL, DEPARTMENT, SHIFT, EMPLOYEE, PAYROLL-YEAR, LST-CALC-DATE
Fields
19
Updated by
0 programs
Referenced by
0 programs

EMPSUMM is the Employee Year-To-Date Tip Pay table in Lawson Payroll (prefix ESM). It is indexed by COMPANY, PROCESS-LEVEL, DEPARTMENT, SHIFT, EMPLOYEE, PAYROLL-YEAR, LST-CALC-DATE (ESMSET1); alternate indexes: ESMSET2 and ESMSET3. It is related 1:1 to PRSYSTEM, DEPTCODE, EMPLOYEE and TPPARAM and 1:M to TIPPAY. The table has 19 fields, 3 indexes and 8 documented relations.

About EMPSUMM

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.

Fields (19)

Column = COBOL field name without the ESM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#ESM-COMPANY PK
COMPANY		Numeric 4——
#ESM-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5Contains the process level.—
#ESM-DEPARTMENT PK
DEPARTMENT		Alpha 5Contains the department.—
#ESM-SHIFT PK
SHIFT		Numeric 1Contains the shift number associated with the pay.—
#ESM-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number . The employee number is used to correlate all of the information related to that person.—
#ESM-PAYROLL-YEAR PK
PAYROLL_YEAR		Numeric 4Contains the payroll year in which the allocation was taken.—
#ESM-LST-CALC-DATE PK
LST_CALC_DATE		Numeric 8 (yyyymmdd)Contains the last calculation date. The system date defaults when the allocation summary is created.—
#ESM-STATUS
STATUS		Numeric 1This field displays the status of the transaction.—
#ESM-HM-PROC-LEV
HM_PROC_LEV		Alpha 5Contains the process level in which the tips were reported.—
#ESM-HM-DEPT
HM_DEPT		Alpha 5Contains the department in which the tips were reported.—
#ESM-ALLOC-METHOD
ALLOC_METHOD		Alpha 1Contains the value that determines if the allocation method used is based on G (Individual Gross Receipts) or H (Hours Worked).—
#ESM-YTD-RCPT
YTD_RCPT		Signed 13.2Contains the year-to-date receipts.—
#ESM-YTD-HOURS
YTD_HOURS		Signed 13.2Contains the year-to-date hours.—
#ESM-YTD-RPT-TIPS
YTD_RPT_TIPS		Signed 13.2Contains the year-to-date reported tips.—
#ESM-YTD-SHORTFALL
YTD_SHORTFALL		Signed 13.2Contains the year-to-date tips shortfall.—
#ESM-YTD-SF-ALLOC
YTD_SF_ALLOC		Signed 13.2Contains the year-to-date shortfall allocation.—
#ESM-YTD-IND-TIPS
YTD_IND_TIPS		Signed 13.2Contains the year-to-date indirect tips.—
#ESM-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).—
#ESM-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.—

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ESMSET1
  1. COMPANY
  2. PROCESS-LEVEL
  3. DEPARTMENT
  4. SHIFT
  5. EMPLOYEE
  6. PAYROLL-YEAR
  7. LST-CALC-DATE
Primary—
ESMSET2
  1. COMPANY
  2. EMPLOYEE
  3. LST-CALC-DATE
  4. PROCESS-LEVEL
  5. DEPARTMENT
  6. SHIFT
—
ESMSET3
  1. COMPANY
  2. PAYROLL-YEAR
  3. EMPLOYEE
  4. PROCESS-LEVEL
  5. DEPARTMENT
  6. SHIFT
PR297, PR299

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMDEPTCODEEMPLOYEETPPARAMTIPPAYEMPSUMM

One to one (7) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
ESM-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
DepartmentDEPTCODERequiredWhen ESM-DEPARTMENT != Spaces
ESM-COMPANY→DPT-COMPANY
ESM-PROCESS-LEVEL→DPT-PROCESS-LEVEL
ESM-DEPARTMENT→DPT-DEPARTMENT
EmployeeEMPLOYEERequired
ESM-COMPANY→EMP-COMPANY
ESM-EMPLOYEE→EMP-EMPLOYEE
Hm DepartmentDEPTCODERequiredWhen ESM-HM-DEPT != Spaces
ESM-COMPANY→DPT-COMPANY
ESM-HM-PROC-LEV→DPT-PROCESS-LEVEL
ESM-HM-DEPT→DPT-DEPARTMENT
Hm Proc LevPRSYSTEMRequiredWhen ESM-HM-PROC-LEV != Spaces
ESM-COMPANY→PRS-COMPANY
ESM-HM-PROC-LEV→PRS-PROCESS-LEVEL
Process LevelPRSYSTEMRequired
ESM-COMPANY→PRS-COMPANY
ESM-PROCESS-LEVEL→PRS-PROCESS-LEVEL
TpparamTPPARAMRequired
ESM-COMPANY→TPP-COMPANY
ESM-PROCESS-LEVEL→TPP-PROCESS-LEVEL
ESM-DEPARTMENT→TPP-DEPARTMENT
ESM-SHIFT→TPP-SHIFT

One to many (1) — child tables

RelationTableRulesConditionField map
Tip PayTIPPAYDelete 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

Programs

No Lawson programs are documented as updating or referencing this table.