REVGOALDTL FILE
File holds information about specific objectives that were used in the Total
Goal Score calculation. This will provide an audit trail of the objective's
Pct Completed and Weighting values that were used in the scoring calculation.
REFERENCED BY
HS08.1
UPDATED BY
PA26.3 PA26.4 PA26.1 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RVG-COMPANY Numeric 4 PA26.3 PA26.4
Element: Hr Company Contains the Company number.
RVG-EMPLOYEE Numeric 9 PA26.3 PA26.4
Element: Employee An employee is assigned this number
within the HR Company.
RVG-REV-SEQ-NBR Numeric 4 PA26.3 PA26.4
Element: Seq Nbr Automatically assigned Sequence Number.
Used as a unique identifier of the
review detail record.
RVG-GOAL-SEQ-NBR Numeric 4 PA26.3 PA26.4
Element: Seq Nbr Automatically assigned Sequence Number.
Used as a unique identifier of Goal on
the review detail record.
RVG-PCT-COMPLETED Numeric 3 PA26.3 PA26.4
Element: Pct Completed Percent value assigned to an individual
objective record that was used in the
Total Goal Score calculation for the
review.
RVG-WEIGHTING Signed 18.6 PA26.3 PA26.4
Element: Weighting Weighting value assigned to an
individual objective record that was
used in the Total Goal Score calculation
for the Review.
REVGOALDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RVGSET1 COMPANY HR11.1 PA115
EMPLOYEE PA26.1 PA26.2
REV-SEQ-NBR PA26.3 PA26.4
GOAL-SEQ-NBR
RVGSET2 COMPANY HS08.1
EMPLOYEE
GOAL-SEQ-NBR
REV-SEQ-NBR
REVGOALDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Emp Objective PAEMPGOAL Required
RVG-COMPANY -> PGO-COMPANY
RVG-EMPLOYEE -> PGO-EMPLOYEE
RVG-GOAL-SEQ-NBR -> PGO-SEQ-NBR
Review REVIEW Not Required
RVG-COMPANY -> REV-COMPANY
RVG-EMPLOYEE -> REV-EMPLOYEE
RVG-REV-SEQ-NBR -> REV-SEQ-NBR
|
