Stack Overflow
Stack Overflow

Questions tagged [time-and-attendance]

Time and Attendance systems are those that keep track of people's comings and goings. Typically this refers to employees working in a business. However it can also be used in other contexts, such as students attending a class.

Time and attendance systems are those that keep track of people's comings and goings. Typically this refers to employees working in a business. However it can also be used in other contexts, such as students attending a class.

There are a whole range of technical problems involved with this category of business systems, such as:

  • Date/Time Set and Interval mathematics
  • Nuances of date and time in the real world
  • Pattern recognition in event streams
  • Business rules engines
  • And much more.

Time and Attendance systems also tend to overlap (Venn diagram style) with the following:

  • Payroll Systems
  • Scheduling Systems
  • Access Control Systems
  • Employee Benefits Systems

The broader category of these systems is known as Workforce Management.

StackOverflow is not the place to discuss commercial Time and Attendance products. However, there are many programming problems associated with building these products, or integrating with them, that may be appropriate if phrased properly.

Also appropriate are generalized questions that would be useful if building an in-house Time and Attendance system.

165 questions
0
votes
1 answer

MSSQL: identify Cohorts from Session Attendance data

I have data on group session attendance by topic, in which one row is one user attending a session on a given date/time. A group offering can have a set number of sessions, e.g. 10, and they are usually offered at the same time (StartTime) and day…
user2716667
  • 15
  • 5
0
votes
1 answer

Check of Time In (Attendance c#)

I am making a small program where an employee will time in/out. The employee has an Employee ID and that is the one that must be used in order to time in and out. Timing in is okay but my problem here is that the employee can time in a lot of times…
Naomi
  • 131
  • 1
  • 3
  • 13
0
votes
0 answers

Displaying Student Attendance from mysql database

I have 4 tables for student attendance. Students (sid, name, regno) classes (classid, startdate, enddate) Student to Classes (sid, classid) class attendance (classid, sid, attendance, date) I want to display attendance data of a class…
Aamir Bashir
  • 21
  • 6
0
votes
1 answer

filter IN and OUT punch timings for Attendance in Day and Night shifts in oracle SP?

I am developing Attendance system which having day and night shift I am unable to filter the IN and OUT punches of the employees? below is my current logic. shift timings on 29-Jun-2015 IN 22:00 OUT 07:00 and on 30-Jun-2015 IN 15:00 OUT 22:30 I am…
Tom
  • 1,343
  • 1
  • 18
  • 37
0
votes
1 answer

SQL to determine if a non-attendance is a “DROPOUT”

I have an attendance table with attendance per week either "Present" or "Absent" and need to have it changed as follows with reasons attached: If a person does not attend for an entire month he is changed to a "DROPOUT" for the weeks he/she was…
user1627440
  • 105
  • 1
  • 2
  • 8
0
votes
0 answers

Analyzing fingerprint attendance log

I'm developing an attendance system using VB.NET & SQL server 2008. there is a shifts table with Start & End time of each shift. and there is an employee table. each employee may have one or more shifts. I'm using a log file taken from the…
ybloodz
  • 167
  • 2
  • 13
0
votes
1 answer

MySQL time and attendance "parse filter" type and status

I have one table.a with multiple columns, but only three are important for the case, lets name them time_stamp, employee_number and station_id. I got this query: SELECT checktime AS time_stamp, userid AS employee_number, SN AS station_id FROM…
crisjff
  • 11
  • 5
0
votes
0 answers

Attendance App JS

I have to create an attendance app for a school project. I'm only allowed to use HTML, CSS and JavaScript Here is my HTML for adding a student
RandomRainbow7
  • 11
  • 2
  • 5
0
votes
3 answers

calculate attendance and mark absentees for each day MS SQL

this is a table for attendance logs: CREATE TABLE [dbo].[DeviceLogs] ( [DeviceLogId] INT NOT NULL, [UserId] NVARCHAR (50) NOT NULL, [LogDate] DATETIME NOT NULL, ); this is my employee table: CREATE TABLE…
ravi
  • 1
  • 1
  • 2
0
votes
1 answer

Attendance register using asp classic

I am looking for vb script in asp classic as below: I have one table named "attendance" in MSSQL2005 database which has some records. The table includes 2 columns (sname, sdate). My question is how can I show all records like attendance register,…
lokesh purohit
  • 179
  • 2
  • 2
  • 16
0
votes
1 answer

Best way to build sql table with unknown number of columns

I am planning a database that will record school attendance for students everyday. The problem is that i cant predict the total numbers of student in a class and also the days will increase steadily, so i am struggling with the MySQL db part. Should…
detola1234
  • 3
  • 3
0
votes
2 answers

How to link a website with an android app

I was wondering how can you link the fields of a website with an app. Like I have a college attendance website where we all check our attendance and then a student made an app on android where we login by entering the student id and password. So how…
modo_incognito
  • 1
  • 1
0
votes
0 answers

Attendance Data as per clock IN/OUT Sql server

I am trying to develop an attendance application which calculates the shift details as per the Clock IN OUT Data , the following are the table details CREATE TABLE [dbo].[INOUTData]( EmpID VARCHAR(10), CLockDate Date NULL, [INTIME] …
Lijo
  • 1
  • 2
0
votes
2 answers

Best way to determine and store Pay Periods for a time clock in PHP and MySQL

I am building a Time Clock application with PHP and Laravel 4. My boss requires that he is able to pull and build different reports based on the data I store in the database for a Time Card record. Right now I store a DateTime for clock in and clock…
JasonDavis
  • 48,204
  • 100
  • 318
  • 537
0
votes
1 answer

PostgreSQL - Comparing time with value >24:00

I'm developing an attendance application using PHP with PostgreSQL as the database. Here is my table: ID - int, PK Name - character varying(50) In - time without time zone Out - time without time zone Basically, I want to check how many person are…
Brian Sumali
  • 5
  • 1
  • 3
1 2 3
…
10 11