Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

VESTHOURS


                             VESTHOURS FILE

                         Employee Vesting Hours

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

REFERENCED BY

BN232     BN237     BN330     BN55.1    BN55.2    HR170
HR70.1

UPDATED BY

BN00.1    BN57.1    PR197     HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

VES-COMPANY            Numeric 4                                 BN57.1  PR197
Element: Company Hr    Contains the company number. The number
                       correlates all information about the
                       company.

VES-EMPLOYEE           Numeric 9                                 BN57.1  PR197
Element: Employee      Contains the employee's number. The
                       number correlates all information about
                       the employee.

VES-PLAN-TYPE          Alpha 2                                   BN57.1  PR197
Element: Plan Type     Contains a benefit type for the vesting
                       hours.

VES-PLAN-CODE          Alpha 4                                   BN57.1  PR197
Element: Plan Code     Contains a user-defined code that
                       represents a benefit plan.

VES-PLAN-YEAR          Numeric 4                                 BN57.1  PR197
Element: Plan Year     Contains the type of year used to
                       determine the vesting computation
                       period.

VES-VEST-HOURS         Signed 7.2                                BN57.1  PR197
Element: Vest Hours    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.

                         VESTHOURS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

VESSET1   COMPANY                                                BN00.1  BN232
          EMPLOYEE                                               BN237   BN330
          PLAN-TYPE                                              BN55.1  BN55.2
          PLAN-CODE                                              BN57.1  HR11.1
          PLAN-YEAR                                              HR170   HR70.1
                                                                 PA115   PR197

VESSET2   COMPANY                                                BN57.1
          EMPLOYEE
          PLAN-TYPE
          PLAN-CODE
          PLAN-YEAR*

VESSET3   COMPANY                                                HR170   HR70.1
          PLAN-TYPE
          PLAN-CODE
          EMPLOYEE
          PLAN-YEAR

                         VESTHOURS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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