Employee Tip Pay
Contains the reported tip income and hours worked to generate the tip income.
UPDATED BY
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||
---|---|---|---|---|---|---|---|---|
TIP-COMPANY Element: Company Hr | Numeric 4 |
|
||||||
TIP-CHECK-TYPE Element: Check Type | Alpha 1 Contains the payment type. |
|
||||||
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. |
|
||||||
TIP-RECORD-DATE Element: Record Date | Numeric 8 (yyyymmdd) Contains the time record date. |
|
||||||
TIP-TIP-PROC-LEV Element: Process Lev Hr | Alpha 5 Contains the process level. |
|
||||||
TIP-TIP-DEPART Element: Department | Alpha 5 Contains the department. |
|
||||||
TIP-SHIFT Element: Shift | Numeric 1 Contains the shift number associated with the pay. |
|
||||||
TIP-PAY-SUM-GRP Element: Pay Sum Grp | Alpha 3 Contains the pay summary group from the time record. |
|
||||||
TIP-SEQ-NBR Element: Seq Nbr | Numeric 4 Contains the automatically assigned sequence number from the time record. |
|
||||||
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. |
|
||||||
TIP-HM-PROC-LEV Element: Process Lev Hr | Alpha 5 Contains the employee's home process level. |
|
||||||
TIP-HM-DEPT Element: Department | Alpha 5 Contains the employee's home department. |
|
||||||
TIP-RPT-TIPS-AMT Element: Rpt Tips Amt | Signed 9.2 Contains the reportable tip payment amount. |
|
||||||
TIP-HOURS Element: Hours | Signed 7.2 Contains the hours associated with this record. |
|
||||||
TIP-CHECK-NBR Element: Check Nbr | Numeric 8 Contains the payment number. |
|
||||||
TIP-CHECK-DATE Element: Check Date | Numeric 8 (yyyymmdd) Contains the payment date. |
|
||||||
TIP-STATUS Element: Status | Numeric 1 Contains the record status. |
|
||||||
TIP-JOB-CODE Element: Job Code | Alpha 9 Contains a user-defined code that represents a type of job. |
|
||||||
TIP-TIP-CRED-AMT Element: Tip Cred Amt | Signed 9.2 Contains the tip credit amount calculated on TP135 (Tip Calculation). |
|
||||||
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. |
|
||||||
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. |
|
||||||
TIP-WORK-STATE Element: Work State | Alpha 2 Identifies the state in which the workers' compensation plan is affective. |
|
||||||
TIP-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||
TIP-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
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 |
|
|||||||||
TIPSET3 |
COMPANY TIP-PROC-LEV TIP-DEPART SHIFT EMPLOYEE WRK-END-DATE SEQ-NBR |
|
|||||||||
TIPSET4 |
COMPANY CHECK-TYPE EMPLOYEE CHECK-NBR SEQ-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| |||||||||||||||
Employee | EMPLOYEE |
Required
| |||||||||||||||
Hm Department | DEPTCODE |
Required
| |||||||||||||||
Hm Proc Lev | PRSYSTEM |
Required
| |||||||||||||||
Pay Sum Group | PAYSUMGRP |
Required
| |||||||||||||||
Tip Department | DEPTCODE |
Required
| |||||||||||||||
Tip Proc Lev | PRSYSTEM |
Required
| |||||||||||||||
Tpparam | TPPARAM |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.