StrengtHening Integrity and accountability program 1 (SIAP 1)*
*Support for Indonesian Corruption Eradication Commission - Directorate of *
*PJKAKI*
*Terms of Reference*
*Position* : *Web Database Designer** for Court
Monitoring Database Application*
*Starting Date* : August 2012
*Duration of Contract *: 6-8 months
*Counterpart (User)* : Indonesia Corruption Eradication Commission –
Directorate of PJKAKI
*Background and Objectives *
KPK’s Strategic Plan for 2008-2011 seeks to improve
the integrity and effectiveness of oversight functions at each agency (page
8) and the National Strategy on Eradication of Corruption (2010-2025)
seeksto improve
coordination of reports on corruption eradication efforts (p.18).
To improve the effectiveness of combating corruption, KPK have conducted
court recording on corruption cases and other cases related to KPK. This
court recording is being coordinated by Directorate of PJKAKI and Deputy of
Information and Data. The data and information about court recording is
gathered by KPK and University team who worked with KPK.
The work will be done in two phases, the first phase will be the design and
analysis phase and the second phase will be the development phase. The
developer will need to complete the database design and analysis phase
before moving on to development phase.
* *
*Activities***
*A. **Database Design and Analysis*
1. Gather and analyze requirements to support database design.
Web designer will work with web deveoper to and develop a database design
document within two months of signed contract.
*B. **Web database design and development*
1. Interface design, modification, and development of web database
applications.
The whole process of designing interface, modifying looks and feel, and
co-develop web database applications should be done by the end of
4th-6thmonth of signed contract.
2. Participates in the testing process; through test, review and
analysis of application.
Testing process with review and analysis of application should be done for
one month by the end of 5th-7th month of signed contract.
3. Modify the web database application design based on test, review
and analysis.
Redesigining interface, look and feel of web applications will be done for
one month and will be finished by the 6th-8th month of signed contract.
* *
*
*
*Requirements*
1. Have a minimum of 2 (two) years experience in designing web
applications, preferably for a government agency;
2. Have past experience and knowledge regarding:
a. Photoshop, Flash and other design applications;
b. XHTML/DHTML, CSS, Javascript;
c. PHP and web database knowledge will be an advantage;
3. Have an experience in writing user manual and system documentation.
This user manual will be accessible in the system where users can access
them easily;
4. Have an experience in user training;
5. Be able to work closely with web developer to develop the user
interface;
6. Have a satisfactory record of Past Performance; and
7. Be able to provide the Services within the time period.
*Deliverables***
The web designer will be part of the team to provide the same deliverables
as below.
1. Report/Documentation on database and system design process (detailed in
annex).
2. Web database application on court monitoring that consists of:
a. Administrative tools to manage coordination and
communicationbetween KPK and Universities.
b. Court Monitoring Reporting System
i. Court Recording Planning.
ii. Documentation of Court Recording.
iii. Record and retrieve information related to Court
Rulling/Verdict.
iv. Database migration from other application to Court Monitoring
System Database to PostgreSQL.
v. Migration from spreadsheet to PostgreSQL.
vi. Generate connection from Court Monitoring System to Document
Management System (ELO) through API (Upload, download, File Listing).
vii. Public Examination.
viii. Database management (1 master database resides in KPK, 1 database
is accessible for public), the data will be pushed from master database to
public database in a scheduled time.
Notes: Details of deliverables is under Annex A.
* *
*Counterparts:*
1. Directorate of PJKAKI (primary) - KPK
2. Directorate of Data Processing and Information - KPK
3. KPK Bureau of Law
*ANNEX A. Detail information on deliverables.*
1. Report/Documentation on database and system design process
including:
a. Database mission statements and objectives,
b. Analysis,
c. Data structure,
d. Table relationships,
e. Business rules,
f. Views, and
g. Data integrity.
h. Software Requirements Specification
i. Use case Model
ii. Activity Diagram
iii. Form/Report Design
i. Application Code
j. Technical Documentation
k. System Configuration
l. User guides
2. Web database application on court recording that consists of
several functions to:
a. Coordination and Communication
i. Forum
ii. Mailbox or personal message to users
iii. Authorization of Court Recording
iv. University team data
v. Workplan for KPK and Universities (Schedule)
b. Court Recording Reporting System
i. Court Recording Planning
ii. Documentation of Court Recording
1. Recapitulation of trial process
a. Court name, Judges, prosecuters, lawyers, lawfirms, suspects
b. Trial resume
2. Realization of court recording
a. Report by case
b. Report on the use of DVD
3. Financial report for each trial
iii. Record and retrieve information related to Court Rulling/Verdict
1. Cases’ title, number and date
2. Court name
3. Verdict Summary and Status (Inkracht/Banding)
4. Modus and Type of Crime (Jenis Pidana)
5. Judges
6. Prosecutors
7. Lawyers
8. Lawfirms
9. Suspects
10. Duration of Verdict (Range in months) – indictment vs verdict
11. Indictmen Contstruction
a. Tunggal
b. Alternatif (X atau Y)
c. Kumulatif (X dan Y)
d. Primer/Subsider/Lebih Subsider
12. Fine - indictment vs verdict
13. Compensation - indictment vs verdict
14. Confinement - indictment vs verdict
15. Sector/Area of Corruption
iv. Database migration from other application to Court Monitoring
System Database (PostgreSQL)
v. Migration from spreadsheet to PostgreSQL
vi. Generate connection from Court Monitoring System to Document
Management System (ELO) through API (Upload, download, File Listing)
vii. Public Examination
viii. Database management (1 master database resides in KPK, 1 database
is accessible for public), the data will be pushed from master database to
public database in a scheduled time.
No comments:
Post a Comment