VESTSCHDDT

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


UPDATED BY
BN00.1 BN03.1 BN232 BN234 BN237 BN33.1
BN33.2 BN33.3 BN533 BN55.1 BN55.2 BN57.1
HR170 HR70.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VSD-COMPANY
Element: Company Hr		Numeric 4
Contains the company number. The number correlates all information about the company.
BN03.1
VSD-VEST-SCHED
Element: Vest Sched		Alpha 2
Contains the code that represents the vesting schedule.
BN03.1
VSD-SERV-YEARS
Element: Serv Years		Numeric 2
Contains the number of years of service required for each level of vesting.
BN03.1
VSD-PCT-VESTED
Element: Pct Vested		Signed 5.2
Contains the percent of employee vesting for one year of service.
BN03.1


VESTSCHDDT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VSDSET1 COMPANY
VEST-SCHED
SERV-YEARS
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


VESTSCHDDT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:10:11 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.