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     BN66.1    ET530     ETI2.1    LP130     PR128
PR130     PR131     PR132     PR134     PR136     PR137
PR140     PR189     PR195     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
PR80.1    PR82.1    PR85.1    PR89.1    UK102     UK330
UK560     TA147     PR198

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TRS-COMPANY            Numeric 4                                 BN150   ET530
Element: Company Hr                                              ETI2.1  LP130
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR189   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
                                                                 PR80.1  PR82.1
                                                                 TA147   UK102
                                                                 UK560

TRS-EMPLOYEE           Numeric 9                                 BN150   ET530
Element: Employee      Contains the employee number. Each        ETI2.1  LP130
                       person employed by the company is         PR128   PR130
                       assigned a unique number. The system      PR131   PR132
                       uses the employee number to correlate     PR134   PR136
                       all of the information related to that    PR189   PR29.1
                       person.                                   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
                                                                 PR80.1  PR82.1
                                                                 TA147   UK102
                                                                 UK560

TRS-TIME-SEQ           Numeric 12                                BN150   ET530
Element: Time Seq      Contains the automatically assigned       ETI2.1  LP130
                       sequence number from the time record.     PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR189   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
                                                                 PR80.1  PR82.1
                                                                 TA147   UK102
                                                                 UK560

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

                         TRSGBLCK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TRSSET1   COMPANY                                                BN150   BN66.1
          EMPLOYEE                                               ET530   ETI2.1
          TIME-SEQ                                               LP130   PR128
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR135   PR136
                                                                 PR137   PR140
                                                                 PR189   PR195
                                                                 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
                                                                 ...

                         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