Skip to Content
-1

Need help in designing custom tables

Nov 22, 2017 at 06:02 PM

49

avatar image
Former Member

time-sheet-project.jpegHi friends,

I am designing a complex timesheet which consists of editable WD ALV. there are seven fields emp id, emp name, date, time type, from time, to time and total time respectively. My doubt is that how many custom tables do i need to design and what all fields do i need to include. I am getting stuck in the DB design. Please check the attachment for the complete details.

Regards,

Saurav Lahiry

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jörgen Lindqvist Nov 23, 2017 at 07:13 AM
0

It is hard to help with this without knowing the full picture of the requirements, your development process and the current system. But here are some basics:

So for transactional data, the fields that the user is entering need to be in the tables while the fields that are fetched from other related tables or calculated need not. In your example, I guess the name will be in HR tables already, and the total time is something that you calculate? If that is the case, you won't need them as fields in you db table.

For customizing, you would need a table for your possible values of the Time Type, if you are not using standard. (The alternative is to hardcode them into the programs, but I would not recommend that from a maintainability and customization perspective. Though I do not know your requirements and system). You can choose to include the rules also in that table, i.e. "number of years as employee" and "managers", or use the authorization concept or (again) hardcode in the program.

Well, that were som basics. Then there is something about "Quota" you need to handle as well. And you might need some flag for approval?

Good luck!

Share
10 |10000 characters needed characters left characters exceeded