TRSBalance

The TRSBalance table contains all balances that can be used in Totalview. These are dynamic values that can be controlled by the customer, but each balance has a Type that is a predefined list.

Valid Types

Value	Description
AuthorizedAbsence	Pre-approved time off, not deducted from other leave balances.
BalanceCorrection	Used for errors in tracking working hours or leave.
ChildSickLeave	Leave to care for a sick child, depending on local labor laws
FlexibleWork	If part of a reduced work schedule, it falls under flexible work; otherwise, it may be Special Leave.
NormalTime	Contracted working hours as per employment agreement.
Other	Unspecified or unknown
Overtime	Additional hours worked beyond contracted time.
ParentalLeave	Time off granted to employees for childbirth and childcare, usually with some form of pay or social security benefit.
SickLeave	Time off that employees can take when they are ill, often compensated.
SpecialLeave	If part of a reduced work schedule, it falls under flexible work; otherwise, it may be Special Leave.
TrainingEducationalLeave	Time off for attending studies or professional development
UnpaidLeave	Time off that an employee can take without pay, for various reasons.
UnpaidSickLeave	Time off that employees can take when they are ill
VacationTime	Paid time that employees are entitled to take off for rest and personal reasons.