VESTHOURS FILE
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
BN232 BN237 BN330 BN55.2 HR170 HR70.1
UPDATED BY
BN00.1 BN500 BN57.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VES-COMPANY Numeric 4 BN500 BN57.1
Company Contains the company number. The number PR197
correlates all information about the
company.
VES-EMPLOYEE Numeric 9 BN500 BN57.1
Employee Contains the employee's number. The PR197
number correlates all information about
the employee.
VES-PLAN-TYPE Alpha 2 BN500 BN57.1
Type Contains a benefit type for the vesting PR197
hours.
VES-PLAN-CODE Alpha 4 BN500 BN57.1
Plan Contains a user-defined code that PR197
represents a benefit plan.
VES-PLAN-YEAR Numeric 4 BN500 BN57.1
Plan Year Contains the type of year used to PR197
determine the vesting computation
period.
VES-VEST-HOURS Signed 7.2 BN500 BN57.1
Vesting Hours Contains the total number of vesting PR197
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.
VESTHOURS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
VESSET1 COMPANY BN00.1 BN232
EMPLOYEE BN237 BN330
PLAN-TYPE BN500 BN55.2
PLAN-CODE BN57.1 HR170
PLAN-YEAR HR70.1 PR197
VESSET2 COMPANY BN57.1
EMPLOYEE
PLAN-TYPE
PLAN-CODE
PLAN-YEAR*
VESSET3 COMPANY HR170 HR70.1
PLAN-TYPE
PLAN-CODE
EMPLOYEE
PLAN-YEAR
VESTHOURS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
