Employee Time Sheet

Navigation: Systems Manual > Attendance Monitoring System > Data Entry >

Employee Time Sheet

The Employee Time Sheet app contains the list of employees whose hours worked are computed and summarized for payroll processing. The daily time sheets are generated from the biometric time sheet data.

Step-by-step instructions:

1. Open Cenral Menu. Your Central Menu maybe different from the screenshot below as each user can have different menu and access rights.

2. Select Systems ->Attendance Monitoring System

3. Double-click Master Files -> Employee Time Sheet.

4. Enter Pay Year and Pay Month to retrieve saved data, if any.

5. Click Ok and you will be redirected to Employee Time Sheet tab window.

6. Enter payroll data under the data grid, Payroll Calendar

7. Select and double click DTS -> Generate TimeSheet - ALL. This will generate the time sheet based on the biometric time sheet data.

8. Review the generated time sheet for each employee. Make necessary correction, if any.

9. Click Save to persist changes made to the database.

Data Definition for Payroll Calendar
Database Table Name: pay_Calendar
Primary Key: CoID+ DocNo

Column Name	Sample Value	Description
CoID	T10	Auto-filled up. The company id that the user is log-in.
DocType	PAY	Auto-filled up. The value is always PAY
DocNo	00001	Auto-generated number. This serves as the primary key.
GLDate	10/15/2020	The date to be used when exporting the journal entries into the GL System
PayDesc	Oct 1-15, 2020	Description of the payroll
PayYear	2020	Payroll Year. This is used when computing the year-end alphalist.
PayMonth	October	Payroll Month. This is used when computing the monthly contributions
PaydayFrequencyID	1st Payday	This is used in computer other benefits and allowances.
FactorPayDayID	Semi-monthly	This is used to retrieve payroll based on this category
PayDateFr	10/01/2020	The beginning date to be used in generating time sheet.
PayDateTo	10/15/2020	The end date to be used in generating time sheet.
WTaxComputationID	Regular	Choose between Regular and Annualized. The Annualized is usually used in the month of December
GroupID	Head Office	Optional only. The employee group where they are assigned. It is used to filter the employee to be generated
LocationID		Optional only. The branch where the employee is assigned . It is used to filter the employee to be generated.
EntityCode		???
EntityName		???
Approvedby		The employee who approved the payroll
DateApproved		The date of approval
IsPosted		Check to lock the payroll from being modified.
Status	A	A=Active; I=InActive.
Createdby, DateCreated, Modifiedby, DateModified		These columns are called audit trails. Their values are auto-generated. One who created or modified the app. It is assumed that the current user is the one who created or modified the record.

Data Definition for Employee Hours Worked Summary. This table is used in computing payroll of each employee

Database Table Name: pay_HrsWorkedSummary
Primary Key: CoID+DocNo+EmpID

