PATSTRESLT – Contains test results.

System: Personnel (PA)
Prefix: PTR
Primary key: COMPANY, TEST, CODE
Fields: 8
Updated by: 4 programs
Referenced by: 8 programs

PATSTRESLT is the Contains test results. table in Lawson Personnel (prefix PTR). It is indexed by COMPANY, TEST, CODE (PTRSET1). It is related 1:1 to PRSYSTEM and PATSTSETUP. It is updated by HR00.1, HR01.1, PA48.1 and PA48.2 and referenced by PA149, PA248, PA249, PA349, PA49.1, PA49.3, PA549 and PA81.2. The table has 8 fields, 1 index and 2 documented relations.

About PATSTRESLT

Contains test results.

Fields (8)

Column = COBOL field name without the PTR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`PTR-COMPANY` PK COMPANY	Numeric 4	—	PA48.1, PA48.2
#`PTR-TEST` PK TEST	Alpha 10	Contains the test.	PA48.1, PA48.2
#`PTR-CODE` PK CODE	Alpha 10	Contains the code for the test result.	PA48.1, PA48.2
#`PTR-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	Contains the test result description.	PA48.1, PA48.2
#`PTR-ACTIVE-FLAG` ACTIVE_FLAG	Alpha 1	Indicates whether the result is active or inactive. `A` Active `I` Inactive	PA48.1, PA48.2
#`PTR-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	PA48.1, PA48.2
#`PTR-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	PA48.1, PA48.2
#`PTR-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	PA48.1, PA48.2

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PTRSET1`	`COMPANY` `TEST` `CODE`	Primary		HR00.1, HR01.1, PA149, PA248, PA249, PA349, PA48.1, PA48.2 +4 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (2) — lookups and parents

Relation Table Rules Condition Field map

Company

PRSYSTEM

Required

`PTR-COMPANY`	→	`PRS-COMPANY`
`Spaces`	→	`PRS-PROCESS-LEVEL`

Test

PATSTSETUP

Required

`PTR-COMPANY`	→	`PAP-COMPANY`
`PTR-TEST`	→	`PAP-TEST`

Programs

Updated by (4)

HR00.1 Company
HR01.1 Process Level
PA48.1 Test Setup
PA48.2 Test Results

Referenced by (8)

PA149 Update Scheduled Tests
PA248 Test Listing
PA249 Employee and Applicant Test Listing
PA349 Employee and Applicant Test Purge
PA49.1 Employee Tests
PA49.3 Applicant Tests
PA549 Employee and Applicant Test Conversion
PA81.2 Test Inquiry

PATSTRESLT – Contains test results.

About PATSTRESLT

Fields (8) Copy as SQL

Indexes (1)

Relations

One to one (2) — lookups and parents

Programs

Updated by (4)

Referenced by (8)

Fields (8)