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
|