PATRNHIST – Training History

System: Personnel (PA)
Prefix: TRH
Primary key: COMPANY, EMPLOYEE, COURSE, DATE-COMPLETED
Fields: 8
Updated by: 5 programs
Referenced by: 10 programs

PATRNHIST is the Training History table in Lawson Personnel (prefix TRH). It is indexed by COMPANY, EMPLOYEE, COURSE, DATE-COMPLETED (TRHSET1); alternate indexes: TRHSET2, TRHSET3, TRHSET4 and TRHSET5. It is related 1:1 to PRSYSTEM, EMPLOYEE, PAEMPLOYEE, PCODES and PASESSION and 1:M to EMPCODES, PAEMPCOSTS, PACOURSE and PATRACKDTL. It is updated by HR11.1, PA115, TR21.1, TR22.1 and TR500 and referenced by TR04.1, TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4, TR201 and 2 more. The table has 8 fields, 5 indexes and 9 documented relations.

About PATRNHIST

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.

Field / column	Type	Description & values	Updated by
`TRH-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	TR21.1, TR22.1, TR500
`TRH-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number.	TR21.1, TR22.1, TR500
`TRH-COURSE` PK COURSE	Alpha 10	Contains the course code.	TR21.1, TR22.1, TR500
`TRH-DATE-COMPLETED` PK DATE_COMPLETED	Numeric 8 (yyyymmdd)	Contains the date the employee completed the course.	TR21.1, TR22.1, TR500
`TRH-COMPLETE-STATS` COMPLETE_STATS	Alpha 1	Contains the completion status. `F` Complete With Competencies `N` Complete With No Competencies `S` Partial With Competencies `P` Partial With No Competencies	TR21.1, TR22.1, TR500
`TRH-CEU-AWARDED` CEU_AWARDED	Signed 5.2	Contains the number of CEUs awarded when the employee completes the course.	TR21.1, TR22.1, TR500
`TRH-RATING` RATING	Alpha 10	Contains the proficiency level achieved from the course.	TR21.1, TR22.1, TR500
`TRH-OBJ-ID` OBJ_ID	Numeric 12	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 marked * are descending. 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

One to one (5) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required		`TRH-COMPANY` → `PRS-COMPANY (PRSSET1)`, `Spaces` → `PRS-PROCESS-LEVEL`
Employee	EMPLOYEE	Required		`TRH-COMPANY` → `EMP-COMPANY`, `TRH-EMPLOYEE` → `EMP-EMPLOYEE`
Paemployee	PAEMPLOYEE	Required		`TRH-COMPANY` → `PEM-COMPANY`, `TRH-EMPLOYEE` → `PEM-EMPLOYEE`
Rating	PCODES	Required	When (TRH-RATING != Spaces)	`"PF"` → `PCO-TYPE`, `TRH-RATING` → `PCO-CODE`
Session	PASESSION	Required	When (TRH-OBJ-ID != Zeroes)	`TRH-OBJ-ID` → `SES-OBJ-ID`

One to many (4) — child tables

Relation	Table	Rules	Condition	Field map
Competency	EMPCODES	Delete Cascades	Valid When (TRH-OBJ-ID != Zeroes)	`TRH-OBJ-ID` → `EPC-OBJ-ID`, `TRH-COMPANY` → `EPC-COMPANY`, `Zeroes` → `EPC-EMP-APP`, `TRH-EMPLOYEE` → `EPC-EMPLOYEE`, → `EPC-TYPE`, → `EPC-CODE`
Cost	PAEMPCOSTS			`TRH-COMPANY` → `EMC-COMPANY`, `TRH-EMPLOYEE` → `EMC-EMPLOYEE`, `TRH-COURSE` → `EMC-COURSE`, → `EMC-DATE`, → `EMC-COST-TYPE`, → `EMC-COST-CAT`
Course	PACOURSE			`TRH-COURSE` → `CRS-COURSE`, → `CRS-EFFECTIVE-DATE`
Trackcourses	PATRACKDTL			`TRH-COURSE` → `TKD-COURSE`, → `TKD-TRACK`

Programs

Updated by (5)

HR11.1 Employee
PA115 Employee Purge
TR21.1 Employee Training History
TR22.1 Session Completion
TR500 Training Conversion

Referenced by (10)

TR04.1 Session
TR120 Group Session Registration
TR121 Job Code Session Registration
TR20.1 Session Registration
TR20.2 Mass Registration
TR20.3 Session Registration Override
TR20.4 Employee Session Registration
TR201 Course Profile
TR222 Employee Training Listing
TR26.1 Employee Training Competency Maintenance