Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PBTIMEREC


                             PBTIMEREC FILE

UPDATED BY

BN150     PR128     PR130     PR131     PR132     PR134
PR136     PR137     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     PR82.1
PR85.1    UK102     UK330     TA147     TP135

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TPB-COMPANY            Numeric 4                                 BN150   PR128
Element: Company Hr    Identifies the AP company if the          PR130   PR131
                       resource type = V.  Identifies the HR     PR132   PR134
                       company if the resource type = E.  It is  PR136   PR137
                       blank for type A, P or Q resources.       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   PR82.1
                                                                 PR85.1  TA147
                                                                 TP135   UK102
                                                                 UK330

TPB-EMPLOYEE           Numeric 9                                 BN150   PR128
Element: Employee      Contains the employee number. Each        PR130   PR131
                       person employed by the company is         PR132   PR134
                       assigned a unique number. The system      PR136   PR137
                       uses the employee number to correlate     PR197   PR29.1
                       all of the information related to that    PR32.1  PR32.2
                       person.                                   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   PR82.1
                                                                 PR85.1  TA147
                                                                 TP135   UK102
                                                                 UK330

TPB-CHECK-ID           Numeric 12                                PR197   PR85.1
Internal Check ID      Contains the payment identification
Number                 number (unique payment identifier used
                       in tracking payment information).

TPB-PAY-SUM-GRP        Alpha 3                                   PR197   PR85.1
Payment Summary
Group

TPB-TIME-SEQ           Numeric 12                                BN150   PR128
Element: Sequence Number                                         PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR137
                                                                 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   PR82.1
                                                                 PR85.1  TA147
                                                                 TP135   UK102
                                                                 UK330

TPB-DED-GRP-AMT        Signed 15.2                               PR85.1
Element: Ded Grp Amt

TPB-DED-GRP-AMT-WC     Signed 15.2                               PR85.1
Element: Ded Grp Amt Wc

TPB-DED-GRP-AMT-SU     Signed 15.2
Element: Ded Grp Amt Su

TPB-PCT-RATE-1         Signed 8.5                                BN150   PR128
Element: Pct Rate 1                                              PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR137
                                                                 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   PR82.1
                                                                 PR85.1  TA147
                                                                 TP135   UK102
                                                                 UK330

TPB-PCT-RATE-2         Signed 8.5                                BN150   PR128
Element: Pct Rate 2                                              PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR137
                                                                 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   PR82.1
                                                                 PR85.1  TA147
                                                                 TP135   UK102
                                                                 UK330

TPB-AMT-RATE-1         Signed 6.2                                BN150   PR128
Element: Amt Rate 1                                              PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR137
                                                                 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   PR82.1
                                                                 PR85.1  TA147
                                                                 TP135   UK102
                                                                 UK330

TPB-AMT-RATE-2         Signed 6.2                                BN150   PR128
Element: Amt Rate 2                                              PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR137
                                                                 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   PR82.1
                                                                 PR85.1  TA147
                                                                 TP135   UK102
                                                                 UK330

TPB-GROSS-AMT-1        Signed 15.2                               BN150   PR128
Element: Gross Amt 1                                             PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR137
                                                                 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   PR82.1
                                                                 PR85.1  TA147
                                                                 TP135   UK102
                                                                 UK330

TPB-GROSS-AMT-2        Signed 15.2                               BN150   PR128
Element: Gross Amt 2                                             PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR137
                                                                 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   PR82.1
                                                                 PR85.1  TA147
                                                                 TP135   UK102
                                                                 UK330

TPB-CLIENT-JOBID       Alpha 20                                  BN150   PR128
Element: Client Jobid                                            PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR137
                                                                 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   PR82.1
                                                                 PR85.1  TA147
                                                                 TP135   UK102
                                                                 UK330

TPB-TIME-USER-FLD      Alpha 20                                  BN150   PR128
Element: Time User Fld                                           PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR137
                                                                 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   PR82.1
                                                                 PR85.1  TA147
                                                                 TP135   UK102
                                                                 UK330

TPB-UNITS-AMOUNT       Signed 15.2                               BN150   PR128
Element: Units Amount  This is the units amount included in      PR130   PR131
                       the file.                                 PR132   PR134
                                                                 PR136   PR137
                                                                 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   PR82.1
                                                                 PR85.1  TA147
                                                                 TP135   UK102
                                                                 UK330

TPB-UNIT-MEASURE       Alpha 12                                  BN150   PR128
Element: Unit Measure                                            PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR137
                                                                 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   PR82.1
                                                                 PR85.1  TA147
                                                                 TP135   UK102
                                                                 UK330

TPB-RATE               Signed 13.4                               BN150   PR128
Element: Rate          Contains the percentage rate.             PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR137
                                                                 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   PR82.1
                                                                 PR85.1  TA147
                                                                 TP135   UK102
                                                                 UK330

TPB-GROSS-CALC-AMT     Signed 15.2
Element: Gross Calc Amt

TPB-CURRENCY-CODE      Alpha 5
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

TPB-CURR-ND            Numeric 1
Account Currency       Represents the number of decimals
Code                   defined for the currency of the object.

TPB-CHECK-TYPE         Alpha 1
Element: Payment Type  Contains the payment type.

                         PBTIMEREC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TPBSET1   COMPANY                                                BN150   PR128
          EMPLOYEE                                               PR130   PR131
          TIME-SEQ                                               PR132   PR134
                                                                 PR136   PR137
                                                                 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   PR82.1
                                                                 ...

                         PBTIMEREC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       EMPLOYEE     Required

                            TPB-COMPANY         -> EMP-COMPANY
                            TPB-EMPLOYEE        -> EMP-EMPLOYEE

Timerecord     TIMERECORD   Required

                            TPB-COMPANY         -> TRD-COMPANY
                            TPB-EMPLOYEE        -> TRD-EMPLOYEE
                            TPB-TIME-SEQ        -> TRD-TIME-SEQ