tbl_shiftgroup

-1 rows


Description

Module: Attendance - Shift Group Definition
Purpose: Stores the current mapping that defines the composition of a Shift Group by linking individual Shifts (e.g., Day Shift, Night Shift, Split Shift) to a master Shift Group (or Work Schedule).
Data: Captures the unique ID of an individual shift and the ID of the group it belongs to.
Process Usage:
- Group Definition: Used by the system to determine which set of shifts are included under one logical grouping for assignment to employees or policy application.
- Scheduling: Critical for systems that assign employees to a group, thereby assigning them to all associated shifts in that group.
- Master Linkage: Acts as the junction table for a many-to-many or one-to-many relationship between shifts and shift groups.
Key Points:
- Active Configuration: This table holds the live, current configuration of the shift groups.
- The naming convention suggests ShiftGroupId might link to a master schedule definition.
Business Impact: Enables flexible and efficient management of complex work schedules and attendance policies for various employee groups.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific mapping record (ShiftId to ShiftGroupId).
shiftid int8 19 null
tbl_shiftmasterv1.shiftid Implied Constraint R

FK: public.tbl_ShiftMasterV1.Id (Implied)
Meaning: The ID of the individual shift (e.g., 9:00 AM - 5:00 PM) that is a component of the shift group.
shiftgroupid int8 19 null

FK: public.tbl_WorkSchedule.Id or public.tbl_ShiftGroupMaster.Id (Implied)
Meaning: The ID of the master Shift Group or Work Schedule to which the individual shift is assigned.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_shiftgroup_pk_tbl_shiftgroup Primary key Asc id

Relationships

Close relationships within degrees of separation