PATRACK FILE

                                 Tracks

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.

REFERENCED BY

TR06.1    TR201     TR205     PA115     TR113     TR114
TR13.1    TR13.2    TR15.1    TR21.1    TR22.1    TR222
TR500

UPDATED BY

TR05.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

TRA-TRACK            Alpha 10                                    TR05.1
Track                Contains the track name.

TRA-EFFECTIVE-DATE   Numeric 8  (yyyymmdd)                       TR05.1
Effective Date       Contains the date the track becomes
                     effective.

TRA-DESC             Alpha 30  (Lower Case)                      TR05.1  TR201
Track Description    Contains the track description.

TRA-END-DATE         Numeric 8  (yyyymmdd)                       TR05.1
End Date             Contains the ending date for the track.

TRA-EST-CMP-TIME     Numeric 3                                   TR05.1
Time to Complete     Contains the approximate time it should
Length               take to complete the track.

TRA-UNIT-VALUE       Alpha 1                                     TR05.1
Length/Unit of Time  Indicates the unit of time upon which
                     the estimated completion time is based.
                     D = Days
                     M = Months
                     Y = Years

TRA-CERT-ACHIEVED    Alpha 10                                    TR05.1
Certificate Achieved Contains the certificate earned when
                     the track is completed.

TRA-VALID-PERIOD     Numeric 3                                   TR05.1
Validation Period    Contains the length of time for which
Length               the certificate is valid.

TRA-UNIT-TYPE        Alpha 1                                     TR05.1
Length/Unit of Time  Indicates the unit in which the
                     certificate validation is measured.
                     Y = Years
                     M = Months
                     D = Days

                         PATRACK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TRASET1   TRACK                                                  TR05.1  TR06.1
          EFFECTIVE-DATE                                         TR201   TR205

TRASET2   TRACK                                                  PA115   TR05.1
          EFFECTIVE-DATE*                                        TR06.1  TR113
                                                                 TR114   TR13.1
                                                                 TR13.2  TR15.1
                                                                 TR21.1  TR22.1
                                                                 TR222   TR500

                         PATRACK FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Certificate    PCODES       Not Required

                            "CE"                 -> PCO-TYPE
                            TRA-CERT-ACHIEVED    -> PCO-CODE

                         PATRACK FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Detail         PATRACKDTL

                            TRA-TRACK            -> TKD-TRACK
                                                    TKD-COURSE

Employee       PAEMPTRACK   Delete Restricted

                            "T"                  -> ETR-TYPE
                            TRA-TRACK            -> ETR-TRACK
                                                    ETR-COMPANY
                                                    ETR-EMPLOYEE