Contains the dates, CEUs, status, and attributes of the courses each employee completes. This information is updated by the Registration Information file after one of the following status is selected in TR22.1 (Session Completion): - Fully Complete - Complte-No Skills - Part Complte-No Skl - Part Complte-Skills TR21.1 (Employee Training History) is the primary program that accesses this file.
Fields (8)
Column = COBOL field name without the TRH- 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.
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
TR21.1, TR22.1
Indexes (5)
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
TRHSET1
COMPANY
EMPLOYEE
COURSE
DATE-COMPLETED
Primary
HR11.1, PA115, TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4 +5 more
TRHSET2
COURSE
COMPANY
EMPLOYEE
DATE-COMPLETED
TR201
TRHSET3
OBJ-ID
COMPANY
EMPLOYEE
Subset
Where OBJ-ID != Zeroes
TR04.1, TR26.1
TRHSET4
COMPANY
EMPLOYEE
DATE-COMPLETED↓
COURSE
—
TRHSET5
COMPANY
EMPLOYEE
COURSE
DATE-COMPLETED↓
—
Relations
Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