Column Name	Sample Value	Description
CoID		Hidden column. Automatically fill up. Hidden column.
DocNo		Child column key. Automatically filled up based on the parent column value. Hidden column
EmpID		Employee ID
EmpName		Employee Name
DaysWorked		Number of days worked. This is used in computing allowance based on number of days worked, if any.
DaysOT		Number of days in overtime. This is used in computing allowance based on number of OT days, if any.
DaysOOT		Number of days in out of towm. This is used in computing allowance based on number of OOT days worked, if any.
Absences		Number of days of absences. For hald-day, enter 0.50
LatesGracePeriod		Total allowable grace period in computing lates for the whole payroll period.
Lates/TotalHrsLateDeduction		Total Lates to be deducted. (TotalLates - LatesGracePeriod)
TotalLates		Total actual lates
RT_RegDay		Regular Time hours worked during regular day
OT_RegDay		Overtime during regular day
ND_RegDay		Night differential during regular day
OTND_RegDay		Overtime and night differential during regular day
RT_RestDay		Regular Time hours worked during rest day
OT_RestDay		Overtime during rest day
ND_RestDay		Night differential during rest day
OTND_RestDay		Overtime and night differential during rest day
RT_Holiday		Regular Time hours worked during holiday
OT_Holiday		Overtime during holiday
ND_Holiday		Night differential during holiday
OTND_Holiday		Overtime and night differential during holiday
RT_HolidayRestDay		Regular Time hours worked during holiday amd rest day
OT_HolidayRestDay		Overtime during holiday amd rest day
ND_HolidayRestDay		Night differential duringholiday amd rest day
OTND_HolidayRestDay		Overtime and night differential during holiday amd rest day
RT_SpecialDay		Regular Time hours worked during special non-working day
OT_SpecialDay		Overtime during special non-working day
ND_SpecialDay		Night differential during special non-working day
OTND_SpecialDay		Overtime and night differential during special non-working day
RT_SpecialDayRestDay		Regular Time hours worked during special non-working day and rest day
OT_SpecialDayRestDay		Overtime during special non-working day and rest day
ND_SpecialDayRestDay		Night differential during special non-working day and rest day
OTND_SpecialDayRestDay		Overtime and night differential during special non-working day and rest day
HolidayPay		Holiday Pay. Some companies pay additional holiday pay when holiday falls on Sunday
SL_NonTaxable		Non taxable Sick Leave
SL_Taxable		Taxable Sick Leave
VL_NonTaxable		Non taxable Vacation Leave
VL_Taxable		Taxable Vacation Leave
TimeSchTypeID		Time Schedule of the employee.
PayClassID		Payroll classificatin of the employee. Fixed Payday = employee with fixed pay or Daily Rate = employee is paid per hour
DeptID		Department ID where the employee is assigned
DeptName		Name of the department.
ContractNo		The contract number to be charged
ContractDesc		Contract description.
Remarks		Any remarks you want to add
Status	A	A=Active; I=InActive.
Createdby, DateCreated, Modifiedby, DateModified		These columns are called audit trails. Their values are auto-generated. One who created or modified the app. It is assumed that the current user is the one who created or modified the record.

Data Definition for Time Sheet

Database Table Name: pay_TimeSheet
Primary Key: DocNo + EmpID + PayDate

