REVIEW – Employee Performance Review

System
Personnel (PA)
Prefix
REV
Primary key
COMPANY, EMPLOYEE, SEQ-NBR
Fields
31
Updated by
11 programs
Referenced by
13 programs

REVIEW is the Employee Performance Review table in Lawson Personnel (prefix REV). It is indexed by COMPANY, EMPLOYEE, SEQ-NBR (REVSET1); alternate indexes: REVSET2, REVSET3, REVSET4 and REVSET5. It is related 1:1 to EMPLOYEE, PRSYSTEM, PAEMPLOYEE and PCODES and 1:M to PACOMMENTS, PAEMPGOAL and REVGOALDTL. It is updated by HR11.1, HR511, HS701, HS702, PA115, PA26.1, PA26.3, PA26.4 and 3 more and referenced by BN234, HCDL.1, HCEM.1, HCHP.1, HR170, HR70.1, HR90.1, HS11.1 and 5 more. The table has 31 fields, 5 indexes and 9 documented relations.

About REVIEW

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

Fields (31)

Column = COBOL field name without the REV- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#REV-COMPANY PK
COMPANY		Numeric 4Contains the company number represents an established company.HR511, HS701, HS702, PA26.1, PA526
#REV-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number.HR511, HS701, HS702, PA26.1, PA526
#REV-SEQ-NBR PK
SEQ_NBR		Numeric 4Review sequence number. Assigned automatically as review records are created.HS701, HS702, PA26.1, PA526
#REV-SCHED-DATE SET2 SET5
SCHED_DATE		Numeric 8 (yyyymmdd)This field contains the scheduled review date.HR511, HS701, HS702, PA26.1, PA526
#REV-CODE SET2 SET5
CODE		Alpha 10This field contains the review type. Valid review types must be setup in PCODES.HR511, HS701, HS702, PA26.1, PA526
#REV-ACTUAL-DATE SET3 SET4
ACTUAL_DATE		Numeric 8 (yyyymmdd)This field contains the actual review date.HS701, HS702, PA26.1, PA526
#REV-RATING
RATING		Alpha 10This field contains the performance rating. Valid performance ratings must be setup in PCODES.HS701, HS702, PA26.1, PA526
#REV-LAST-NAME
LAST_NAME		Alpha 30 (Lower Case)This field contains the last name of person conducting the review.HS701, HS702, PA26.1, PA526
#REV-FIRST-NAME
FIRST_NAME		Alpha 15 (Lower Case)This field contains the first name of person conducting the review.HS701, HS702, PA26.1, PA526
#REV-MIDDLE-INIT
MIDDLE_INIT		Alpha 1This field contains the middle initial of the person conducting the review.HS701, HS702, PA26.1, PA526
#REV-BY-EMPLOYEE
BY_EMPLOYEE		Numeric 9This field contains the employee number of person conducting the review. Must be a valid employee setup in EMPLOYEE.HS701, HS702, PA26.1, PA526
#REV-FULL-NAME
FULL_NAME		Derived——
#REV-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.HR511, HS701, HS702, PA26.1, PA526
#REV-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.HR511, HS701, HS702, PA26.1, PA526
#REV-USER-ID
USER_ID		Alpha 10 (Lower Case)—HR511, HS701, HS702, PA26.1, PA526
#REV-LABEL-NAME
LABEL_NAME		Derived——
#REV-MODEL-NAME
MODEL_NAME		Alpha 10This is a TVP integrated field value. Employee will be evaluated under a specific Model Name in the TVP product.HS701, HS702, PA26.1, PA526
#REV-PERCENTILE
PERCENTILE		Signed 7.4This is a TVP integrated field value. Employee will be assigned a Performance Percentile or Competency Ranking in the TVP product.HS701, HS702, PA26.1, PA526
#REV-PERF-SCORE
PERF_SCORE		Signed 7.4This 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.HS701, HS702, PA26.1, PA526
#REV-PERF-WEIGHTING
PERF_WEIGHTING		Signed 7.4This is the weighting entered on the employee's review. It is used in the Overall Score calculation.HS701, HS702, PA26.1, PA526
#REV-GOAL-SCORE
GOAL_SCORE		Signed 18.6The Total Goal Score is computed from adding the Individual Goal Scores and dividing by the number of goals being scored. It is used in the Overall Score calculation.HS701, HS702, PA26.1, PA26.3, PA26.4, PA526
#REV-GOAL-WEIGHTING
GOAL_WEIGHTING		Signed 7.4This weighting is entered on the employee's review. It is used in the Overall Score calculation.HS701, HS702, PA26.1, PA526
#REV-TOTAL-SCORE
TOTAL_SCORE		Signed 18.6The Total Score is calculated for the employee's review.HS701, HS702, PA26.1, PA526
#REV-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This enterable user defined field is used to further define or classify the employee's review.HS701, HS702, PA26.1, PA526
#REV-REV-SCHEDULE
REV_SCHEDULE		Alpha 2This identifies the frequency of the performance reviews for the employee.
  • AN Annual
  • MO Monthly
  • QT Quarterly
  • SA Semi-Annual
  • 9M Nine Month
