|
|
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
|
