Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAEMPTRACK


                            PAEMPTRACK FILE

                           Required Training

Contains information about tracks and courses that employees are required to
take.

TR13.1 (Required Training by Track & Course) and TR13.2 (Required Training by
Employee - Track or Course) are the primary programs that update this file.

REFERENCED BY

TR120     TR121     TR20.1    TR20.2    TR20.3    TR201
TR222     TR05.1

UPDATED BY

TR113     TR114     TR13.1    TR13.2    TR15.1    TR21.1
TR22.1    TR500     HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ETR-COMPANY            Numeric 4                                 TR113   TR114
Element: Company       Contains the company number.              TR13.1  TR13.2
                                                                 TR15.1

ETR-EMPLOYEE           Numeric 9                                 TR113   TR114
Element: Employee      Contains the employee number. Each        TR13.1  TR13.2
                       person employed by the company is         TR15.1
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

ETR-TYPE               Alpha 2                                   TR113   TR114
Element: Type          Indicates whether the required training   TR13.1  TR13.2
                       is a course or a track.                   TR15.1
                       CS = Course
                       TR = Track

ETR-TRACK              Alpha 10                                  TR113   TR114
Element: Track or CoursContains the track or course code.        TR13.1  TR13.2
                                                                 TR15.1

ETR-START-DATE         Numeric 8  (yyyymmdd)                     TR113   TR114
Element: Effective DateContains the date the track or course     TR13.1  TR13.2
                       is assigned to the employee.              TR15.1

ETR-TRACK-STATUS       Alpha 1                                   TR113   TR114
Element: Status        Indicates whether the employee has        TR13.1  TR13.2
                       completed the track.                      TR15.1  TR21.1
                       C = Complete                              TR22.1  TR500
                       I = Incomplete; Default value
                       F = Fully completed
                       N = Completed without skills prof
                       S = Partially completed with skill
                       P = Partially completed - no skill

ETR-EXP-CMPLT-DATE     Numeric 8  (yyyymmdd)                     TR113   TR114
Estimated              Contains the estimated date for           TR13.1  TR13.2
Completion Date        completing the course or track.           TR15.1

ETR-END-DATE           Numeric 8  (yyyymmdd)                     TR13.1  TR13.2
Element: End Date      Contains the date the employee            TR15.1  TR21.1
                       completed the course or track.            TR22.1  TR500

                         PAEMPTRACK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ETRSET1   COMPANY                                                HR11.1  PA115
          EMPLOYEE                                               TR113   TR114
          TYPE                                                   TR120   TR121
          TRACK                                                  TR13.2  TR15.1
                                                                 TR20.1  TR20.2
                                                                 TR20.3  TR201
                                                                 TR21.1  TR22.1
                                                                 TR222   TR500

ETRSET3   TYPE                                                   TR05.1  TR13.1
          TRACK                                                  TR13.2  TR15.1
          COMPANY                                                TR201
          EMPLOYEE

                         PAEMPTRACK FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            ETR-COMPANY     -> PRS-COMPANY
                            Spaces          -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            ETR-COMPANY     -> EMP-COMPANY
                            ETR-EMPLOYEE    -> EMP-EMPLOYEE

Paemployee     PAEMPLOYEE   Required

                            ETR-COMPANY     -> PEM-COMPANY
                            ETR-EMPLOYEE    -> PEM-EMPLOYEE

                         PAEMPTRACK FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Course         PACOURSE
                            Valid When (ETR-TYPE = "CS" )

                            ETR-TRACK       -> CRS-COURSE
                                               CRS-EFFECTIVE-DATE

Track          PATRACK
                            Valid When (ETR-TYPE = "TR" )

                            ETR-TRACK       -> TRA-TRACK
                                               TRA-EFFECTIVE-DATE