Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRPAYTOTAL


                            PRPAYTOTAL FILE

The Pay Total file contains a record of the total hour for a pay period as
entered by an employee using the Web Time Entry process.  The total hours on
this record are an accumulation of the hours on each PRPENDTIME record for the
pay period.

REFERENCED BY

HS22.1    HS22.3

UPDATED BY

HS04.1    HS35.1    HS36.1    HS535

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PYT-COMPANY            Numeric 4                                 HS04.1  HS35.1
Element: Company       The company number represents an          HS36.1
                       established company and is entered on
                       all function codes.

PYT-EMPLOYEE           Numeric 9                                 HS04.1  HS35.1
Element: Employee      Contains the employee number. Each        HS36.1
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

PYT-PAY-PER-START      Numeric 8  (yyyymmdd)                     HS04.1  HS35.1
Element: Pay Per Start Contains the Pay Period Start date.       HS36.1

PYT-TOTAL-HOURS        Signed 9.2                                HS04.1  HS35.1
Element: Total Hours   Contain the total hours for the pay       HS36.1
                       period.

PYT-STATUS             Numeric 1                                 HS04.1  HS35.1
Element: Status        This field displays the status of the     HS36.1  HS535
                       transaction.
                       1 = SUBMITTED
                       2 = APPROVED
                       3 = REJECTED
                       4 = HOLD

PYT-TIMECARD-TYPE      Numeric 1                                 HS04.1  HS35.1
Element: Timecard Type Contains the time record type.  Valid     HS36.1
                       values are:

                       0 = Normal.

                       1 = Exception.
                       2

                         PRPAYTOTAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PYTSET1   COMPANY                                                HS04.1  HS22.1
          PAY-PER-START                                          HS35.1  HS36.1
          EMPLOYEE                                               HS535

PYTSET2   COMPANY                                                HS22.1  HS22.3
          EMPLOYEE
          PAY-PER-START

                         PRPAYTOTAL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       EMPLOYEE     Required

                            PYT-COMPANY     -> EMP-COMPANY
                            PYT-EMPLOYEE    -> EMP-EMPLOYEE

Prsystem       PRSYSTEM     Required

                            PYT-COMPANY     -> PRS-COMPANY
                            Spaces          -> PRS-PROCESS-LEVEL