PAEMPTRACK – Required Training

System
Personnel (PA)
Prefix
ETR
Primary key
COMPANY, EMPLOYEE, TYPE, TRACK
Fields
8
Updated by
10 programs
Referenced by
9 programs

PAEMPTRACK is the Required Training table in Lawson Personnel (prefix ETR). It is indexed by COMPANY, EMPLOYEE, TYPE, TRACK (ETRSET1); alternate indexes: ETRSET3. It is related 1:1 to PRSYSTEM, EMPLOYEE and PAEMPLOYEE and 1:M to PACOURSE and PATRACK. It is updated by HR11.1, PA115, TR113, TR114, TR13.1, TR13.2, TR15.1, TR21.1 and 2 more and referenced by TR05.1, TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4, TR201 and 1 more. The table has 8 fields, 2 indexes and 5 documented relations.

About PAEMPTRACK

Contains information about tracks and courses that employees are required to take. TR13.1 (Required Training by Track & Course) and TR13.2 (Required Training by Employee - Track or Course) are the primary programs that update this file.

Fields (8)

Column = COBOL field name without the ETR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ETR-COMPANY PK
COMPANY		Numeric 4Contains the company number.TR113, TR114, TR13.1, TR13.2, TR15.1
ETR-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.TR113, TR114, TR13.1, TR13.2, TR15.1
ETR-TYPE PK
TYPE		Alpha 2Indicates whether the required training is a course or a track.
  • CS Course
  • TR Track
TR113, TR114, TR13.1, TR13.2, TR15.1
ETR-TRACK PK
TRACK		Alpha 10Contains the track or course code.TR113, TR114, TR13.1, TR13.2, TR15.1
ETR-START-DATE
START_DATE		Numeric 8 (yyyymmdd)Contains the date the track or course is assigned to the employee.TR113, TR114, TR13.1, TR13.2, TR15.1
ETR-TRACK-STATUS
TRACK_STATUS		Alpha 1Indicates whether the employee has completed the track.
  • C Complete
  • I Incomplete; Default value
  • F Fully completed
  • N Completed without skills prof
  • S Partially completed with skill
  • P Partially completed - no skill
TR113, TR114, TR13.1, TR13.2, TR15.1, TR21.1, TR22.1, TR500
ETR-EXP-CMPLT-DATE
EXP_CMPLT_DATE		Numeric 8 (yyyymmdd)Contains the estimated date for completing the course or track.TR113, TR114, TR13.1, TR13.2, TR15.1
ETR-END-DATE
END_DATE		Numeric 8 (yyyymmdd)Contains the date the employee completed the course or track.TR13.1, TR13.2, TR15.1, TR21.1, TR22.1, TR500

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ETRSET1COMPANY, EMPLOYEE, TYPE, TRACKPrimaryHR11.1, PA115, TR113, TR114, TR120, TR121, TR13.2, TR15.1 +9 more
ETRSET3TYPE, TRACK, COMPANY, EMPLOYEETR05.1, TR13.1, TR13.2, TR15.1, TR201

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredETR-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredETR-COMPANY → EMP-COMPANY, ETR-EMPLOYEE → EMP-EMPLOYEE
PaemployeePAEMPLOYEERequiredETR-COMPANY → PEM-COMPANY, ETR-EMPLOYEE → PEM-EMPLOYEE

One to many (2) — child tables

RelationTableRulesConditionField map
CoursePACOURSEValid When (ETR-TYPE = "CS")ETR-TRACK → CRS-COURSE, → CRS-EFFECTIVE-DATE
TrackPATRACKValid When (ETR-TYPE = "TR")ETR-TRACK → TRA-TRACK, → TRA-EFFECTIVE-DATE

Programs

Updated by (10)

Referenced by (9)