Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            PATSTRESLT FILE

Contains test results.

REFERENCED BY

PA149     PA248     PA249     PA349     PA49.1    PA49.3
PA549     PA81.2

UPDATED BY

PA48.1    PA48.2    HR00.1    HR01.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

PTR-TEST             Alpha 10                                    PA48.1  PA48.2
Test                 Contains the test.

PTR-CODE             Alpha 10                                    PA48.1  PA48.2
Code                 Contains the code for the test result.

PTR-DESCRIPTION      Alpha 30  (Lower Case)                      PA48.1  PA48.2
Description          Contains the test result description.

PTR-ACTIVE-FLAG      Alpha 1                                     PA48.1  PA48.2
Status               Indicates whether the result is active
                     or inactive.
                     A = Active
                     I = Inactive

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

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

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

                         PATSTRESLT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PTRSET1   COMPANY                                                HR00.1  HR01.1
          TEST                                                   PA149   PA248
          CODE                                                   PA249   PA349
                                                                 PA48.1  PA48.2
                                                                 PA49.1  PA49.3
                                                                 PA549   PA81.2
                                                                 PR197

                         PATSTRESLT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PTR-COMPANY    -> PRS-COMPANY
                            Spaces         -> PRS-PROCESS-LEVEL

Test           PATSTSETUP   Required

                            PTR-COMPANY    -> PAP-COMPANY
                            PTR-TEST       -> PAP-TEST