TIPPAY FILE
Employee Tip Pay
Contains the reported tip income and hours worked to generate the tip income.
UPDATED BY
AC541 AC542 BN150 PR128 PR131 PR132
PR134 PR136 PR195 PR197 PR32.2 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR36.1 PR45.1 PR530 PR82.1
PR85.1 UK102 UK120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TIP-COMPANY Numeric 4 PR195 PR197
Company The company number represents an PR82.1 PR85.1
established company and is entered on
all function codes.
TIP-CHECK-TYPE Alpha 1 PR195 PR197
Payment Type Contains the payment type. PR82.1 PR85.1
TIP-EMPLOYEE Numeric 9 PR195 PR197
Employee Employee number is assigned to each PR82.1 PR85.1
person employed by the firm. It is used
to correlate all of the information
related to that person.
TIP-RECORD-DATE Numeric 8 (yyyymmdd) PR195 PR197
Record Date Contains the time record date. PR82.1 PR85.1
TIP-TIP-PROC-LEV Alpha 5 PR195 PR197
Tip Process Level Contains the process level. PR82.1 PR85.1
TIP-TIP-DEPART Alpha 5 PR195 PR197
Tip Department Contains the department. PR82.1 PR85.1
TIP-SHIFT Numeric 1 PR195 PR197
Shift Contains the shift number associated PR82.1 PR85.1
with the pay.
TIP-PAY-SUM-GRP Alpha 3 PR195 PR197
Payment Summary Contains the pay summary group from the PR82.1 PR85.1
Group time record.
TIP-SEQ-NBR Numeric 4 PR195 PR197
Sequence Number Contains the automatically assigned PR82.1 PR85.1
sequence number from the time record.
TIP-TIP-PAY-TYPE Numeric 1 PR195 PR197
Tip Pay Type Contains the value that indicates if PR82.1 PR85.1
the pay is from direct or indirect tips
as indicated on the pay summary group
record.
TIP-HM-PROC-LEV Alpha 5 PR195 PR197
Home Process Level Contains the employee's home process PR82.1 PR85.1
level.
TIP-HM-DEPT Alpha 5 PR195 PR197
Home Department Contains the employee's home department. PR82.1 PR85.1
TIP-RPT-TIPS-AMT Signed 9.2 PR195 PR197
Rpt Tips Amt Contains the reportable tip payment PR82.1 PR85.1
amount.
TIP-HOURS Signed 7.2 PR195 PR197
Hours Contains the hours associated with this PR82.1 PR85.1
record.
TIP-CHECK-NBR Numeric 8 PR195 PR197
Payment Number Contains the payment number. PR82.1 PR85.1
TIP-CHECK-DATE Numeric 8 (yyyymmdd) PR195 PR197
Payment Date Contains the payment date. PR82.1 PR85.1
TIP-STATUS Numeric 1 PR195 PR197
Status Contains the record status. PR82.1 PR85.1
TIP-JOB-CODE Alpha 9 PR195 PR197
Job Code Contains a user-defined code that PR82.1 PR85.1
represents a type of job.
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) PR195 PR197
Wrk End Date Contains the work period end date which PR82.1 PR85.1
is determined by the employee's pay plan
and the time record date.
TIP-PAY-END-DATE Numeric 8 (yyyymmdd) PR195 PR197
Pay End Date Contains the pay period end date which PR82.1 PR85.1
is determined by the employee's pay plan
and the time record date.
TIP-WORK-STATE Alpha 2 PR195 PR197
Work State Identifies the state in which the PR82.1 PR85.1
workers' compensation plan is affective.
TIP-CURRENCY-CODE Alpha 5 PR195 PR197
Currency Code This field contains the company base PR82.1 PR85.1
currency code established in Company
(GL10.1 ).
TIP-CURR-ND Numeric 1 PR195 PR197
Currency Number of Represents the number of decimals PR82.1 PR85.1
Decimals defined for the currency of the object.
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 AC541 AC542
TIP-PROC-LEV BN150 PR128
TIP-DEPART PR131 PR132
SHIFT PR134 PR136
EMPLOYEE PR195 PR197
WRK-END-DATE PR32.2 PR33.2
SEQ-NBR PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR45.1
PR530 PR82.1
PR85.1 UK102
UK120
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
|
