REVGOALDTL

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
Element: Hr Company		Numeric 4
Contains the Company number.
PA26.3 PA26.4
RVG-EMPLOYEE
Element: Employee		Numeric 9
An employee is assigned this number within the HR Company.
PA26.3 PA26.4
RVG-REV-SEQ-NBR
Element: Seq Nbr		Numeric 4
Automatically assigned Sequence Number. Used as a unique identifier of the review detail record.
PA26.3 PA26.4
RVG-GOAL-SEQ-NBR
Element: Seq Nbr		Numeric 4
Automatically assigned Sequence Number. Used as a unique identifier of Goal on the review detail record.
PA26.3 PA26.4
RVG-PCT-COMPLETED
Element: Pct Completed		Numeric 3
Percent value assigned to an individual objective record that was used in the Total Goal Score calculation for the review.
PA26.3 PA26.4
RVG-WEIGHTING
Element: Weighting		Signed 18.6
Weighting value assigned to an individual objective record that was used in the Total Goal Score calculation for the Review.
PA26.3 PA26.4


REVGOALDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RVGSET1 COMPANY
EMPLOYEE
REV-SEQ-NBR
GOAL-SEQ-NBR
HR11.1 PA115
PA26.1 PA26.2
PA26.3 PA26.4
RVGSET2 COMPANY
EMPLOYEE
GOAL-SEQ-NBR
REV-SEQ-NBR
HS08.1


REVGOALDTL FILE RELATIONS


ONE TO ONE RELATIONS

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

File created: Thu Jun 09 02:25:12 2016

Home
Contact Us



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