PayrollEmployeeStandardPayDetailsEvents


Columns

Column Type Size Nulls Auto Default Children Parents Comments
tPayrollEmployeeStandardPayDetailsEventsSeq int 4 null
ID int 4 √ null
StandardPayLineIdentifier int 4 √ null
EffectiveDate datetime 16,3 √ null
TransactionType char 1 √ null
PayCode varchar 10 null
PayCodeShortDescription varchar 15 √ null
PayRate decimal 12,5 √ null
CurrentPayRate decimal 12,5 √ null
PayRateSource char 1 √ null
PayFactor decimal 12,8 √ null
CurrentPayFactor decimal 12,8 √ null
PayFactorSource char 1 √ null
PayAmount money 21,4 √ null
CalcPayAmount money 21,4 √ null
CurrentPayAmount money 21,4 √ null
PayAmountSource char 1 √ null
ManualFlag bit 1 √ null
EmployeeName varchar 100 √ null
PayCodeType varchar 3 √ null
PayCodeTypeDescription varchar 50 √ null
PayGroup varchar 5 √ null
PayGroupDescription varchar 40 √ null
Category varchar 5 √ null
CategoryDescription varchar 50 √ null
SelectedFlag bit 1 null
PostingNumber int 4 √ null
GLCode varchar 15 √ null
GLSuballocationCode varchar 15 √ null
CurrentPayUnits decimal 12,5 √ null
PayUnits decimal 12,5 √ null
ProcessedFlag bit 1 √ null
SystemGeneratedFlag bit 1 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views