PayrollLeaveAwardDefinitionsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PayrollLeaveAwardDefinitionsHistorySeq int identity 4 √ null
PayrollLeaveAwardDefinitionsSeq int 4 √ null
AwardCode varchar 15 √ null
LeaveCode varchar 15 √ null
MonthsEmployed smallint 2 √ null
AdditionalMonthsEmployed smallint 2 √ null
EntitlementUnits decimal 12,4 √ null
EntitlementProRataFlag bit 1 √ null
EntitlementHoursPerPayPeriod decimal 12,4 √ 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_PayrollLeaveAwardDefinitionsHistory Primary key Asc PayrollLeaveAwardDefinitionsHistorySeq