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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ETRSET1
  1. COMPANY
  2. EMPLOYEE
  3. TYPE
  4. TRACK
PrimaryHR11.1, PA115, TR113, TR114, TR120, TR121, TR13.2, TR15.1 +9 more
ETRSET3
  1. TYPE
  2. TRACK
  3. COMPANY
  4. EMPLOYEE
TR05.1, TR13.1, TR13.2, TR15.1, TR201

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
ETR-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
ETR-COMPANY→EMP-COMPANY
ETR-EMPLOYEE→EMP-EMPLOYEE
PaemployeePAEMPLOYEERequired
ETR-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)