Classic ASP Discussion - eLeave System: Advice needed

Print Page | Close Window

eLeave System: Advice needed

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=16663
Printed Date: 29 March 2026 at 7:01pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: eLeave System: Advice needed

Posted By: ngaisteve1
Subject: eLeave System: Advice needed
Date Posted: 23 September 2005 at 4:20am

I have been working on a simple eLeave System. I would like to get more advice of my db design. Basically, I have 2 tables here: user and leave_application. I will just put the relevant field needed for leave calculation.

user: date_employment, type, t_annual_entitled, t_annual_actual_taken, t_annual_balance
leave_application: date_leave_from, date_leave_to

There are 2 values under type, E - Executive and NE - Non-Executive.

Example
- If type = E, t_annual = 22
- If date_employment = 7 July 2005, t_workingdays = 187
- So, my formula for t_annual_entitled = (22 * 187) / 365

So, is my db design and my formula okay for this system? Any other better ways? Advice needed. Thank you.