Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PATSTRESLT


                            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    PBIP.1    PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PTR-COMPANY            Numeric 4                                 PA48.1  PA48.2
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.

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

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

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

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

PTR-DATE-STAMP         Numeric 8  (yyyymmdd)                     PA48.1  PA48.2
Element: 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
Element: 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
Element: User          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
                                                                 PBIP.1  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