Project Description:
**PHP and MYSQL Application to track Pension Data?
Project will be awarded quickly within 2 days so review and bid quickly.
**
**Quick Turnaround required. Bonus opportunity.? My rating is very high so bid with confidence.
This is not a difficult application but will give developer opportunity to show their craft.
Additional work and long term relationship? for top quality work and response
Sample applications included in your bid response? have developed will enhance chances of winning the bid.
Forms and interface need to look good and provide smooth logical interface. Re-design tables as you see fit for ease of ongong maintenance
**
* Individual Contact info
* Beneficiary Info
* Salary Data
* Dates of service and some pension data
* Some Lookup Tables (State Table, Access Table etc)
* A few Simple Reports
* Convert and Load Data into MYSQL from Dbase Files (once for test system and once for final production
See additional description of project.
## Deliverables
Sample DBase tables and field descriptions included in attachments
?
**Deliverables
**
?
1) **Initial Connectivity Application**
? ? ? ? ? ? ? ? ? ? ? Simple application to install at client to establish connectivity to form a starting point to add elements of the system as they become available.?
Basically a simple login screen enter username and password and validate against UserAccess table in MySQL.? ?
Display main menu? with one menu option Maintain User Access Table
One Form to Add /Change /Delete? Authorized users to the system
?
2) I will create additional specifications on the primary form? and the code tables but to get an idea
? ? ? ? ? ? ? ? ? ? ? **Employee form** with I was thinking of tabs for? (DBF structures enclosed)
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Basic Data? (Name, DOH, DOB etc)
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Address Data
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Salary History? ? (SALARY.DBF)
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Employment History
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Pension Data
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Spouse/Beneficiary Data
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Employee Contact Form (Log of Calls made by employee to office)
? ? ? ? ? ? ? ? ? ? ? **Employer Form** 2 Tabs
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Employer Basic Form (DBF Structure Enclosed)
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Employer Billing Data
? ? ? ? ? ? ? ? ? ? ? **Code Tables (DBFs Enclosed)**
**? ? ? ? ? ? ? ? ? ? ? Scripts to Load initial Data (DBFs) into test System MYSQL)**
?
3) 2 or 3 simple reports to come later
?
4) Final changes and wipe out and reload data
?
5) Assist on getting application loaded on my laptop with source and development environment to assist in debugging and adding new features.
