Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PATRACK


                              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    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    HR89.8    HR89.9    HR91.7    TR03.1

UPDATED BY

TR05.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

TRA-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     TR05.1
Element: Effective DateContains the date the track becomes
                       effective.

TRA-DESC               Alpha 30  (Lower Case)                    TR05.1  TR201
Element: Track DescriptContains the track description.

TRA-END-DATE           Numeric 8  (yyyymmdd)                     TR05.1
Element: 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
Element: Length/Unit ofIndicates 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
Element: Certificate AcContains 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
Element: Length/Unit ofIndicates the unit in which the
                       certificate validation is measured.
                       Y = Years
                       M = Months
                       D = Days

TRA-CERT-SOURCE        Alpha 10
Element: 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                                                  PA115   TR05.1
          EFFECTIVE-DATE*                                        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       Required
                            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

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