110 likes | 131 Views
Sunflower Project Project Costing Conversion Workshop. June 18, 2009. Welcome & Introductions. Dean Arzoian – SMART Technical Team Manager, State Bruce Myers – SMART Technical Team Manager, Accenture Fred Barnes – Data Conversion and Interfaces Lead, State
E N D
Sunflower ProjectProject Costing Conversion Workshop June 18, 2009
Welcome & Introductions • Dean Arzoian – SMART Technical Team Manager, State • Bruce Myers – SMART Technical Team Manager, Accenture • Fred Barnes – Data Conversion and Interfaces Lead, State • Jenny Brately – Data Conversion Coordinator, Accenture • Kathy Lewis – Project Costing Lead, State • Josh San Souci – Project Costing Lead, Accenture
Converting into SMART • What Is Data Conversion? • One-time load of data into the SMART system for agency systems • Transactional Data: Transactions open at cutover to the SMART system • Master Data: Data supporting transaction processing, such as Customers • How Is It Accomplished? • File Upload: Loading data sets provided in defined formats, such as flat file extracts or Excel templates, through upload processes • Online: Data entry directly into the SMART system for low volume and/or complex data sets
Converting into SMARTAgency Conversions SMART – Projects and Contracts Projects (CNV006): Load of project and project activity definitions for projects not tied to grants, or grant-related projects for agencies not using the Grants module Contracts (CNV013): Creation of contract definitions for reimbursable projects to generate customer billing
Converting into SMART using the Upload Process • Upload Data Conversion Approach – Flat File Layout
Converting into SMART using the Upload Process • Projects Conversion (CNV006): • INF22 – Projects Upload will be used • File Type: ASCII Fixed Length • File Layout Record Structure:
Converting into SMART using the Upload Process Projects Conversion (CNV006) INF22 – Projects Upload Data File Sample
Converting into SMART using the Online Process • Online Data Conversion Approach • Purpose: Provide method of data conversion for smaller and/or complex data sets. • Timing: Online conversions will take place prior to go-live of the SMART, in June 2010. Some may take place after go-live, depending on processing needs. • Method: Enter data directly into SMART system based on paper documents, reports, queries or direct access to agency systems. Guidance for data entry will be provided by the SMART project.
Converting into SMARTKey Data Conversion Activities & Timeline Sunflower Project Timeline
Converting into SMARTSupport, Contact Information and Reference Information • Reference Material and Contact Information: • Office Hours • Tuesdays and Thursdays: 9am to 10am, 10am to 11am • Wednesdays: 2pm to 3pm, 3pm to 4pm • Website • http://www.da.ks.gov/smart/ • Email • SunflowerFMS@da.ks.gov – Include ‘Conversion’ in subject line