VESTHOURS – Employee Vesting Hours
- System
- Benefits (BN)
- Prefix
VES- Primary key
COMPANY,EMPLOYEE,PLAN-TYPE,PLAN-CODE,PLAN-YEAR- Fields
- 12
- Updated by
- 5 programs
- Referenced by
- 8 programs
VESTHOURS is the Employee Vesting Hours table in Lawson Benefits (prefix VES). It is indexed by COMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, PLAN-YEAR (VESSET1); alternate indexes: VESSET2 and VESSET3. It is related 1:1 to BNCOMPANY, PRSYSTEM, PLAN and EMPLOYEE. It is updated by BN00.1, BN57.1, HR11.1, PA115 and PR197 and referenced by BN232, BN237, BN330, BN55.1, BN55.2, HR170, HR70.1 and ZH230. The table has 12 fields, 3 indexes and 5 documented relations.
About VESTHOURS
The Employee Vesting Hours file contains employee vesting hours in defined contribution and defined benefit plans. PR199 (Payroll Close) updates this file; you can override vesting hours by using BN57.1 (Vesting Hours).
Fields (12)
Column = COBOL field name without the VES- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
VES-COMPANY PKCOMPANY | Numeric 4 | Contains the company number. The number correlates all information about the company. | BN57.1, PR197 |
VES-EMPLOYEE PKEMPLOYEE | Numeric 9 | Contains the employee's number. The number correlates all information about the employee. | BN57.1, PR197 |
VES-PLAN-TYPE PKPLAN_TYPE | Alpha 2 | Contains a benefit type for the vesting hours. | BN57.1, PR197 |
VES-PLAN-CODE PKPLAN_CODE | Alpha 4 | Contains a user-defined code that represents a benefit plan. | BN57.1, PR197 |
VES-PLAN-YEAR PKPLAN_YEAR | Numeric 4 | Contains the type of year used to determine the vesting computation period. | BN57.1, PR197 |
VES-VEST-HOURSVEST_HOURS | Signed 7.2 | Contains the total number of vesting hours for the vesting year for the employee. If the value in this field is less than PLN-VEST-HOURS on the Plan file, the vesting year is not included in vesting calculations. | BN57.1, PR197 |
VES-CREATE-DATECREATE_DATE | Numeric 8 (yyyymmdd) | — | BN57.1, PR197 |
VES-CREATE-TIMECREATE_TIME | Numeric 6 (hhmmss) | — | BN57.1, PR197 |
VES-CREATE-USER-IDCREATE_USER_ID | Alpha 10 (Lower Case) | — | BN57.1, PR197 |
VES-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | — | BN57.1, PR197 |
VES-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | — | BN57.1, PR197 |
VES-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | BN57.1, PR197 |
Indexes (3)
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 |
|---|---|---|---|---|
VESSET1 | COMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, PLAN-YEAR | Primary | BN00.1, BN232, BN237, BN330, BN55.1, BN55.2, BN57.1, HR11.1 +4 more | |
VESSET2 | COMPANY, EMPLOYEE, PLAN-TYPE, PLAN-CODE, PLAN-YEAR* | BN57.1, ZH230 | ||
VESSET3 | COMPANY, PLAN-TYPE, PLAN-CODE, EMPLOYEE, PLAN-YEAR | HR170, HR70.1 |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | BNCOMPANY | Required | VES-COMPANY → BNC-COMPANY | |
| Company Name | PRSYSTEM | Required | VES-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Db Plan | PLAN | Required | When VES-PLAN-TYPE = "DB" | VES-COMPANY → PLN-COMPANY, VES-PLAN-TYPE → PLN-PLAN-TYPE, VES-PLAN-CODE → PLN-PLAN-CODE |
| Dc Plan | PLAN | Required | When VES-PLAN-TYPE = "DC" | VES-COMPANY → PLN-COMPANY, VES-PLAN-TYPE → PLN-PLAN-TYPE, VES-PLAN-CODE → PLN-PLAN-CODE |
| Employee | EMPLOYEE | Required | VES-COMPANY → EMP-COMPANY, VES-EMPLOYEE → EMP-EMPLOYEE |