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.
UPDATED BY

PR297

PR299

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
ESM-COMPANY Element: Company Hr	Numeric 4
ESM-PROCESS-LEVEL Element: Process Lev Hr	Alpha 5 Contains the process level.
ESM-DEPARTMENT Element: Department	Alpha 5 Contains the department.
ESM-SHIFT Element: Shift	Numeric 1 Contains the shift number associated with the pay.
ESM-EMPLOYEE Element: 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 Element: Payroll Year	Numeric 4 Contains the payroll year in which the allocation was taken.
ESM-LST-CALC-DATE Element: Lst Calc Date	Numeric 8 (yyyymmdd) Contains the last calculation date. The system date defaults when the allocation summary is created.
ESM-STATUS Element: Status	Numeric 1 This field displays the status of the transaction.
ESM-HM-PROC-LEV Element: Process Lev Hr	Alpha 5 Contains the process level in which the tips were reported.
ESM-HM-DEPT Element: Department	Alpha 5 Contains the department in which the tips were reported.
ESM-ALLOC-METHOD Element: 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 Element: Ytd Rcpt	Signed 13.2 Contains the year-to-date receipts.
ESM-YTD-HOURS Element: Ytd Hours	Signed 13.2 Contains the year-to-date hours.
ESM-YTD-RPT-TIPS Element: Ytd Rpt Tips	Signed 13.2 Contains the year-to-date reported tips.
ESM-YTD-SHORTFALL Element: Ytd Shortfall	Signed 13.2 Contains the year-to-date tips shortfall.
ESM-YTD-SF-ALLOC Element: Ytd Sf Alloc	Signed 13.2 Contains the year-to-date shortfall allocation.
ESM-YTD-IND-TIPS Element: Ytd Ind Tips	Signed 13.2 Contains the year-to-date indirect tips.
ESM-CURRENCY-CODE Element: Currency Code	Alpha 5 This field contains the company base currency code established in Company (GL10.1 ).
ESM-CURR-ND Element: Acct Nd	Numeric 1 The number of decimals assigned to a particular account as determined by the account currency.

EMPSUMM FILE INDEX

EMPSUMM FILE RELATIONS

ONE TO ONE RELATIONS

EMPSUMM FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.