Contains fiscal year budget based salary distributions. The data was drawn from Pillar, the former budgeting system, by way of the Budget Office. There is one view of the table: BUDGET_DISTRIBUTION
joins the budget distribution data to SALARY_SECURITY. Data coming from Pillar
was scrubbed in AIX before loading to the Data Warehouse to accomplish the following:
Insert fiscal year, Remove hyphens from Social Security Number, Lift department
number from home and job department fields, Create 26-digit COA account number
by concatenating components (the COA account, number is null if any one of the
components is null), Create 9-digit old account number by concatenating account
and subcode (the old account number is null if the 6-digit account number is
null, but subcode in this case is allowed to be null). 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 salary distributions of employees.
||Indexed Data Elements
- You can view a BUDGET_DISTRIBUTION row if you have security for the employee's
home school or department, the job department, or the distribution account
CNAC or ORG. As of this writing (August 1999) this table contains only fiscal
year 1997 data.
- The BUDGET_DISTRIBUTION 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