TIPPAY

Employee Tip Pay

Contains the reported tip income and hours worked to generate the tip income.
UPDATED BY
BN150 PR521 EXI2.1 EXI4.1 LP130 LP140
PR128 PR130 PR131 PR132 PR134 PR135
PR136 PR137 PR189 PR195 PR197 PR29.1
PR32.1 PR32.2 PR33.1 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR35.9 PR36.1 PR37.1 PR45.1 PR529 PR530
PR560 PR582 PR80.1 PR80.4 PR82.1 PR85.1
UK102 UK560 TA147

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TIP-COMPANY
Element: Company Hr
Numeric 4
PR195 PR197
PR582 PR82.1
PR85.1
TIP-CHECK-TYPE
Element: Check Type
Alpha 1
Contains the payment type.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-EMPLOYEE
Element: Employee
Numeric 9
Employee number is assigned to each person employed by the firm. It is used to correlate all of the information related to that person.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-RECORD-DATE
Element: Record Date
Numeric 8 (yyyymmdd)
Contains the time record date.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-TIP-PROC-LEV
Element: Process Lev Hr
Alpha 5
Contains the process level.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-TIP-DEPART
Element: Department
Alpha 5
Contains the department.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-SHIFT
Element: Shift
Numeric 1
Contains the shift number associated with the pay.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-PAY-SUM-GRP
Element: Pay Sum Grp
Alpha 3
Contains the pay summary group from the time record.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-SEQ-NBR
Element: Seq Nbr
Numeric 4
Contains the automatically assigned sequence number from the time record.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-TIP-PAY-TYPE
Element: Tip Pay Type
Numeric 1
Contains the value that indicates if the pay is from direct or indirect tips as indicated on the pay summary group record.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-HM-PROC-LEV
Element: Process Lev Hr
Alpha 5
Contains the employee's home process level.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-HM-DEPT
Element: Department
Alpha 5
Contains the employee's home department.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-RPT-TIPS-AMT
Element: Rpt Tips Amt
Signed 9.2
Contains the reportable tip payment amount.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-HOURS
Element: Hours
Signed 7.2
Contains the hours associated with this record.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-CHECK-NBR
Element: Check Nbr
Numeric 8
Contains the payment number.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-CHECK-DATE
Element: Check Date
Numeric 8 (yyyymmdd)
Contains the payment date.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-STATUS
Element: Status
Numeric 1
Contains the record status.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-JOB-CODE
Element: Job Code
Alpha 9
Contains a user-defined code that represents a type of job.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-TIP-CRED-AMT
Element: Tip Cred Amt
Signed 9.2
Contains the tip credit amount calculated on TP135 (Tip Calculation).
PR85.1
TIP-WRK-END-DATE
Element: Wrk End Date
Numeric 8 (yyyymmdd)
Contains the work period end date which is determined by the employee's pay plan and the time record date.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-PAY-END-DATE
Element: Pay End Date
Numeric 8 (yyyymmdd)
Contains the pay period end date which is determined by the employee's pay plan and the time record date.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-WORK-STATE
Element: Work State
Alpha 2
Identifies the state in which the workers' compensation plan is affective.
PR195 PR197
PR582 PR82.1
PR85.1
TIP-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
PR195 PR197
PR582 PR82.1
PR85.1
TIP-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
PR195 PR197
PR582 PR82.1
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
TIP-PROC-LEV
TIP-DEPART
SHIFT
RECORD-DATE
EMPLOYEE
PAY-SUM-GRP
CHECK-TYPE
SEQ-NBR
KeyChange
TIPSET3 COMPANY
TIP-PROC-LEV
TIP-DEPART
SHIFT
EMPLOYEE
WRK-END-DATE
SEQ-NBR
KeyChange
...
BN150 PR521
EXI2.1 EXI4.1
LP130 LP140
PR128 PR130
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR195
PR197 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
TIPSET4 COMPANY
CHECK-TYPE
EMPLOYEE
CHECK-NBR
SEQ-NBR
KeyChange
PR85.1


TIPPAY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Wed Jun 08 20:51:16 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.