Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TAREASCODE


                            TAREASCODE FILE

REFERENCED BY

BN150     ET530     ET700     ETI2.1    LP08.2    LP130
LP208     LP209     LP211     LP251     LP260     LP262
LP53.1    LP54.1    LP553     LP554     LP60.2    LP61.1
LP62.1    LP62.2    PR128     PR130     PR131     PR132
PR134     PR135     PR136     PR137     PR189     PR29.1
PR30.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

LP09.2    HR00.1    HR01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TRE-COMPANY            Numeric 4                                 LP09.2
Element: Company Hr

TRE-REASON-CODE        Alpha 4                                   LP09.2
Element: Ta Reason Cd

TRE-DESCRIPTION        Alpha 30  (Lower Case)                    LP09.2
Element: Ta Description

TRE-REASON-TYPE        Numeric 1                                 LP09.2
Element: Ta Reason Type1 = Absence
                       2 = Non Absence

TRE-PLAN-BALANCE       Numeric 1                                 LP09.2
Element: Lp Plan Bal   0 = None
                       1 = Available
                       2 = Reserve

TRE-SERVICE-CODE       Alpha 4                                   LP09.2
Element: Ta Service Cd

TRE-POINTS             Signed 7.2                                LP09.2
Element: Points

TRE-STATUS             Numeric 1                                 LP09.2
Element: Ta Status     0 = Active
                       1 = Inactive

                         TAREASCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TRESET1   COMPANY                                                BN150   ET530
          REASON-CODE                                            ET700   ETI2.1
                                                                 HR00.1  HR01.1
                                                                 LP08.2  LP09.2
                                                                 LP09.3  LP09.4
                                                                 LP130   LP208
                                                                 LP209   LP211
                                                                 LP251   LP260
                                                                 LP262   LP53.1
                                                                 LP54.1  LP553
                                                                 LP554   LP60.2
                                                                 LP61.1  LP62.1
                                                                 LP62.2  PR128
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 ...

                         TAREASCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            TRE-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

Service Code   TASERVCODE   Required
                            When (TRE-SERVICE-CODE != Spaces )

                            TRE-COMPANY         -> TSC-COMPANY
                            TRE-SERVICE-CODE    -> TSC-SERVICE-CODE

                         TAREASCODE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ta Reason      TAREASONS    Delete Cascades

                            TRE-COMPANY         -> TRO-COMPANY
                            TRE-REASON-CODE     -> TRO-REASON-CODE
                                                   TRO-REASON-CLASS