TIPPAY FILE
Employee Tip Pay
Contains the reported tip income and hours worked to generate the tip income.
UPDATED BY
BN150 ET530 ETI2.1 LP130 PR128 PR130
PR131 PR132 PR134 PR136 PR189 PR195
PR197 PR29.1 PR32.2 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR35.9 PR36.1 PR45.1 PR529 PR530 PR560
PR80.1 PR82.1 PR85.1 UK102 UK560 TA147
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TIP-COMPANY Numeric 4 ET530 PR195
Element: Company Hr PR197 PR82.1
PR85.1
TIP-CHECK-TYPE Alpha 1 ET530 PR195
Element: Check Type Contains the payment type. PR197 PR82.1
PR85.1
TIP-EMPLOYEE Numeric 9 ET530 PR195
Element: Employee Employee number is assigned to each PR197 PR82.1
person employed by the firm. It is used PR85.1
to correlate all of the information
related to that person.
TIP-RECORD-DATE Numeric 8 (yyyymmdd) ET530 PR195
Element: Record Date Contains the time record date. PR197 PR82.1
PR85.1
TIP-TIP-PROC-LEV Alpha 5 ET530 PR195
Element: Process Lev HrContains the process level. PR197 PR82.1
PR85.1
TIP-TIP-DEPART Alpha 5 ET530 PR195
Element: Department Contains the department. PR197 PR82.1
PR85.1
TIP-SHIFT Numeric 1 ET530 PR195
Element: Shift Contains the shift number associated PR197 PR82.1
with the pay. PR85.1
TIP-PAY-SUM-GRP Alpha 3 ET530 PR195
Element: Pay Sum Grp Contains the pay summary group from the PR197 PR82.1
time record. PR85.1
TIP-SEQ-NBR Numeric 4 ET530 PR195
Element: Seq Nbr Contains the automatically assigned PR197 PR82.1
sequence number from the time record. PR85.1
TIP-TIP-PAY-TYPE Numeric 1 ET530 PR195
Element: Tip Pay Type Contains the value that indicates if PR197 PR82.1
the pay is from direct or indirect tips PR85.1
as indicated on the pay summary group
record.
TIP-HM-PROC-LEV Alpha 5 ET530 PR195
Element: Process Lev HrContains the employee's home process PR197 PR82.1
level. PR85.1
TIP-HM-DEPT Alpha 5 ET530 PR195
Element: Department Contains the employee's home department. PR197 PR82.1
PR85.1
TIP-RPT-TIPS-AMT Signed 9.2 ET530 PR195
Element: Rpt Tips Amt Contains the reportable tip payment PR197 PR82.1
amount. PR85.1
TIP-HOURS Signed 7.2 ET530 PR195
Element: Hours Contains the hours associated with this PR197 PR82.1
record. PR85.1
TIP-CHECK-NBR Numeric 8 ET530 PR195
Element: Check Nbr Contains the payment number. PR197 PR82.1
PR85.1
TIP-CHECK-DATE Numeric 8 (yyyymmdd) ET530 PR195
Element: Check Date Contains the payment date. PR197 PR82.1
PR85.1
TIP-STATUS Numeric 1 ET530 PR195
Element: Status Contains the record status. PR197 PR82.1
PR85.1
TIP-JOB-CODE Alpha 9 ET530 PR195
Element: Job Code Contains a user-defined code that PR197 PR82.1
represents a type of job. PR85.1
TIP-TIP-CRED-AMT Signed 9.2 PR85.1
Element: Tip Cred Amt Contains the tip credit amount
calculated on TP135 (Tip Calculation).
TIP-WRK-END-DATE Numeric 8 (yyyymmdd) ET530 PR195
Element: Wrk End Date Contains the work period end date which PR197 PR82.1
is determined by the employee's pay plan PR85.1
and the time record date.
TIP-PAY-END-DATE Numeric 8 (yyyymmdd) ET530 PR195
Element: Pay End Date Contains the pay period end date which PR197 PR82.1
is determined by the employee's pay plan PR85.1
and the time record date.
TIP-WORK-STATE Alpha 2 ET530 PR195
Element: Work State Identifies the state in which the PR197 PR82.1
workers' compensation plan is affective. PR85.1
TIP-CURRENCY-CODE Alpha 5 ET530 PR195
Element: Currency Code This field contains the company base PR197 PR82.1
currency code established in Company PR85.1
(GL10.1 ).
TIP-CURR-ND Numeric 1 ET530 PR195
Element: Acct Nd The number of decimals assigned to a PR197 PR82.1
particular account as determined by the PR85.1
account currency.
TIPPAY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TIPSET1 COMPANY
EMPLOYEE
RECORD-DATE
TIP-PROC-LEV
TIP-DEPART
SHIFT
PAY-SUM-GRP
CHECK-TYPE
SEQ-NBR
TIPSET2 COMPANY KeyChange
TIP-PROC-LEV
TIP-DEPART
SHIFT
RECORD-DATE
EMPLOYEE
PAY-SUM-GRP
CHECK-TYPE
SEQ-NBR
TIPSET3 COMPANY KeyChange BN150 ET530
TIP-PROC-LEV ETI2.1 LP130
TIP-DEPART PR128 PR130
SHIFT PR131 PR132
EMPLOYEE PR134 PR136
WRK-END-DATE PR189 PR195
SEQ-NBR PR197 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
...
TIPSET4 COMPANY KeyChange PR85.1
CHECK-TYPE
EMPLOYEE
CHECK-NBR
SEQ-NBR
TIPPAY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TIP-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
TIP-COMPANY -> EMP-COMPANY
TIP-EMPLOYEE -> EMP-EMPLOYEE
Hm Department DEPTCODE Required
When TIP-HM-DEPT != Spaces
TIP-COMPANY -> DPT-COMPANY
TIP-HM-PROC-LEV -> DPT-PROCESS-LEVEL
TIP-HM-DEPT -> DPT-DEPARTMENT
Hm Proc Lev PRSYSTEM Required
TIP-COMPANY -> PRS-COMPANY
TIP-HM-PROC-LEV -> PRS-PROCESS-LEVEL
Pay Sum Group PAYSUMGRP Required
TIP-COMPANY -> PSG-COMPANY
TIP-PAY-SUM-GRP -> PSG-PAY-SUM-GRP
Tip Department DEPTCODE Required
When TIP-TIP-DEPART != Spaces
TIP-COMPANY -> DPT-COMPANY
TIP-TIP-PROC-LEV -> DPT-PROCESS-LEVEL
TIP-TIP-DEPART -> DPT-DEPARTMENT
Tip Proc Lev PRSYSTEM Required
TIP-COMPANY -> PRS-COMPANY
TIP-TIP-PROC-LEV -> PRS-PROCESS-LEVEL
Tpparam TPPARAM Required
TIP-COMPANY -> TPP-COMPANY
TIP-TIP-PROC-LEV -> TPP-PROCESS-LEVEL
TIP-TIP-DEPART -> TPP-DEPARTMENT
TIP-SHIFT -> TPP-SHIFT
|
