The funding (FAU) for an appointment. Similar to the appointment, the distribution is also date and percentage of time controlled. The format and contents of the pay rate field depends on the hourly or annual rate code. The Derived Department Code comes from the DAFIS Chart of Accounts Account Table when the Distribution is established and rederived if the funding changes. The data originates from the Employee Data Base (EDB) and contains recently-expired, current and future distributions.
Similar to the Appointment Table (EDBAPP), the data warehouse update process does a comparison against the UCOP data base and any records that are added, changed or deleted are identified in the UCD_ADC_CODE and UCD_ADC_DATE. Records that are flagged as deleted will be deleted from the data warehouse after 8 days.
On July 1, 2006, a conversion of pay distributions was necessary for both federal funding compliance plus supporting the new Effort Reporting System (ERS). From now on any academic appointees (or late renewals, rehires, etc) with off-scale, health Science Compensation Plan components or additional Summer Compensation-By Agreement pay must be established using the new consolidated DOS codes and compressed payrates. A new table EDBDIS_EFFRPT shows the "expanded" distribution for the new DOS Codes. See the Compression Translation PDF document for more explanation of the new DOS codes.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| APPT_NUM | APPOINTMENT NUMBER | NUMBER(5) | The number used to identify an appointment. (key) |
| COMP_IND | COMPRESSION INDICATOR | VARCHAR2(1) | The code indicating whether this distribution was compressed for the Effort Reporting System project. (derived based on DOS field during update/load process) (values are Y=yes and N=no) |
| DIST_ADC_CODE | ADD/DELETE/CHANGE FLAG | VARCHAR2(1) | The code indicating the type of action taken on a distribution. (values are A=add a new distribution, C=change an already existing distribution, or D=delete an existing distribution) |
| DIST_DEPT_CODE | DERIVED DEPARTMENT CODE | VARCHAR2(6) | The code indicating the department or other administrative unit associated with the account number for a distribution. (translation in CTLHME table) |
| DIST_DOS | DESCRIPTION OF SERVICE CODE | VARCHAR2(3) | The code indicating the type of service or type of pay associated with the appointment. (translation in CTLDOS table) |
| DIST_FTE | DISTRIBUTION FULL TIME EQUIVALENT | NUMBER(3,2) | The percentage of the budgeted position which the distribution represents. |
| DIST_NUM | DISTRIBUTION NUMBER | NUMBER(5) | The number uniquely identifying a payroll distribution associated with an appointment. (key) |
| DIST_OFF_ABOVE | ABOVE/OFF SCALE INDICATOR | VARCHAR2(1) | The code indicating the relationship of pay rate to the step and salary range for the title code of the appointment. (values are A=above scale-academic, B=above scale-academic/red circle, O=off scale-academic,P=off scale-academic/red circle,R=red circle-nonacademic or BLANK=on scale. Other codes can be created for special handling during pay reduction periods.) |
| DIST_PAYRATE | DISTRIBUTION PAY RATE | NUMBER(9,4) | The full-time hourly rate, pay period amount, or by agreement amount associated with the distribution. |
| DIST_PERCENT | DISTRIBUTION PERCENT TIME | NUMBER(5,4) | The anticipated time which is chargeable to the distribution. |
| DIST_PERQ | DISTRIBUTION PREQUISITE | VARCHAR2(3) | The code indicating the type of perquisite provided. |
| DIST_STEP | STEP | VARCHAR2(3) | The level, within a pay range, of the associated distribution pay rate. |
| DIST_UNIT_CODE | DISTRIBUTION BARGAINING UNIT CODE | VARCHAR2(1) | The code indicating a group, within a bargaining unit, to which a distribution for an appointment is assigned for collective bargaining purposes, excluding range adjustments. (translation in CTLBUT table) |
| EMPLOYEE_ID | EMPLOYEE ID NUMBER | VARCHAR2(9) | The unique employee identification number. (key) |
| FAU | FULL ACCOUNTING UNIT | VARCHAR2(30) | The identifier assigned by the department for the purpose of identifying a specific expenditure. For payroll purposes, this is the identifier of an account against which salary or wage expenses are charged. The full accounting unit (FAU) is composed of the chart of accounts number, account number, sub account number, object number, sub object number, and project number. (This field has been split into its individual components during the update/load process) |
| FAU_CHART | CHART OF ACCOUNTS NUMBER | VARCHAR2(1) | Identifer of a Chart of Accounts. (created from FAU field during update/load process) (translation in COACRT table) |
| FAU_ACCT | ACCOUNT NUMBER | VARCHAR2(7) | Organization chosen identifier used to classify financial resources for accounting and reporting purposes. (created from FAU field during update/load process) (translation in COAACR table) |
| FAU_SUBACCT | SUB ACCOUNT NUMBER | VARCHAR2(5) | Allows an account to be broken down in more detail (Cost Center) in order to better track detail transactions. The sub account takes on the attributes of the account it reports, including account manager, fund group and function code. Assigned by account manager. (created from FAU field during update/load process) (translation in COASAC table) |
| FAU_OBJECT | OBJECT NUMBER | VARCHAR2(4) | Identifier used to classify accounting transactions by type. Examples are academic salaries, in-state travel, Reg Fee income. (created from FAU field during update/load process) (translation in COAOBJ table) |
| FAU_SUBOBJ | SUB OBJECT NUMBER | VARCHAR2(3) | Provides for an object code to be broken down into greater detail. Assigned by account manager. (created from FAU field during update/load process) (translation in COASOB table) |
| FAU_PROJECT | PROJECT NUMBER | VARCHAR2(10) | The code used to track and accumulate transactions across multiple charts, accounts and fund groups. (created from FAU field during update/load process) (translation in COAPRJ table) |
| FAU_ORG_CD | ORGANIZATION CODE | VARCHAR2(4) | The identifier of an organization. (added from DaFIS Account table during update/load process) |
| FAU_OP_FUND | UCD/OP FUND NUMBER | VARCHAR2(6) | UCD pre-DAFIS fund number for reporting to Office of the President. (added from DaFIS Account table during update/load process) |
| FAU_SUB_FUND_GRP_TYP_CD | SUB FUND GROUP TYPE CODE | VARCHAR2(1) | Used to group similar sub funds. For example, Federal Contracts would be a sub fund group type with a number of associated sub fund groups. (Derived from look-up to the DaFIS Chart/Account table.) |
| FAU_SUB_FUND_GROUP_CD | SUB FUND GROUP CODE | VARCHAR2(6) | The code used to identify the fund source of an account. Similar to the A11 system fund number, but will be an alpha abbreviation instead of a number. (Derived from look-up to the DaFIS Chart/Account table.) |
| PAY_BEGIN_DATE | PAY BEGIN DATE | DATE | The date on which an appointment commences to be charged against an associated distribution. |
| PAY_END_DATE | PAY ENDING DATE | DATE | The date on which an appointment ceases to be charged against an associated distribution. For pay distributions with indefinite ending dates (99/99/99), this field is null. |
| UCD_ADC_CODE | UCD ADD/DELETE/CHANGE FLAG | VARCHAR2(1) | The code indicating the type of action taken on an appointment when it was added to the PPS Data Warehouse. (values are A=add a new appointment, C=change an already existing appointment, or D=delete an existing appointment. |
| UCD_ADC_DATE | UCD ADD/DELETE/CHANGE DATE | DATE | The date when a distribution change is added to the UCD data warehouse. |
| WORK_STUDY_PGM | WORK STUDY PROGRAM CODE | VARCHAR2(1) | The code indicating the type of work study program associated with a distribution. (translation in CTLWSP table) |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to PPS Data Warehouse Support at: paysys-support@ucdavis.edu
Last Updated: August 25, 2006