CU Home Help
Columbia University Information Technology
 Service Alerts
 CUIT Service Catalog
 Get Help Now
 Manage My UNI
 Email
 CourseWorks
 Services Overview
 Network Overview
 Telecommunications
 Software
 Labs & Classrooms
 Printing
 Security
 Network Use Policy
 Copyright
 About CUIT
 CUIT Home


E-mail & Computing
Administrative Applications

Software > Administrative Applications

CUIT supports University-wide information applications in a variety of ways, including:
  • Implementing systems
  • Providing technical staff and management to project teams
  • Providing IT strategic planning and application portfolio management
  • Providing application security management
  • Designing and maintaining enterprise technology architecture.
Each application we support has a data owner or custodian, usually a central University administrative department, such as the Controller's Office, which owns the financial data. The data owners determine who can access their applications.

The access request process for each application is slightly different. If you need to access these applications as part of your job, you will need a University Network ID (UNI) and in some cases a CUIT Administrative ID. In addition, some of the applications below require their own ID, which is administered by the application's data owners. You will also need authorization from the application's data owner. Below are brief descriptions of the applications we support and contact information for access permission. (Further technical descriptions of CUIT administrative applications are available online.)

Accounts Payable (AP/CAR)
Advance - Alumni Development
Departmental Advanced Tracking & Reporting (DARTS)
Data Warehouse Reporting (DWR)
Financial Accounting (FAS)
Financial Front End (FFE)
Labor Distribution (LDS)
OnBase (EDM)
People @ Columbia (PAC)
Purchasing (CAPS)
Research and Compliance (Rascal)
Projects Tracking (SPOTS)
Student Information (SIS)
Web Salary Accounting Forms (WebSAF)


Back to Top

Accounts Payable/Controlled Analytical Review (AP/CAR)

Runs under Windows and allows authorized users to inquire about and enter departmental invoices at their own desktops, have them approved by authorized electronic signers, store them on the mainframe, and track their status through all phases of processing. CAR also provides entry and inquiry facilities on vendor information, 1099, and employee travel activities, as well as comprehensive reports. A CUIT Administrative ID is required. For more information go to the AP/CAR information web page or contact Procurement Systems at ac2323@columbia.edu.

AP/CAR includes OnBase, an integrated document imaging solution that allows you to send invoices to Accounts Payable electronically, view invoices and other documents online, and receive email notification of status changes and aging history.


Back to Top

Advance - Alumni Development System

Advance is the new alumni and development system that enables the University alumni and development community to coordinate the process of identifying and managing relationships with prospects and donors. It provides the infrastructure necessary to sustain the accelerating evolution of the fund-raising presence in the University environment. For more information contact the Advance Help Line at 212-851-7933 or advhelp@columbia.edu

If you are using Windows Vista:
Advance - Alumni Development - In order for the 'sync' to work you must select "Run this program as an administrator".


Back to Top

Departmental Advanced Tracking & Reporting (DARTS)

DARTS is a web-based reporting application for financial data created by Medical Center application developers. Reports are generated from a special data warehouse system of enterprise financial data, called Data Mart. Access to DARTS is through FFE.  See FFE information below.


Back to Top

Data Warehouse

Provides administrators with access to data extracted from the central University systems for analysis, decision support, and operational reporting. These central systems are:
  • Student Information Systems (SIS)
  • People @ Columbia (PAC)
  • Financial Accounting System (FAS)
  • Labor Distribution System (LDS)
  • Projects and Grants (SPOTS)
  • AP/CAR
  • Purchasing
Access is authorized by the data custodians for these systems. For more information see the Data Warehouse web site.

Please contact Susan St. John-Parsons in CUIT at 212-854-3298 or at ss53@columbia.edu for access to all information in the Data Warehouse systems, except SIS. For SIS-extracted data contact Elena Birenbaum in Student Information Systems at 212-854-8535 or send e-mail to infoline@columbia.edu.


Back to Top

Financial Accounting System (FAS)

