PATRACKDTL – Track Courses

System
Personnel (PA)
Prefix
TKD
Primary key
TRACK, COURSE
Fields
8
Updated by
1 program
Referenced by
15 programs

PATRACKDTL is the Track Courses table in Lawson Personnel (prefix TKD). It is indexed by TRACK, COURSE (TKDSET1); alternate indexes: TKDSET2 and TKDSET3. It is related 1:M to PAATTRIB, PACOURSE, PATRACK and PATRNHIST. It is updated by TR06.1 and referenced by TR01.1, TR03.1, TR05.1, TR120, TR121, TR20.1, TR20.2, TR20.3 and 7 more. The table has 8 fields, 3 indexes and 4 documented relations.

About PATRACKDTL

Contains the courses defined for each track. TR06.1 is the primary program that updates this file.

Fields (8)

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

Field / columnTypeDescription & valuesUpdated by
TKD-TRACK PK
TRACK		Alpha 10Contains the track code.TR06.1
TKD-COURSE PK
COURSE		Alpha 10Contains the course code.TR06.1
TKD-EFFECTIVE-DATE
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)Contains the date a course is included in the track.TR06.1
TKD-END-DATE
END_DATE		Numeric 8 (yyyymmdd)Contains the last date the course is included in the track.TR06.1
TKD-EST-CMP-TIME
EST_CMP_TIME		Numeric 3Contains an estimate of the amount of time it takes to complete the course.TR06.1
TKD-UNIT-TYPE
UNIT_TYPE		Alpha 1Indicates the unit by which the time to complete is measured.
  • Y Years
  • M Months
  • D Days
TR06.1
TKD-REQUIRED-FLAG
REQUIRED_FLAG		Alpha 1Indicates whether the course is required for track completion.
  • Y Yes
  • N No
TR06.1
TKD-SEQ
SEQ		Numeric 3This field contains the record sequence number.TR06.1

Indexes (3)

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

IndexKeysFlagsConditionUsed in
TKDSET1TRACK, COURSEPrimaryTR05.1, TR06.1, TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4 +4 more
TKDSET2COURSE, TRACKTR01.1, TR03.1, TR201
TKDSET3TRACK, SEQ, COURSEKeyChangeTR06.1, TR205

Relations

One to many (4) — child tables

RelationTableRulesConditionField map
AttributesPAATTRIBTKD-COURSE → TRB-COURSE, → TRB-TYPE, → TRB-CODE
CoursePACOURSETKD-COURSE → CRS-COURSE, → CRS-EFFECTIVE-DATE
TrackPATRACKTKD-TRACK → TRA-TRACK, → TRA-EFFECTIVE-DATE
TrainingPATRNHISTTKD-COURSE → TRH-COURSE, → TRH-COMPANY, → TRH-EMPLOYEE, → TRH-DATE-COMPLETED

Programs

Updated by (1)

Referenced by (15)