Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TASERVICE


                             TASERVICE FILE

REFERENCED BY

LP140     LP145     LP188     LP198     LP210     LP251
LP260     LP353     LP60.1    LP60.3    BN150     ET530
ETI2.1    LP130     PR128     PR130     PR131     PR132
PR134     PR135     PR136     PR137     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    PR82.1    UK102     UK560     TA147


UPDATED BY

LP08.3    LP08.4    LP08.1    LP08.2    HR00.1    HR01.1


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TSV-COMPANY            Numeric 4                                 LP08.3  LP08.4
Element: Company Hr

TSV-SERVICE-CLASS      Alpha 3                                   LP08.3  LP08.4
Element: Ta Service Cls

TSV-SERVICE-CODE       Alpha 4                                   LP08.3  LP08.4
Element: Ta Service Cd

TSV-HOURS-FLAG         Alpha 1                                   LP08.3  LP08.4
Element: Hours Flag    1 = Include
                       2 = Exclude
                       3 = Subtract

TSV-WAGES-FLAG         Alpha 1                                   LP08.3  LP08.4
Element: Wages Flag    1 = Include
                       2 = Exclude
                       3 = Subtract

                         TASERVICE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TSVSET1   COMPANY                                                HR00.1  HR01.1
          SERVICE-CLASS                                          LP08.1  LP08.3
          SERVICE-CODE                                           LP140   LP145
                                                                 LP188   LP198
                                                                 LP210   LP251
                                                                 LP260   LP353
                                                                 LP60.1  LP60.3

TSVSET2   COMPANY                                                BN150   ET530
          SERVICE-CODE                                           ETI2.1  LP08.2
          SERVICE-CLASS                                          LP08.4  LP130
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR135
                                                                 PR136   PR137
                                                                 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
                                                                 ...

                         TASERVICE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            TSV-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Service Class  TASERVCLSS   Required

                            TSV-COMPANY          -> TSL-COMPANY
                            TSV-SERVICE-CLASS    -> TSL-SERVICE-CLASS

Service Code   TASERVCODE   Required

                            TSV-COMPANY          -> TSC-COMPANY
                            TSV-SERVICE-CODE     -> TSC-SERVICE-CODE