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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#VES-COMPANY PK
COMPANY		Numeric 4Contains the company number. The number correlates all information about the company.BN57.1, PR197
#VES-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee's number. The number correlates all information about the employee.BN57.1, PR197
#VES-PLAN-TYPE PK
PLAN_TYPE		Alpha 2Contains a benefit type for the vesting hours.BN57.1, PR197
#VES-PLAN-CODE PK
PLAN_CODE		Alpha 4Contains a user-defined code that represents a benefit plan.BN57.1, PR197
#VES-PLAN-YEAR PK
PLAN_YEAR		Numeric 4Contains the type of year used to determine the vesting computation period.BN57.1, PR197
#VES-VEST-HOURS
VEST_HOURS		Signed 7.2Contains 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-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)—BN57.1, PR197
#VES-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)—BN57.1, PR197
#VES-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—BN57.1, PR197
#VES-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)—BN57.1, PR197
#VES-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)—BN57.1, PR197
#VES-USER-ID
USER_ID		Alpha 10 (Lower Case)—BN57.1, PR197

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
VESSET1
  1. COMPANY
  2. EMPLOYEE
  3. PLAN-TYPE
  4. PLAN-CODE
  5. PLAN-YEAR
PrimaryBN00.1, BN232, BN237, BN330, BN55.1, BN55.2, BN57.1, HR11.1 +4 more
VESSET2
  1. COMPANY
  2. EMPLOYEE
  3. PLAN-TYPE
  4. PLAN-CODE
  5. PLAN-YEAR ↓
BN57.1, ZH230
VESSET3
  1. COMPANY
  2. PLAN-TYPE
  3. PLAN-CODE
  4. EMPLOYEE
  5. PLAN-YEAR
HR170, HR70.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
BNCOMPANYPRSYSTEMPLANEMPLOYEEVESTHOURS

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CompanyBNCOMPANYRequired
VES-COMPANY→BNC-COMPANY
Company NamePRSYSTEMRequired
VES-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Db PlanPLANRequiredWhen VES-PLAN-TYPE = "DB"
VES-COMPANY→PLN-COMPANY
VES-PLAN-TYPE→PLN-PLAN-TYPE
VES-PLAN-CODE→PLN-PLAN-CODE
Dc PlanPLANRequiredWhen VES-PLAN-TYPE = "DC"
VES-COMPANY→PLN-COMPANY
VES-PLAN-TYPE→PLN-PLAN-TYPE
VES-PLAN-CODE→PLN-PLAN-CODE
EmployeeEMPLOYEERequired
VES-COMPANY→EMP-COMPANY
VES-EMPLOYEE→EMP-EMPLOYEE

Programs

Updated by (5)

Referenced by (8)