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 BN232 BN237 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
Company Contains the company number. The number
correlates all information about the
company.
VSD-VEST-SCHED Alpha 2 BN03.1
Schedule Contains the code that represents the
vesting schedule.
VSD-SERV-YEARS Numeric 2 BN03.1
Years of Service Contains the number of years of service
required for each level of vesting.
VSD-PCT-VESTED Signed 5.2 BN03.1
Percent 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
SERV-YEARS
VSDSET2 COMPANY BN232 BN237
VEST-SCHED BN55.2 BN57.1
SERV-YEARS* 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
|
