Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TIPPAY


                              TIPPAY FILE

                            Employee Tip Pay

Contains the reported tip income and hours worked to generate the tip income.

UPDATED BY

BN150     ET530     ETI2.1    LP130     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
PR35.9    PR36.1    PR45.1    PR529     PR530     PR560
PR80.1    PR82.1    PR85.1    UK102     UK560     TA147


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TIP-COMPANY            Numeric 4                                 ET530   PR195
Element: Company Hr                                              PR197   PR82.1
                                                                 PR85.1

TIP-CHECK-TYPE         Alpha 1                                   ET530   PR195
Element: Check Type    Contains the payment type.                PR197   PR82.1
                                                                 PR85.1

TIP-EMPLOYEE           Numeric 9                                 ET530   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)                     ET530   PR195
Element: Record Date   Contains the time record date.            PR197   PR82.1
                                                                 PR85.1

TIP-TIP-PROC-LEV       Alpha 5                                   ET530   PR195
Element: Process Lev HrContains the process level.               PR197   PR82.1
                                                                 PR85.1

TIP-TIP-DEPART         Alpha 5                                   ET530   PR195
Element: Department    Contains the department.                  PR197   PR82.1
                                                                 PR85.1

TIP-SHIFT              Numeric 1                                 ET530   PR195
Element: Shift         Contains the shift number associated      PR197   PR82.1
                       with the pay.                             PR85.1

TIP-PAY-SUM-GRP        Alpha 3                                   ET530   PR195
Element: Pay Sum Grp   Contains the pay summary group from the   PR197   PR82.1
                       time record.                              PR85.1

TIP-SEQ-NBR            Numeric 4                                 ET530   PR195
Element: Seq Nbr       Contains the automatically assigned       PR197   PR82.1
                       sequence number from the time record.     PR85.1

TIP-TIP-PAY-TYPE       Numeric 1                                 ET530   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                                   ET530   PR195
Element: Process Lev HrContains the employee's home process      PR197   PR82.1
                       level.                                    PR85.1

TIP-HM-DEPT            Alpha 5                                   ET530   PR195
Element: Department    Contains the employee's home department.  PR197   PR82.1
                                                                 PR85.1

TIP-RPT-TIPS-AMT       Signed 9.2                                ET530   PR195
Element: Rpt Tips Amt  Contains the reportable tip payment       PR197   PR82.1
                       amount.                                   PR85.1

TIP-HOURS              Signed 7.2                                ET530   PR195
Element: Hours         Contains the hours associated with this   PR197   PR82.1
                       record.                                   PR85.1

TIP-CHECK-NBR          Numeric 8                                 ET530   PR195
Element: Check Nbr     Contains the payment number.              PR197   PR82.1
                                                                 PR85.1

TIP-CHECK-DATE         Numeric 8  (yyyymmdd)                     ET530   PR195
Element: Check Date    Contains the payment date.                PR197   PR82.1
                                                                 PR85.1

TIP-STATUS             Numeric 1                                 ET530   PR195
Element: Status        Contains the record status.               PR197   PR82.1
                                                                 PR85.1

TIP-JOB-CODE           Alpha 9                                   ET530   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)                     ET530   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)                     ET530   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                                   ET530   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                                   ET530   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                                 ET530   PR195
Element: Acct Nd       The number of decimals assigned to a      PR197   PR82.1
                       particular account as determined by the   PR85.1
                       account currency.


                         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                                BN150   ET530
          TIP-PROC-LEV                                           ETI2.1  LP130
          TIP-DEPART                                             PR128   PR130
          SHIFT                                                  PR131   PR132
          EMPLOYEE                                               PR134   PR136
          WRK-END-DATE                                           PR189   PR195
          SEQ-NBR                                                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
                                                                 ...

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