BUDGET_BASE Table - Data Element Index   Tables and Data Elements   Salary Management Home   Data Warehouse Home

BUDGET_BASE Table

Explanation
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.

Common Uses
To locate the budgeted base salaries of employees.

BUDGET_BASE_SEQUENCE_NUMBER

BUDGET_BASE_SEQUENCE_NUMBER

FISCAL_YEAR

HOME_DEPT

HOME_DEPT_ORG

HOME_SCHOOL

HOME_SCHOOL_CENTER

SSN

EMPLOYEE (DWADMIN)

Cautions

• 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.

BUDGET_BASE Table - Data Element Index   Tables and Data Elements   Salary Management Home   Data Warehouse Home