TIPPAY FILE
Employee Tip Pay
Contains the reported tip income and hours worked to generate the tip income.
UPDATED BY
AC541 AC542 BN150 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 PR36.1
PR45.1 PR529 PR530 PR560 PR80.1 PR82.1
PR85.1 UK102 UK560 TA147 UK120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TIP-COMPANY Numeric 4 AC542 PR195
Element: Company The company number represents an PR197 PR82.1
established company and is entered on PR85.1
all function codes.
TIP-CHECK-TYPE Alpha 1 AC542 PR195
Element: Payment Type Contains the payment type. PR197 PR82.1
PR85.1
TIP-EMPLOYEE Numeric 9 AC542 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) AC542 PR195
Element: Record Date Contains the time record date. PR197 PR82.1
PR85.1
TIP-TIP-PROC-LEV Alpha 5 AC542 PR195
Element: Tip Process LeContains the process level. PR197 PR82.1
PR85.1
TIP-TIP-DEPART Alpha 5 AC542 PR195
Element: Tip DepartmentContains the department. PR197 PR82.1
PR85.1
TIP-SHIFT Numeric 1 AC542 PR195
Element: Shift Contains the shift number associated PR197 PR82.1
with the pay. PR85.1
TIP-PAY-SUM-GRP Alpha 3 AC542 PR195
Payment Summary Contains the pay summary group from the PR197 PR82.1
Group time record. PR85.1
TIP-SEQ-NBR Numeric 4 AC542 PR195
Element: Sequence NumbeContains the automatically assigned PR197 PR82.1
sequence number from the time record. PR85.1
TIP-TIP-PAY-TYPE Numeric 1 AC542 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 AC542 PR195
Element: Home Process LContains the employee's home process PR197 PR82.1
level. PR85.1
TIP-HM-DEPT Alpha 5 AC542 PR195
Element: Home DepartmenContains the employee's home department. PR197 PR82.1
PR85.1
TIP-RPT-TIPS-AMT Signed 9.2 AC542 PR195
Element: Rpt Tips Amt Contains the reportable tip payment PR197 PR82.1
amount. PR85.1
TIP-HOURS Signed 7.2 AC542 PR195
Element: Hours Contains the hours associated with this PR197 PR82.1
record. PR85.1
TIP-CHECK-NBR Numeric 8 AC542 PR195
Element: Payment NumberContains the payment number. PR197 PR82.1
PR85.1
TIP-CHECK-DATE Numeric 8 (yyyymmdd) AC542 PR195
Element: Date Contains the payment date. PR197 PR82.1
PR85.1
TIP-STATUS Numeric 1 AC542 PR195
Element: Status Contains the record status. PR197 PR82.1
PR85.1
TIP-JOB-CODE Alpha 9 AC542 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) AC542 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) AC542 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 AC542 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 AC542 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 AC542 PR195
Account Currency PR197 PR82.1
Code 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 AC541 AC542
TIP-PROC-LEV BN150 PR128
TIP-DEPART PR130 PR131
SHIFT PR132 PR134
EMPLOYEE PR136 PR189
WRK-END-DATE PR195 PR197
SEQ-NBR PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.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
|
