Addendum 1: Specific Tasks to be Performed – Web and Database Systems Consultant
1. Build a relational MS SQL Server database with tables based on the Project’s data collection tools for these components:
• Sex Workers (SW)
• Men who have sex with other men (MSM)
• Marginalized Youth (MY) and
• Drugs users (DU).
• Trainings and Sensitizations
• Peer Educators Trainings
• System Users
• General
• Reports (narrative)
2. Program a web based application in Asp.Net and C# using the development software Microsoft Visual Studio 2010, with a module for each one of the components mentioned above, applying all necessary validations and security procedures and based on their specific sets of data collection tools (forms):
• Sex Workers (SW)
o Interventions Data collection form (Maintenance: add/save/edit//delete/search)
o Queries (filtered, multi variable), by:
Two dates period (All fields)
Dates and: User / Country / Type of Activity / Gender / Age group / NGO / PE / Site / New-Subseq / Education /
Type of Activity = Individual and: Country / Age Group / Gender / Co-Factors / Place / NGO / PE / Site / New-Subseq / Education / Referrals to HIV Test / Referral to Other Services / Safe Spaces / Support Groups / Accompanied / Minimum Packages
Type of Activity = Group and: Country / Place / NGO / PE / Site / Education / Referrals to HIV Test / Referral to Other Services / Safe Spaces / Support Groups / Accompanied / Minimum Packages
o Detailed report listing stratified by: Month / Country / NGO / PE
o Summarized report by: Dates period / Country / NGO / PE
o Summarized report by: Dates period / Country / NGO / Type of Activity / Gender / Age
• Men who have sex with other men (MSM)
o Interventions Data collection form (Maintenance: add/save/edit//delete/search)
o Queries (filtered, multi variable), by:
Two dates period (All fields)
Dates and: User / Country / Type of Activity / Self Identified Gender / Age group / NGO / PE / Site / New-Subseq / Education /
Type of Activity = Individual and: Country / Age Group / Self Identified Gender / Identity / Co-Factors / Place / NGO / PE / Site / New-Subseq / Education / Referrals to HIV Test / Referral to Other Services / Safe Spaces / Support Groups / Accompanied / Minimum Packages
Type of Activity = Group and: Country / Place / NGO / PE / Site / Education / Referrals to HIV Test / Referral to Other Services / Safe Spaces / Support Groups / Accompanied / Minimum Packages
o Detailed report listing stratified by: Month / Country / NGO / PE
o Summarized report by: Dates period / Country / NGO / PE
o Summarized report by: Dates period / Country / NGO / Type of Activity / Gender / Age
• Marginalized Youth (MY)
o Interventions Data collection form (Maintenance: add/save/edit//delete/search)
o Queries (filtered, multi variable), by:
Two dates period (All fields)
Dates and: User / Country / Type of Activity / Gender / Age group / NGO / PE / Site / New-Subseq / Education / Referrals to HIV Test / Referral to Other Services / Safe Spaces / Support Groups / Accompanied / Minimum Packages
Type of Activity = Individual and: Country / Age Group / Gender / Co-Factors / Place / NGO / PE / Site / New-Subseq / Education / Referrals to HIV Test / Referral to Other Services / Safe Spaces / Support Groups / Accompanied / Minimum Packages
Type of Activity = Group and: Country / Place / NGO / PE / Site / Education / Referrals to HIV Test / Referral to Other Services / Safe Spaces / Support Groups / Accompanied / Minimum Packages
o Detailed report listing stratified by: Month / Country / NGO / PE
o Summarized report by: Dates period / Country / NGO / PE
o Summarized report by: Dates period / Country / NGO / Type of Activity / Gender / Age
• Drugs users (DU)
o Interventions Data collection form (Maintenance: add/save/edit//delete/search)
o Queries (filtered, multi variable), by:
Two dates period (All fields)
Dates and: User / Country / Type of Activity / Gender / Age group / NGO / PE / Site / New-Subseq / Education / Referrals to HIV Test / Referral to Other Services / Safe Spaces / Support Groups / Accompanied / Minimum Packages
Type of Activity = Individual and: Country / Age Group / Gender / Co-Factors / Place / NGO / PE / Site / New-Subseq / Education / Referrals to HIV Test / Referral to Other Services / Safe Spaces / Support Groups / Accompanied / Minimum Packages
Type of Activity = Group and: Country / Place / NGO / PE / Site / Education / Referrals to HIV Test / Referral to Other Services / Safe Spaces / Support Groups / Accompanied / Minimum Packages
o Detailed report listing stratified by: Month / Country / NGO / PE
o Summarized report by: Dates period / Country / NGO / PE
o Summarized report by: Dates period / Country / NGO / Type of Activity / Gender / Age
• Trainings and Sensitizations
o Training Activity Data collection form (Maintenance: add/save/edit//delete/search)
o Queries (filtered, multi variable), by:
Two dates period (All fields)
Dates and: User / Country / Type of Activity / Target population / Gender / Profession / Population served / NGO
o Detailed report listing stratified by: Dates period / Country / NGO / Type of Activity
o Summarized report by: Dates period / Country / NGO / Type of Activity
o Summarized report by: Dates period / Country / NGO / Type of Activity / Profession / Gender
• Peer Educators Trainings
o PE Training Activities Data collection form (Maintenance: add/save/edit//delete/search)
o Queries (filtered, multi variable), by:
Two dates period (All fields)
Dates and: User / Country / Target population / Gender / Profession / NGO
o Detailed report listing stratified by: Dates period / Country / NGO /
o Summarized report by: Dates period / Country / NGO / Gender
• System Users
o Maintenance: add/save/edit/user level setting/delete/search users
o Users password change
• General (All populations)
o General Intake Form Maintenance: add/save/edit/user level setting/delete/search
o Queries to include all populations by:
Two dates period (All fields)
Dates and: User / Country / Type of Activity / Gender / Age group / NGO / PE / Site / New-Subseq / Education /
Type of Activity = Individual and: Country / Age Group / Gender / Co-Factors / Place / NGO / PE / Site / New-Subseq / Education / Referrals to HIV Test / Referral to Other Services / Safe Spaces / Support Groups / Accompanied / Minimum Packages
Type of Activity = Group and: Country / Place / NGO / PE / Site / Education / Referrals to HIV Test / Referral to Other Services / Safe Spaces / Support Groups / Accompanied / Minimum Packages
o Detailed report listing stratified by: Month / Country / NGO / PE
o Summarized report by: Dates period / Country / NGO / PE
o Summarized report by: Dates period / Country / NGO / Type of Activity / Gender / Age
• Reports (narrative)
o Create a module where users can upload their narrative report files to a folder on the server.
3. Create a desktop backup version of the system, which has to let users update the web database with any records entered offline.
4. Write a developer’s guide in Spanish, aimed to programmers for future maintenance procedures.
Other specifications:
• The application must include a Login and a Language Selection module.
• All modules should be in Spanish and English languages.
• Layouts of forms on screen most look similar to the physical paper forms.
• Records added to the system most track user and dates information.
• As the system must be pilot tested with real data from a user-case scenario, and using different browsers, it could need some post pilot refinements.
• There will be an option to sign a follow-up contract to perform periodic updates or modifications to the system on demand.
