Orange County NC Website
Browse       Search
| Statement of Work | Traverse Implementation Project <br />| Work Activities Work Activities 8 <br />The MEI will include demographic data from existing cases and people from ACTS. To assist its creation, <br />Northwoods will use an import tool to perform a one-time import of ACTS demographic data from NC Data <br />Warehouse and automatically add it to the MEI. <br />Northwoods will consult with Orange CSS on the custom fields that Orange CSS requires and then configure <br />these custom fields in Traverse. Northwoods will then consult with Orange CSS on how to connect specific <br />content items to specific cases, people, and/or organizations within Traverse. <br />Please note that Orange CSS will be responsible for maintaining the MEI once Northwoods finishes the initial <br />import of data from ACTS. This will involve Orange CSS creating all new cases in Traverse as part of the agency’s <br />day-forward approach. To ensure that the MEI is appropriately maintained, Northwoods will provide Orange <br />CSS with MEI consultation as part of this project's scope. <br />ETL Configuration <br />Extract, transform, load (ETL) configuration involves importing data from disparate system(s)—ACTS via NC Data <br />Warehouse—into Traverse. Northwoods will configure the following ETL processes: <br />• A one-time import of ACTS demographic data from NC Data Warehouse to Traverse <br />Northwoods will determine ETL requirements—inclusive of a unique case file or case member identifier—during <br />the ancillary system evaluation sessions, documenting the results in the Solution Design Document project <br />deliverable. <br />Consistent with the approved Solution Design Document, Orange CSS will provide Northwoods with, at a <br />minimum, an ACTS CSV file (or similar method of transport) consisting of case, client, and service provider <br />demographic data. <br />Northwoods will then complete a preliminary configuration of the ETL process to ensure it appropriately imports <br />data. Following the preliminary configuration, Northwoods will conduct an ETL review with Orange CSS as <br />described in “ETL Review” on page 9. <br />The Northwoods project team will test the ETL process(es) as designed and documented in the Solution Design <br />Document within a dedicated test environment to confirm the system complies with specified requirements. <br />During ETL testing, Northwoods will validate that client, case, and provider information from ACTS is available <br />within Traverse and mapped to the appropriate fields within the solution. <br />Please note that the ACTS data transfer from NC Data Warehouse will be one way (from NC Data Warehouse <br />into Traverse). Exporting data from Traverse to NC Data Warehouse or ACTS is considered outside project scope <br />and would be subject to change request(s). <br />DocuSign Envelope ID: D7D212FB-FBC9-4D6C-91D3-137CA2E41E22