Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TREXCEPT


                             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

HR55.1    HR55.2    HR55.3    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
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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

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

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

TRX-PAY-CODE           Alpha 4                                   HS05.1  PR28.1
Element: 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
Element: Offset Pay    Contains a pay code that is to be used
                       as the offset pay code.

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

                       0 = Normal.

                       1 = Exception.
                       2

TRX-FORM-TYPE          Alpha 1
Element: Form Type     " " = Employee
                       E = Employee
                       M = Manager

                         TREXCEPT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TRXSET1   COMPANY                                                HR55.1  HR55.2
          GROUP-NAME                                             HR55.3  HS05.1
          COLUMN-NUMBER                                          HS21.1  HS36.1
                                                                 PR128   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