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 | 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. |
|
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 PAYROLL-YEAR EMPLOYEE PROCESS-LEVEL DEPARTMENT SHIFT |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| |||||||||||||||
Department | DEPTCODE |
Required
| |||||||||||||||
Employee | EMPLOYEE |
Required
| |||||||||||||||
Hm Department | DEPTCODE |
Required
| |||||||||||||||
Hm Proc Lev | PRSYSTEM |
Required
| |||||||||||||||
Process Level | PRSYSTEM |
Required
| |||||||||||||||
Tpparam | TPPARAM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Tip Pay | TIPPAY |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.