Payroll Personnel Data Warehouse


Table and Fields Description

Table Description --- DVTETH

The translation list for the ethnicity code as used by the Payroll/Personnel System. This code is not the same as the one used by the Student Information System (SIS). This entity will be manually maintained.


Fields Definition

Field Name Business Name Data Type Description
ETH_CODE ETHNICITY CODE VARCHAR2(1) The two character code identifying the ethnicity of the employee.
ETH_DESCRIPTION ETHNICITY CODE DESCRIPTION VARCHAR2(40) The translation of the ethnicity code used by the Payroll and HR Offices.
ETH_SUMMARY_DESC ETHNICITY CODE SUMMARIZATION VARCHAR2(15) The summaries of the ethnicity code used in "roll ups" by the Office of the President (UCOP).

Top of this page Data Dictionary PPS Main Menu



Sent Comment to: PPS Data Warehouse Support
Last Updated: June 14, 2006