# Rpttimesheethoursbalanceresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rpttimesheethoursbalanceresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ActualHours` | `int64` | Actual Hours | ☑ | | | `Department` | `string` | Department | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `Difference` | `int64` | Difference | ☑ | | | `Id` | `int32` | ID | ☑ | | | `IncompleteDays` | `string` | Incomplete Days | ☐ | | | `LeaveHours` | `int64` | Leave Hours | ☑ | | | `LeavesInRequest` | `int64` | Leaves in Request | ☑ | | | `LowestStatus` | `string` | Lowest Status | ☐ | | | `LT01` | `int64` | Leave Type 1 | ☑ | | | `LT02` | `int64` | Leave Type 2 | ☑ | | | `LT03` | `int64` | Leave Type 3 | ☑ | | | `LT04` | `int64` | Leave Type 4 | ☑ | | | `LT05` | `int64` | Leave Type 5 | ☑ | | | `LT06` | `int64` | Leave Type 6 | ☑ | | | `LT07` | `int64` | Leave Type 7 | ☑ | | | `LT08` | `int64` | Leave Type 8 | ☑ | | | `LT09` | `int64` | Leave Type 9 | ☑ | | | `LT10` | `int64` | Leave Type 10 | ☑ | | | `LT11` | `int64` | Leave Type 11 | ☑ | | | `LT12` | `int64` | Leave Type 12 | ☑ | | | `LT13` | `int64` | Leave Type 13 | ☑ | | | `LT14` | `int64` | Leave Type 14 | ☑ | | | `LT15` | `int64` | Leave Type 15 | ☑ | | | `LT16` | `int64` | Leave Type 16 | ☑ | | | `LT17` | `int64` | Leave Type 17 | ☑ | | | `LT18` | `int64` | Leave Type 18 | ☑ | | | `LT19` | `int64` | Leave Type 19 | ☑ | | | `LT20` | `int64` | Leave Type 20 | ☑ | | | `LT21` | `int64` | Leave Type 21 | ☑ | | | `LT22` | `int64` | Leave Type 22 | ☑ | | | `LT23` | `int64` | Leave Type 23 | ☑ | | | `LT24` | `int64` | Leave Type 24 | ☑ | | | `LT25` | `int64` | Leave Type 25 | ☑ | | | `LT26` | `int64` | Leave Type 26 | ☑ | | | `LT27` | `int64` | Leave Type 27 | ☑ | | | `LT28` | `int64` | Leave Type 28 | ☑ | | | `LT29` | `int64` | Leave Type 29 | ☑ | | | `LT30` | `int64` | Leave Type 30 | ☑ | | | `NormalTime` | `int64` | Normal Time | ☑ | | | `Overtime` | `int64` | Overtime | ☑ | | | `OvertimeDays` | `string` | Overtime Days | ☐ | | | `ParentResourceType` | `string` | Parent Resource Type | ☐ | | | `ProductivityPct` | `decimal` | Productivity % | ☐ | | | `PublicHolidays` | `int32` | Public Holidays | ☐ | | | `ResourceExternalCode` | `string` | Resource External Code | ☐ | | | `ResourceId` | `int32` | Resource ID | ☑ | | | `ResourceName` | `string` | Resource Name | ☐ | | | `ResourceType` | `string` | Resource Type | ☐ | | | `TotalTime` | `int64` | Total Time | ☑ | | | `UnRegisteredDays` | `int32` | Unregistered Days | ☐ | | | `WorkSchedule` | `int64` | Work Schedule | ☑ | |