Payroll Personnel Data Warehouse

Table and Fields Description

Table Description --- EDBACT

A historical record of personnel transaction action affecting the employee (person), appointment or distribution. More than one action can affect an employee, appointment or distribution for any given date. An action entry does not have to be unique for the employee on any given date.

The action entry for an employee (person) record has the employee id number, action date, action code and blanks in the appointment and distribution number fields. (Ties to the EDBPER table.)
The action entry for an appointment record has the employee id number, action date, appointment number and action code. (Ties to the EDBAPP table.)
The action entry for a distribution has the employee id number, action date, distribution number and action code. (Ties to the EDBDIS table.)

Warning: While the appointment and/or distribution must have been in existence on the date of the action, the EDBACT record is not deleted when the associated EDBPER, EDBAPP and EDBDIS records are deleted. If the appointment or distribution's ending date has passed, the changed appointment or distribution may have been deleted through the routine maintenance process. The payroll system then reuses that appointment or distribution number which causing a mismatch between the historical action record and the appointment/distribution. The data originates from the Employee Data Base (EDB) and is created by manual and automated processes.

The data warehouse will contain a limited snapshot of the action data. Any action dated (Action Effective Date) dating greater than two months (60 days) prior to the current date and forward will be included. Action table entries older than two months (60 days) will drop off the table. This snapshot approach is necessary due to the 300,000+ count of the transactions in the UCOP-base database and the lack of historical integrity due to the system's reuse of appointment numbers. Translations of the action codes can be found in the DVTACT table.

Fields Definition

Field Name	Business Name	Data Type	Description
ACTION_CODE	ACTION CODE	VARCHAR2(2)	The code indicating the personnel action which affected the employees record
ACTION_EFFDATE	ACTION EFFECTIVE DATE	DATE	The date the personnel action will be effective.
APPT_NUM	APPOINTMENT NUMBER	NUMBER(5)	The number of the appointment affected by the action, if applicable.
DIST_NUM	DISTRIBUTION NUMBER	NUMBER(5)	The number of the distribution affected by the action, if applicable.
EMPLOYEE_ID	EMPLOYEE ID NUMBER	VARCHAR2(9)	The unique employee identification number.
UCD_ADC_DATE	UCD ADD/DELETE/CHANGE DATE	DATE	The date the personnel action is added.

Top of this page

Data Dictionary

PPS Main Menu

Sent Comment to: PPS Data Warehouse Support
Last Updated: June 30, 1999