employeeAccruedTime

Stores data related to accrued time for employees, such as vacation or sick leave, to manage employee benefits.

Columns


Name	Type	References	Description
accrualmethod	String		The method used to accrue hours, such as 'Hourly' or 'Daily', specifying how employee accrual is calculated.
accrualrate	Double		The rate at which hours are accrued for the employee, often expressed as a percentage or number of hours per time period.
accruedhours	Double		The total number of hours accrued by the employee, typically representing earned time off or leave hours.
effectivedate	Date		The date on which the accrual method or rate becomes effective, often marking the start of a new accrual period.
employee	String		The identifier or name of the employee associated with the accrual, used to track and manage their earned hours.
expirationdate	Date		The date when the accrued hours, benefits, or leave expire or must be used, often related to time-sensitive employee benefits.
inactive	Boolean		Indicates whether the accrual record is inactive, meaning the employee is no longer eligible to accrue hours or benefits.
maximumaccruedhours	Double		The maximum number of hours an employee can accrue, setting a cap on the total earned hours they can accumulate.
monetaryrate	Decimal		The monetary rate associated with accrued hours, often used for converting hours into a monetary value (for example, paid time off).
resetaccruedhoursatyearend	Boolean		Indicates whether accrued hours should be reset at the end of the year, often used for annual benefits or leave tracking.