Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             TREXCEPT FILE

This file contains exception pay codes and offsetting pay codes for deviating
employee attendances, such as absences. It is also used by web self service to
create column definitions.

REFERENCED BY

HS21.1    HS36.1    PR128     HS22.1

UPDATED BY

HS05.1    PR28.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

TRX-COMPANY          Numeric 4                                   HS05.1  PR28.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.


TRX-GROUP-NAME       Alpha 10                                    HS05.1  HS36.1
Group Name           Contains an employee group name.            PR28.1

TRX-COLUMN-NUMBER    Numeric 2                                   HS05.1  PR28.1
Column Number        Contains the column number value.

TRX-COLUMN-LABEL     Alpha 15  (Lower Case)                      HS05.1  PR28.1
Column Label         Contains the column label to be used
                     for Web Exception Time Entry.


TRX-PAY-CODE         Alpha 4                                     HS05.1  PR28.1
Payment Code         Contains the pay code. A pay code is a
                     user-defined code that identifies a kind
                     of pay.


TRX-OFFSET-PAY       Alpha 4                                     HS05.1  PR28.1
Offset Pay           Contains a pay code that is to be used
                     as the offset pay code.


TRX-TIMECARD-TYPE    Numeric 1                                   PR28.1
Timecard Type        Contains a value that determines the
                     type of time record.  Valid values are:

                     0 = Normal.

                     1 = Exception.
                     2

                         TREXCEPT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TRXSET1   COMPANY                                                HS05.1  HS21.1
          GROUP-NAME                                             HS36.1  PR128
          COLUMN-NUMBER                                          PR28.1

TRXSET2   COMPANY       KeyChange                                HS22.1  HS36.1
          GROUP-NAME                                             PR128   PR28.1
          PAY-CODE
          COLUMN-NUMBER

TRXSET3   COMPANY       KeyChange
          PAY-CODE
          GROUP-NAME
          COLUMN-NUMBER

                         TREXCEPT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Persgroup      PERSGROUP    Required

                            TRX-COMPANY       -> PRG-COMPANY  (PRGSET1)
                            TRX-GROUP-NAME    -> PRG-GROUP-NAME

Prsystem       PRSYSTEM     Required

                            TRX-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

                         TREXCEPT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Offset Paycode PRPAYCODE

                            TRX-COMPANY       -> PCD-COMPANY
                            TRX-OFFSET-PAY    -> PCD-PAY-CODE
                                                 PCD-PROCESS-LEVEL
                                                 PCD-JOB-CODE

Paycode        PRPAYCODE

                            TRX-COMPANY       -> PCD-COMPANY
                            TRX-PAY-CODE      -> PCD-PAY-CODE
                                                 PCD-PROCESS-LEVEL
                                                 PCD-JOB-CODE