Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PayrollLeaveAwardsHistorySeq | int identity | 4 | √ | null |
|
|
||
| PayrollLeaveAwardsSeq | int | 4 | √ | null |
|
|
||
| AwardCode | varchar | 15 | √ | null |
|
|
||
| LeaveCode | varchar | 15 | √ | null |
|
|
||
| LeaveUnitsCode | char | 1 | √ | null |
|
|
||
| LeavePayableFlag | bit | 1 | √ | null |
|
|
||
| LeaveAccrueFlag | bit | 1 | √ | null |
|
|
||
| LeaveAccrueAnniversaryFlag | bit | 1 | √ | null |
|
|
||
| LeaveAccrueDay | tinyint | 1 | √ | null |
|
|
||
| LeaveAccrueMonth | tinyint | 1 | √ | null |
|
|
||
| LeaveAccrueMaxEntitlementUnits | decimal | 12,4 | √ | null |
|
|
||
| EntitlementUpFrontFlag | bit | 1 | √ | null |
|
|
||
| ApplyFTEFlag | bit | 1 | √ | null |
|
|
||
| UnitsWorkedPerYear | decimal | 9,3 | √ | null |
|
|
||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| ModifiedByID | int | 4 | √ | null |
|
|
||
| DeleteFlag | bit | 1 | √ | null |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_PayrollLeaveAwardsHistory | Primary key | Asc | PayrollLeaveAwardsHistorySeq |