Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TAPAYROLL


                             TAPAYROLL FILE

Payroll Rules define service codes for use or payout of hours balances,
service codes for payout of earnings balances, whether payout is automatic as
earnings are accrued, and which balances are printed on payments.

REFERENCED BY

BN150     ET530     ETI2.1    LP02.1    LP08.1    LP08.2
LP130     LP140     LP201     LP203     PR128     PR130
PR131     PR132     PR134     PR135     PR136     PR137
PR160     PR180     PR189     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     PR80.1
PR80.2    PR82.1    UK102     UK560     TA147

UPDATED BY

LP03.5    HR00.1    HR01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TPR-COMPANY            Numeric 4                                 LP03.5
Element: Company Hr

TPR-PAYROLL-RULE       Alpha 10                                  LP03.5
Element: Ta Rule

TPR-DESCRIPTION        Alpha 30  (Lower Case)                    LP03.5
Element: Ta Description

TPR-HRS-SRV-CLS        Alpha 3                                   LP03.5
Element: Ta Service Cls

TPR-HRS-PYO-SRV-CD     Alpha 4                                   LP03.5
Element: Ta Service Cd

TPR-HRS-NEGATV-BAL     Numeric 1                                 LP03.5
Element: Ta Negativ Bal1 = Warning
                       2 = Error
                       3 = Do not check balance
                       4 = Reclassify as unpaid time

TPR-HRS-AVAIL-DESC     Alpha 30  (Lower Case)                    LP03.5
Element: Ta Description

TPR-HRS-AVAIL-PRNT     Numeric 1                                 LP03.5
Element: Ta Print      0 = No
                       1 = Yes

TPR-HRS-ACCR-DESC      Alpha 30  (Lower Case)                    LP03.5
Element: Ta Description

TPR-HRS-ACCR-PRNT      Numeric 1                                 LP03.5
Element: Ta Print      0 = No
                       1 = Yes

TPR-HRS-RESRV-DESC     Alpha 30  (Lower Case)                    LP03.5
Element: Ta Description

TPR-HRS-RESRV-PRNT     Numeric 1                                 LP03.5
Element: Ta Print      0 = No
                       1 = Yes

TPR-HRS-CARRY-DESC     Alpha 30  (Lower Case)                    LP03.5
Element: Ta Description

TPR-HRS-CARRY-PRNT     Numeric 1                                 LP03.5
Element: Ta Print      0 = No
                       1 = Yes

TPR-ERN-SRV-CLS        Alpha 3                                   LP03.5
Element: Ta Service Cls

TPR-ERN-PYO-SRV-CD     Alpha 4                                   LP03.5
Element: Ta Service Cd

TPR-ERN-NEGATV-BAL     Numeric 1                                 LP03.5
Element: Ta Negativ Bal1 = Warning
                       2 = Error
                       3 = Do not check balance
                       4 = Reduce to plan balance

TPR-ERN-AVAIL-DESC     Alpha 30  (Lower Case)                    LP03.5
Element: Ta Description

TPR-ERN-AVAIL-PRNT     Numeric 1                                 LP03.5
Element: Ta Print      0 = No
                       1 = Yes

TPR-ERN-ACCR-DESC      Alpha 30  (Lower Case)                    LP03.5
Element: Ta Description

TPR-ERN-ACCR-PRNT      Numeric 1                                 LP03.5
Element: Ta Print      0 = No
                       1 = Yes

TPR-ERN-RESRV-DESC     Alpha 30  (Lower Case)                    LP03.5
Element: Ta Description

TPR-ERN-RESRV-PRNT     Numeric 1                                 LP03.5
Element: Ta Print      0 = No
                       1 = Yes

TPR-ERN-CARRY-DESC     Alpha 30  (Lower Case)                    LP03.5
Element: Ta Description

TPR-ERN-CARRY-PRNT     Numeric 1                                 LP03.5
Element: Ta Print      0 = No
                       1 = Yes

TPR-DATE-STAMP         Numeric 8  (yyyymmdd)                     LP03.5
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

TPR-TIME-STAMP         Numeric 6  (hhmmss)                       LP03.5
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

TPR-USER-ID            Alpha 10  (Lower Case)                    LP03.5
Element: User

TPR-HRS-WEB-EDIT       Numeric 1
Element: Ta Negativ Bal1 = Warning
                       2 = Error
                       3 = Do not check balance
                       4 = Reclassify as unpaid time

TPR-ERN-WEB-EDIT       Numeric 1
Element: Ta Negativ Bal1 = Warning
                       2 = Error
                       3 = Do not check balance
                       4 = Reduce to plan balance

TPR-HRS-NEG-LIMIT      Signed 18.6
Element: Ta Amount

TPR-HRS-LINK-TABLE     Alpha 10
Element: Ta Table

TPR-HRS-FINAL-OPT      Numeric 1
Element: Ta Negativ Bal1 = Original plan negative bal opt
                       2 = Link plan negative bal opt

TPR-HRS-PROC-ORDER     Numeric 1
Element: Ta Proc Order 1 = Link plans
                       2 = Orig neg bal limit
                       3 = Link plans; orig neg bal limit
                       4 = Link plans; link neg bal limit
                       5 = Orig neg bal limit; link plans
                       6 = Org ng bal lmt; link; link lmt

TPR-HRS-UNPAID-CD      Alpha 4
Element: Ta Service Cd

TPR-ERN-NEG-LIMIT      Signed 18.6
Element: Ta Amount

TPR-ERN-LINK-TABLE     Alpha 10
Element: Ta Table

TPR-ERN-FINAL-OPT      Numeric 1
Element: Ta Negativ Bal1 = Original plan negative bal opt
                       2 = Link plan negative bal opt

TPR-ERN-PROC-ORDER     Numeric 1
Element: Ta Proc Order 1 = Link plans
                       2 = Orig neg bal limit
                       3 = Link plans; Orig neg bal limit
                       4 = Link plans; link neg bal limit
                       5 = Orig neg bal limit; link plans
                       6 = Org ng bal lmt; link; link lmt

                         TAPAYROLL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TPRSET1   COMPANY                                                BN150   ET530
          PAYROLL-RULE                                           ETI2.1  HR00.1
                                                                 HR01.1  LP02.1
                                                                 LP03.5  LP08.1
                                                                 LP08.2  LP130
                                                                 LP140   LP201
                                                                 LP203   PR128
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR135   PR136
                                                                 PR137   PR160
                                                                 PR180   PR189
                                                                 PR29.1  PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

                         TAPAYROLL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            TPR-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Ern Pyo Srv Cd TASERVCODE   Required
                            When TPR-ERN-PYO-SRV-CD != Spaces

                            TPR-COMPANY           -> TSC-COMPANY
                            TPR-ERN-PYO-SRV-CD    -> TSC-SERVICE-CODE

Ern Srv Cls    TASERVCLSS   Required
                            When TPR-ERN-SRV-CLS != Spaces

                            TPR-COMPANY           -> TSL-COMPANY
                            TPR-ERN-SRV-CLS       -> TSL-SERVICE-CLASS

Hrs Pyo Srv Cd TASERVCODE   Required
                            When TPR-HRS-PYO-SRV-CD != Spaces

                            TPR-COMPANY           -> TSC-COMPANY
                            TPR-HRS-PYO-SRV-CD    -> TSC-SERVICE-CODE

Hrs Srv Cls    TASERVCLSS   Required
                            When TPR-HRS-SRV-CLS != Spaces

                            TPR-COMPANY           -> TSL-COMPANY
                            TPR-HRS-SRV-CLS       -> TSL-SERVICE-CLASS