Parks Expenditure and Download data Month-End Real Auto PS_PROJ_RESOURCE, SQL Server 99 Crystal reports are ODBC Revenue System from Rainier Time PS_JRNL_LN_BUDG, and MS generated by using this database to PS_JRNL_LN, Access system data. It provides APPO.mdb, PS_LEDGER, detailed financial EXPREV.mdb, PS_PO_LINE_ACCTG, information to directors, PS_PAYMENT_TBL, project managers, executive EXPSUM.mdb, PS_PYMNT_VCHR_XREF, assistants, financial REVENUE.mdb PS_PYMNT_XREF_VW, analysts and unit and SSRS.mdb PS_VCHR_ACCTG_LINE supervisors for their and decision making regarding PS_ZPO_ENC_SUMMARY budget/expenditure/revenue projections and the potential financial status of the Department. Parks - Page 2 Batch or Auto or Summit Application Name Description Frequency Real Tables Used Language Misc. Info Manual Interface Time Expenditures and Download actual Real Time Manual/DTS PS_PROJ_RESOURCE T-SQL in The directors, ODBC Revenues Views transactions SQL Server managers, Strategic (PC2005) from Advisors, Sr. Rainier database to Financial Analysts Parks SQL Server and Unit Supervisors use the Expenditure and Revenue to create the Pivot tables for their management reports Budget Download budget Month-End Real Time Manual/DTS PS_JRNL_LN_BUDG T-SQL in The directors, ODBC transactions SQL Server managers, Strategic (GLBud2005) from Advisors, Sr. Rainier database to Financial Analysts Parks SQL Server and Unit Supervisors use the Budget views to create the
Parks Expenditure and Revenue System Download data from Rainier database to APPO.mdb, EXPREV.mdb, EXPSUM.mdb, REVENUE.mdb and SSRS.mdb Month-End Real Time Auto PS_PROJ_RESOURCE, PS_JRNL_LN_BUDG, PS_JRNL_LN, PS_LEDGER, PS_PO_LINE_ACCTG, PS_PAYMENT_TBL, PS_PYMNT_VCHR_XREF, PS_PYMNT_XREF_VW, PS_VCHR_ACCTG_LINE and PS_ZPO_ENC_SUMMARY SQL Server and MS Access 99 Crystal reports are generated by using this system data. It provides detailed financial information to directors, project managers, executive assistants, financial analysts and unit supervisors for their decision making regarding budget/expenditure/revenue projections and the potential financial status of the Department. ODBC Parks - Page 2 Application Name Description Frequency Batch or Real Time Auto or Manual Tables Used Language Misc. Info Summit Interface Expenditures and Revenues Views Download actual transactions (PC2005) from Rainier database to Parks SQL Server Real Time Manual/DTS PS_PROJ_RESOURCE T-SQL in SQL Server The directors, managers, Strategic Advisors, Sr. Financial Analysts and Unit Supervisors use the Expenditure and Revenue to create the Pivot tables for their management reports ODBC Budget Download budget transactions (GLBud2005) from Rainier database to Parks SQL Server Month-End Real Time Manual/DTS PS_JRNL_LN_BUDG T-SQL in SQL Server The directors, managers, Strategic Advisors, Sr. Financial Analysts and Unit Supervisors use the Budget views to create the ODBC
Attach5.docx