|
|
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
TP220 TP40.2 TP40.3 TP40.5 PR297 PR298
PR299 TP210
UPDATED BY
TP100 TP105
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ESM-COMPANY Numeric 4 TP100
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
ESM-PROCESS-LEVEL Alpha 5 TP100
Element: Process Lev HrContains the process level.
ESM-DEPARTMENT Alpha 5 TP100
Element: Department Contains the department.
ESM-SHIFT Numeric 1 TP100
Element: Shift Contains the shift number associated
with the pay.
ESM-EMPLOYEE Numeric 9 TP100
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 TP100
Element: Current PayrolContains the payroll year in which the
allocation was taken.
ESM-LST-CALC-DATE Numeric 8 (yyyymmdd) TP100
Element: Lst Calc Date Contains the last calculation date. The
system date defaults when the allocation
summary is created.
ESM-STATUS Numeric 1 TP100
Element: Status This field displays the status of the
transaction.
ESM-HM-PROC-LEV Alpha 5 TP100
Element: Process Lev HrContains the process level in which the
tips were reported.
ESM-HM-DEPT Alpha 5 TP100
Element: Department Contains the department in which the
tips were reported.
ESM-ALLOC-METHOD Alpha 1 TP100
Element: Allocation MetContains 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 TP100
Year-to-date Contains the year-to-date receipts.
Receipts
ESM-YTD-HOURS Signed 13.2 TP100
Element: Year-to-date HContains the year-to-date hours.
ESM-YTD-RPT-TIPS Signed 13.2 TP100
Year-to-date Contains the year-to-date reported tips.
Reported Tips
ESM-YTD-SHORTFALL Signed 13.2 TP100
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 TP100
Element: Ytd Ind Tips Contains the year-to-date indirect tips.
ESM-CURRENCY-CODE Alpha 5 TP100
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
ESM-CURR-ND Numeric 1 TP100
Account Currency Represents the number of decimals
Code defined for the currency of the object.
EMPSUMM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ESMSET1 COMPANY TP100 TP105
PROCESS-LEVEL TP220 TP40.2
DEPARTMENT
SHIFT
EMPLOYEE
PAYROLL-YEAR
LST-CALC-DATE
ESMSET2 COMPANY TP40.3 TP40.5
EMPLOYEE
LST-CALC-DATE
PROCESS-LEVEL
DEPARTMENT
SHIFT
ESMSET3 COMPANY PR297 PR298
PAYROLL-YEAR PR299 TP210
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
Alc Summ ALCSUMM Required
ESM-COMPANY -> ASM-COMPANY (ASMSET1)
ESM-PROCESS-LEVEL -> ASM-PROCESS-LEVEL
ESM-DEPARTMENT -> ASM-DEPARTMENT
ESM-SHIFT -> ASM-SHIFT
ESM-PAYROLL-YEAR -> ASM-PAYROLL-YEAR
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
Ye Alloc YEALLOC Required
ESM-COMPANY -> YEA-COMPANY
ESM-PAYROLL-YEAR -> YEA-PAYROLL-YEAR
ESM-EMPLOYEE -> YEA-EMPLOYEE
ESM-HM-PROC-LEV -> YEA-HM-PROC-LEV
ESM-HM-DEPT -> YEA-HM-DEPT
EMPSUMM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Alc Gross ALCGROSS Delete Restricted
ESM-COMPANY -> AGR-COMPANY
TPP-ALLOC-METHOD -> AGR-ALLOC-METHOD
ESM-PROCESS-LEVEL -> AGR-PROCESS-LEVEL
ESM-DEPARTMENT -> AGR-DEPARTMENT
ESM-SHIFT -> AGR-SHIFT
AGR-RECORD-DATE
Emp Gross EMPGROSS Delete Restricted
ESM-COMPANY -> EGR-COMPANY
ESM-EMPLOYEE -> EGR-EMPLOYEE
EGR-RECORD-DATE
EGR-PROCESS-LEVEL
EGR-DEPARTMENT
EGR-SHIFT
Tip Control TIPCTL Delete Restricted
ESM-COMPANY -> TPC-COMPANY
ESM-PROCESS-LEVEL -> TPC-PROCESS-LEVEL
ESM-DEPARTMENT -> TPC-DEPARTMENT
ESM-SHIFT -> TPC-SHIFT
TPC-RECORD-DATE
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
|
