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.

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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TRASET1TRACK, EFFECTIVE-DATEPrimaryTR05.1, TR06.1, TR201, TR205, TR26.1
TRASET2TRACK, EFFECTIVE-DATE*PA115, TR05.1, TR06.1, TR113, TR114, TR13.1, TR13.2, TR15.1 +4 more
TRASET3CERT-ACHIEVED, TRACK, 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

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
DetailPATRACKDTLTRA-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)