Orange County NC Website
Browse       Search
3 <br /> <br /> <br />with the TPA claim number when received. If the number is not input to the <br />record it will not be updated with TPA status/financials. <br /> <br />The Loss Run file will be provided by Orange County to the ClearRisk SFTP, and <br />the integration will run on a moving forward basis meaning ClearRisk’s <br />integration will update any existing claims, but entering new or missing claims <br />into the system will be the responsibility of Orange County. <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’s best <br />practices. Data will be provided via ORANGE COUNTY completing ClearRisk’s <br />data migration templates (specific list of data-types listed in 5.1 below) and <br />ClearRisk will manually manipulate ORANGE COUNTY existing data (specific list <br />of data-types listed in 5.2 below). <br /> <br /> <br />5.1 Data migrated via ORANGE COUNTY spreadsheets <br /> <br />See below for the list of data-sets to be migrated via spreadsheets (non- <br />template) provided by ORANGE COUNTY to ClearRisk: <br /> <br /> <br />Data Type Excel Sheet Tab <br />(Appendix B) <br />Records <br />Policies Policies 15 <br /> <br />The data migration will be executed based on ClearRisk best practices meaning <br />provided data will be manipulated to fit into ClearRisk’s standard modules and <br />fields. ClearRisk staff will endeavor to map the fields defined in the Data <br />Docusign Envelope ID: D2823CF9-24EF-4CAA-AF7E-6E5594A72609