Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PATESTOVER


                            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     PA48.1


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PAV-COMPANY            Numeric 4                                 PA49.2
Element: Company Hr

PAV-EMPLOYEE           Numeric 9                                 PA49.2
Element: 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
Element: Test          Contains the test.

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

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

PAV-DATE-STAMP         Numeric 8  (yyyymmdd)                     PA49.2
Element: 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
Element: 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
Element: User

                         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

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

Paemployee     PAEMPLOYEE   Required

                            PAV-COMPANY     -> PEM-COMPANY
                            PAV-EMPLOYEE    -> PEM-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