Central record-keeping and management information system on income and expenditures for University funds of all types. Accounting information may be downloaded to user PCs to provide departments with monthly extracts (including general ledger, subsidiary ledger, and monthly transactions) for ad-hoc reporting. Online inquiry is available to departments with authorization from Ed Hamilton in the Controller's Office at 212-854-2085. A CUIT Administrative ID is required.


Back to Top

Financial Front End (FFE)

For all departmental administrators, the system allows for the creation, approvals routing, and nightly transmission of edited financial data directly from the PC to the Financial Accounting System (FAS), Labor Distribution System (LDS), and the Purchasing System (CAPS). FEE data is automatically reconciled to FAS daily. Current financial data is available through various reports. For more information see the FFE information web page.

To obtain access to FFE, fill out the Combined DAF/FFE Application Form. Print out the form (be sure to obtain the required signatures). To avoid processing delays, please forward the form to the appropriate office:

Arts and Sciences applicants: to Audrey Rosenblatt, 105 Low Library, MC 4302 (212-854-6108).

Medical Center applicants: to Medical Center Business Office, 2-443, P&S (212-305-3597).

All others: to Office of the Controller, FFE Administrator, Mail Code 8738.

For more information send e-mail to: ffetech@columbia.edu, or contact Ed Hamilton in the Controller's Office at 212-854-2085.


Back to Top

Labor Distribution System (LDS)

Allocates salary expenses from Payroll to the appropriate accounts and reports this information to the Financial Accounting System. Limited access. PAD (Payroll Account Distribution) reports provide a summary of payroll charges for each area. PADs can also be sent electronically.  For more information, contact Frank Iovino in the Controller's Office at 212-851-2820. A CUIT Administrative ID is required.


Back to Top

People @ Columbia (PAC)

This new Web-based system integrates human resources, benefits, and payroll systems. The system expands staff and managers' access to data, improves the University's hiring process, and ensures that we achieve up-to-date compliancy with government rules and regulations. Employees have the ability to update and/or view their personal human resources, paycheck, and benefits data via the web. A People@Columbia ID Application is required.

For Benefits information or access, contact Susana Kwan in Human Resources at sck2102@columbia.edu or 212-851-2932.

For HR access, contact Jim Lindner in Human Resources at jl35@columbia.edu or 212-851-2922.


Back to Top

Purchasing System (CAPS)

Provides online entry, control, distribution, and retrieval of purchase order information, as well as a variety of reports. Online inquiry is available to departments. For more information, contact Terry Park in the Purchasing Office at 212-854-7342 or tp194@columbia.edu A CUIT Administrative ID is required.


Back to Top

Research and Compliance System (Rascal)

Rascal provides Web access to research information for the entire Columbia research community. Its components include Funding Opportunities, Processing Proposals, Conflict of Interest, CV Builder, Animal Care, Compliance Testing, Human Subjects. For more information, visit the Rascal Home Page, call the Rascal Help Line at 212-851-0213 or send e-mail to rascal@columbia.edu.


Back to Top

Sponsored Projects Tracking System (SPOTS)

This system, for the Offices of Projects and Grants/Grants and Contracts (OPG/GC), is being replaced. Very limited access. Contact Carol Tycko in the Office of Projects and Grants at 212-854-6857 or 212-305-2505. A CUIT Administrative ID is required.


Back to Top

Student Information System (SIS)

Online, integrated system for admissions, student records (registration, grades, course/class, transcripts, certifications, degree audit), financial aid, student accounts, and housing. Web and/or telephone access provided to students for registration, grades, holds, course/class, account balance and check availability inquiry. Access is available to authorized users. For more information, send e-mail to infoline@columbia.edu or call the SIS Infoline at 212-854-2989. An SIS ID is required.


Back to Top

Web Salary Accounting Forms (WebSAF)

WebSAF is a web-based application that allows for the creation, editing, approval routing, and nightly transmission of information for the account distribution on an employee's salary, Fellowship, Scholarship or Traineeship to the Labor Distribution System. WebSAF is part of the FFE application. Activity on the FFE database for WebSAF is transaction-based. All transactions are retained in history for future reference, as necessary. Access to WebSAF is through FFE. See FFE information above.