Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PATRNHIST


                             PATRNHIST FILE

                            Training History

Contains the dates, CEUs, status, and attributes of the courses each employee
completes. This information is updated by the Registration Information file
after one of the following status is selected in TR22.1 (Session Completion):
 - Fully Complete
 - Complte-No Skills
 - Part Complte-No Skl
 - Part Complte-Skills

TR21.1 (Employee Training History) is the primary program that accesses this
file.

REFERENCED BY

TR120     TR121     TR20.1    TR20.2    TR20.3    TR201
TR222     TR04.1    TR26.1

UPDATED BY

TR21.1    TR22.1    TR500     HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TRH-COMPANY            Numeric 4                                 TR21.1  TR22.1
Element: Company       Contains the company number.              TR500

TRH-EMPLOYEE           Numeric 9                                 TR21.1  TR22.1
Element: Employee      Contains the employee number.             TR500

TRH-COURSE             Alpha 10                                  TR21.1  TR22.1
Element: Course Code   Contains the course code.                 TR500

TRH-DATE-COMPLETED     Numeric 8  (yyyymmdd)                     TR21.1  TR22.1
Element: Completed     Contains the date the employee            TR500
                       completed the course.

TRH-COMPLETE-STATS     Alpha 1                                   TR21.1  TR22.1
Element: Completion StaContains the completion status.           TR500
                       F = Complete With Competencies
                       N = Complete With No Competencies
                       S = Partial With Competencies
                       P = Partial With No Competencies

TRH-CEU-AWARDED        Signed 5.2                                TR21.1  TR22.1
Element: CEU           Contains the number of CEUs awarded       TR500
                       when the employee completes the course.

TRH-RATING             Alpha 10                                  TR21.1  TR22.1
Element: Proficiency   Contains the proficiency level achieved   TR500
                       from the course.


TRH-OBJ-ID             Numeric 12                                TR21.1  TR22.1
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

                         PATRNHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TRHSET1   COMPANY                                                HR11.1  PA115
          EMPLOYEE                                               TR120   TR121
          COURSE                                                 TR20.1  TR20.2
          DATE-COMPLETED                                         TR20.3  TR201
                                                                 TR21.1  TR22.1
                                                                 TR222   TR500

TRHSET2   COURSE                                                 TR201
          COMPANY
          EMPLOYEE
          DATE-COMPLETED

TRHSET3   OBJ-ID        Subset                                   TR04.1  TR26.1
          COMPANY       Where OBJ-ID != Zeroes
          EMPLOYEE

                         PATRNHIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            TRH-COMPANY     -> PRS-COMPANY
                            Spaces          -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            TRH-COMPANY     -> EMP-COMPANY
                            TRH-EMPLOYEE    -> EMP-EMPLOYEE

Paemployee     PAEMPLOYEE   Required

                            TRH-COMPANY     -> PEM-COMPANY
                            TRH-EMPLOYEE    -> PEM-EMPLOYEE

Rating         PCODES       Required
                            When (TRH-RATING != Spaces )

                            "PF"            -> PCO-TYPE
                            TRH-RATING      -> PCO-CODE

Session        PASESSION    Required
                            When (TRH-OBJ-ID != Zeroes )

                            TRH-OBJ-ID      -> SES-OBJ-ID

                         PATRNHIST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Competency     EMPCODES     Delete Cascades
                            Valid When (TRH-OBJ-ID != Zeroes )

                            TRH-OBJ-ID      -> EPC-OBJ-ID
                            TRH-COMPANY     -> EPC-COMPANY
                            Zeroes          -> EPC-EMP-APP
                            TRH-EMPLOYEE    -> EPC-EMPLOYEE
                                               EPC-TYPE
                                               EPC-CODE

Cost           PAEMPCOSTS

                            TRH-COMPANY     -> EMC-COMPANY
                            TRH-EMPLOYEE    -> EMC-EMPLOYEE
                            TRH-COURSE      -> EMC-COURSE
                                               EMC-DATE
                                               EMC-COST-TYPE
                                               EMC-COST-CAT

Course         PACOURSE

                            TRH-COURSE      -> CRS-COURSE
                                               CRS-EFFECTIVE-DATE

Trackcourses   PATRACKDTL

                            TRH-COURSE      -> TKD-COURSE
                                               TKD-TRACK