Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| LeaveTransactionsSeq | int | 4 | null |
|
|
|||
| ID | int | 4 | null |
|
|
|||
| CreatedDate | datetime | 16,3 | √ | null |
|
|
||
| CreatedByID | int | 4 | √ | null |
|
|
||
| TransactionCode | char | 1 | null |
|
|
|||
| AwardCode | varchar | 15 | null |
|
|
|||
| LeaveCode | varchar | 15 | null |
|
|
|||
| LeaveSubCategoryCode | varchar | 15 | null |
|
|
|||
| Units | decimal | 12,4 | null |
|
|
|||
| LeaveUnitsCode | char | 1 | null |
|
|
|||
| LeaveUnitsDescription | varchar | 6 | null |
|
|
|||
| Hours | decimal | 12,4 | √ | null |
|
|
||
| Days | decimal | 12,4 | √ | null |
|
|
||
| Weeks | decimal | 12,4 | √ | null |
|
|
||
| Balance | decimal | 40,4 | √ | null |
|
|
||
| LeaveDateStart | datetime | 16,3 | √ | null |
|
|
||
| LeaveDateReturn | datetime | 16,3 | √ | null |
|
|
||
| IncludeInPayFlag | bit | 1 | null |
|
|
|||
| PostingNumber | int | 4 | √ | null |
|
|
||
| LeaveComment | varchar | 100 | √ | null |
|
|
||
| TransactionFullTimeHoursPerDay | decimal | 12,4 | null |
|
|
|||
| BalanceInHours | decimal | 40,4 | √ | null |
|
|
||
| BalanceInDays | decimal | 40,4 | √ | null |
|
|
||
| BalanceInWeeks | decimal | 40,4 | √ | null |
|
|
Table contained 0 rows