Column Name	Sample Value	Description
CoID		Hidden column. Automatically fill up. Hidden column.
DocNo		Child column key. Automatically filled up based on the parent column value. Hidden column
BioID		Biometric ID of the employee
EmpID		Employee ID
EmpName		Employee Name
PayDate		The payroll date
Day		Automatically filled up. Refers to the day of the week.
Filler		Hidden column. Filler is used when the company uses 12MN as the cut-off day when computer holiday. It is recommended to use 24-hour to simplify computation
IsHoliday		Check if the PayDate is holiday. If you fill-up the Holiday master file, the value will automatically determine by the system
IsRestDay		Check if the PayDate is an scheduled rest day of the employee
IsSpecialDay		Check if the PayDate is a non-working day. If you fill-up the Holiday master file, the value will automatically determine by the system
TimeIn		Time IN of the employee. The system uses the first time in of the employee as his/her time in.
AdjTimeIn		Hidden column. The value is the scheduled Time In of the employee instead of the actual time in as the system uses this value in computing hours worked of the employee. Flexi-time employee uses the actual time in.
TimeOutAM		Optional only. Used only when computing undertime
TimeInPM		Optional only. Used only when computing undertime
TimeOutPM		Optional only. Used only when computing undertime
TimeInOT		Optional only.
TimeOut		Time OUT of the employee. The system uses the last time out of the employee as his/her time out.
LeadTimeOut		Optional only. The time out after midnight. This is necessary when computing holiday pay for the next day is a holiday.
_Fx		Hidden. This is used by the system when computing hours worked when user click the Recompute Formula button.
OB		Check if the employee is under Official Business
AutoOT		Check if the system will computer overtime automatically even without the OT form
ApprovedOT		Check if the OT is approved.
MaxOTApproved		The max OT hours approved, leave 0 if unlimited
RT		Computed Regular Time for the day. This is important for Daily Wage Earner where the actual hours worked is used in computing their salary
OT		Computed Overtime for the day
ND		Computed Night Differential for the day
OTND		Computed OT and ND
Lates		Lates=ISNULL(LatesAM,0)+ISNULL(LatesPM,0)
LatesAM		Lates in terms of hours
LatesPM		Lates in terms of hours
Undertime		Undertime=ISNULL(UndertimeAM,0)+ISNULL(UndertimePM,0)
UndertimeAM		Undertime in terms of hours
UndertimePM		Undertime in terms of hours
L_RT, L_OT, L_ND, L_OTND, L_Lates, L_LatesAM, L_LatesPM, L_Undertime, L_UndertimeAM, L_UndertimePM,		Hidden columns. Use only for Lead Time when computing holiday for employees who worked after midnight and considered as holiday pay
AWOL		Check if the employee is AWOL.
Absences		Number of days of absences. For hald-day, enter 0.50
LeaveWithPay		Number of days of leave with pay. For hald-day, enter 0.50
DaysWorked		Number of days worked. This is used in computing allowance based on number of days worked, if any.
DaysOT		Number of days in overtime. This is used in computing allowance based on number of OT days, if any.
DaysOOT		Number of days in out of towm. This is used in computing allowance based on number of OOT days worked, if any.
HolidayPay		Amount of holiday pay, if any. Some company pays additional holiday pay when the holidays falls on Sunday or Rest day of the employee
SL_Taxable		Number of days on taxable SL, if any
VL_Taxable		Number of days on taxable VL, if any
SL_NonTaxable		Number of days on non-taxable SL, if any
VL_NonTaxable		Number of days on non-taxable VL, if any
LunchBreak	1	Number of hours to be deducted from the total hours worked of the employee.
OTBreak		Number of hours to be deducted from the total hours worked of the employee. Ex: 5pm - 5:30pm is considered as OT Break for some companies..
MidNightBreak	1	Number of hours to be deducted from the total hours worked of the employee who worked after midnight. Ex: 12MN - 1:00am is considered as MidnightBreak for some companies..
L_LunchBreak L_OTBreak, L_MidNightBreak		Hidden columns. Use only for Lead Time when computing holiday after midnight when the next day is a holiday
PayClassID	F	Either Fixed or Daily paid. Payroll computation for Fixed Type is the based on the Fixed Monthly/Semi-monthly or Weekly salary rate less absences and lates. For Daily Type, the computation is based on the actual hours worked multiplied by the employee daily rate.
SchTimeIn, SchTimeOutAM, SchTimeInPM, SchTimeOut, SchTimeInGracePeriod, SchTimeInCutOff, SchTotalRT, SchLunchBreak, SchOTBreak, SchMidNightBreak, SchLunchBreakDeduction, SchOTBreakDeduction, SchMidnightBreakDeduction, SchMinRT, SchMinOT, SchMaxUndertime		Time Schedules of the employee
PayableHrs		Total computed payable hours.
PayableHrsPreND		Total computed payable hours before ND. This is used by the system in computing ND
PayableND		PayableND=ISNULL(ND,0)+ISNULL(OTND,0)
L_PayableHrs, L_PayableHrsPreND, L_PayableND,
PayClassID	F	Either Fixed or Daily paid. Payroll computation for Fixed Type is based on the Fixed Monthly/Semi-monthly or Weekly salary rate less absences and lates. For Daily Type, the computation is based on the actual hours worked multiplied by the employee daily rate.
PayTaxTypeID		Select from the dropdown list: Above, MWE, Contractor and ROHQ
ContractNo		The contract number to be charged
ContractDesc		Contract description.
Remarks		Any remarks you want to add
Status	A	A=Active; I=InActive.
Createdby, DateCreated, Modifiedby, DateModified		These columns are called audit trails. Their values are auto-generated. One who created or modified the app. It is assumed that the current user is the one who created or modified the record.