Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

VESTSCHDDT


                            VESTSCHDDT FILE

                        Vesting Schedule Detail

The Vesting Schedule Detail file contains the information required for a
vesting schedule.

BN03.1 (Vesting Schedule) is the primary program that updates this file.

REFERENCED BY

BN203     BN234     BN33.1    BN33.2    BN33.3    BN533
BN232     BN237     BN55.1    BN55.2    BN57.1    HR170
HR70.1

UPDATED BY

BN00.1    BN03.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

VSD-COMPANY            Numeric 4                                 BN03.1
Element: Company Hr    Contains the company number. The number
                       correlates all information about the
                       company.

VSD-VEST-SCHED         Alpha 2                                   BN03.1
Element: Vest Sched    Contains the code that represents the
                       vesting schedule.

VSD-SERV-YEARS         Numeric 2                                 BN03.1
Element: Serv Years    Contains the number of years of service
                       required for each level of vesting.

VSD-PCT-VESTED         Signed 5.2                                BN03.1
Element: Pct Vested    Contains the percent of employee
                       vesting for one year of service.

                         VESTSCHDDT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

VSDSET1   COMPANY                                                BN00.1  BN03.1
          VEST-SCHED                                             BN203   BN234
          SERV-YEARS                                             BN33.1  BN33.2
                                                                 BN33.3  BN533

VSDSET2   COMPANY                                                BN232   BN237
          VEST-SCHED                                             BN55.1  BN55.2
          SERV-YEARS*                                            BN57.1  HR170
                                                                 HR70.1

                         VESTSCHDDT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            VSD-COMPANY       -> BNC-COMPANY

Vest Schedule  VESTSCHDHD   Required

                            VSD-COMPANY       -> VSH-COMPANY
                            VSD-VEST-SCHED    -> VSH-VEST-SCHED