A table of employees with multiple pay distributions from the staffing list. The data
originates from the Planning and Budget Office Staffing List.
Fields Definition
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| ADD_DATE | STAFFING DATA SET DATE | DATE | The date the version of staffing data was produced. |
| DIST_AMT | CALCULATED DISTRIBUTION GROSS PAY | NUMBER(13,4) | The calculated distribution gross produced by staffing list detail report process. |
| DIST_FTE | DISTRIBUTION FULL TIME EQUIVALENT | NUMBER(5,2) | The percentage of the budgeted position which the distribution represents. |
| 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 whether the budget is associated with an Academic title or Staffing title. (values are A=academic,S=staff) |
| EMPLOYEE_ID | EMPLOYEE ID NUMBER | VARCHAR2(9) | The unique employee identification number. |
| FAU_CHART | CHART OF ACCOUNTS NUMBER | VARCHAR2(1) | The chart of accounts identifier. (translation in coacrt table) |
| FAU_ACCT | ACCOUNT NUMBER | VARCHAR2(7) | 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 Staffinf 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. |
| TITLE_CD | TITLE CODE | VARCHAR2(4) | The code indicating the position classification associated with the distribution or provision. (translation in ctltci table) |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data
Warehouse Support
Last Updated: May 6, 1999