I Need Help Fixing My Small Time Sheet Table - Relational DB - SQL Server

Posted by user327387 on Stack Overflow See other posts from Stack Overflow or by user327387
Published on 2010-04-29T07:16:49Z Indexed on 2010/04/29 7:27 UTC
Read the original article Hit count: 188

Filed under:
|
|

I have a TimeSheet table as:

CREATE TABLE TimeSheet
(
    timeSheetID 
    employeeID 
    setDate 
    timeIn 
    outToLunch 
    returnFromLunch
    timeOut
);

Employee will set his/her time sheet daily, i want to ensure that he/she doesn't cheat. What should i do?

Should i create a column that gets date/time of the system when insertion/update happens to the table and then compare the created date/time with the time employee's specified - If so in this case i will have to create date/time column for timeIn, outToLunch, returnFromLunch and timeOut. I don't know, what do you suggest?

Note: i'm concerned about tracking these 4 columns timeIn, outToLunch, returnFromLunch and timeOut

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server