LeaveCases

Single-record retrieval by LeaveCaseId, or a bulk read for an employee over a date range (requires PersonId, StartDate, EndDate; no pagination).

Columns

Name	Type	References
LeaveCaseId [KEY]	Long
PersonId	Long	Employees.PersonId
EmployeeFullName	String
CaseCode	String
DisplayCaseCode	String
LongCaseCode	String
StartDate	Date
EndDate	Date
RequestDate	Date
FrequencyEffectiveDate	Date
ReasonId	Long
ReasonName	String
FrequencyId	Long
FrequencyName	String
ApprovalStatusId	Long
ApprovalStatusName	String
CategoryId	Long
CategoryName	String
StatusId	Long
StatusName	String
DateDefaultsTypeId	Long