PAEMPGOAL – Employee Goals

System: Human Resources (HR)
Prefix: PGO
Primary key: COMPANY, EMPLOYEE, SEQ-NBR
Fields: 24
Updated by: 4 programs
Referenced by: 4 programs

PAEMPGOAL is the Employee Goals table in Lawson Human Resources (prefix PGO). It is indexed by COMPANY, EMPLOYEE, SEQ-NBR (PGOSET1); alternate indexes: PGOSET2, PGOSET3, PGOSET4 and PGOSET5. It is related 1:1 to PRSYSTEM, EMPLOYEE, PAEMPLOYEE and PCODES and 1:M to REVGOALDTL. It is updated by HR11.1, HS08.1, HS08.2 and PA115 and referenced by HS208, PA26.2, PA26.3 and PA26.4. The table has 24 fields, 5 indexes and 5 documented relations.

About PAEMPGOAL

Contains the goals or objectives to which an employee is assigned. These objectives are defined in the Goal Management system, Performance Management system, and through the Employee and Manager Self Service Goal Management Task. Goal Management is part of the Performance Alignment solution that will provide managers the tools to be able to set, track, observe, and measure individual or team objectives and duties where the objectives clearly align to overall corporate strategy.

Fields (24)

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

Field / column	Type	Description & values	Updated by
`PGO-COMPANY` PK COMPANY	Numeric 4	Contains the number that represents an established company and is entered on all functions.	HS08.1
`PGO-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.	HS08.1
`PGO-SEQ-NBR` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number. Used as a unique identifier of the objective that has been defined.	HS08.1
`PGO-PRIORITY` PRIORITY	Numeric 2	Indicates order of precedence for objectives.	HS08.1
`PGO-OBJECTIVE` OBJECTIVE	Alpha 30 (Lower Case)	Description of the objective. An attachment exists for this field to allow additional information to be input about the employee's objective. This is a scrollable field.	HS08.1
`PGO-START-DATE` START_DATE	Numeric 8 (yyyymmdd)	The beginning date of the objective.	HS08.1
`PGO-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	The end date of the objective. The start and end date assigned to the objective will determine the type of goal (i.e. quarterly, monthly, semiannual, or annual).	HS08.1
`PGO-LINKED-TO` LINKED_TO	Alpha 30 (Lower Case)	Description of the person on the company's organizational structure that the objective relates to. Used to link the objective to a higher level goal to create a cascading roll-up view. This is a scrollable field	—
`PGO-ALIGNED-TO` ALIGNED_TO	Alpha 30 (Lower Case)	Description of the goal on the organizational structure that the objective is associated to. Used to link the goals together to create a cascading roll-up view. This is a scrollable field.	—
`PGO-STATUS` STATUS	Alpha 10	This field displays the status of the objective. Used as a tracking mechanism for employee and manager self service. This field is a user-defined status code with a pcode type of 'SG'.	HS08.1
`PGO-COMPLETE` COMPLETE	Numeric 1	Indicates whether the objective has been completed. Workflow will update this field to a complete status when the manager approves the objective that has been completed by the employee. The employee may be eligible for compensation for an objective with a complete status. `0` Not Complete `1` Employee Complete `2` Manager Complete `3` Approved for Payout `4` Scheduled for Payout `5` Payout Complete `6` On Hold `7` Active `8` Inactive `9` Reject	HS08.1
`PGO-PCT-COMPLETED` PCT_COMPLETED	Numeric 3	Indicates the percentage of the objective that has been completed by the employee. Typically, an employee will update this field value. When this value equals 100 percent, the manager will be notified.	HS08.1
`PGO-WEIGHTING` WEIGHTING	Signed 18.6	Numeric weighting assigned to the objective that will be used as the compensation payout to the employee through a Lawson or non-Lawson compensation or payroll application. This value could represent a flat dollar amount or a percent value.	HS08.1
`PGO-AMT-PCT-IND` AMT_PCT_IND	Numeric 1	Indicates whether the weighting value is a dollar amount or a percent. `1` Amount `2` Percent	HS08.1
`PGO-COMPLETE-DATE` COMPLETE_DATE	Numeric 8 (yyyymmdd)	Indicates the date the objective was completed. Typically, this would be the same date the Complete status was updated from the manager.	HS08.1
`PGO-ACCEPTED` ACCEPTED	Numeric 1	Indicates whether the employee has acknowledged and accepted the objective assigned to them from the manager. `0` Not Reviewed `1` Reviewed `2` Manager Approved	HS08.1, HS08.2
`PGO-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	Indicates the creation date of when the objective was intially added to the system.	HS08.1
`PGO-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	Indicates the creation time of when the objective was intially added to the system.	HS08.1
`PGO-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	Indicates the user id of the person who intially added the objective in the system.	HS08.1
`PGO-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to the objective record.	HS08.1
`PGO-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the objective record was last changed.	HS08.1
`PGO-USER-ID` USER_ID	Alpha 10 (Lower Case)	Contains the user ID of the person who last changed the objective record.	HS08.1
`PGO-TYPE` TYPE	Alpha 1	Indicates whether the objective was created by the employee or the manager. `E` Employee Objective `M` Manager Objective	HS08.1
`PGO-GOAL-SCORE` GOAL_SCORE	Signed 18.6	Individual Goal Score that is calculated by multiplying the Pct Complete by the Weighting. This value is used to compute the Total Goal Score used in the Performance Review.	—

Indexes (5)

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
`PGOSET1`	`COMPANY`, `EMPLOYEE`, `SEQ-NBR*`	Primary		HR11.1, HS08.1, HS08.2, HS208, PA115, PA26.2, PA26.3, PA26.4
`PGOSET2`	`COMPANY`, `EMPLOYEE`, `PRIORITY`, `END-DATE*`, `SEQ-NBR`	KeyChange		—
`PGOSET3`	`COMPANY`, `EMPLOYEE`, `END-DATE*`, `PRIORITY`, `SEQ-NBR`	KeyChange		HS08.1, HS208
`PGOSET4`	`COMPANY`, `EMPLOYEE`, `END-DATE*`, `PCT-COMPLETED`, `SEQ-NBR`	KeyChange		—
`PGOSET5`	`COMPANY`, `EMPLOYEE`, `COMPLETE`, `END-DATE*`, `SEQ-NBR`	KeyChange, Subset	Where (COMPLETE = 1)	—

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
Company	PRSYSTEM	Required	`PGO-COMPANY` → `PRS-COMPANY (PRSSET1)`, `Spaces` → `PRS-PROCESS-LEVEL`
Employee	EMPLOYEE	Required	`PGO-COMPANY` → `EMP-COMPANY`, `PGO-EMPLOYEE` → `EMP-EMPLOYEE`
Paemployee	PAEMPLOYEE	Required	`PGO-COMPANY` → `PEM-COMPANY`, `PGO-EMPLOYEE` → `PEM-EMPLOYEE`
Status	PCODES	Required	`"SG"` → `PCO-TYPE`, `PGO-STATUS` → `PCO-CODE`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Review Detail	REVGOALDTL			`PGO-COMPANY` → `RVG-COMPANY`, `PGO-EMPLOYEE` → `RVG-EMPLOYEE`, `PGO-SEQ-NBR` → `RVG-GOAL-SEQ-NBR`, → `RVG-REV-SEQ-NBR`

PAEMPGOAL – Employee Goals

About PAEMPGOAL

Fields (24)

Indexes (5)

Relations

One to one (4) — lookups and parents

One to many (1) — child tables

Programs

Updated by (4)

Referenced by (4)