|
|
REVIEW FILE
Employee Performance Review
The Employee Performance Review file contains information pertaining to
employee performance reviews.
REFERENCED BY
HR90.1 HR511 PA345 PA370 BN234 HCDL.1
HCEM.1 HCHP.1 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 Hr 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: Last 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 Contains the user ID of the person who
last changed this record.
REV-LABEL-NAME Derived
Element: Label Name
REVIEW FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
REVSET1 COMPANY HR90.1
EMPLOYEE
SEQ-NBR
REVSET2 COMPANY HR511 PA26.1
EMPLOYEE PA345 PA370
SCHED-DATE
CODE
REVSET3 COMPANY KeyChange BN234 HCDL.1
EMPLOYEE HCEM.1 HCHP.1
ACTUAL-DATE HR11.1 HR170
SEQ-NBR HR70.1 HS11.1
PA115 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
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
|
