Timesheets

The Activities table captures details about the various tasks or activities that employees work on. It includes fields like Name, Code, and Project Reg. Number (to associate the activity with a specific project), along with the Start Date and End Date of each activity. This table helps ensure that each task is tracked with its specific timeframe and project alignment.

The Cost Centers table holds information related to different organizational cost centers, which may be departments or units responsible for budgeting and expense tracking. Fields like Name and Description offer clarity on the purpose of each cost center, ensuring expenses and time are correctly allocated.

The Projects table records essential information about ongoing projects, such as the Reg. Number, Name, Location, and Project Manager responsible. This table helps in organizing time entries by project and ensures that managers can easily access relevant project information.

Finally, the Timesheets table is the core table where individual time entries are logged. Key fields include the Activity Name, Cost Center Name, and Timesheet for User, along with the Start Date, End Date, and Submitted Date. This table also tracks who authorized the timesheet and stores other relevant details, ensuring a complete and accurate record of time spent on each activity for reporting and billing purposes.