VIMS Tracking the insurance status of Payment information to SUMMIT via STORM (to taxicab operating within the City be confirmed) WORKS City’s credit card and Epayable Payment information to SUMMIT (direct system (Bank of America) interface) Parks Page 1 Batch Auto or Summit Application Name Description Frequency or Real Tables Used Language Misc. Info Manual Interface Time Expenditure and Revenue Download budget Annually Batch Manual PS_JRNL_LN_BUDG PeopleTools ODBC Budget data from SUMMIT Queries and Budget Module and Excel upload to GL Capital Improvement Download data Month-End Real Auto PS_PROJ_RESOURCE SQL Server 52 Crystal reports are ODBC Project System from Rainier Time MS Access generated by using this database to SQL system data. It also Server and then provides data information to forward to feed the CIP Monitor System. It provides CIP.mdb, detailed financial CIPEXPREV.mdb information to CIP and CIPSUM.mdb managers, Sr. financial analysts and unit supervisors for their decision making regarding budget/expenditure/revenue projections and the potential financial status of the Department.
VIMS Tracking the insurance status of taxicab operating within the City Payment information to SUMMIT via STORM (to be confirmed) WORKS City’s credit card and Epayable system (Bank of America) Payment information to SUMMIT (direct interface) Parks Page 1 Application Name Description Frequency Batch or Real Time Auto or Manual Tables Used Language Misc. Info Summit Interface Expenditure and Revenue Budget Download budget data from SUMMIT Budget Module and upload to GL Annually Batch Manual PS_JRNL_LN_BUDG PeopleTools Queries and Excel ODBC Capital Improvement Project System Download data from Rainier database to SQL Server and then forward to CIP.mdb, CIPEXPREV.mdb and CIPSUM.mdb Month-End Real Time Auto PS_PROJ_RESOURCE SQL Server MS Access 52 Crystal reports are generated by using this system data. It also provides data information to feed the CIP Monitor System. It provides detailed financial information to CIP managers, Sr. financial analysts and unit supervisors for their decision making regarding budget/expenditure/revenue projections and the potential financial status of the Department. ODBC
Attach5.docx