HS701, HS702, PA26.1, PA526
#REV-NEXT-REVIEW
NEXT_REVIEW		Numeric 8 (yyyymmdd)This is the date of the next scheduled employee review.HS701, HS702, PA26.1, PA526
#REV-NEXT-REV-CODE
NEXT_REV_CODE		Alpha 10This identifies the review type for the next scheduled review. It is defined as a PCODE value.HS701, HS702, PA26.1, PA526
#REV-LAST-REVIEW
LAST_REVIEW		Numeric 8 (yyyymmdd)This contains the date of the employee's last review.HR511, HS701, HS702, PA26.1, PA526
#REV-REVIEW-FLAG
REVIEW_FLAG		Numeric 1This 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
HS701, HS702, PA26.1, PA526
#REV-APPRVL-STATUS
APPRVL_STATUS		Numeric 1This new field with different approval statuses will provide an approval sign off process for a review.
  • 0 No Approval
  • 1 Manager Approval
  • 2 Employee Approval
  • 3 Final Approval
—
#REV-AUTO-ADD-REV
AUTO_ADD_REV		Numeric 1Auto Add Rev on PA26 will allow the client to determine whether they want reviews to be added automatically based on the next review date or want to add those reviews themselves manually.
  • 1 No
  • 2 Yes
—

Indexes (5)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
REVSET1
  1. COMPANY
  2. EMPLOYEE
  3. SEQ-NBR
PrimaryHR11.1, HR511, HR90.1, ZH500, PA115, PA26.1, PA26.3, PA26.4 +1 more
REVSET2
  1. COMPANY
  2. EMPLOYEE
  3. SCHED-DATE
  4. CODE
  5. SEQ-NBR
HS702, PA26.1, PA345, PA370, PA526
REVSET3
  1. COMPANY
  2. EMPLOYEE
  3. ACTUAL-DATE
  4. SEQ-NBR
KeyChangeBN234, HCDL.1, HCEM.1, HCHP.1, HR170, HR70.1, PA115, PA350 +1 more
REVSET4
  1. COMPANY
  2. EMPLOYEE
  3. ACTUAL-DATE ↓
  4. SEQ-NBR
KeyChangeHS11.1, HS11.2, PA26.1, PA311, PA345, PA526
REVSET5
  1. COMPANY
  2. EMPLOYEE
  3. SCHED-DATE ↓
  4. CODE
  5. SEQ-NBR
KeyChangeHS701, HS702

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
EMPLOYEEPRSYSTEMPAEMPLOYEEPCODESPACOMMENTSPAEMPGOALREVGOALDTLREVIEW

One to one (6) — lookups and parents

RelationTableRulesConditionField map
By EmployeeEMPLOYEERequiredWhen REV-BY-EMPLOYEE != Zeroes
REV-COMPANY→EMP-COMPANY
REV-BY-EMPLOYEE→EMP-EMPLOYEE
CompanyPRSYSTEMRequired
REV-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
REV-COMPANY→EMP-COMPANY
REV-EMPLOYEE→EMP-EMPLOYEE
Pa EmployeePAEMPLOYEERequired
REV-COMPANY→PEM-COMPANY
REV-EMPLOYEE→PEM-EMPLOYEE
RatingPCODESRequiredWhen REV-RATING != Spaces
"PR"→PCO-TYPE
REV-RATING→PCO-CODE
Review TypePCODESRequiredWhen REV-CODE != Spaces
"RT"→PCO-TYPE
REV-CODE→PCO-CODE

One to many (3) — child tables

RelationTableRulesConditionField map
Em CommentsPACOMMENTSDelete 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
—→PAC-DATE
Emp ObjectivePAEMPGOAL
REV-COMPANY→PGO-COMPANY
REV-EMPLOYEE→PGO-EMPLOYEE
—→PGO-SEQ-NBR
Review DetailREVGOALDTL
REV-COMPANY→RVG-COMPANY
REV-EMPLOYEE→RVG-EMPLOYEE
REV-SEQ-NBR→RVG-REV-SEQ-NBR
—→RVG-GOAL-SEQ-NBR

Programs

Updated by (11)

Referenced by (13)