Financial Systems

Support

Service Description

Central record-keeping and management information system on income and expenditures for University funds of all types.
Status: 
Active

Details

Financial Systems comprise of the following modules:

FAS Module - Central record-keeping and management information system on income and expenditures for University funds of all types.  (Available only to Controller’s Office)

  • General Ledger and Subledger management.
  • Provides online, batch, and reporting for FAS system.
  • Daily file maintenance.
  • Compliance with University accounting audit regulations.
  • Maintain interfaces with systems within and outside the university such as Data Warehouse, DARTS, and FFE, from which FAS data can be viewed; and other university systems.
  • Workflow development and enhancement support.
  • Manage application development and infrastructure maintenance activities
  • Monthly and annual FAS reporting.
  • Data Management
For access to FAS contact: Edwin Hamilton
 
For application security access visit: http://www.columbia.edu/acis/adminapps/#fas
 
Standard Costs: No cost for accessing the system (centrally funded).  (N.B.: Freeze on special projects is in effect until July 2012.)
 
Service and Support Contacts:
1st Level of Support - University helpdesk:  212-854-1919 or email:  ffetech@columbia.edu
2nd and 3rd Level of Services : Controller’s Office – Ed Hamilton | CUIT – Bill Thompson or Joan Richards
 
Service Targets: Online available M-F, 7am-7pm; Sat, 7am-6pm; Sun by special arrangement (with email notification of maintenance downtimes).
 
Service Eligibility: Users authorized by the appropriate Finance Security Administrator
 
Prerequisites: Authorization by the appropriate (departmental) Finance Security Administrator.
 

 
FinSys Module – Includes the following functions and features:
  • Budgeting Tools
  • Cash
  • Inter Departmental Invoicing (IDI)
  • Application Security Maintenance
  • P-Card Administration
  • Change Order
  • Vendor Create
  • WebPur
  • Various Financial Reports
  • Maintain Interfaces with systems within the university such as: Data Warehouse, DARTS, Payroll, LDS, FAS, CAPS, APCAR etc.
  • Workflow development and enhancement support.
  • Manage application development and infrastructure maintenance activities
  • Reporting
  • Data Management
For access to FinSys please visit:  http://www.my.columbia.edu
 
 
Standard Costs: No cost for accessing the system (centrally funded). (N.B. Freeze on special projects is in effect until July 2012.)
 
Service and Support Contacts: 
1st Level of Support -  CU Helpdesk: 212-854-1919 or  email: ffetech@columbia.edu
2nd and 3rd Level of Services - CUIT – Joan Richards
 
Service Targets: Available from 7am-6am (with email notification of maintenance downtimes).
 
Service Eligibility: Users authorized by the appropriate Finance Security Administrator
 
Prerequisites: Authorization by the appropriate (departmental) Finance Security Administrator.
 

 
FFE Module - Includes the following functions and features:
  • Account Create
  • Attribute Change
  • Journal Entry (JE)
  • Purchasing Requisition
  • Time Collection
  • Various Financial Reports
  • Maintain Interfaces with systems within the university such as Data Warehouse, DARTS, Payroll, LDS, FAS, etc.
  • Workflow development and enhancement support.
  • Manage application development and infrastructure maintenance activities
  • Reporting
  • Data Management
For access to FFE please visit: http://www.ais.columbia.edu/car/install.htm
 
 
Standard Costs:  No cost for accessing the system (centrally funded). (N.B. Freeze on special projects is in effect until July 2012.)
 
Service and Support Contacts: 
1st Level of Support -  CU Helpdesk : 212-854-1919 or email : ffetech@columbia.edu
2nd and 3rd Level of Services -  CUIT – Joan Richards
 
Service Targets: Available from 7am-6am (with email notification of maintenance downtimes).
 
Service Eligibility: Users authorized by the appropriate Finance Security Administrator
 
