tbl_attendance_workschedule

1 rows


Description

Module: HRMS Time & Attendance (Work Schedule Master)
Purpose: Stores the current, master configuration for different employee work schedules used across the organization.
Data: Defines required working hours (daily/weekly/monthly), flexible work settings, and the calculation basis for attendance and leave.
Process Usage:
- Directly referenced by the attendance processing engine to calculate an employee’s daily and period attendance status (e.g., present, half-day, absent).
- Linked to employee records to apply specific working hour rules.
Key Points:
- Critical for payroll accuracy, compliance with labor laws regarding work hours, and standardizing scheduling rules.
- Supports configuration for both fixed and flexible work arrangements.
Business Impact: Ensures fair and compliant tracking of employee working time.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_attendance_workschedule_id_seq'::regclass)

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single master work schedule configuration.
workschedulename varchar 255 √ null

The user-friendly name of the work schedule (e.g., “Standard 5-Day WFH,” “Factory Flexi-Shift”).
Format: Varchar/Text.
flexibletype varchar 20 √ null

Defines the type of flexible schedule applied (e.g., Daily, Weekly, Monthly, or Not Applicable).
Format: Varchar/Text.
duration varchar 20 √ null

The standard total time duration covered by the schedule configuration (e.g., 8:00 hours).
Format: Time/Interval.
reason varchar 1000 √ null

General notes or justification for the creation or modification of this specific schedule configuration.
Format: Text.
monthlyminimumhours int4 10 √ null

The minimum total working hours required over a monthly period to meet attendance compliance for this schedule.
Format: Time/Interval.
weeklyminimumhours int4 10 √ null

The minimum total working hours required over a weekly period to meet attendance compliance for this schedule.
Format: Time/Interval.
dailyminimumhours int4 10 √ null

The minimum working hours required daily to qualify for a full day of attendance credit.
Format: Time/Interval.
dailyhalfdayminimumhours int4 10 √ null

The minimum working hours required daily to qualify for a half day of attendance credit.
Format: Time/Interval.
hoursforfulldayleave int4 10 √ null

The number of hours used as working credit or deducted from an employee’s balance for a full day of leave.
Format: Time/Interval.
hoursforhalfdayleave int4 10 √ null

The number of hours used as working credit or deducted from an employee’s balance for a half day of leave.
Format: Time/Interval.
stage varchar 20 √ null

The current lifecycle stage of the work schedule configuration (e.g., Draft, Active, Archived).
Format: Varchar/Text.
workingdayscount int4 10 √ 0

The number of required working days in the schedule period (e.g., 5-day or 6-day week).
Format: Integer.
createdby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The user who created this work schedule configuration.
createddate timestamp 29,6 √ null

Timestamp of when the work schedule configuration record was created.
Format: Timestamp with timezone.
modifiedby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The last user who modified the work schedule configuration record.
modifieddate timestamp 29,6 √ null

Timestamp of the last modification to the work schedule configuration record.
Format: Timestamp with timezone.
calculation_on varchar 20 √ null

Specifies the basis for minimum hours calculation (e.g., Based on shift hours, Based on month days, Fixed value).
Format: Varchar/Text.

Indexes

Constraint Name Type Sort Column(s)
tbl_attendance_workschedule_pk_tbl_attendance_workschedule Primary key Asc id
tbl_attendance_workschedule_qk_tbl_attendance_workschedule Must be unique Asc workschedulename

Relationships

Close relationships within degrees of separation