|
|
TIPPAY FILE
Employee Tip Pay
Contains the reported tip income and hours worked to generate the tip income.
REFERENCED BY
TP130 TP00.1 TP140
UPDATED BY
BN150 PR128 PR130 PR131 PR132 PR134
PR136 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 PR82.1 PR85.1 UK102 TA147 TP100
TP105 TP135 TP30.1 TP30.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TIP-COMPANY Numeric 4 PR197 PR82.1
Element: Company Hr Identifies the AP company if the PR85.1 TP135
resource type = V. Identifies the HR TP30.1 TP30.2
company if the resource type = E. It is
blank for type A, P or Q resources.
TIP-CHECK-TYPE Alpha 1 PR197 PR82.1
Element: Payment Type Contains the payment type. PR85.1 TP135
TP30.1 TP30.2
TIP-EMPLOYEE Numeric 9 PR197 PR82.1
Element: Employee Employee number is assigned to each PR85.1 TP135
person employed by the firm. It is used TP30.1 TP30.2
to correlate all of the information
related to that person.
TIP-RECORD-DATE Numeric 8 (yyyymmdd) PR197 PR82.1
Element: Record Date Contains the time record date. PR85.1 TP135
TP30.1 TP30.2
TIP-TIP-PROC-LEV Alpha 5 PR197 PR82.1
Element: Process Lev HrContains the process level. PR85.1 TP135
TP30.1 TP30.2
TIP-TIP-DEPART Alpha 5 PR197 PR82.1
Element: Department Contains the department. PR85.1 TP135
TP30.1 TP30.2
TIP-SHIFT Numeric 1 PR197 PR82.1
Element: Shift Contains the shift number associated PR85.1 TP135
with the pay. TP30.1 TP30.2
TIP-PAY-SUM-GRP Alpha 3 PR197 PR82.1
Payment Summary Contains the pay summary group from the PR85.1 TP135
Group time record. TP30.1 TP30.2
TIP-SEQ-NBR Numeric 4 PR197 PR82.1
Element: Sequence NumbeContains the automatically assigned PR85.1 TP135
sequence number from the time record. TP30.1 TP30.2
TIP-TIP-PAY-TYPE Numeric 1 PR197 PR82.1
Element: Tip Pay Type Contains the value that indicates if PR85.1 TP135
the pay is from direct or indirect tips TP30.1 TP30.2
as indicated on the pay summary group
record.
TIP-HM-PROC-LEV Alpha 5 PR197 PR82.1
Element: Process Lev HrContains the employee's home process PR85.1 TP135
level. TP30.1 TP30.2
TIP-HM-DEPT Alpha 5 PR197 PR82.1
Element: Department Contains the employee's home department. PR85.1 TP135
TP30.1 TP30.2
TIP-RPT-TIPS-AMT Signed 9.2 PR197 PR82.1
Element: Rpt Tips Amt Contains the reportable tip payment PR85.1 TP135
amount. TP30.1 TP30.2
TIP-HOURS Signed 7.2 PR197 PR82.1
Element: Hours Contains the hours associated with this PR85.1 TP135
record. TP30.1 TP30.2
TIP-CHECK-NBR Numeric 8 PR197 PR82.1
Element: Payment NumberContains the payment number. PR85.1 TP135
TIP-CHECK-DATE Numeric 8 (yyyymmdd) PR197 PR82.1
Element: Payment Date Contains the payment date. PR85.1 TP135
TIP-STATUS Numeric 1 PR197 PR82.1
Element: Status Contains the record status. PR85.1 TP100
TP135 TP30.1
TP30.2
TIP-JOB-CODE Alpha 9 PR197 PR82.1
Element: Job Code Contains a user-defined code that PR85.1 TP135
represents a type of job.
TIP-TIP-CRED-AMT Signed 9.2 PR85.1 TP135
Element: Tip Cred Amt Contains the tip credit amount TP30.1
calculated on TP135 (Tip Calculation).
TIP-WRK-END-DATE Numeric 8 (yyyymmdd) PR197 PR82.1
Element: Wrk End Date Contains the work period end date which PR85.1 TP135
is determined by the employee's pay plan
and the time record date.
TIP-PAY-END-DATE Numeric 8 (yyyymmdd) PR197 PR82.1
Element: Pay End Date Contains the pay period end date which PR85.1 TP135
is determined by the employee's pay plan
and the time record date.
TIP-WORK-STATE Alpha 2 PR197 PR82.1
Element: Work State Identifies the state in which the PR85.1 TP135
workers' compensation plan is affective.
TIP-CURRENCY-CODE Alpha 5 PR197 PR82.1
Element: Currency Code This field contains the company base PR85.1 TP30.1
currency code established in Company TP30.2
(GL10.1 ).
TIP-CURR-ND Numeric 1 PR197 PR82.1
Account Currency Represents the number of decimals PR85.1 TP30.1
Code defined for the currency of the object. TP30.2
TIPPAY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TIPSET1 COMPANY TP105 TP135
EMPLOYEE TP30.1 TP30.2
RECORD-DATE
TIP-PROC-LEV
TIP-DEPART
SHIFT
PAY-SUM-GRP
CHECK-TYPE
SEQ-NBR
TIPSET2 COMPANY KeyChange TP130 TP30.2
TIP-PROC-LEV
TIP-DEPART
SHIFT
RECORD-DATE
EMPLOYEE
PAY-SUM-GRP
CHECK-TYPE
SEQ-NBR
TIPSET3 COMPANY KeyChange BN150 PR128
TIP-PROC-LEV PR130 PR131
TIP-DEPART PR132 PR134
SHIFT PR136 PR197
EMPLOYEE PR29.1 PR32.2
WRK-END-DATE PR33.2 PR33.3
SEQ-NBR PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 UK102
TA147 TP00.1
...
TIPSET4 COMPANY KeyChange PR85.1 TP130
CHECK-TYPE TP140
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
Emp Gross EMPGROSS Not Required
TIP-COMPANY -> EGR-COMPANY
TIP-EMPLOYEE -> EGR-EMPLOYEE
TIP-RECORD-DATE -> EGR-RECORD-DATE
TIP-TIP-PROC-LEV -> EGR-PROCESS-LEVEL
TIP-TIP-DEPART -> EGR-DEPARTMENT
TIP-SHIFT -> EGR-SHIFT
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 Control TIPCTL Required
TIP-COMPANY -> TPC-COMPANY
TIP-TIP-PROC-LEV -> TPC-PROCESS-LEVEL
TIP-TIP-DEPART -> TPC-DEPARTMENT
TIP-SHIFT -> TPC-SHIFT
TIP-RECORD-DATE -> TPC-RECORD-DATE
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
|