Prerequisites: Authorization by the appropriate (departmental) Finance Security Administrator.
 

 
APCAR – Invoice Processing/Vendor Maintenance
  • Provide the processing of approved vouchers via direct deposit, payment by check or wire transfer.
  • Annual 1099 reporting of services from all identified 1099 vendors.
  • Provide application maintenance service for up-to-date compliance with government rules and regulations.
  • Maintain Interfaces with systems within and outside the university such as Data Warehouse, CAPS, FAS, FFE, SIS, InfoEd, OnBase, Unclaim Properties, Patient Refund, PSS, Store Room and NextSource.
  • Workflow development and enhancement support.
  • Manage application development and infrastructure maintenance activities
  • Account Payable reporting needs
  • Data Management
For access to APCAR visit the APCAR application access page at: http://www.ais.columbia.edu/car/install.htm
 
 
 

 

Standard Costs:  No cost for accessing the system (centrally funded). (N.B. Freeze on special projects is in effect until July 2012.)
 
Service and Support Contacts:
1st Level of Support - AP Service Center: 212-854-2122, ServiceCenterWeb Form
2nd and 3rd Level of Services - Procurement Services:  Anthony Cerbins | Accounts Payable: Joseph Labetti | CUIT: Joan Richards
 
Service Targets:  Mon-Wed 7am-8pm, Thurs-Fri 7am-7pm Sat 7am-6pm (with email notification of maintenance downtimes).  
 
 

 

Service Eligibility: Users authorized by the appropriate Finance Security Administrator
 
Prerequisites: Authorization by the appropriate (departmental) Finance Security Administrator.
 

 
CAPS (Available only to Purchasing Office)
 
  • Provide the processing of Purchase Orders, Change Orders and Requisitions.
  • Provide application maintenance service for up-to-date compliance with government rules and regulations.
  • Maintain Interfaces with systems within and outside the university such as Data Warehouse, AP/CAR, FAS, FFE, OnBase.
  • Workflow development and enhancement support.
  • Manage application development and infrastructure maintenance activities
  • CAPS reporting needs
  • Effort Reporting
 
  • This system facilitates both the monitoring of effort distributions during the year and the  required annual certification of effort.
  • Provide application maintenance service for up-to-date compliance with government rules and regulations, and for application version upgrades.
  • Maintain Interfaces with systems within the university such as Data Warehouse directly, and FAS & Labor Accounting indirectly.
 
For application access please email:  purchasing@columbia.edu
For application security access please visit: http://www.columbia.edu/acis/adminapps/#caps
 
 

 

Standard Costs:  No cost for accessing the system (centrally funded). (N.B. Freeze on special projects is in effect until July 2012.)
 
Service and Support Contacts:
1st Level of Support - AP Service Center: 212-854-4179 or email purchasing@columbia.edu
2nd and 3rd Level of Services - Procurement Services:  Anthony Cerbins | Purchasing Office: Hugh Horowitz | CUIT: Joan Richards 
 
Service Targets: Mon-Wed 7am-8pm, Thurs-Fri 7am-7pm Sat 7am-6pm (with email notification of maintenance downtimes).  
 
 

 

 
Service Eligibility: Users authorized by the appropriate Finance Security Administrator
 
Prerequisites: Authorization by the appropriate (departmental) Finance Security Administrator.
 

 
ECRT - Effort Reporting
 
Effort reporting is the federally-mandated process by which the salary charged to a sponsored  project is certified as reasonable in relation to the effort expended on that project. This system facilitates both the monitoring of effort distributions during the year and the required annual certification of effort. 
 
For application access please visit: http://www.effortreporting.columbia.edu/
 
For information about security and access please email: effort-reporting@columbia.edu
 
 

 

Standard Costs:  No cost for accessing the system (centrally funded). (N.B. Freeze on special projects is in effect until July 2012.)
 
Service and Support Contacts
1st Level of Support: email effort-reporting@columbia.edu
2nd and 3rd Level of Services:
Office Of the Controller  - Kristi Lynn Vitale
Office Of the Controller – Orlando Byrd
CUIT - Joan Richards 
CUIT - Irina Guletsky
 
Service Targets: Mon - Sat 12am - 11:59pm, Sun 3:am - 11:59pm
 
 

 

Service Eligibility: Users authorized by the appropriate Finance Security Administrator
 
Prerequisites: Authorization by the appropriate (departmental) Finance Security Administrator.