Contains budget base salaries by fiscal year. The data was drawn from Pillar, the former budgeting system,
by way of the Budget Office. There is one view of the table: BUDGET_BASE joins
the budget base data to the SALARY_SECURITY Table. Data coming from Pillar was"scrubbed" in AIX before loading in the Data Warehouse to remove hyphens from
Social Security Numbers, insert the fiscal year and lift the department number
from the input "home department" field. Updates to this table are performed
at the request of the Budget Office. The Loader operates in full "replace" mode,
so that all data must be supplied at all times. This table was last loaded with
fiscal year 1997 data.
To locate the budgeted base salaries of employees.
||Indexed Data Elements
- You can only see a BUDGET_BASE row if you have security for the employee's
home school or department. As of this writing (August 1999) this table contains
only fiscal year 1997 data.
- The BUDGET_BASE table can be found in the DWADMIN schema.
Questions about this page? Email us at email@example.com
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania