Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TAPLAN


                              TAPLAN FILE

REFERENCED BY

BN15.1    BN215     ET700     ES02.2    HR04.2    HR04.3
HR04.7    HR04.8    HR11.1    HR511     HR80.1    HR80.2
HR80.3    HR80.4    HR80.5    HR80.6    HR80.7    HR80.8
HR80.9    HR81.1    HR81.2    HR81.3    HR81.4    HR81.5
HR81.6    HR81.7    HR81.8    HR81.9    HR82.1    HR82.2
HR82.3    HR82.4    HR82.5    HR82.6    HR82.7    HR82.8
HR82.9    HR83.1    HR83.2    HR83.3    HR83.4    HR83.5
HR83.6    HR83.7    HR83.8    HR83.9    HR84.1    HR84.2
HR84.3    HR84.4    HR84.5    HR84.6    HR84.7    HR84.8
HR84.9    HR85.1    HR85.2    HR85.3    HR85.4    HR85.5
HR85.6    HR85.7    HR85.8    HR86.1    HR86.2    HR86.3
HR86.4    HR86.5    HR86.6    HR86.7    HR86.8    HR86.9
HR87.1    HR87.2    HR87.3    HR87.4    HR87.5    HR87.6
HR87.7    HR87.8    HR87.9    HR88.1    HR88.2    HR88.3
HR88.4    HR88.5    HR88.6    HR88.7    HR89.1    HR89.2
HR89.3    HR89.4    HR89.5    HR89.6    HR89.7    HR89.8
HR89.9    HR91.7    LP02.1    LP03.1    LP03.2    LP03.3
LP03.4    LP03.5    LP03.6    LP100     LP101     LP103
LP130     LP138     LP140     LP145     LP15.1    LP180
LP188     LP197     LP201     LP220     LP231     LP240
LP264     LP270     LP31.1    LP32.1    LP32.2    LP32.3
LP331     LP34.1    LP370     LP570     LP63.1    LP63.2
LP64.1    LP64.2    LP70.1    LP70.2    LP80.1    LP88.1
PA100     PA52.4    BN150     ET530     ETI2.1    LP198
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

LP01.1    HR00.1    HR01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TAP-COMPANY            Numeric 4                                 LP01.1
Element: Company Hr

TAP-PLAN               Alpha 10                                  LP01.1
Element: Ta Plan

TAP-DESCRIPTION        Alpha 30  (Lower Case)                    LP01.1
Element: Ta Description

TAP-STATUS             Numeric 1                                 LP01.1
Element: Ta Status     1 = Active
                       2 = Inactive

TAP-AUTO-ENROLL        Numeric 1                                 LP01.1
Element: Ta Auto Enroll0 = No
                       1 = Yes

TAP-BALANCE-TYPE       Numeric 1                                 LP01.1
Element: Ta Balance    1 = Employee group
                       2 = Position code

TAP-ENROLL-TYPE        Numeric 1                                 LP01.1
Element: Ta Enroll Type1 = Employee Group
                       2 = Employee group; position code
                       3 = Employee group; position level

TAP-TABLE-BASIS        Numeric 1                                 LP01.1
Element: Ta Basis      1 = Cycle based
                       2 = Hours based

TAP-CATEGORY           Alpha 10                                  LP01.1  LP180
Element: Ta Category

TAP-WEB-AVAILABLE      Alpha 1                                   LP01.1
Element: Web Available 1 = Not Available
                       2 = Available

TAP-WEB-AVAIL-SUPV     Alpha 1                                   LP01.1
Element: Web Avail Supv1 = Not Available
                       2 = Available

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

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

TAP-USER-ID            Alpha 10  (Lower Case)                    LP01.1
Element: User

                         TAPLAN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TAPSET1   COMPANY                                                BN15.1  BN215
          PLAN                                                   ET700   ES02.2
                                                                 HR00.1  HR01.1
                                                                 HR04.2  HR04.3
                                                                 HR04.7  HR04.8
                                                                 HR11.1  HR511
                                                                 HR80.1  HR80.2
                                                                 HR80.3  HR80.4
                                                                 HR80.5  HR80.6
                                                                 HR80.7  HR80.8
                                                                 HR80.9  HR81.1
                                                                 HR81.2  HR81.3
                                                                 HR81.4  HR81.5
                                                                 HR81.6  HR81.7
                                                                 HR81.8  HR81.9
                                                                 ...

TAPSET2   COMPANY       Subset
          PLAN          Where (WEB-AVAILABLE = "2" )

TAPSET3   COMPANY       Subset
          PLAN          Where (WEB-AVAIL-SUPV = "2" )

TAPSET4   COMPANY       Subset                                   BN150   ET530
          PLAN          Where (STATUS = 1 )                      ETI2.1  HR11.1
                                                                 HR511   LP100
                                                                 LP130   LP140
                                                                 LP145   LP188
                                                                 LP198   PA100
                                                                 PA52.4  PR128
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR135   PR136
                                                                 PR137   PR160
                                                                 PR180   PR189
                                                                 PR29.1  PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 ...

                         TAPLAN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Category       PCODES       Required
                            When (TAP-CATEGORY != Spaces )

                            "TC"            -> PCO-TYPE
                            TAP-CATEGORY    -> PCO-CODE

Company        PRSYSTEM     Required

                            TAP-COMPANY     -> PRS-COMPANY
                            Spaces          -> PRS-PROCESS-LEVEL

                         TAPLAN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bn Plan Group  BNTAGROUP

                            TAP-COMPANY     -> BTG-COMPANY
                            TAP-PLAN        -> BTG-TA-PLAN
                                               BTG-EMPLOYEE-GROUP
                                               BTG-PLAN-CODE

Bn Ta Employee BNTAEMPBAL   Delete Restricted

                            TAP-COMPANY     -> BTE-COMPANY
                            TAP-PLAN        -> BTE-TA-PLAN
                                               BTE-EMPLOYEE-GROUP
                                               BTE-EMPLOYEE
                                               BTE-POSITION
                                               BTE-PLAN-CODE
                                               BTE-START-DATE

Employees      TAEEMASTER   Delete Restricted

                            TAP-COMPANY     -> TEM-COMPANY
                            TAP-PLAN        -> TEM-PLAN
                                               TEM-EMPLOYEE-GROUP
                                               TEM-EMPLOYEE
                                               TEM-POSITION

Structure      TASTRUCTUR

                            TAP-COMPANY     -> TST-COMPANY
                            TAP-PLAN        -> TST-PLAN
                                               TST-EMPLOYEE-GROUP
                                               TST-BEGIN-DATE