Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TRSGBLCK


                             TRSGBLCK FILE

This file contains segment block data for employee time records.

REFERENCED BY

PR135

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     PR198

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TRS-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   PR29.1
                       blank for type A, P or Q resources.       PR32.2  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR35.9  PR36.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR82.1  TA147
                                                                 TP135   UK102

TRS-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   PR29.1
                       uses the employee number to correlate     PR32.2  PR33.2
                       all of the information related to that    PR33.3  PR35.1
                       person.                                   PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR35.9  PR36.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR82.1  TA147
                                                                 TP135   UK102

TRS-TIME-SEQ           Numeric 12                                BN150   PR128
Element: Sequence NumbeContains the automatically assigned       PR130   PR131
                       sequence number from the time record.     PR132   PR134
                                                                 PR136   PR29.1
                                                                 PR32.2  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR35.9  PR36.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR82.1  TA147
                                                                 TP135   UK102

TRS-SEGMENT-BLOCK      Alpha 103                                 BN150   PR128
Element: User Analysis This field identifies the user analysis   PR130   PR131
                       values included in the transaction.       PR132   PR134
                                                                 PR136   PR29.1
                       You can either type up to four values     PR32.2  PR33.2
                       or use Define (F6) to open the User       PR33.3  PR35.1
                       Analysis Entry subform. Use this subform  PR35.2  PR35.3
                       to select the user analysis values you    PR35.4  PR35.5
                       want to include in the transaction. If    PR35.6  PR35.8
                       you choose to type values, use commas to  PR35.9  PR36.1
                       separate them. For example:               PR45.1  PR529
                       value1,value2,value3,value4               PR530   PR560
                                                                 PR82.1  TA147
                       There are three conditions that affect    TP135   UK102
                       how you can select user analysis values.
                       See the User Analysis Entry form help or
                       the Strategic Ledger procedures manual
                       for additional information.

                         TRSGBLCK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TRSSET1   COMPANY                                                BN150   PR128
          EMPLOYEE                                               PR130   PR131
          TIME-SEQ                                               PR132   PR134
                                                                 PR135   PR136
                                                                 PR137   PR197
                                                                 PR198   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
                                                                 ...

                         TRSGBLCK FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       EMPLOYEE     Required

                            TRS-COMPANY     -> EMP-COMPANY
                            TRS-EMPLOYEE    -> EMP-EMPLOYEE