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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REV-COMPANY Numeric 4 PA26.1
Company Contains the company number represents
an established company.
REV-EMPLOYEE Numeric 9 PA26.1
Employee Contains the employee number.
REV-SEQ-NBR Numeric 4 PA26.1
Sequence Number Review sequence number. Assigned
automatically as review records are
created.
REV-SCHED-DATE Numeric 8 (yyyymmdd) PA26.1
Scheduled Date This field contains the scheduled
review date.
REV-CODE Alpha 10 PA26.1
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
Rating This field contains the performance
rating. Valid performance ratings must
be setup in PCODES.
REV-LAST-NAME Alpha 30 (Lower Case) PA26.1
Last Name This field contains the last name of
person conducting the review.
REV-FIRST-NAME Alpha 15 (Lower Case) PA26.1
First Name This field contains the first name of
person conducting the review.
REV-MIDDLE-INIT Alpha 1 PA26.1
Middle Initial This field contains the middle initial
of the person conducting the review.
REV-BY-EMPLOYEE Numeric 9 PA26.1
Employee Reviewed By This field contains the employee number
of person conducting the review. Must
be a valid employee setup in EMPLOYEE.
REV-FULL-NAME Derived
Full Name
REV-DATE-STAMP Numeric 8 (yyyymmdd) PA26.1
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
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
User ID Name Contains the user ID of the person who
last changed this record.
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 HR170
ACTUAL-DATE HR70.1 HS11.1
SEQ-NBR 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
|
