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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#VSD-COMPANY PKCOMPANY | Numeric 4 | Contains the company number. The number correlates all information about the company. | BN03.1 |
#VSD-VEST-SCHED PKVEST_SCHED | Alpha 2 | Contains the code that represents the vesting schedule. | BN03.1 |
#VSD-SERV-YEARS PKSERV_YEARS | Numeric 2 | Contains the number of years of service required for each level of vesting. | BN03.1 |
#VSD-PCT-VESTEDPCT_VESTED | Signed 5.2 | Contains the percent of employee vesting for one year of service. | BN03.1 |
Indexes (2)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
VSDSET1 |
| Primary | BN00.1, BN03.1, BN203, BN234, BN33.1, BN33.2, BN33.3, BN533 | |
VSDSET2 |
| 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 |
| |||||||
| Vest Schedule | VESTSCHDHD | Required |
|
Programs
Updated by (2)
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