PATRACK – Tracks

System
Personnel (PA)
Prefix
TRA
Primary key
TRACK, EFFECTIVE-DATE
Fields
10
Updated by
1 program
Referenced by
110 programs

PATRACK is the Tracks table in Lawson Personnel (prefix TRA). It is indexed by TRACK, EFFECTIVE-DATE (TRASET1); alternate indexes: TRASET2 and TRASET3. It is related 1:1 to PCODES and 1:M to PATRACKDTL and PAEMPTRACK. It is updated by TR05.1 and referenced by HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 and 102 more. The table has 10 fields, 3 indexes and 4 documented relations.

About PATRACK

Contains track definition information such as the name, description, effective dates, and certificates earned upon completion. TA05.1 (Track) is the primary program that updates this file.

Fields (10)

Column = COBOL field name without the TRA- 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
#TRA-TRACK PK
TRACK		Alpha 10Contains the track name.TR05.1
#TRA-EFFECTIVE-DATE PK
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)Contains the date the track becomes effective.TR05.1
#TRA-DESC
DESC		Alpha 30 (Lower Case)Contains the track description.TR05.1, TR201
#TRA-END-DATE
END_DATE		Numeric 8 (yyyymmdd)Contains the ending date for the track.TR05.1
#TRA-EST-CMP-TIME
EST_CMP_TIME		Numeric 3Contains the approximate time it should take to complete the track.TR05.1
#TRA-UNIT-VALUE
UNIT_VALUE		Alpha 1Indicates the unit of time upon which the estimated completion time is based.
  • D Days
  • M Months
  • Y Years
TR05.1
#TRA-CERT-ACHIEVED SET3
CERT_ACHIEVED		Alpha 10Contains the certificate earned when the track is completed.TR05.1
#TRA-VALID-PERIOD
VALID_PERIOD		Numeric 3Contains the length of time for which the certificate is valid.TR05.1
#TRA-UNIT-TYPE
UNIT_TYPE		Alpha 1Indicates the unit in which the certificate validation is measured.
  • Y Years
  • M Months
  • D Days
TR05.1
#TRA-CERT-SOURCE
CERT_SOURCE		Alpha 10Indicates the certification source which should be recorded on the employee record (when the track is completed).—

Indexes (3)

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
TRASET1
  1. TRACK
  2. EFFECTIVE-DATE
PrimaryTR05.1, TR06.1, TR201, TR205, TR26.1
TRASET2
  1. TRACK
  2. EFFECTIVE-DATE ↓
PA115, TR05.1, TR06.1, TR113, TR114, TR13.1, TR13.2, TR15.1 +4 more
TRASET3
  1. CERT-ACHIEVED
  2. TRACK
  3. EFFECTIVE-DATE ↓
KeyChange, SubsetWhere CERT-ACHIEVED != SpacesHR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +22 more (list truncated in source)

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
Cert SourcePCODESRequiredWhen TRA-CERT-SOURCE != Spaces
"CU"→PCO-TYPE
TRA-CERT-SOURCE→PCO-CODE
CertificatePCODESRequiredWhen TRA-CERT-ACHIEVED != Spaces
"CE"→PCO-TYPE
TRA-CERT-ACHIEVED→PCO-CODE

One to many (2) — child tables

RelationTableRulesConditionField map
DetailPATRACKDTL
TRA-TRACK→TKD-TRACK
—→TKD-COURSE
EmployeePAEMPTRACKDelete Restricted
"TR"→ETR-TYPE
TRA-TRACK→ETR-TRACK
—→ETR-COMPANY
—→ETR-EMPLOYEE

Programs

Updated by (1)

Referenced by (110)