EMPSUMM

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

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
PR297 PR299


EMPSUMM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


EMPSUMM FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Wed Jun 08 20:51:09 2016

Home
Contact Us



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