Challenge Overview
Project Overview
Welcome to the OPM SCRD Test Data Creation contest! In this contest, you will need to provide Test Data for the SCRD System. This is not a normal Test Scenarios contest. This is a Test Data creation contest.
The Office of Personnel Management (OPM) has an existing legacy application called the Service Credit Redeposit/Deposit System (SCRD). The mission of the Service Credit Redeposit/Deposit System (SCRD) is to compute deposits and redeposits, create an initial bill, post payments, and send out receipts to federal employees for periods of federal employment service that were either not covered by retirement deductions (deposits), or were covered and later refunded by the federal government (redeposits).
This competition will provide Test Data to be used during the developement of all SCRD modules.
Tips for success:
- Asking questions early and getting feedback is very important for the success of this competition.
- Raise questions if you feel anything is confusing, or if you have any questions on the provided documentation (Copilot and PM will be available to answer questions).
Contest Objective
The goal of this competition is to provide Test Data based on different scenarios provided by the client.
The provided scenarios are a bunch of every day usage scanned documents from the client where you will find all data that will be used in the SCRD system (Account information, Payment Deposits/redeposits ...)
The Test Data needs to be formatted according to the Database model provided in the Data Services Module Architecture.
You can get inspired from the Test Data available in the OPM Demo PoC VM Assembly (see provided resources)
Technologies
- SQL
Provided Resources
Documentation Provided
The following documentation will be available :
- SCRD Scenarions: http://apps.topcoder.com/wiki/download/attachments/93159486/Scenarios.zip
- OPM Data Services Module Architecture: http://apps.topcoder.com/wiki/download/attachments/93159486/OPM+Data+Services+Module+Arch+-+11-8-13.zip
- OPM Demo PoC VM Assembly http://apps.topcoder.com/
wiki/download/attachments/ 93159486/OPM+Demo+PoC+VM+ Assembly+12-30-12.zip - OPM project Wiki: http://apps.topcoder.com/wiki/display/projects/OPM
Final Submission Guidelines
Submission Deliverables
You must provide Test Data in the form of SQL scripts for all the provided scenarios.
Final Submission
- Your final submission must contain a single .zip file with all the submission deliverables.
- For each member, the final submission should be uploaded to the Online Review Tool.
- You must not include any identifying information, such as your handle, in your submission. Your submission should be anonymous and you will be scored down in screening for not complying.