A table of staffing list filled position and provision position data. The data
originates from the Planning and Budget Office Staffing List.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| ADD_DATE | STAFFING DATA SET DATE | DATE | The date the version of staffing data was produced. |
| APPT_NUM | APPOINTMENT NUMBER | VARCHAR2(2) | The number uniquely identifying a payroll distribution associated with an appointment. |
| APPT_REP_CD | APPOINTMENT REPRESENTED CODE | VARCHAR2(1) | The code indicating whethter the appointment is eligible for collective bargaining representation. (values are C=covered by collective bargaining, S=supervisor (uncovered), U= uncovered) |
| DEPT_PROV_CD | DEPARTMENTAL PROVISION CODE | VARCHAR2(6) | The departmental provision code. It is assigned by department to uniquely identify open provision. |
| DIST_AMT | CALCULATED DISTRIBUTION GROSS PAY | NUMBER(13,4) | The calculated distribution gross pay amount produced by staffing list detail report process. |
| DIST_ANNUAL | CALCULATED ANNUAL DISTRIBUTION PAY | NUMBER(13,4) | The calculated annual distribution pay amount produced by staffing list detail report process. |
| DIST_NUM | DISTRIBUTION NUMBER | VARCHAR2(1) | The number uniquely identifying a payroll distribution. |
| DIST_FTE | DISTRIBUTION FULL TIME EQUIVALENT | NUMBER(5,2) | The percentage of the budgeted position which the distribution represents. |
| DIST_PAYRATE | DISTRIBUTION PAY RATE | NUMBER(9,4) | The full-time hourly rate, pay period amount, or by agreement amount associated with the distribution. |
| EMPLOYEE_ID | EMPLOYEE ID NUMBER | VARCHAR2(9) | The unique employee identification number. |
| EMP_NAME | EMPLOYEE NAME | VARCHAR2(26) | The name of the employee. Format is "last,first m". |
| EMP_TYPE_CD | STAFFING CATEGORIES | VARCHAR2(1) | An indicator indicating staffing categories. (values are A=academic, S=staff) |
| FAU_CHART | CHART OF ACCOUNTS NUMBER | VARCHAR2(1) | The chart of accounts identifier. (translation in coacrt table) |
| FAU_ACCT | ACCOUNT NUMBER | VARCHAR2(7) | The organization-chosen identifier used to classify financial resources for accounting and reporting purposes. (translation in coaacr table) |
| FAU_SUBACCT | SUB ACCOUNT NUMBER | VARCHAR2(5) | The more detailed account code (Cost Center) used to track detail transactions. The sub account takes on the attributes of the account it reports to, including account manager, fund group and function code. (translation in coasac table) |
| FAU_OBJ_CONSOLDTN | OBJECT CONSOLIDATION NUMBER | VARCHAR2(4) | The identifier for a group of object levels and their associated objected codes for budgeting and Office of the President requirements. (translation in coaobj table) |
| FAU_SUBOBJ | SUB OBJECT NUMBER | VARCHAR2(3) | Provides for an object code to be broken down into greater detail. (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. (translation in coaprj table) |
| FAU_HOME_DEPT_CD | FUNDING DEPARTMENT CODE | VARCHAR2(6) | The department associated with the funding. Currently used to identify campus departments for Staffing and report distribution. (Derived from look-up to the DaFIS Chart/Account table) (translation in ctlhme table) |
| FAU_ORG_CD | ORGANIZATION CODE | VARCHAR2(4) | The identifier of an organization. (Derived from look-up to the DaFIS Chart/Account table) |
| FAU_SUB_FUND_GRP_CD | SUB FUND GROUP NUMBER | VARCHAR2(6) | The DaFIS sub fund group code. |
| FISCAL_YEAR | FISCAL YEAR | NUMBER(4) | The four-digit Fiscal Year during which this staffing budget transaction was processed. |
| RECORD_TYPE_CD | DATA SOURCE IDENTIFIER | VARCHAR2(2) | The identifier indicating where the data came from. (values are PA=payroll, PR=provision) |
| TITLE_CD | TITLE CODE | VARCHAR2(4) | The code indicating the position classification associated with the distribution or provision. (translation in ctltci table) |
| TITLE_CD_DESC | JOB TITLE CODE ABBREVIATED NAME | VARCHAR2(30) | A short description of the title code. |
| TITLE_CD_UNIT | TITLE/BARGAINING UNIT CODE | VARCHAR2(2) | The code indicating the collective bargaining unit to which a title code belongs to. (translation in ctlbut table) |
| PAY_END_DATE | PAY ENDING DATE | DATE | The end date of this distribution. |
| PROV_AMT | CALCULATED PROVISION GROSS PAY | NUMBER(13,4) | The calculated provision gross produced by staffing list detail report process. |
| PROV_ANNUAL | CALCULATED ANNUAL PROVISION PAY | NUMBER(13,4) | The calculated annual provision pay produced by staffing list detail report process. |
| PROV_FTE | PROVISION FULL TIME EQUIVALENT | NUMBER(5,2) | The percentage of the budgeted position which the provision represents. |
| PROV_PAYRATE | PROVISION PAY RATE | NUMBER(9,4) | The full-time hourly rate, pay period amount, or by agreement amount associated with the provision. |
| PROVISION_DESC | PROVISION DESCRIPTION | VARCHAR2(60) | The open provision description and comments. |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comments to PPS Data Warehouse Support at: paysys-support@ucdavis.edu
Last Updated: May 19, 1999