tbl_payrollcycle

1 rows


Description

Module: Payroll - Payroll Cycle Configuration Master
Purpose: Defines the complete scheduling and processing rules for different payroll cycles (e.g., Monthly, Weekly) across various organizational units.
Data: Captures the cycle type, effective date, cutoff day for pay period, and tentative dates (as day numbers) for crucial payroll steps like attendance processing and final pay date.
Process Usage:
- Scheduling Engine: Used by the system to determine the exact dates for a given month/period, ensuring consistency in payroll execution.
- Timeline Communication: Provides the key dates for HR and employees regarding attendance submission, approval deadlines, and salary payment.
Key Points:
- Frequency Control: cycleType defines the pay frequency (Monthly, Bi-weekly, etc.).
- Date Rules: The various Date fields (as day integers) are used to dynamically calculate the actual calendar dates for each payroll run.
Business Impact: Ensures timely, consistent, and compliant management of the recurring payroll process.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this payroll cycle definition.
sbuid int8 19 null

FK: public.tbl_SBU.sbuId (Implied)
Meaning: The Strategic Business Unit (SBU) or company division to which this payroll cycle configuration applies.
cycletype varchar 50 null

The frequency of the payroll cycle (e.g., CALENDAR_MONTH, ATTENDANCE_CUT_OFF, SALARY_CUT_OFF).
effectivedate date 13 null

The date from which this specific payroll cycle rule set is active.
cutoffdate int8 19 √ null

The day of the month (1-31) used to define the pay period cutoff (e.g., a value of 25 means the pay period runs from the 26th of the previous month to the 25th of the current month).
fixedday int8 19 √ null

The fixed day of the month (1-31) on which the salary is typically credited to the employee.
tentativeattendanceprocessdate int8 19 √ null

The tentative day of the month (1-31) when the system should begin processing attendance data for the period.
tentativeattendancefreezedate int8 19 √ null

The tentative day of the month (1-31) when attendance approvals are typically due and the attendance data is frozen for payroll calculation.
tentativepayrolldate int8 19 √ null

The tentative day of the month (1-31) for the final payroll calculation run, usually a few days before the fixedDay payment date.
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_payrollcycle_pk_tbl_payrollcycle Primary key Asc id

Relationships

Close relationships within degrees of separation