Reporting

Columbia University streamlines the reporting environments into two repositories: Accounting and Reporting at Columbia (ARC) and the University Data Store (UDS).

ARC provides real-time access to financial data and the University Data Store (UDS) is the data warehouse repository, where data from ARC, PAC/LA, Student, and Historical/Legacy system data is stored.

Within the University Data Store (UDS) is the HR Data Store.  The HR Data Store is the location of the HR, PAC and Labor Accounting Reports.  The data in the HR Data Store is “day old data”.  That is, running a report today displays information as of yesterday.  

There are many HR, PAC and Labor Accounting reports available to help you in managing your day to day activities.

 

 

Labor Accounting Reports

Labor Accounting reports provide detail on Fringe Rates, Funding Setup, Payroll Information and Suspense Detail in a Department, Employee or Combo Code view. Access to Labor Accounting Reports is provided to the following PAC roles:

  • Manager Self-Service
  • Manager Reporter
  • Labor Accounting Approver

 

Employee Job and Personal Information Reports

Manager Self-Service (MSS) Reports

Manager Self-Service reports provide earnings and payroll information in an employee or department view.  Access to MSS Reports is provided to the following PAC roles:

  • Manager Self-Service
  • Manager Reporter
 

HR Manager Reports

HR Manager Reports provide additional information related to job and personal information, position management, termination and more. Access to HR Manager Reports is provided to the following PAC roles:

  • Manager Self-Service
  • Manager Reporter

Reports can be easily accessed from the Reports area in the HR Manager Resources section on the myColumbia portal.

For information on PAC roles and their required training, refer to the PAC Roles to Training Chart in the Related Document section.

 

Custom Reports

For information on custom reports and mailings, reference the Custom Reports and Mailings page.