Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

REVIEW


                              REVIEW FILE

                      Employee Performance Review

The Employee Performance Review file contains information pertaining to
employee performance reviews.

REFERENCED BY

HR90.1    PA345     PA370     BN234     HCDL.1    HCEM.1
HCHP.1    HR170     HR70.1    PA350     HS11.1    HS11.2
PA311

UPDATED BY

HR511     HS701     PA26.1    PA26.3    PA26.4    PA702
HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

REV-COMPANY            Numeric 4                                 HR511   HS701
Element: Company Hr    Contains the company number represents    PA26.1
                       an  established company.

REV-EMPLOYEE           Numeric 9                                 HR511   HS701
Element: Employee      Contains the employee number.             PA26.1

REV-SEQ-NBR            Numeric 4                                 HS701   PA26.1
Element: Seq Nbr       Review sequence number.  Assigned
                       automatically as review records are
                       created.

REV-SCHED-DATE         Numeric 8  (yyyymmdd)                     HR511   HS701
Element: Sched Date    This field contains the scheduled         PA26.1
                       review date.

REV-CODE               Alpha 10                                  HR511   HS701
Element: Code          This field contains the review type.      PA26.1
                       Valid review types must be setup in
                       PCODES.

REV-ACTUAL-DATE        Numeric 8  (yyyymmdd)                     HS701   PA26.1
Element: Actual Date   This field contains the actual review
                       date.

REV-RATING             Alpha 10                                  HS701   PA26.1
Element: Rating        This field contains the performance
                       rating.  Valid performance ratings must
                       be setup in PCODES.

REV-LAST-NAME          Alpha 30  (Lower Case)                    HS701   PA26.1
Element: Last Name     This field contains the last name of
                       person conducting the review.

REV-FIRST-NAME         Alpha 15  (Lower Case)                    HS701   PA26.1
Element: First Name    This field contains the first name of
                       person conducting the review.

REV-MIDDLE-INIT        Alpha 1                                   HS701   PA26.1
Element: Middle Init   This field contains the middle initial
                       of the person conducting the review.

REV-BY-EMPLOYEE        Numeric 9                                 HS701   PA26.1
Element: By Employee   This field contains the employee number
                       of person conducting the review.  Must
                       be a valid employee setup in EMPLOYEE.

REV-FULL-NAME          Derived
Element: Full Name

REV-DATE-STAMP         Numeric 8  (yyyymmdd)                     HR511   HS701
Element: Date Stamp    This field contains the server date       PA26.1
                       (month, date, and year) of the last
                       change to this record.

REV-TIME-STAMP         Numeric 6  (hhmmss)                       HR511   HS701
Element: Time Stamp    Contains the server time (hour, minute,   PA26.1
                       and second) when the record was last
                       changed.

REV-USER-ID            Alpha 10  (Lower Case)                    HR511   HS701
Element: User                                                    PA26.1

REV-LABEL-NAME         Derived
Element: Label Name

REV-MODEL-NAME         Alpha 10                                  HS701   PA26.1
Element: Model Name    This is a TVP integrated field value.
                       Employee will be evaluated under a
                       specific Model Name in the TVP product.

REV-PERCENTILE         Signed 7.4                                HS701   PA26.1
Element: Percentile    This is a TVP integrated field value.
                       Employee will be assigned a Performance
                       Percentile or Competency Ranking in the
                       TVP product.

REV-PERF-SCORE         Signed 7.4                                HS701   PA26.1
Element: Perf Score    This is a TVP integrated field value.
                       Employee will be assigned a Performance
                       Score in the TVP product with a value of
                       1.00  - 5.00.  This value needs to be
                       converted to a 1-100% value prior to
                       integrating into Lawson.  This value
                       will be used to calculate the Total
                       Overall Score on the Review.

REV-PERF-WEIGHTING     Signed 7.4                                HS701   PA26.1
Element: Perf WeightingThis is the weighting entered on the
                       employee's review.  It is used in the
                       Overall Score calculation.

REV-GOAL-SCORE         Signed 18.6                               HS701   PA26.1
Element: Goal Score    The Total Goal Score is computed from     PA26.3  PA26.4
                       adding the Individual Goal Scores and
                       dividing by the number of goals being
                       scored.  It is used in the Overall Score
                       calculation.

REV-GOAL-WEIGHTING     Signed 7.4                                HS701   PA26.1
Element: Goal WeightingThis weighting is entered on the
                       employee's review.  It is used in the
                       Overall Score calculation.

REV-TOTAL-SCORE        Signed 18.6                               HS701   PA26.1
Element: Total Score   The Total Score is calculated for the
                       employee's review.

