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