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.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: Schedule Contains the code that represents the
vesting schedule.
VSD-SERV-YEARS Numeric 2 BN03.1
Element: Years of ServiContains the number of years of service
required for each level of vesting.
VSD-PCT-VESTED Signed 5.2 BN03.1
Element: Percent VestedContains 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.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
|