REV-DESCRIPTION        Alpha 30  (Lower Case)                    HS701   PA26.1
Element: Description   This enterable user defined field is
                       used to further define or classify the
                       employee's review.

REV-REV-SCHEDULE       Alpha 2                                   HS701   PA26.1
Element: Rev Schedule  This identifies the frequency of the      PA702
                       performance reviews for the employee.
                       AN = Annual
                       MO = Monthly
                       QT = Quarterly
                       SA = Semi-Annual
                       9M = Nine Month

REV-NEXT-REVIEW        Numeric 8  (yyyymmdd)                     HS701   PA26.1
Element: Next Review   This is the date of the next scheduled    PA702
                       employee review.

REV-NEXT-REV-CODE      Alpha 10                                  HS701   PA26.1
Element: Next Rev Code This identifies the review type for the   PA702
                       next scheduled review.  It is defined as
                       a PCODE value.

REV-LAST-REVIEW        Numeric 8  (yyyymmdd)                     HR511   HS701
Element: Last Review   This contains the date of the employee's  PA26.1  PA702
                       last review.

REV-REVIEW-FLAG        Numeric 1                                 HS701   PA26.1
Element: Review Flag   This identifies whether the review
                       record was created by the TVP
                       integration.  TVP users will not be able
                       to enter data for the new Performance
                       field values that were integrated from
                       TVP on PA26.  This will be controlled
                       through edits.
                       1 = Interfaced Data

                         REVIEW FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

REVSET1   COMPANY                                                HR11.1  HR511
          EMPLOYEE                                               HR90.1  PA115
          SEQ-NBR                                                PA26.1  PA26.3
                                                                 PA26.4  PA702

REVSET2   COMPANY                                                PA26.1  PA345
          EMPLOYEE                                               PA370
          SCHED-DATE
          CODE
          SEQ-NBR

REVSET3   COMPANY       KeyChange                                BN234   HCDL.1
          EMPLOYEE                                               HCEM.1  HCHP.1
          ACTUAL-DATE                                            HR170   HR70.1
          SEQ-NBR                                                PA115   PA345
                                                                 PA350   PA370

REVSET4   COMPANY       KeyChange                                HS11.1  HS11.2
          EMPLOYEE                                               PA26.1  PA311
          ACTUAL-DATE*                                           PA702
          SEQ-NBR

REVSET5   COMPANY       KeyChange                                HS701
          EMPLOYEE
          SCHED-DATE*
          CODE
          SEQ-NBR

                         REVIEW FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

By Employee    EMPLOYEE     Required
                            When REV-BY-EMPLOYEE != Zeroes

                            REV-COMPANY        -> EMP-COMPANY
                            REV-BY-EMPLOYEE    -> EMP-EMPLOYEE

Company        PRSYSTEM     Required

                            REV-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            REV-COMPANY        -> EMP-COMPANY
                            REV-EMPLOYEE       -> EMP-EMPLOYEE

Pa Employee    PAEMPLOYEE   Required

                            REV-COMPANY        -> PEM-COMPANY
                            REV-EMPLOYEE       -> PEM-EMPLOYEE

Rating         PCODES       Required
                            When REV-RATING != Spaces

                            "PR"               -> PCO-TYPE
                            REV-RATING         -> PCO-CODE

Review Type    PCODES       Required
                            When REV-CODE != Spaces

                            "RT"               -> PCO-TYPE
                            REV-CODE           -> PCO-CODE

                         REVIEW FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Em Comments    PACOMMENTS   Delete Restricted

                            REV-COMPANY        -> PAC-COMPANY
                            Zeroes             -> PAC-EMP-APP
                            "RV"               -> PAC-CMT-TYPE
                            REV-EMPLOYEE       -> PAC-EMPLOYEE
                            Spaces             -> PAC-JOB-CODE
                            Spaces             -> PAC-ACTION-CODE
                            REV-SEQ-NBR        -> PAC-LN-NBR
                                                  PAC-SEQ-NBR

Emp Objective  PAEMPGOAL

                            REV-COMPANY        -> PGO-COMPANY
                            REV-EMPLOYEE       -> PGO-EMPLOYEE
                                                  PGO-SEQ-NBR

Review Detail  REVGOALDTL

                            REV-COMPANY        -> RVG-COMPANY
                            REV-EMPLOYEE       -> RVG-EMPLOYEE
                            REV-SEQ-NBR        -> RVG-REV-SEQ-NBR
                                                  RVG-GOAL-SEQ-NBR