Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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     TR26.1    DA113     DA13.1
PA115     TR113     TR114     TR13.1    TR13.2    TR15.1
TR21.1    TR22.1    TR222     TR500     HR04.2    HR04.3
HR04.7    HR04.8    HR80.1    HR80.2    HR80.3    HR80.4
HR80.5    HR80.6    HR80.7    HR80.8    HR80.9    HR81.1
HR81.2    HR81.3    HR81.4    HR81.5    HR81.6    HR81.7
HR81.8    HR81.9    HR82.1    HR82.2    HR82.3    HR82.4
HR82.5    HR82.6    HR82.7    HR82.8    HR82.9    HR83.1
HR83.2    HR83.3    HR83.4    HR83.5    HR83.6    HR83.7
HR83.8    HR83.9    HR84.1    HR84.2    HR84.3    HR84.4
HR84.5    HR84.6    HR84.7    HR84.8    HR84.9    HR85.1
HR85.2    HR85.3    HR85.4    HR85.5    HR85.6    HR85.7
HR85.8    HR86.1    HR86.2    HR86.3    HR86.4    HR86.5
HR86.6    HR86.7    HR86.8    HR86.9    HR87.1    HR87.2
HR87.3    HR87.4    HR87.5    HR87.6    HR87.7    HR87.8
HR87.9    HR88.1    HR88.2    HR88.3    HR88.4    HR88.5
HR88.6    HR88.7    HR89.1    HR89.2    HR89.3    HR89.4
HR89.5    HR89.6    HR89.7    TR03.1

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

TRA-CERT-SOURCE      Alpha 10
Cert Source          Indicates the certification source which
                      should be recorded on the employee
                     record (when the track is completed).

                         PATRACK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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

TRASET3   CERT-ACHIEVED KeyChange, Subset                        HR04.2  HR04.3
          TRACK         Where CERT-ACHIEVED != Spaces            HR04.7  HR04.8
          EFFECTIVE-DATE*                                        HR80.1  HR80.2
                                                                 HR80.3  HR80.4
                                                                 HR80.5  HR80.6
                                                                 HR80.7  HR80.8
                                                                 HR80.9  HR81.1
                                                                 HR81.2  HR81.3
                                                                 HR81.4  HR81.5
                                                                 HR81.6  HR81.7
                                                                 HR81.8  HR81.9
                                                                 HR82.1  HR82.2
                                                                 HR82.3  HR82.4
                                                                 HR82.5  HR82.6
                                                                 HR82.7  HR82.8
                                                                 ...

                         PATRACK FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cert Source    PCODES       Required
                            When TRA-CERT-SOURCE != Spaces

                            "CU"                 -> PCO-TYPE
                            TRA-CERT-SOURCE      -> PCO-CODE

Certificate    PCODES       Not Required
                            Valid When TRA-CERT-ACHIEVED != Spaces

                            "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