A table of staffing list budget and position summary 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. |
| AMT_OUT_OF_BAL | OUT OF BALANCE AMOUNT | NUMBER(13,4) | The amount that the Full Accounting Unit is out of balance. |
| BUDGET_AMT | BUDGET AMOUNT | NUMBER(10) | The total amount of appropriation for the Full Accounting Unit. |
| BUDGET_FTE | BUDGET FTE | NUMBER(6,2) | The total full time equivalent of apropriation for the Full Accounting Unit. |
| DIST_AMT | DISTRIBUTION GROSS AMOUNT | NUMBER(13,4) | The total calculated distribution gross produced by the staffing list detail report process for the Full Accounting Unit. |
| DIST_FTE | DISTRIBUTION FTE | NUMBER(6,2) | The total full time equivalent of distribution for the Full Accounting Unit. |
| EMP_TYPE_CD | STAFFING CATEGORIES | VARCHAR2(1) | An indicator indicating whether the budget is associated with an Academic title or Staffing title. |
| 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 ctvhme 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. |
| FTE_OUT_OF_BAL | FTE OUT OF BALANCE | NUMBER(5,2) | The Full Time Equivalent amount that the Full Accounting Unit is out of balance. |
| OUT_OF_BAL_IND | OUT OF BALANCE INDICATOR | VARCHAR2(1) | The indicator whether eith the FTE or Amount for the Full Accounting Unit is out of balance. (values are Y=yes,N=no) |
| PROV_AMT | PROVISION AMOUNT | NUMBER(13,4) | The total calculated provision gross produced by the staffing list detail report process for the Full Account Unit. |
| PROV_FTE | PROVISION FTE | NUMBER(5,2) | The total full time equivalent of the provision positions for the Full Account Unit. |
| 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