Lawson Insight Technical Documentation

                            PATRACKDTL FILE

                             Track Courses

Contains the courses defined for each track.

TR06.1 is the primary program that updates this file.

REFERENCED BY

TR05.1    TR120     TR121     TR20.1    TR20.2    TR20.3
TR21.1    TR22.1    TR222     TR500     TR01.1    TR03.1
TR201     TR205

UPDATED BY

TR06.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TKD-TRACK              Alpha 10                                  TR06.1
Element: Track         Contains the track code.

TKD-COURSE             Alpha 10                                  TR06.1
Element: Course Code   Contains the course code.

TKD-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     TR06.1
Element: Start Date    Contains the date a course is included
                       in the track.

TKD-END-DATE           Numeric 8  (yyyymmdd)                     TR06.1
Element: End Date      Contains the last date the course is
                       included in the track.

TKD-EST-CMP-TIME       Numeric 3                                 TR06.1
Element: Time to CompleContains an estimate of the amount of
                       time it takes to complete the course.

TKD-UNIT-TYPE          Alpha 1                                   TR06.1
Time to                Indicates the unit by which the time to
Complete/Unit of Time  complete is measured.
                       Y = Years
                       M = Months
                       D = Days

TKD-REQUIRED-FLAG      Alpha 1                                   TR06.1
Element: Required      Indicates whether the course is
                       required for track completion.
                       Y = Yes
                       N = No

TKD-SEQ                Numeric 3                                 TR06.1
Element: Seq           This field contains the record sequence
                       number.

                         PATRACKDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TKDSET1   TRACK                                                  TR05.1  TR06.1
          COURSE                                                 TR120   TR121
                                                                 TR20.1  TR20.2
                                                                 TR20.3  TR21.1
                                                                 TR22.1  TR222
                                                                 TR500

TKDSET2   COURSE                                                 TR01.1  TR03.1
          TRACK                                                  TR201

TKDSET3   TRACK         KeyChange                                TR06.1  TR205
          SEQ
          COURSE

                         PATRACKDTL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Attributes     PAATTRIB

                            TKD-COURSE    -> TRB-COURSE
                                             TRB-TYPE
                                             TRB-CODE

Course         PACOURSE

                            TKD-COURSE    -> CRS-COURSE
                                             CRS-EFFECTIVE-DATE

Track          PATRACK

                            TKD-TRACK     -> TRA-TRACK
                                             TRA-EFFECTIVE-DATE

Training       PATRNHIST

                            TKD-COURSE    -> TRH-COURSE
                                             TRH-COMPANY
                                             TRH-EMPLOYEE
                                             TRH-DATE-COMPLETED