Payroll Personnel Data Warehouse

Table and Fields Description

Table Description --- DVTCTZ

The translation list for the citizenship code (CITIZEN_CODE) on the EDBPAY table. This entity was locally-developed and is manually maintained.

Fields Definition

Field Name Business Name Data Type Description
CTZ_CODE CITIZENSHIP CODE VARCHAR2(1) The one character code identifying the status of the employee's citizenship.
CTZ_DESCRIPTION CITZ CODE TRANSLATION VARCHAR2(50) The description of the citizenship code.
Top of this page Data Dictionary PPS Main Menu



Sent Comment to: PPS Data Warehouse Support
Last Updated: February 12, 2002