VESTSCHDDT – Vesting Schedule Detail

System: Benefits (BN)
Prefix: VSD
Primary key: COMPANY, VEST-SCHED, SERV-YEARS
Fields: 4
Updated by: 2 programs
Referenced by: 13 programs

VESTSCHDDT is the Vesting Schedule Detail table in Lawson Benefits (prefix VSD). It is indexed by COMPANY, VEST-SCHED, SERV-YEARS (VSDSET1); alternate indexes: VSDSET2. It is related 1:1 to BNCOMPANY and VESTSCHDHD. It is updated by BN00.1 and BN03.1 and referenced by BN203, BN232, BN234, BN237, BN33.1, BN33.2, BN33.3, BN533 and 5 more. The table has 4 fields, 2 indexes and 2 documented relations.

About VESTSCHDDT

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.

Fields (4)

Column = COBOL field name without the VSD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`VSD-COMPANY` PK COMPANY	Numeric 4	Contains the company number. The number correlates all information about the company.	BN03.1
`VSD-VEST-SCHED` PK VEST_SCHED	Alpha 2	Contains the code that represents the vesting schedule.	BN03.1
`VSD-SERV-YEARS` PK SERV_YEARS	Numeric 2	Contains the number of years of service required for each level of vesting.	BN03.1
`VSD-PCT-VESTED` PCT_VESTED	Signed 5.2	Contains the percent of employee vesting for one year of service.	BN03.1

Indexes (2)

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
`VSDSET1`	`COMPANY`, `VEST-SCHED`, `SERV-YEARS`	Primary		BN00.1, BN03.1, BN203, BN234, BN33.1, BN33.2, BN33.3, BN533
`VSDSET2`	`COMPANY`, `VEST-SCHED`, `SERV-YEARS*`			BN232, BN237, BN55.1, BN55.2, BN57.1, HR170, HR70.1

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	BNCOMPANY	Required		`VSD-COMPANY` → `BNC-COMPANY`
Vest Schedule	VESTSCHDHD	Required		`VSD-COMPANY` → `VSH-COMPANY`, `VSD-VEST-SCHED` → `VSH-VEST-SCHED`

Programs

Updated by (2)

BN00.1 Benefits Company
BN03.1 Vesting Schedule

Referenced by (13)

BN203 Vesting Schedule Listing
BN232 Benefits Statement
BN234 Employee Stock Option Listing
BN237 Vesting Report
BN33.1 Employee Stock Option Grant Mass Entry
BN33.2 Employee Stock Option Grant
BN33.3 Employee Stock Option Vesting Detail
BN533 Employee Stock Option Grant Conversion
BN55.1 Defined Contribution or Defined Benefit Acct Balance
BN55.2 Vested Amounts
BN57.1 Vesting Hours
HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry