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    TR201
TR205

UPDATED BY

TR06.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

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

TKD-EST-CMP-TIME     Numeric 3                                   TR06.1
Time to Complete     Contains 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 Timecomplete is measured.
                     Y = Years
                     M = Months
                     D = Days

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

TKD-SEQ              Numeric 3                                   TR06.1
Sequence Number      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  TR201
          TRACK

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