Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

VESTSCHDHD


                            VESTSCHDHD FILE

                        Vesting Schedule Header

The Vesting Schedule Header file contains information about vesting schedules.

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

REFERENCED BY

BN137     BN15.1    BN203     BN215     BN223     BN23.1
BN33.1    BN33.2

UPDATED BY

BN00.1    BN03.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

VSH-DESC               Alpha 30  (Lower Case)                    BN03.1
Element: Description   Contains the description of the vesting
                       schedule.

                         VESTSCHDHD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

VSHSET1   COMPANY                                                BN00.1  BN03.1
          VEST-SCHED                                             BN137   BN15.1
                                                                 BN203   BN215
                                                                 BN223   BN23.1
                                                                 BN33.1  BN33.2

                         VESTSCHDHD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        BNCOMPANY    Required

                            VSH-COMPANY       -> BNC-COMPANY

Company Name   PRSYSTEM     Required

                            VSH-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

                         VESTSCHDHD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Vesting Detail VESTSCHDDT   Delete Restricted

                            VSH-COMPANY       -> VSD-COMPANY
                            VSH-VEST-SCHED    -> VSD-VEST-SCHED
                                                 VSD-SERV-YEARS