Payroll Personnel Data Warehouse
The following list of tables is organized by system or category of data. For more detailed information about the description of and data fields contained in each of the tables, click on the table name link. See Explanation of View Tables for more information on the naming convensions used for accessing the tables controlled by Security (CSE, EDB, EDW, ETH, PAR and STF).
Tables Description
| System | Table | Description |
|---|---|---|
| FAU Information | COAACR | DAFIS account table - view of FIS_ORGANIZATION_ACCOUNT table |
| COACRT | DAFIS chart table - view of FIS_CHART_OF_ACCTS table | |
| COAOBJ | DAFIS object table - view of FIS_OBJECT table | |
| COAPRJ | DAFIS project table - view of FIS_PROJECT table | |
| COASAC | DAFIS sub account table - view of FIS_SUB_ACCOUNT table | |
| COASOB | DAFIS sub object table - view of FIS_SUB_OBJECT table | |
| Control - Translations | CTLBUT | Bargaining unit name translation |
| CTLDOS | Description of service code translation | |
| CTLFCT | Foreign country code translation | |
| CTLGTN | Gross-to-Net or deduction code translation | |
| CTLHME | Home department code translation | |
| CTVHME | A view of home department code translation - school and improved description added | |
| CTLJGD | Job group code translation | |
| CTLJGT | Job group code to job title code link | |
| CTLTCI | Job title code translation (contains most current entry for each job title) | |
| CTLTCI_UCOP | Original job title code translation (contains multiple entries per job title). See CTLTCI for table and data field description. | |
| CTLWSF | Work study split-funding table | |
| CTLWSP | Work study program code translation | |
| Code Translations | DVTACT | Action code translation |
| DVTBEN | Benefit code translation | |
| DVTCTO | Class title outline/Occupational sub group code translation | |
| DVTCTZ | Citizenship code translation | |
| DVTETH | Ethnicity code translation | |
| DVTFOC | Federal occupational code translation | |
| DVTLOA | Leave of absence code translation | |
| DVTLVC | Leave accrual code translation | |
| DVTREL | Employee relations code translation | |
| DVTSCH | School/division code translation | |
| DVTSEP | Separation reason code translation | |
| DVTVSA | Visa code translation | |
| Liens | CSECSR | Committed salary/Payroll liens |
| Employee Data | EDBACT | Personnel actions affecting the employees - A 3-month snapshot |
| EDBAPP | Appointment information relating to an individual employee | |
| EDBBEL | Benefit eligibility information relating to an individual employee | |
| EDBBEN | Benefits information relating to an individual employee | |
| EDBBND | Saving bond information relating to an individual employee | |
| EDBCMP | Campus specific information relating to an individual employee | |
| EDBDEP | Dependent information relating to an individual employee | |
| EDBDIS | Appointment distribution information relating to an individual employee | |
| EDBEAR | Year-to-date earning information relating to an individual employee | |
| EDBFAD | Foreign address information relating to an individual employee | |
| EDBFNA | Financial aid information relating to an individual employee | |
| EDBFNW | Work study information relating to an individual employee | |
| EDBLSC | Layoff Seniority Credit record relating to an individual emplyee | |
| EDBPAY | Pay record information relating to an individual employee | |
| EDBPER | Personnel information relating to an individual employee | |
| EDBPCC | Corporate Credit Card information relating to an individual employee | |
| EDBPCM | YTD, QTD and pay-status information relating to an individual employee | |
| UCDAPTDIS | Combination of current person, appointment and distribution data | |
| Detailed Expenses | EDWEXP | Monthly expense distributions relating to an individual employee |
| EDWPCR | Payroll Control Records relating to the monthly expense distribution records | |
| Summarized Expenses | ETHTOE | Monthly transfer of expense information relating to an individual employees' pay |
| Updates | NOTIFICATION | Local table to store update information |
| THE_DATE | Local table to store extract date | |
| Payroll Data | PARDAT | Dollar adjustment information relating to an employee's pay cycle |
| PARDRC | Deduction information relating to an employee's pay cycle | |
| PARERN | Detail earnings information relating to an employee's pay cycle | |
| PAREUD | Employee and total information relating to an employee's pay cycle | |
| PARHAT | Hours adjustment information relating to an employee's pay cycle | |
| PARPIR | Date and cycle information relating to a pay cycle | |
| Staffing Lists | STFSCTL | Staffing list control information - title and date loaded |
| STFDBUD | Staffing list detail budget transactions | |
| STFFPPD | Staffing list filled position and provision position data | |
| STFSUMM | Staffing list budget and position summary data | |
| STFXLST | Staffing list employees with multiple pay distributions |
Send Comments to PPS Data Warehouse Support at: paysys-support@ucdavis.edu
Last Updated: June 20, 2006