Orange County NC Website
Browse       Search
6 <br /> <br /> <br />Orange County (via SFTP site) and create/update existing employee records <br />within the ClearRisk system. High-level activities include: <br /> <br />● SFTP Configuration <br />● Mapping of Employee roster to ClearRisk System <br />● Data Automation (to create/update existing employee records) <br /> <br />The integration will be limited to the data column headers from Appendix B Tab <br />“Employee Roster Integration” and will use the Employee Number column as the <br />unique identifier when matching or creating records. <br /> <br />See Appendix D for workflow diagrams that include how integration will <br />operate, and Appendix C for process diagrams that include ClearRisk’s general <br />process for configuring integrations. <br /> <br />5.0 Data Migration <br />Several types of data will be provided to ClearRisk by Orange County for <br />manipulation and insertion into the ClearRisk system based on ClearRisk best <br />practices. Data will be provided via Orange County completing ClearRisk data <br />migration templates, or ClearRisk will manually manipulate Orange County <br />existing data. See list of data types below as well as if a reference data sheet <br />will be manipulated or ClearRisk’s data migration templates will be used: <br /> <br />Data to be provided via ClearRisk migration templates <br /> <br />● Departments <br /> <br />The data provided to ClearRisk by Orange County will be limited to that <br />contained in the column header samples in Appendix B Tab “Data Migration” as <br />well as the record amounts listed below. See below for list: <br /> <br /> <br />Data Type Excel Sheet Tab <br />(Appendix B) <br />Records <br />DocuSign Envelope ID: BD441C19-1E7C-4FDE-8321-A4585AF240A5