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

HR650     HR90.1    HR511     PA345     PA370     HCEM.1
HCOP.1    HCOP.2    HR170     HR70.1    HS11.1    PA311
PA350

UPDATED BY

PA26.1    HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

REV-SEQ-NBR            Numeric 4                                 PA26.1
Element: Sequence NumbeReview sequence number.  Assigned
                       automatically as review records are
                       created.

REV-SCHED-DATE         Numeric 8  (yyyymmdd)                     PA26.1
Element: Scheduled DateThis field contains the scheduled
                       review date.

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

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

REV-RATING             Alpha 10                                  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)                    PA26.1
Element: Name          This field contains the last name of
                       person conducting the review.

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

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

REV-BY-EMPLOYEE        Numeric 9                                 PA26.1
Element: Employee RevieThis 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)                     PA26.1
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

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

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

REV-LABEL-NAME         Derived
Element: Label Name

                         REVIEW FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

REVSET1   COMPANY                                                HR650   HR90.1
          EMPLOYEE
          SEQ-NBR

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

REVSET3   COMPANY       KeyChange                                HCEM.1  HCOP.1
          EMPLOYEE                                               HCOP.2  HR11.1
          ACTUAL-DATE                                            HR170   HR70.1
          SEQ-NBR                                                HS11.1  PA115
                                                                 PA26.1  PA311
                                                                 PA345   PA350
                                                                 PA370

                         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

                            "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