Payroll Personnel Data Warehouse


Table and Fields Description

Table Description --- DVTACT

The translation of the two-digit action code (i.e. promotion, casual to career, change in fund source). A different set of action codes exist for each level of action: employee, appointment and distribution. The action level indicates whether this action relates to an action affecting the individual person (per), the appointment (app) or distribution (dist) level. This entity will be manually maintained.


Fields Definition


Field Name Business Name Data Type Description
ACT_CODE ACTION CODE VARCHAR2(2) The two character code identifying the personnel action affecting the employee record.
ACT_DESCRIPTION ACTION DESCRIPTION VARCHAR2(30) The description of the action code.
ACT_LEVEL ACTION LEVEL VARCHAR2(4) The level (person, appointment or distribution) to which the action pertains.

Top of this page Data Dictionary PPS Main Menu



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