Challenge Overview
Project Overview
As part of the Claims Panel Counsel Management strategic initiative, claims would like to improve the storage and maintenance of claims panel counsel by loading their existing data into a database and creating a new maintenance application to replace the use of a spreadsheet. They would also like to automate the feedback and rating process to better manage approved counsel.
Challenge Overview
For this challenge, we will primary build base application and CRUD functionality of this project. We’d like you to:
1. Build the DB structure. The provided Data Elements_v2.xlsx has all the information you need to build the database.
2. Load the initial data from the provided excel file. The import process from the spreadsheet should be repeatable either via grunt or gulp command.
3. Create user groups. This application will only be available to internal employees, although user authentication is out of scope for this challenge we need to establish the user groups (claims and administration).
4. Create the Counsel Management functionality, that includes:
- Counsel CRUD - when adding a new record:
- None of the fields will be required.
- Default the status field to active
- Attorney records (Vendor Type) will not be deleted. Instead, they will be marked with the inactive status.
- All fields described in the data elements spreadsheet will be editable by the Administration group (assume the current user is in Administration group).
Technical Requirements
If possible, use the latest versions of the following:
- NodeJS. You are require to use this NodeJS style guide.
- MySQL (Keep in mind that the end state will be MS Sequel but we will use MySQL for challenges)
- Sequelize (Make sure you don't use any MySQL specific functionality. Models must be compatible with MSSQL)
- Use AngularJS for Front end JavaScript. Use this AngularJS style guide.
- Use http://passportjs.org/ for any authentication (if needed)
- We will be using Bootstrap for the stylesheet and the client want’s to use the Cube Bootstrap Admin Theme + AngularJS theme. The template can be downloaded from this link: https://dl.dropboxusercontent.com/u/172732/products_WB008R559.zip
- Use SASS pre-processor for any CSS update.
- Use nodeunit for unit testing.
Final Submission Guidelines
Submission Deliverables
For each member, the final submission should be uploaded via the challenge detail page on topcoder.com.
Below is an overview of the deliverables. Please check against the challenge scorecard:
- Source code
- Deployment Guide
- Simple unlisted video of your solution in action
- Unit tests and helper scripts to help verify your application successfully meets the requirements.
- Any additional scripts to setup database, configuration, etc.