EMPSUMM FILE
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 PR298
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ESM-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
ESM-PROCESS-LEVEL Alpha 5
Process Level Contains the process level.
ESM-DEPARTMENT Alpha 5
Department Contains the department.
ESM-SHIFT Numeric 1
Shift Contains the shift number associated
with the pay.
ESM-EMPLOYEE Numeric 9
Employee Contains the employee number . The
employee number is used to correlate all
of the information related to that
person.
ESM-PAYROLL-YEAR Numeric 4
Current Payroll Year Contains the payroll year in which the
allocation was taken.
ESM-LST-CALC-DATE Numeric 8 (yyyymmdd)
Lst Calc Date Contains the last calculation date. The
system date defaults when the allocation
summary is created.
ESM-STATUS Numeric 1
Status This field displays the status of the
transaction.
ESM-HM-PROC-LEV Alpha 5
Home Process Level Contains the process level in which the
tips were reported.
ESM-HM-DEPT Alpha 5
Home Department Contains the department in which the
tips were reported.
ESM-ALLOC-METHOD Alpha 1
Allocation Method Contains the value that determines if
the allocation method used is based on G
(Individual Gross Receipts) or H (Hours
Worked).
ESM-YTD-RCPT Signed 13.2
Year-to-date Contains the year-to-date receipts.
Receipts
ESM-YTD-HOURS Signed 13.2
Year-to-date Hours Contains the year-to-date hours.
ESM-YTD-RPT-TIPS Signed 13.2
Year-to-date Contains the year-to-date reported tips.
Reported Tips
ESM-YTD-SHORTFALL Signed 13.2
Year-to-date Tips Contains the year-to-date tips
Shortfall shortfall.
ESM-YTD-SF-ALLOC Signed 13.2
Year-to-date Contains the year-to-date shortfall
Shortfall Alloc allocation.
ESM-YTD-IND-TIPS Signed 13.2
Ytd Ind Tips Contains the year-to-date indirect tips.
ESM-CURRENCY-CODE Alpha 5
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
ESM-CURR-ND Numeric 1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
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 PR297 PR298
PAYROLL-YEAR
EMPLOYEE
PROCESS-LEVEL
DEPARTMENT
SHIFT
ESMSET4 COMPANY KeyChange
EMPLOYEE
HM-PROC-LEV
HM-DEPT
PAYROLL-YEAR
PROCESS-LEVEL
DEPARTMENT
EMPSUMM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
ESM-COMPANY -> PRS-COMPANY (PRSSET1)
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 RELATED
NAME 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
|
