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.

Field / column	Type	Description & values	Updated by
`ESM-COMPANY` PK COMPANY	Numeric 4	—	—
`ESM-PROCESS-LEVEL` PK PROCESS_LEVEL	Alpha 5	Contains the process level.	—
`ESM-DEPARTMENT` PK DEPARTMENT	Alpha 5	Contains the department.	—
`ESM-SHIFT` PK SHIFT	Numeric 1	Contains the shift number associated with the pay.	—
`ESM-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains 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 4	Contains 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 1	This field displays the status of the transaction.	—
`ESM-HM-PROC-LEV` HM_PROC_LEV	Alpha 5	Contains the process level in which the tips were reported.	—
`ESM-HM-DEPT` HM_DEPT	Alpha 5	Contains the department in which the tips were reported.	—
`ESM-ALLOC-METHOD` ALLOC_METHOD	Alpha 1	Contains 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.2	Contains the year-to-date receipts.	—
`ESM-YTD-HOURS` YTD_HOURS	Signed 13.2	Contains the year-to-date hours.	—
`ESM-YTD-RPT-TIPS` YTD_RPT_TIPS	Signed 13.2	Contains the year-to-date reported tips.	—
`ESM-YTD-SHORTFALL` YTD_SHORTFALL	Signed 13.2	Contains the year-to-date tips shortfall.	—
`ESM-YTD-SF-ALLOC` YTD_SF_ALLOC	Signed 13.2	Contains the year-to-date shortfall allocation.	—
`ESM-YTD-IND-TIPS` YTD_IND_TIPS	Signed 13.2	Contains the year-to-date indirect tips.	—
`ESM-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	—
`ESM-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	—

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`ESMSET1`	`COMPANY`, `PROCESS-LEVEL`, `DEPARTMENT`, `SHIFT`, `EMPLOYEE`, `PAYROLL-YEAR`, `LST-CALC-DATE`	Primary	—
`ESMSET2`	`COMPANY`, `EMPLOYEE`, `LST-CALC-DATE`, `PROCESS-LEVEL`, `DEPARTMENT`, `SHIFT`		—
`ESMSET3`	`COMPANY`, `PAYROLL-YEAR`, `EMPLOYEE`, `PROCESS-LEVEL`, `DEPARTMENT`, `SHIFT`		PR297, PR299

Relations

One to one (7) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required		`ESM-COMPANY` → `PRS-COMPANY`, `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`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
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`

Programs

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