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
BN232 BN237 BN330 BN55.1 BN55.2 HR170
HR70.1 ZH230


UPDATED BY
BN00.1 BN57.1 PR197 HR11.1 PA115

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
VES-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN57.1 PR197
VES-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
BN57.1 PR197
VES-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
BN57.1 PR197
VES-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
BN57.1 PR197
VES-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
BN57.1 PR197
VES-USER-ID
Element: User Id
Alpha 10 (Lower Case)
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 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 02:10:17 2016

Home
Contact Us



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