REVIEW

Employee Performance Review

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

REFERENCED BY
HR90.1 PA311


UPDATED BY
HR511 HS701 HS702 PA26.1 PA26.3 PA26.4
PA526 PA702 HR11.1 PA115 PA345 BN234
HCDL.1 HCEM.1 HCHP.1 HR170 HR70.1 PA350
PA370 HS11.1 HS11.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REV-COMPANY
Element: Company Hr
Numeric 4
Contains the company number represents an established company.
HR511 HS701
HS702 PA26.1
PA526
REV-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee number.
HR511 HS701
HS702 PA26.1
PA526
REV-SEQ-NBR
Element: Seq Nbr
Numeric 4
Review sequence number. Assigned automatically as review records are created.
HS701 HS702
PA26.1 PA526
REV-SCHED-DATE
Element: Sched Date
Numeric 8 (yyyymmdd)
This field contains the scheduled review date.
HR511 HS701
HS702 PA26.1
PA526
REV-CODE
Element: Code
Alpha 10
This field contains the review type. Valid review types must be setup in PCODES.
HR511 HS701
HS702 PA26.1
PA526
REV-ACTUAL-DATE
Element: Actual Date
Numeric 8 (yyyymmdd)
This field contains the actual review date.
HS701 HS702
PA26.1 PA526
REV-RATING
Element: Rating
Alpha 10
This field contains the performance rating. Valid performance ratings must be setup in PCODES.
HS701 HS702
PA26.1 PA526
REV-LAST-NAME
Element: 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
Element: 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
Element: Middle Init
Alpha 1
This field contains the middle initial of the person conducting the review.
HS701 HS702
PA26.1 PA526
REV-BY-EMPLOYEE
Element: By Employee
Numeric 9
This 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
Element: Full Name
Derived
REV-DATE-STAMP
Element: 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
Element: 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
Element: User
Alpha 10 (Lower Case)
HR511 HS701
HS702 PA26.1
PA526
REV-LABEL-NAME
Element: Label Name
Derived
REV-MODEL-NAME
Element: Model Name
Alpha 10
This 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
Element: Percentile
Signed 7.4
This 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
Element: Perf Score
Signed 7.4
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.
HS701 HS702
PA26.1 PA526
REV-PERF-WEIGHTING
Element: Perf Weighting
Signed 7.4
This 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
Element: Goal Score
Signed 18.6
The 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
Element: Goal Weighting
Signed 7.4
This weighting is entered on the employee's review. It is used in the Overall Score calculation.
HS701 HS702
PA26.1 PA526
REV-TOTAL-SCORE
Element: Total Score
Signed 18.6
The Total Score is calculated for the employee's review.
HS701 HS702
PA26.1 PA526
REV-DESCRIPTION
Element: 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
Element: Rev Schedule
Alpha 2
This 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
PA702
REV-NEXT-REVIEW
Element: Next Review
Numeric 8 (yyyymmdd)
This is the date of the next scheduled employee review.
HS701 HS702
PA26.1 PA526
PA702
REV-NEXT-REV-CODE
Element: Next Rev Code
Alpha 10
This identifies the review type for the next scheduled review. It is defined as a PCODE value.
HS701 HS702
PA26.1 PA526
PA702
REV-LAST-REVIEW
Element: Last Review
Numeric 8 (yyyymmdd)
This contains the date of the employee's last review.
HR511 HS701
HS702 PA26.1
PA526 PA702
REV-REVIEW-FLAG
Element: Review Flag
Numeric 1
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
HS701 HS702
PA26.1 PA526
REV-APPRVL-STATUS
Element: Status
Numeric 1
This 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
Element: Auto Add Rev
Numeric 1
Auto 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


REVIEW FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
REVSET1 COMPANY
EMPLOYEE
SEQ-NBR
HR11.1 HR511
HR90.1 PA115
PA26.1 PA26.3
PA26.4 PA702
REVSET2 COMPANY
EMPLOYEE
SCHED-DATE
CODE
SEQ-NBR
HS702 PA26.1
PA345 PA526
REVSET3 COMPANY
EMPLOYEE
ACTUAL-DATE
SEQ-NBR
KeyChange
BN234 HCDL.1
HCEM.1 HCHP.1
HR170 HR70.1
PA115 PA350
PA370
REVSET4 COMPANY
EMPLOYEE
ACTUAL-DATE*
SEQ-NBR
KeyChange
HS11.1 HS11.2
PA26.1 PA311
PA345 PA526
PA702
REVSET5 COMPANY
EMPLOYEE
SCHED-DATE*
CODE
SEQ-NBR
KeyChange
HS701 HS702


REVIEW FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Wed Jun 08 20:50:28 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.