Find Jobs
Hire Freelancers

Simple HR Leave/Sick tracking website

$30-250 USD

Selesai
Disiarkan hampir 9 tahun yang lalu

$30-250 USD

Dibayar semasa penghantaran
We have an old Leave/Sick tracking system in Lotus Notes. The software is so old that it only works on older computers. We are going to switch to Kronos in 2-3 years, but need something to replace the current Lotus Notes system as it keeps crashing. Basically, we need a web site (preferred in PHP) linked to a Microsoft SQL Server (that is a requirement at our office) that allows the HR person to enter vacation time and sick time for our employees. We have about 1,700 employees, so we need the accrual to be automatic, either by a monthly cron job or a MS SQL scheduled task. You can design the database how you feel is best. I will have most of the data in a CSV file that will need to be imported to SQL Server. We probably will start with a few records, and then eventually import all ~1700 users into the database before we go live. The website will be for internal use only, it will not be public facing. But we do need a simple login for the HR folks to update data, and keep all other employees out from modifying the data. On the first of every month, each full time employee gets 6.66 hours of sick time and between 8-14 hours of vacation time, depending on their years of service (0-5 years, 6-10 years, 10-15 years and 16+ years). Part time employees get less, depending on their FTE percentage, for example, 1/2 time employees get 3.33 hours of sick time, etc. There is a cap on vacation and sick time for employees. For example, 0-5 year employees earn a max of 192 hours a year. If they have more than 192 hours on July 1, it is lost/capped at 192. On our annual fiscal year (July 1), we need to roll over any excessive sick time over the cap to vacation time, at a rate of 5 sick hours to 1 hour vacation time. For example, if someone has 400 hours of sick time on July 1, we will take 400-360=40 hours then 20% of 40 hours is 8 hours. Roll that 8 hours over to vacation. If vacation is maxed out to the cap, they lose that 8 hours. The HR person needs to be able to manually override sick or vacation time. Maybe someone forgot to turn in their leave slip, or someone took time off without pay, then they need to adjust the leave time manually. We need to print two different kinds of reports, one a summary and one is detailed. I have attached a few pages of them as PDFs to this bid. Please look at them and review. The Leave Summary is more detailed for each user. Notice for some users, the report is put on two pages. We would like to fit it all on one page. The second page is where the HR person's override information is put in, and it is where the roll over or cut off at the beginning of the fiscal year is reported. We would like to print reports either by Org Unit or by name. For example, If we want to print the reports of everyone in DCJ org unit, then the report should show all DCJ org unit. We also have State Patrol, indicated by SPxx where xx is the troop number. We want to be able to print either all patrol troop numbers, or specify a troop, such as SP1A for troop 1A or SP* for all troops. The second report is more of a summary of all employees' leave balance. It is in alphabetic order from A to Z by last name. We would like it to look like the Sick and Annual [login to view URL] - but get the top columns lined up a little better. I will have a Ubuntu 14.04 test server for you to get on with both FTP access and SSH access. I will also give you access to a test SQL server (Microsoft SQL Server 2008 R2 Express). I'm not sure if you will have SQL Server Studio Management Studio access from your remote location or if you need to RDP into the server to use SSMS. I'm still working on it. We will only communicate via emails, Freelancer PMs or Google Hangouts/Chat. There will be no phone, voice or video conversation held.
ID Projek: 7723053

Tentang projek

10 cadangan
Projek jarak jauh
Aktif 9 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
Good day , I am ready to start work with you and make it using (ASP.NET and SQL Server ) If my technology ok with u let me know so i will breakdown all of you requirements to tasks with estimations . looking forward to hearing from you Thanks BR, Yasser Shehab Team Leader Software Developer [login to view URL]
$223 USD dalam 7 hari
5.0 (21 ulasan)
5.7
5.7
10 pekerja bebas membida secara purata $938 USD untuk pekerjaan ini
Avatar Pengguna
Dear Sir, Able to start right now. I have more than 2+ years experience in jquery,ajax,html,css,php, paypal integration and web based cms and frameworks like joomla,codegintter etc. I read all your description and know exactly what is needed to do and within timeline. I hope I am able to help you and I am waiting for your reply. Regards, bdphpguru
$244 USD dalam 7 hari
4.9 (90 ulasan)
5.2
5.2
Avatar Pengguna
Hello, i have more than 8 year experience in php,html,mysql and i can help you for sure we will talk more when we meet together Thanks Ricky
$155 USD dalam 3 hari
4.7 (31 ulasan)
5.2
5.2
Avatar Pengguna
very small change for me to get this project. But if you chose me, i can start project and finish it. after finish you can pay money for me. You can chat with me to deal Project cost. I need only 10$/hr for project and alway support when you want
$5,555 USD dalam 30 hari
5.0 (10 ulasan)
4.1
4.1

Tentang klien

Bendera UNITED STATES
Arvada, United States
5.0
25
Kaedah pembayaran disahkan
Ahli sejak Dis 8, 2004

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.