TIPPAY FILE
Employee Tip Pay
Contains the reported tip income and hours worked to generate the tip income.
UPDATED BY
BN150 PR128 PR131 PR132 PR134 PR136
PR137 PR140 PR150 PR195 PR199 PR32.1
PR32.2 PR33.1 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR36.1
PR37.1 PR45.1 PR530 PR80.1 PR82.1 PR85.1
UK102 UK330 UK120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TIP-COMPANY Numeric 4 PR150 PR195
Company The company number represents an PR199 PR82.1
established company and is entered on PR85.1
all function codes.
TIP-CHECK-TYPE Alpha 1 PR150 PR195
Payment Type Contains the payment type. PR199 PR82.1
PR85.1
TIP-EMPLOYEE Numeric 9 PR150 PR195
Employee Employee number is assigned to each PR199 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) PR150 PR195
Record Date Contains the time record date. PR199 PR82.1
PR85.1
TIP-TIP-PROC-LEV Alpha 5 PR150 PR195
Tip Process Level Contains the process level. PR199 PR82.1
PR85.1
TIP-TIP-DEPART Alpha 5 PR150 PR195
Tip Department Contains the department. PR199 PR82.1
PR85.1
TIP-SHIFT Numeric 1 PR150 PR195
Shift Contains the shift number associated PR199 PR82.1
with the pay. PR85.1
TIP-PAY-SUM-GRP Alpha 3 PR150 PR195
Payment Summary Contains the pay summary group from the PR199 PR82.1
Group time record. PR85.1
TIP-SEQ-NBR Numeric 4 PR150 PR195
Sequence Number Contains the automatically assigned PR199 PR82.1
sequence number from the time record. PR85.1
TIP-TIP-PAY-TYPE Numeric 1 PR150 PR195
Tip Pay Type Contains the value that indicates if PR199 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 PR150 PR195
Home Process Level Contains the employee's home process PR199 PR82.1
level. PR85.1
TIP-HM-DEPT Alpha 5 PR150 PR195
Home Department Contains the employee's home department. PR199 PR82.1
PR85.1
TIP-RPT-TIPS-AMT Signed 9.2 PR150 PR195
Rpt Tips Amt Contains the reportable tip payment PR199 PR82.1
amount. PR85.1
TIP-HOURS Signed 7.2 PR150 PR195
Hours Contains the hours associated with this PR199 PR82.1
record. PR85.1
TIP-CHECK-NBR Numeric 8 PR150 PR195
Payment Number Contains the payment number. PR199 PR82.1
PR85.1
TIP-CHECK-DATE Numeric 8 (yyyymmdd) PR150 PR195
Payment Date Contains the payment date. PR199 PR82.1
PR85.1
TIP-STATUS Numeric 1 PR150 PR195
Status Contains the record status. PR199 PR82.1
PR85.1
TIP-JOB-CODE Alpha 9 PR150 PR195
Job Code Contains a user-defined code that PR199 PR82.1
represents a type of job. PR85.1
TIP-TIP-CRED-AMT Signed 9.2 PR85.1
Tip Cred Amt Contains the tip credit amount
calculated on TP135 (Tip Calculation).
TIP-WRK-END-DATE Numeric 8 (yyyymmdd) PR150 PR195
Wrk End Date Contains the work period end date which PR199 PR82.1
is determined by the employee's pay PR85.1
plan and the time record date.
TIP-PAY-END-DATE Numeric 8 (yyyymmdd) PR150 PR195
Pay End Date Contains the pay period end date which PR199 PR82.1
is determined by the employee's pay PR85.1
plan and the time record date.
TIP-WORK-STATE Alpha 2 PR150 PR195
Work State Identifies the state in which the PR199 PR82.1
workers' compensation plan is affective. PR85.1
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 PR128
TIP-PROC-LEV PR131 PR132
TIP-DEPART PR134 PR136
SHIFT PR137 PR140
EMPLOYEE PR150 PR195
WRK-END-DATE PR199 PR32.1
SEQ-NBR PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
...
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
|