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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#TKD-TRACK PKTRACK | Alpha 10 | Contains the track code. | TR06.1 |
#TKD-COURSE PKCOURSE | Alpha 10 | Contains the course code. | TR06.1 |
#TKD-EFFECTIVE-DATEEFFECTIVE_DATE | Numeric 8 (yyyymmdd) | Contains the date a course is included in the track. | TR06.1 |
#TKD-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | Contains the last date the course is included in the track. | TR06.1 |
#TKD-EST-CMP-TIMEEST_CMP_TIME | Numeric 3 | Contains an estimate of the amount of time it takes to complete the course. | TR06.1 |
#TKD-UNIT-TYPEUNIT_TYPE | Alpha 1 | Indicates the unit by which the time to complete is measured.
| TR06.1 |
#TKD-REQUIRED-FLAGREQUIRED_FLAG | Alpha 1 | Indicates whether the course is required for track completion.
| TR06.1 |
#TKD-SEQ SET3SEQ | Numeric 3 | This field contains the record sequence number. | TR06.1 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
TKDSET1 |
| Primary | TR05.1, TR06.1, TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4 +4 more | |
TKDSET2 |
| TR01.1, TR03.1, TR201 | ||
TKDSET3 |
| KeyChange | TR06.1, TR205 |
Relations
One to many (4) — child tables
Programs
Updated by (1)
- TR06.1 Track Courses
Referenced by (15)
- TR01.1 Course
- TR03.1 Course Certifications and Competencies
- TR05.1 Track
- TR120 Group Session Registration
- TR121 Job Code Session Registration
- TR20.1 Session Registration
- TR20.2 Mass Registration
- TR20.3 Session Registration Override
- TR20.4 Employee Session Registration
- TR201 Course Profile
- TR205 Track Listing
- TR21.1 Employee Training History
- TR22.1 Session Completion
- TR222 Employee Training Listing
- TR500 Training Conversion