EHRC-RFP-007 - Competency Database Management & Development

The successful contractor must be able to build or customize an off-the-shelf system (referred to herein as Competency Building Platform) that can accomplish each requirement identified below:
 

1. Develop a competency management system that allows competencies to be created, stored, managed, edited, rearranged, and accessed
2. Allow for multiple contextual scales, lists, sections, descriptions to be added or removed
3. The system must have the ability to attach searchable metadata to all elements within the competency
4. Provide reporting/search outputs (examples of reporting could include, but not limited, last editor for a competency, last date of modification, etc.)
5. The ability to have multiple competency writers work simultaneously and independently
6. Track changes and have the ability to rollback changes
7. Provide a system that allows administrators to manage user access (e.g. limit certain users to edit only privileges)
8. Input competencies via Excel, CSV files and common database formats (optional ability to import from Word)
9. Output competencies to Word, PDF, Excel, and common, easily imported database formats
10. Search functions
11. Reporting functions
12. The system must have the capacity to store competencies in both official Canadian languages and toggle between the two
13. Demonstrate how changes made to the competency framework in one language can be flagged for update in the other language. For example, if a new competency category is entered using the English interface, a corresponding entry with a temporary placeholder title should be created in the French database with a prompt to add the French equivalent
14. The system will be used by EHRC staff and competency development contractors
15. An optional requirement for a public facing competency portal should be available for jobseekers/workers-in-transition can search for their occupation/profile/competency categories to determine where they best fit within the EHRC competency framework
16. An optional requirement for integration with other third party online software via API or other automated connection interface to allow competency/occupation specific information to be transferred to another software by request. Note, actual integration is NOT in scope for this project, just the API connection as an off-the-shelf component of the software.