VESTHOURS

Employee Vesting Hours

The Employee Vesting Hours file contains employee vesting hours in defined contribution and defined benefit plans. PR199 (Payroll Close) updates this file; you can override vesting hours by using BN57.1 (Vesting Hours).

REFERENCED BY
BN330 ZB537


UPDATED BY
BN00.1 BN232 BN237 BN55.1 BN55.2 BN57.1
HR11.1 HR170 HR70.1 ZH230 PA115 PR197

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VES-COMPANY
Element: Company Hr
Numeric 4
Contains the company number. The number correlates all information about the company.
BN57.1 PR197
VES-EMPLOYEE
Element: Employee
Numeric 9
Contains the employee's number. The number correlates all information about the employee.
BN57.1 PR197
VES-PLAN-TYPE
Element: Plan Type
Alpha 2
Contains a benefit type for the vesting hours.
BN57.1 PR197
VES-PLAN-CODE
Element: Plan Code
Alpha 4
Contains a user-defined code that represents a benefit plan.
BN57.1 PR197
VES-PLAN-YEAR
Element: Plan Year
Numeric 4
Contains the type of year used to determine the vesting computation period.
BN57.1 PR197
VES-VEST-HOURS
Element: Vest Hours
Signed 7.2
Contains the total number of vesting hours for the vesting year for the employee. If the value in this field is less than PLN-VEST-HOURS on the Plan file, the vesting year is not included in vesting calculations.
BN57.1 PR197


VESTHOURS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VESSET1 COMPANY
EMPLOYEE
PLAN-TYPE
PLAN-CODE
PLAN-YEAR
BN00.1 BN232
BN237 BN330
BN55.1 BN55.2
BN57.1 ZB537
HR11.1 HR170
HR70.1 PA115
PR197
VESSET2 COMPANY
EMPLOYEE
PLAN-TYPE
PLAN-CODE
PLAN-YEAR*
BN57.1 ZH230
VESSET3 COMPANY
PLAN-TYPE
PLAN-CODE
EMPLOYEE
PLAN-YEAR
HR170 HR70.1


VESTHOURS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company BNCOMPANY Required
VES-COMPANY->BNC-COMPANY
Company Name PRSYSTEM Required
VES-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Db Plan PLAN Required
When VES-PLAN-TYPE ="DB"
VES-COMPANY->PLN-COMPANY
VES-PLAN-TYPE->PLN-PLAN-TYPE
VES-PLAN-CODE->PLN-PLAN-CODE
Dc Plan PLAN Required
When VES-PLAN-TYPE ="DC"
VES-COMPANY->PLN-COMPANY
VES-PLAN-TYPE->PLN-PLAN-TYPE
VES-PLAN-CODE->PLN-PLAN-CODE
Employee EMPLOYEE Required
VES-COMPANY->EMP-COMPANY
VES-EMPLOYEE->EMP-EMPLOYEE


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

Home
Contact Us



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