Header1
Columbia University Effort Reporting
Search Finance
Columbia University Effort Reporting
Finance HomeEffort ReportingColumbia UniversityResearch HomeEffort Reporting

What is ECRT?


ecrt logoIn October 2007, Columbia University launched an on-line, web-based effort reporting system called ECRT (Effort Certification and Reporting Technology). This system facilitates both the monitoring of effort distributions during the year and the required annual certification of effort. ECRT can be used to monitor effort for the current fiscal year, which ends June 30. The annual certification period begins in October.

Click here to access ECRT.

ECRT training is available for Effort Coordinators and faculty.  Click here for additional information.

Below are various resources including step-by-step instructions for how to use ECRT:

Faculty
ECRT Training Resource Description File

How to Certify Effort in ECRT

Step-by-step instructions for certifying effort in ECRT.

PDF Icon How to Certify Effort in ECRT

How to Certify Effort for Others in ECRT

Step-by-step instructions for PIs certifying research staffs' effort in ECRT.

PDF Icon How to Certify for Others in ECRT

Certify Effort Video

A simulation that provides a step-by-step tutorial on how to certify effort in ECRT.  It does not have narration, but it does have some sound effects. 

Flash video icon Certify Effort

How to Certify Effort for Others Video

A simulation that provides a step-by-step tutorial on how to certify effort for your researchers in ECRT.  It does not have narration, but it does have some sound effects. 

Flash video icon Certify Effort for Others

Overview of Effort Reporting and ECRT

A slide presentation that provides an overview of Effort Reporting at Columbia.

PowerPoint iconECRT Training Faculty

ECRT Frequently Asked Questions

FAQs about the ECRT System

PDF Icon ECRT FAQs


Effort Coordinators
ECRT Training Resource Description File

ECRT System Training

This course is mandatory for all effort coordinators. It will familiarize effort coordinators with ECRT and will provide step-by-step instructions on using the system.

If you have not had training, click here to send an email to receive information on upcoming trainings.

Click here for additional information.

How to View Certifiers in Your Department

Step-by-step instructions for viewing certification status for your department.

PDF Icon
How to View Certifiers in Your Department

Using Query Analyzer to Run Reports

Step-by-step instructions for using Query Analyzer to Run Reports.

PDF Icon
Using Query Analyzer to Run Reports


| Top |