PayrollEmployeeLeaveApplicationsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PayrollEmployeeLeaveApplicationsHistorySeq int identity 4 √ null
PayrollEmployeeLeaveApplicationsSeq int 4 √ null
ID int 4 √ null
AwardCode varchar 15 √ null
LeaveCode varchar 15 √ null
Units decimal 12,4 √ null
LeaveDateStart datetime 16,3 √ null
LeaveDateReturn datetime 16,3 √ null
LeaveComment varchar 1000 √ null
LeaveStatusCode varchar 15 √ null
CreatedDate datetime 16,3 √ null
CreatedByID int 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_PayrollEmployeeLeaveApplicationsHistory Primary key Asc PayrollEmployeeLeaveApplicationsHistorySeq