job_id  job_type    job_type       User         job_time               job_name
1       1           Day            User1        2015-04-23 23:20:10   Job1
2       2           Night          User2        2015-04-23 13:20:10   Job2
3       3           Day & Night.   User3        2015-04-22 23:10:10   Job3
4       3           Day & Night.   User3        2015-04-20 13:40:10   Job4
5       1           Day            User4        2015-04-26 03:20:10   Job5

task_entry_id    job_id      task_option_type     emp_id        completed_task_count    status
1                1             Day                  101         10                      1
2                1             Day                  102         0                       0
3                1             Day                  103         5                       1
4                2             Night                101         20                      1
5                3             Day                  101         4                       1
5                3             Night                101         0                       0
6                3             Day                  102         10                      1
7                3             Night                102         5                       1

job_id      task_entry_count    status      completed_task_count
1           3                   PENDING     15
2           1                   COMPLETE    20
3           2                   PENDING     19