Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            PATESTOVER FILE

Contains employee test override information. This file is maintained
primarily by PA49.2 (Employee Test Override).

REFERENCED BY

PA149     PA248     PA249     PA549     PA81.1

UPDATED BY

PA49.2    HR00.1    HR01.1    HR11.1    PA115     PBIP.1
PR197     PA48.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PAV-COMPANY          Numeric 4                                   PA49.2
Company              The company number represents an
                     established company and is entered on
                     all function codes.


PAV-EMPLOYEE         Numeric 9                                   PA49.2
Employee             Contains the employee number. Each
                     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.


PAV-TEST             Alpha 10                                    PA49.2
Test                 Contains the test.

PAV-REASON           Alpha 10                                    PA49.2
Reason               Contains the reason for the override.

PAV-ELIG-FLAG        Alpha 1                                     PA49.2
Elig Flag            Indicates whether the employee is
                     eligible or ineligible for the test.

PAV-DATE-STAMP       Numeric 8  (yyyymmdd)                       PA49.2
Date Stamp           This field contains the server date
                     (month, date, and year) of the last
                     change to this record.


PAV-TIME-STAMP       Numeric 6  (hhmmss)                         PA49.2
Time Stamp           Contains the server time (hour, minute,
                     and second) when the record was last
                     changed.

PAV-USER-ID          Alpha 10  (Lower Case)                      PA49.2
User ID Name         Contains the user ID of the person who
                     last changed this record.

                         PATESTOVER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PAVSET1   COMPANY                                                HR00.1  HR01.1
          EMPLOYEE                                               HR11.1  PA115
          TEST                                                   PA149   PA248
                                                                 PA249   PA49.1
                                                                 PA49.2  PA49.3
                                                                 PA549   PA81.1
                                                                 PBIP.1  PR197

PAVSET2   COMPANY                                                PA248   PA48.1
          TEST
          EMPLOYEE

                         PATESTOVER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PAV-COMPANY     -> PRS-COMPANY
                            Spaces          -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            PAV-COMPANY     -> EMP-COMPANY
                            PAV-EMPLOYEE    -> EMP-EMPLOYEE

Reason         PCODES       Required
                            When (PAV-REASON != Spaces )

                            "TE"            -> PCO-TYPE
                            PAV-REASON      -> PCO-CODE

Test           PATSTSETUP   Required

                            PAV-COMPANY     -> PAP-COMPANY
                            PAV-TEST        -> PAP-TEST