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

BUDGET_DISTRIBUTION Table

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

Common Uses
To locate the budgeted base salary distributions of employees.

BUDGET_DIST_SEQUENCE_NUMBER

BUDGET_DIST_SEQUENCE_NUMBER

DISTRIBUTION_ACCOUNT

DISTRIBUTION_COA_ACCOUNT

DISTRIBUTION_COA_CENTER_REF

DISTRIBUTION_COA_CNAC

DISTRIBUTION_COA_FUND

DISTRIBUTION_COA_OBJECT

DISTRIBUTION_COA_ORG

DISTRIBUTION_COA_PROGRAM

FISCAL_YEAR

HOME_DEPT

HOME_DEPT_ORG

HOME_SCHOOL

HOME_SCHOOL_CTR

JOB_CLASS

JOB_DEPT

JOB_DEPT_ORG

SSN

EMPLOYEE (DWADMIN)

Cautions

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

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