REVGOALDTL – File holds information about specific objectives that were used in the Total Goal Score calculation.

System: Personnel (PA)
Prefix: RVG
Primary key: COMPANY, EMPLOYEE, REV-SEQ-NBR, GOAL-SEQ-NBR
Fields: 6
Updated by: 5 programs
Referenced by: 1 program

REVGOALDTL is the File holds information about specific objectives that were used in the Total Goal Score calculation. table in Lawson Personnel (prefix RVG). It is indexed by COMPANY, EMPLOYEE, REV-SEQ-NBR, GOAL-SEQ-NBR (RVGSET1); alternate indexes: RVGSET2. It is related 1:1 to PAEMPGOAL and REVIEW. It is updated by HR11.1, PA115, PA26.1, PA26.3 and PA26.4 and referenced by HS08.1. The table has 6 fields, 2 indexes and 2 documented relations.

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

Fields (6)

Column = COBOL field name without the RVG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`RVG-COMPANY` PK COMPANY	Numeric 4	Contains the Company number.	PA26.3, PA26.4
`RVG-EMPLOYEE` PK EMPLOYEE	Numeric 9	An employee is assigned this number within the HR Company.	PA26.3, PA26.4
`RVG-REV-SEQ-NBR` PK REV_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` PK GOAL_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` 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` 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

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`RVGSET1`	`COMPANY`, `EMPLOYEE`, `REV-SEQ-NBR`, `GOAL-SEQ-NBR`	Primary		HR11.1, PA115, PA26.1, PA26.2, PA26.3, PA26.4
`RVGSET2`	`COMPANY`, `EMPLOYEE`, `GOAL-SEQ-NBR`, `REV-SEQ-NBR`			HS08.1

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (5)

HR11.1 Employee
PA115 Employee Purge
PA26.1 Review
PA26.3 Web Review Goal Detail
PA26.4 Review Goal Detail

Referenced by (1)

HS08.1 Goal Management Tracking