Employee Salary Distribution History

PAC Reporting

Salary Distribution history, which shows the amounts and percentages of an individual's salary charged to which ChartFields, can be found in the People@Columbia (PAC) Labor Accounting module.

The page in the system displays the employee's salary distribution history including the most recent profile.  

Salary Distribution information is viewable only by the home department. The most recent profile is displayed and shows all approved funding allocations for an employee's regular earnings.

You can also view the employee's most recent and historical salary distribution profiles as well as the combo codes and allocations for a particular salary distribution, if the salary was charged to more than one ChartString.

PAC Funding Setup Report provides helpful per employee funding data.  This can be found in PAC. 

 

FDS Reports

Another option is to download the FDS Payroll Detail Report or the Employee Report into Excel (be sure to save CSV file as an Excel Workbook).  Then create a pivot table (Insert>Pivot Table), then manipulate the data to create a custom table as per your needs.  To learn more about how to use Excel Pivot Tables, see Lynda.com for online training.  

 

For more detailed information, see the Labor Accounting Info Page.

 

 

Related Training & Info