A table containing the staffing list detail budget transactions. The data originates
from the Planning and Budget Office Staffing List.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| ADD_DATE | STAFFING DATA VERSION DATE | DATE | The date of the version of staffing data was produced. |
| BUDGET_AMT | BUDGETED AMOUNT | NUMBER(10) | The amount of appropriation or income transaction. |
| BUDGET_DATE | BUDGET TRANSACTION DATE | DATE | The date when the transaction was posted to the general ledger. |
| BUDGET_DESC | BUDGET TRANSACTION DESCRIPTION | VARCHAR2(60) | The narrative information about the nature or source of a transaction. |
| BUDGET_FTE | BUDGETED FTE | NUMBER(6,2) | The amount of an appropriation full time equivalent transaction. |
| DOC_REF_NBR | DAFIS DOCUMENT REFERENCE | VARCHAR2(9) | The DaFIS document reference number for this staffing list detail report. |
| EMP_TYPE_CD | STAFFING CATEGORIES | VARCHAR2(1) | An indicator indicating whether the budget is associated with an Academic title or Staff title. (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. Assigned by account managers. (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) | The code which 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_SUB_FUND_GRP_CD | SUB FUND GROUP NUMBER | VARCHAR2(6) | The DaFIS sub fund group code. |
| FAU_ORG_CD | ORGANIZATION CODE | VARCHAR2(4) | The identifier of an organization. (Derived from look-up to the DaFIS Chart/Account 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) |
| FISCAL_YEAR | FISCAL YEAR | NUMBER(4) | The four-digit Fiscal Year during which this staffing budget transaction was processed. |
| ORIGIN_CODE | DOCUMENT ORIGIN CODE | VARCHAR2(2) | The DaFIS document origin code. (Currently "--") |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to PPS Data Warehouse Support at: paysys-support@ucdavis.edu
Last Updated: May 19, 1999