|
|
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 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
VES-COMPANY Numeric 4 BN500 BN57.1
Element: Company Contains the company number. The number PR197
correlates all information about the
company.
VES-EMPLOYEE Numeric 9 BN500 BN57.1
Element: Employee Contains the employee's number. The PR197
number correlates all information about
the employee.
VES-PLAN-TYPE Alpha 2 BN500 BN57.1
Element: Type Contains a benefit type for the vesting PR197
hours.
VES-PLAN-CODE Alpha 4 BN500 BN57.1
Element: Plan Contains a user-defined code that PR197
represents a benefit plan.
VES-PLAN-YEAR Numeric 4 BN500 BN57.1
Element: Plan Year Contains the type of year used to PR197
determine the vesting computation
period.
VES-VEST-HOURS Signed 7.2 BN500 BN57.1
Element: 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 HR11.1
PLAN-YEAR HR170 HR70.1
PA115 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
|
