tPayrollEmployeeStandardPayDetailsEvents


Columns

Column Type Size Nulls Auto Default Children Parents Comments
tPayrollEmployeeStandardPayDetailsEventsSeq int identity 4 √ null
CreatedByID int 4 √ null
CreatedDate datetime 16,3 √ null
ID int 4 √ null
EffectiveDate datetime 16,3 √ null
TransactionType char 1 √ null
PayCode varchar 10 ('')
PayRate varchar 80 √ null
PayFactor decimal 12,8 √ null
PayAmount varchar 80 √ null
ManualFlag bit 1 √ null
SelectedFlag bit 1 ((0))
PostingNumber int 4 √ null
StandardPayLineIdentifier int 4 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_tPayrollEmployeeStandardPayDetailsEvents Primary key Asc tPayrollEmployeeStandardPayDetailsEventsSeq
AK_tPayrollEmployeeStandardPayDetailsEvents_ID Performance Asc ID