Payroll Personnel Data Warehouse


Table and Fields Description

Table Description --- DVTBEN

The translation list of the two-character benefit plan codes. The entity includes the benefit plan, a description of the plan and the type of benefit plan (i.e. medical, dental, vision, legal). This entity will be manually maintained.


Fields Definition


Field Name Business Name Data Type Description
BEN_CODE BENEFIT PLAN CODE VARCHAR2(2) The two character code identifying the medical, dental, legal, vision benefit plans offered by the University.
BEN_DESCRIPTION BENEFIT PLAN NAME VARCHAR2(30) The description of the benefit code.
BEN_TYPE BENEFIT PLAN TYPE VARCHAR2(7) The type of benefit program (medical, dental, legal, vision) the code pertains to..

Top of this page Data Dictionary PPS Main Menu



Sent Comment to: PPS Data Warehouse Support
Last Updated: February 5, 1999