PATSTRESLT FILE

                              Test Results

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

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

                         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