Payroll Tables

 

Column Name Column Type Length Default Value Description Enumeration
Id bigint 4      
PaYear smallint 2      
PaQuarter tinyint 1      
Key nvarchar 50      
Value nvarchar max 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Amount pDecimal 13 0    
Id int 4      
PaDay tinyint 1      
PaMonth tinyint 1      
PaYear smallint 2      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
UserId pUserID 20      
WrkStnId pWrkStnID 20      
Id nvarchar 50      
Value nvarchar 255      
Counter int 4      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
DeptAllocId nvarchar 10      
AllocToDeptId pDeptID 10      
AllocPct pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Descr varchar 30      
Id varchar 10      
ExpDate datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CheckDate datetime 8      
CheckNumber pCheckNum 10      
CollOnUncolMed pDecimal 13 0    
CollOnUncolOasdi pDecimal 13 0    
EmployeeId pEmpID 11      
FicaTips pDecimal 13 0    
GrossPay pDecimal 13 0    
Id int 4      
NetPay pDecimal 13 0    
PaYear smallint 2      
PdCode tinyint 1      
TipsDeemedWages pDecimal 13 0    
TotalHoursWorked pDecimal 13 0    
TransSeqNo varchar 3      
ts timestamp 8      
Type tinyint 1 0   0 = Calculated, 1 = Manual
UncollectedMedicare pDecimal 13 0    
UncollectedOasdi pDecimal 13 0    
VoidHistCheckId int 4      
VoucherNumber varchar 50      
WeeksUnderLimit pDecimal 13 0    
WeeksWorked pDecimal 13 0    
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
CheckId int 4      
Id int 4      
DeductionCode pCode 3      
DeductionHours pDecimal 13 0    
DeductionAmount pDecimal 13 0    
DeductionBalance pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CheckId int 4      
CurrentAmount pDecimal 13 0    
DirectDepositYN bit 1 0    
DistributionId int 4      
TraceNumber int 4 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
CheckId int 4      
LeaveCodeId pCode 3      
LocalTaxAuthorityId int 4      
ProjectDetailId int 4      
StateTaxAuthorityId int 4      
EarningCode pCode 3      
SUIState nvarchar 2      
DepartmentId pDeptID 10      
AdjEntryFlags bit 1 0    
LaborClass nvarchar 3      
HoursWorked pDecimal 13 0    
Pieces pDecimal 13 0    
EarningCodeRate pDecimal 13 0    
EarningAmount pDecimal 13 0    
TransId int 4 0    
DeptAllocId nvarchar 10      
CustId pCustID 10      
ProjId nvarchar 10      
PhaseId nvarchar 10      
TaskId nvarchar 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CheckId int 4      
Id int 4      
DeductionCode pCode 3      
DepartmentId pDeptID 10      
DeductionHours pDecimal 13 0    
DeductionAmount pDecimal 13 0    
DeductionBalance pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CheckId int 4      
Id int 4      
TaxAuthorityDtlId int 4      
TaxAuthorityId int 4      
DepartmentId pDeptID 10      
WithholdingCode pCode 3      
Description nvarchar 30      
WithholdingPayments pDecimal 13 0    
WithholdingEarnings pDecimal 13 0    
GrossEarnings pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14      
Id int 4      
EmployeeId pEmpID 11      
GroupCode tinyint 1      
EmployeeName nvarchar 36      
DepartmentId pDeptID 10      
SocialSecurityNo nvarchar 255      
CheckNumber pCheckNum 10      
CheckDate datetime 8      
GrossPay pDecimal 13      
NetPay pDecimal 13      
WeeksWorked pDecimal 13      
HoursWorked pDecimal 13      
WeeksUnderLimit pDecimal 13      
FicaTips pDecimal 13      
TipsDeemedWages pDecimal 13      
UncollectedOasdi pDecimal 13      
UncollectedMedicare pDecimal 13      
CollOnUncollOasdi pDecimal 13      
CollOnUncollMed pDecimal 13      
Voided bit 1      
VoidDate datetime 8      
VoidBankId pBankID 10      
CheckRun datetime 8      
SelectedYn bit 1      
TipsReported pDecimal 13      
PeriodRunCode tinyint 1      
BankId pBankID 10      
PaYear smallint 2      
GlYear smallint 2      
GlPeriod smallint 2      
CF xml -1      
ts timestamp 8      
EmployeeType tinyint 1   Employee Type 0 = Hourly, 1 = Salaried
GLAcctCash pGlAcct 40      
PaMonth tinyint 1      
Type tinyint 1   Check Type 0 = Calculated, 1 = Manual
VoucherNumber varchar 50      
Column Name Column Type Length Default Value Description Enumeration
CheckId int 4      
GLAcctLiability pGlAcct 40      
Id int 4      
PostRun pPostRun 14      
DeductionCode pCode 3      
Hours pDecimal 13      
Amount pDecimal 13      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CheckId int 4      
CurrentAmount pDecimal 13      
DirectDepositYN bit 1      
DistributionId int 4      
PostRun pPostRun 14      
TraceNumber int 4      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CheckId int 4      
DeptAllocId varchar 10      
GLAcctDept pGlAcct 40      
Id int 4      
LeaveCodeId pCode 3      
PostRun pPostRun 14      
EarningCode pCode 3      
StateCode nvarchar 2      
SUIState nvarchar 2      
LocalCode nvarchar 4      
DepartmentId pDeptID 10      
LaborClass nvarchar 3      
HoursWorked pDecimal 13      
HourlyRate pDecimal 13      
EarningsAmount pDecimal 13      
Pieces pDecimal 13      
CustId pCustID 10      
ProjId nvarchar 10      
PhaseId nvarchar 10      
TaskId nvarchar 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CheckId int 4      
GLAcctDept pGlAcct 40      
GLAcctLiability pGlAcct 40      
Id int 4      
PostRun pPostRun 14      
DeductionCode pCode 3      
DepartmentId pDeptID 10      
Hours pDecimal 13      
Amount pDecimal 13      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CheckId int 4      
GLAcctDept pGlAcct 40      
GLAcctLiability pGlAcct 40      
Id int 4      
Local varchar 2      
State varchar 2      
TaxAuthorityType tinyint 1   Tax Authority Type 0 = Fed, 1 = State, 2 = Local, 3 = Earnings, 4 = Deductions, 5 = Hours, 6 = Pieces
PostRun pPostRun 14      
DepartmentId pDeptID 10      
WithholdingCode pCode 3      
Description nvarchar 30      
WithholdingAmount pDecimal 13      
WithholdingEarnings pDecimal 13      
GrossEarnings pDecimal 13      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CheckId int 4      
HoursAccrued pDecimal 13 0    
Id int 4      
LeaveCodeId pCode 3      
PostRun pPostRun 14      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CheckId int 4      
Id int 4      
PostRun pPostRun 14      
GLAcctLiability pGlAcct 40      
Local varchar 2      
State varchar 2      
TaxAuthorityType tinyint 1   Tax Authority Type 0 = Fed, 1 = State, 2 = Local, 3 = Earnings, 4 = Deductions, 5 = Hours, 6 = Pieces
WithholdingCode nvarchar 3      
Description nvarchar 30      
WithholdingAmount pDecimal 13      
WithholdingEarnings pDecimal 13      
GrossEarnings pDecimal 13      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
PaYear smallint 2      
PrintedYn bit 1 0    
GlPeriod smallint 2      
GlYear smallint 2      
PeriodEndDate datetime 8      
DateOnCheck datetime 8      
BankId pBankID 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
InfoId int 4      
Selected bit 1 0    
PeriodStartDate datetime 8      
PdCode tinyint 1 -1    
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CheckId int 4      
HoursAccrued pDecimal 13 0    
Id int 4      
LeaveCodeId pCode 3      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
BankId pBankID 10      
CheckNumber pCheckNum 10      
AccountNumber pGlAcct 40      
ActionType tinyint 1 0 Action Type 0 = Add, 1 = Delete
TransactionType tinyint 1 0 Transaction Type 0 = Register, 1 = Void
CheckAmount pDecimal 13 0    
CheckDate datetime 8      
PayeeName nvarchar 38      
PayeeAddress1 nvarchar 30      
PayeeAddress2 nvarchar 60      
PayeeCity nvarchar 30      
PayeeRegion nvarchar 10      
PayeePostalCode nvarchar 10      
BatchID pBatchID 6      
PostRun pPostRun 14      
TransmitDate datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id varchar 10      
Description nvarchar 20      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CheckId int 4      
Id int 4      
TransId int 4      
TransType tinyint 1   Transaction Type 0 = Earning, 1 = Deduction, 2 = EmployerCost
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CheckId int 4      
Id int 4      
TaxAuthorityDtlId int 4      
TaxAuthorityId int 4      
WithholdingCode pCode 3      
Description nvarchar 30      
WithholdingPayments pDecimal 13 0    
WithholdingEarnings pDecimal 13 0    
GrossEarnings pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CalcOnGross bit 1 -1    
EmployerPaid bit 1      
Id int 4      
DeductionCode pCode 3      
Description nvarchar 15      
GLLiabilityAccount pGlAcct 40      
EmpExpenseAcct pGlAcct 40      
DeferredComp bit 1 0    
SequenceNumber nvarchar 3      
FormulaId nvarchar 12      
W2Box nvarchar 3      
W2Code nvarchar 2      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
DeductionCodeId int 4      
EarningCodeId pCode 3      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id pDeptID 10      
DepartmentName nvarchar 30      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
DepartmentId pDeptID 10      
TaxAuthorityId int 4      
Type tinyint 1   Tax Authority Type 0 = Fed, 1 = State, 2 = Local, 3 = Earnings, 4 = Deductions, 5 = Hours, 6 = Pieces
Code pCode 3      
Description nvarchar 40      
GLAcct pGlAcct 40      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
EntryDate datetime 8      
Id int 4      
PaYear smallint 2      
DeptDtlId int 4      
PaMonth tinyint 1      
Amount pDecimal 13 0    
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
AddToBase pDecimal 13 0    
EarningTypeId char 1      
Id pCode 3      
IncludeInNet bit 1 -1    
Description nvarchar 40      
FixedWithholding bit 1 0    
GLHoldingAccount pGlAcct 40      
Multiplier pDecimal 13 0    
W2Box nvarchar 3      
W2Code nvarchar 2      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Description varchar 40      
Id char 1      
ReplaceSalaryPay bit 1 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
EmployeeId pEmpID 11      
Date datetime 8      
Reason nvarchar 255      
Amount pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CalcOnGross bit 1 -1    
DeductionCodeId int 4   Deduction Code ID 0 = Deduction, 1 = Employer Cost
Id int 4      
PaYear smallint 2      
PeriodCode1 tinyint 1 -1 Period Code 1 0 = NoDeductions, 1 = TakeDeductionAmount, 2 = DecliningBalance, 3 = FormulaBased, 4 = PercentageOfPay, 5 = FixedRatePerHour, 6 = DecliningBalanceByPercent, 7 = DecliningBalanceByFormula
PeriodCode2 tinyint 1 -1 Period Code 2 0 = NoDeductions, 1 = TakeDeductionAmount, 2 = DecliningBalance, 3 = FormulaBased, 4 = PercentageOfPay, 5 = FixedRatePerHour, 6 = DecliningBalanceByPercent, 7 = DecliningBalanceByFormula
PeriodCode3 tinyint 1 -1 Period Code 3 0 = NoDeductions, 1 = TakeDeductionAmount, 2 = DecliningBalance, 3 = FormulaBased, 4 = PercentageOfPay, 5 = FixedRatePerHour, 6 = DecliningBalanceByPercent, 7 = DecliningBalanceByFormula
PeriodCode4 tinyint 1 -1 Period Code 4 0 = NoDeductions, 1 = TakeDeductionAmount, 2 = DecliningBalance, 3 = FormulaBased, 4 = PercentageOfPay, 5 = FixedRatePerHour, 6 = DecliningBalanceByPercent, 7 = DecliningBalanceByFormula
PeriodCode5 tinyint 1 -1 Period Code 5 0 = NoDeductions, 1 = TakeDeductionAmount, 2 = DecliningBalance, 3 = FormulaBased, 4 = PercentageOfPay, 5 = FixedRatePerHour, 6 = DecliningBalanceByPercent, 7 = DecliningBalanceByFormula
EmployeeId pEmpID 11      
SeqNum char 2 '1'    
ScheduledAmount pDecimal 13 0    
Balance pDecimal 13 0    
UseFactorFlag bit 1 0    
OverrideFactor1 pDecimal 13 0    
OverrideFactor2 pDecimal 13 0    
OverrideFactor3 pDecimal 13 0    
OverrideFactor4 pDecimal 13 0    
OverrideFactor5 pDecimal 13 0    
OverrideFactor6 pDecimal 13 0    
FormulaId nvarchar 12      
CF xml -1      
ts timestamp 8      
OverrideFactor7 pDecimal 13 0    
OverrideFactor8 pDecimal 13 0    
OverrideFactor9 pDecimal 13 0    
OverrideFactor10 pDecimal 13 0    
OverrideFactor11 pDecimal 13 0    
OverrideFactor12 pDecimal 13 0    
OverrideFactor13 pDecimal 13 0    
OverrideFactor14 pDecimal 13 0    
OverrideFactor15 pDecimal 13 0    
OverrideFactor16 pDecimal 13 0    
OverrideFactor17 pDecimal 13 0    
OverrideFactor18 pDecimal 13 0    
OverrideFactor19 pDecimal 13 0    
OverrideFactor20 pDecimal 13 0    
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
EmployeeId pEmpID 11      
DegreeCode nvarchar 6      
Major nvarchar 25      
Date datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TaxAuthorityDtlId int 4      
WithholdId int 4      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Amount pDecimal 13      
EmployerPaid bit 1      
EntryDate datetime 8      
Id int 4      
PaMonth tinyint 1      
PaYear smallint 2      
EmployeeId pEmpID 11      
DeductionCode pCode 3      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Amount pDecimal 13      
EntryDate datetime 8      
Hours pDecimal 13      
Id int 4      
PaMonth tinyint 1      
PaYear smallint 2      
EmployeeId pEmpID 11      
EarningCode pCode 3      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
EntryDate datetime 8      
GrossPayAmount pDecimal 13      
Id int 4      
EmployeeId pEmpID 11      
NetPayAmount pDecimal 13      
PaMonth tinyint 1      
PaYear smallint 2      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
EntryDate datetime 8      
Id int 4      
LeaveCodeId pCode 3      
PaYear smallint 2      
PaMonth tinyint 1      
EmployeeId pEmpID 11      
PrintedFlag bit 1      
From nvarchar 2   Employee Leave Source AJ = Adjustment, BG = Beginning Balance, PC = Check, VC = Void Check
EarningCode pCode 3      
Description nvarchar 25      
CheckNumber pCheckNum 10      
AdjustmentDate datetime 8      
AdjustmentAmount pDecimal 13      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Amount pDecimal 13      
EntryDate datetime 8      
Id int 4      
EmployeeId pEmpID 11      
MiscCodeId varchar 10      
PaMonth tinyint 1      
PaYear smallint 2      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
EarningAmount pDecimal 13      
EmployeeId pEmpID 11      
EmployerPaid bit 1      
EntryDate datetime 8      
Id int 4      
Local varchar 2      
PaMonth tinyint 1      
PaYear smallint 2      
State varchar 2      
TaxableAmount pDecimal 13      
TaxAuthorityType tinyint 1   Tax Authority Type 0 = Fed, 1 = State, 2 = Local, 3 = Earnings, 4 = Deductions, 5 = Hours, 6 = Pieces
ts timestamp 8      
WithholdAmount pDecimal 13      
WithholdingCode pCode 3      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
EmployeeId pEmpID 11      
LeaveCodeId pCode 3      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
AdjustedHireDate datetime 8      
AdjustToMinimum bit 1 0    
CheckSort varchar 10      
CorporateOfficer bit 1 0    
Deceased bit 1 0    
DefaultEarningCode pCode 3      
DepartmentId pDeptID 10      
DfltDeptAllocId varchar 10      
EeoClass varchar 1      
EligibleForPension bit 1 0    
EmployeeId pEmpID 11      
EmployeeStatus tinyint 1 0 Employee Status 0 = Full-Time, 1 = Part-Time
EmployeeType tinyint 1 0 Employee Type 0 = Hourly, 1 = Salaried
ExemptFromOvertime bit 1 0    
GroupCode tinyint 1 0    
HourlyRate pDecimal 13 0    
JobTitle varchar 40      
LaborClass varchar 3      
LastCheckDate datetime 8      
LastReviewDate datetime 8      
NextReviewDate datetime 8      
OverridePay pDecimal 13 0    
ParticipatingIn401k bit 1 0    
PayDistribution tinyint 1 0 Pay Distribution 0 = None, 1 = Amount, 2 = Percent
PayPeriodsPerYear smallint 2 0    
Salary pDecimal 13 0    
SeasonalEmployee bit 1 0    
Sex char 1      
StartDate datetime 8      
StatutoryEmployee bit 1 0    
SupervisorId pEmpID 11      
TerminationDate datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
OverrideFactor1 pDecimal 13 0    
OverrideFactor2 pDecimal 13 0    
OverrideFactor3 pDecimal 13 0    
OverrideFactor4 pDecimal 13 0    
OverrideFactor5 pDecimal 13 0    
OverrideFactor6 pDecimal 13 0    
TaxAuthorityDtlId int 4      
ts timestamp 8      
OverrideFactor7 pDecimal 13 0    
OverrideFactor8 pDecimal 13 0    
OverrideFactor9 pDecimal 13 0    
OverrideFactor10 pDecimal 13 0    
OverrideFactor11 pDecimal 13 0    
OverrideFactor12 pDecimal 13 0    
OverrideFactor13 pDecimal 13 0    
OverrideFactor14 pDecimal 13 0    
OverrideFactor15 pDecimal 13 0    
OverrideFactor16 pDecimal 13 0    
OverrideFactor17 pDecimal 13 0    
OverrideFactor18 pDecimal 13 0    
OverrideFactor19 pDecimal 13 0    
OverrideFactor20 pDecimal 13 0    
WithholdId int 4      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
EmployeeId pEmpID 11      
Date datetime 8      
Reason nvarchar 255      
OldRate pDecimal 13 0    
NewRate pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
AccountNumber nvarchar 510      
AccountType tinyint 1 0 Account Type 0 = Paycheck, 1 = Checking, 2 = Savings
AmountPercent pDecimal 13      
EmployeeId pEmpID 11      
Id int 4      
PrenoteIn bit 1 0    
PrenoteOut bit 1 0    
RoutingCode varchar 50      
TraceNumber int 4 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
EmployeeId pEmpID 11      
PictItem image 16      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
EmployeeId pEmpID 11      
EarnCodeId pCode 3      
PaYear smallint 2      
Rate pDecimal 13 0    
RateType tinyint 1 0 Earning Rate Type 0 = None, 1 = Percent Of Regular Rate, 2 = Override Regular Rate
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
DefaultWH bit 1 0    
EICCode varchar 1      
EmployeeId pEmpID 11      
Exemptions tinyint 1 0    
ExtraWithholding pDecimal 13 0    
FixedWithholding pDecimal 13 0    
HomeState char 2      
Id int 4      
MaritalStatus varchar 3      
PaYear smallint 2      
SUIState varchar 2      
TaxAuthorityId int 4      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id varchar 12      
Description nvarchar 35      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Column1 pDecimal 13 0    
Column10 pDecimal 13 0    
Column2 pDecimal 13 0    
Column3 pDecimal 13 0    
Column4 pDecimal 13 0    
Column5 pDecimal 13 0    
Column6 pDecimal 13 0    
Column7 pDecimal 13 0    
Column8 pDecimal 13 0    
Column9 pDecimal 13 0    
FormulaTableYearId int 4      
GradientYn bit 1 -1    
SequenceNumber smallint 2      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Description varchar 40      
Id int 4      
Status varchar 3      
TableId varchar 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ColumnHdr varchar 255      
ColumnHdr1 varchar 30      
ColumnHdr2 varchar 30      
ColumnHdr3 varchar 30      
ColumnHdr4 varchar 30      
ColumnHdr5 varchar 30      
ColumnHdr6 varchar 30      
ColumnHdr7 varchar 30      
FormulaTableId int 4      
Id int 4      
PaYear smallint 2      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
FormulaId varchar 12      
FormulaText nvarchar max      
Id int 4      
OverrideFactor1 pDecimal 13 0    
OverrideFactor2 pDecimal 13 0    
OverrideFactor3 pDecimal 13 0    
OverrideFactor4 pDecimal 13 0    
OverrideFactor5 pDecimal 13 0    
OverrideFactor6 pDecimal 13 0    
PaYear smallint 2      
TableId varchar 8      
CF xml -1      
ts timestamp 8      
OverrideFactor7 pDecimal 13 0    
OverrideFactor8 pDecimal 13 0    
OverrideFactor9 pDecimal 13 0    
OverrideFactor10 pDecimal 13 0    
OverrideFactor11 pDecimal 13 0    
OverrideFactor12 pDecimal 13 0    
OverrideFactor13 pDecimal 13 0    
OverrideFactor14 pDecimal 13 0    
OverrideFactor15 pDecimal 13 0    
OverrideFactor16 pDecimal 13 0    
OverrideFactor17 pDecimal 13 0    
OverrideFactor18 pDecimal 13 0    
OverrideFactor19 pDecimal 13 0    
OverrideFactor20 pDecimal 13 0    
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
DegreeDescription nvarchar 25      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
PaYear smallint 2      
State char 2      
FieldNumberOfSsn tinyint 1      
FieldNumberOfName tinyint 1      
FieldNumberOfTotalWages tinyint 1      
FieldNumberOfExcessWage tinyint 1      
FieldNumberOfTaxWages tinyint 1      
FieldNumberOfWksWorked tinyint 1      
FieldNumberOfHrsWorked tinyint 1      
SuiMonth tinyint 1      
PrinZeroEarnFlag bit 1 0    
SortByFlag tinyint 1   Sort Flag 1 = Last Name, 2 = Social Security Number
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id varchar 3      
Description nvarchar 20      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
HrsWkd pDecimal 13 0    
LeaveCodeId pCode 3      
MaxHrs pDecimal 13 0    
MinAccrual pDecimal 13 0    
CF xml -1      
ts timestamp 8      
UpToYear smallint 2      
Column Name Column Type Length Default Value Description Enumeration
Description varchar 35      
Id pCode 3      
IncludeAccrualCalc bit 1 0    
MaxAccrual pDecimal 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Descr varchar 50      
Id varchar 10      
SequenceNumber smallint 2 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
EmployeeId pEmpID 11      
LastName nvarchar 20      
FirstName nvarchar 15      
Suffix nvarchar 4      
BoxB nvarchar 17      
BoxC nvarchar 50      
BoxC1 nvarchar 70      
BoxA nvarchar 510      
BoxE nvarchar 70      
BoxF1 nvarchar 25      
BoxF2 nvarchar 23      
BoxF3 nvarchar 15      
BoxF4 nvarchar 4      
Box15a bit 1      
Box15b bit 1 0    
Box15c bit 1 0    
Box15f bit 1 0    
chkThirdPartySP bit 1 0    
Box16a nvarchar 4      
SumOfBox1 pDecimal 13 0    
SumOfBox2 pDecimal 13 0    
SumOfBox3 pDecimal 13 0    
SumOfBox4 pDecimal 13 0    
SumOfBox5 pDecimal 13 0    
SumOfBox6 pDecimal 13 0    
SumOfBox7 pDecimal 13 0    
SumOfBox8 pDecimal 13 0    
SumOfBox9 pDecimal 13 0    
SumOfBox10 pDecimal 13 0    
SumOfBox11 pDecimal 13 0    
SumOfBox12 pDecimal 13 0    
SumOfBox17 pDecimal 13 0    
SumOfBox18 pDecimal 13 0    
SumOfBox20 pDecimal 13 0    
SumOfBox21 pDecimal 13 0    
SUITotWages pDecimal 13 0    
SUITotTaxWages pDecimal 13 0    
SumOfBox13Line1 pDecimal 13 0    
SumOfBox13Line2 pDecimal 13 0    
SumOfBox13Line3 pDecimal 13 0    
SumOfBox14Line1 pDecimal 13 0    
SumOfBox14Line2 pDecimal 13 0    
SumOfBox14Line3 pDecimal 13 0    
Box13LineDesc1 nvarchar 40      
Box13LineDesc2 nvarchar 40      
Box13LineDesc3 nvarchar 40      
DesigRothContrAA pDecimal 13 0    
DesigRothContrBB pDecimal 13 0    
DefCompD pDecimal 13 0    
DefCompE pDecimal 13 0    
DefCompF pDecimal 13 0    
DefCompG pDecimal 13 0    
DefCompH pDecimal 13 0    
Military pDecimal 13 0    
NON457 pDecimal 13 0    
sec457 pDecimal 13 0    
GTLI pDecimal 13 0    
HSAW pDecimal 13 0    
NonTaxCmbPay pDecimal 13 0    
Def409ANonQDC pDecimal 13 0    
Inc409ANonQDC pDecimal 13 0    
OptionalCode nvarchar 2      
ReportPeriod nvarchar 6      
StartDate datetime 8      
TerminDate datetime 8      
OtherStateData nvarchar 10      
Box16b nvarchar 20      
TaxTypeCode nvarchar 1   State Tax Type Code C = City Income Tax, D = County Income Tax, E = School District Income Tax, F = Other Income Tax
StateCode int 4 0    
SupplData1 nvarchar 75      
SupplData2 nvarchar 75      
StateControlNo int 4      
WeeksNo int 4 0    
StateRec bit 1 0    
ExercNonStatOpt pDecimal 13 0    
UncollOASDIMed pDecimal 13 0    
UncollMed pDecimal 13 0    
UncollRRTA pDecimal 13 0    
MedSavAccount pDecimal 13 0    
SimpRetAccount pDecimal 13 0    
QualAdopExp pDecimal 13 0    
SpouseSSN nvarchar 510      
CivilStatus nvarchar 1      
PRCommissions pDecimal 13 0    
PRAllowances pDecimal 13 0    
PRTipsSubjTax pDecimal 13 0    
PRRetirFund pDecimal 13 0    
VirgIslTotWages pDecimal 13 0    
VirgIslIncomeTax pDecimal 13 0    
TaxEntityCode nvarchar 5      
Territories bit 1 0    
chkForeign bit 1 0    
ts timestamp 8      
MiddleInit nvarchar 1      
AddressLine1 nvarchar 30      
AddressLine2 nvarchar 60      
ContrUnder457b pDecimal 13      
EmplrCostSpsCovrg pDecimal 13      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
EmployeeId pEmpID 11      
DeductCode pCode 3      
LaborClass nvarchar 3      
Hours pDecimal 13 0    
Amount pDecimal 13 0    
TransDate datetime 8      
SeqNo nvarchar 3      
Note nvarchar 255      
RunCode nvarchar 2      
CutoffDate datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
LeaveCodeId pCode 3      
LocalTaxAuthorityId int 4      
StateTaxAuthorityId int 4      
EmployeeId pEmpID 11      
EarningCode pCode 3      
DepartmentId pDeptID 10      
LaborClass nvarchar 3      
Rate pDecimal 13 0    
Pieces pDecimal 13 0    
Hours pDecimal 13 0    
Amount pDecimal 13 0    
TransDate datetime 8      
SUIState nvarchar 2      
SeqNo nvarchar 3      
CustId pCustID 10      
ProjId nvarchar 10      
PhaseId nvarchar 10      
TaskId nvarchar 10      
RunCode nvarchar 2      
CutoffDate datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
EmployeeId pEmpID 11      
DeductCode pCode 3      
DepartmentId pDeptID 10      
LaborClass nvarchar 3      
Hours pDecimal 13 0    
Amount pDecimal 13 0    
TransDate datetime 8      
SeqNo nvarchar 3      
Note nvarchar 255      
RunCode nvarchar 2      
CutoffDate datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
FedEIN nvarchar 10      
CompName nvarchar 57      
Addr1 nvarchar 22      
Addr2 nvarchar 22      
City nvarchar 30      
State nvarchar 23      
Zip nvarchar 15      
CountryCode nvarchar 4      
PinNumber nvarchar 17      
chkResubFlag bit 1 0    
WFID nvarchar 6      
PreparerCode nvarchar 1   Preparer Code A = Accounting Firm, L = Self-Prepared, O = Other, P = Parent Company, S = Service Bureau
SoftwareCode nvarchar 2   Software Code 98 = In - House Program, 99 = Off - the - Shelf
chkForeign bit 1 0    
SubCompName nvarchar 57      
SubAddr1 nvarchar 22      
SubAddr2 nvarchar 22      
SubCity nvarchar 30      
SubState nvarchar 23      
SubZip nvarchar 15      
SubCountryCode nvarchar 4      
EMail nvarchar 40      
Notification nvarchar 1   Method of Notification 1 = E-Mail/ Internet, 2 = Postal Service
AgentIndCode nvarchar 1   Agent Indicator Code 1 = 2678 Agent, 2 = Common Pay Master
EmplAgentEIN nvarchar 10      
AgentForEIN nvarchar 9      
ERCompName nvarchar 57      
ERAddr1 nvarchar 22      
ERAddr2 nvarchar 22      
ERCity nvarchar 30      
ERState nvarchar 23      
ERZip nvarchar 15      
ERCountryCode nvarchar 4      
TaxJurisCode nvarchar 1   Jurisdiction Code G = Guam, N = Northern Mariana, P = Puerto Rico, S = American Samoa, V = Virgin Islands
PRU nvarchar 4      
OtherEIN nvarchar 9      
Type nvarchar 1   Employment Code A = Agriculture, H = Household, M = Military, Q = Medicare Qualified Government Employment, X = Railroad, R = Regular(All Others)
chkTerminBusin bit 1 0    
chkThirdPartySP bit 1 0    
ThirdPartyWithheld pDecimal 13 0    
ReportPeriod nvarchar 6      
ContactName nvarchar 27      
ContacPhone nvarchar 15      
Extension nvarchar 5      
fax nvarchar 10      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Code pCode 3      
CodeType tinyint 1   Code Type 0 = Other, 1 = Income Tax, 2 = Unemployment Tax
Description varchar 30      
EmployerPaid bit 1      
EmplrExpenseAcct pGlAcct 40      
FixedPercent pDecimal 13 0    
FormulaId varchar 12      
GlLiabilityAccount pGlAcct 40      
Id int 4      
PaYear smallint 2      
TaxAuthorityId int 4      
TaxId varchar 17      
TaxType int 4      
CF xml -1      
ts timestamp 8      
WeeksWorkedLimit pDecimal 13 0    
Column Name Column Type Length Default Value Description Enumeration
DeductionCodeId pCode 3      
TaxAuthorityDtlId int 4      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
EarningCodeId pCode 3      
TaxAuthorityDtlId int 4      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Description varchar 30      
Id int 4      
Local varchar 2      
State varchar 2      
TaxAuthority varchar 4      
CF xml -1      
ts timestamp 8      
Type tinyint 1   Type 0 = Fed, 1 = State, 2 = Local, 3 = Earnings, 4 = Deductions, 5 = Hours, 6 = Pieces
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
PaYear smallint 2      
EmployeeId pEmpID 11      
DeductCode pCode 3      
LaborClass nvarchar 3      
Hours pDecimal 13 0    
Amount pDecimal 13 0    
TransDate datetime 8      
SeqNo nvarchar 3      
Note nvarchar 255      
PostedYn bit 1 0    
PostRun pPostRun 14      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CheckId int 4      
Id int 4      
PaYear smallint 2      
PostRun pPostRun 14      
PaMonth tinyint 1      
EmployeeId pEmpID 11      
DeductCode pCode 3      
LaborClass nvarchar 3      
Hours pDecimal 13      
Amount pDecimal 13      
TransDate datetime 8      
SeqNo nvarchar 3      
Note nvarchar 255      
CheckNumber pCheckNum 10      
Voided bit 1      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
LeaveCodeId pCode 3      
LocalTaxAuthorityId int 4      
PaYear smallint 2      
ProjectDetailId int 4      
StateTaxAuthorityId int 4      
EmployeeId pEmpID 11      
EarningCode pCode 3      
DepartmentId pDeptID 10      
LaborClass nvarchar 3      
Rate pDecimal 13 0    
Pieces pDecimal 13 0    
Hours pDecimal 13 0    
Amount pDecimal 13 0    
TransDate datetime 8      
SUIState nvarchar 2      
SeqNo nvarchar 3      
DeptAllocId nvarchar 10      
CustId pCustID 10      
ProjId nvarchar 10      
PhaseId nvarchar 10      
TaskId nvarchar 10      
PostedYn bit 1 0    
PostRun pPostRun 14      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
LeaveCodeId pCode 3      
PaYear smallint 2      
PostRun pPostRun 14      
PaMonth tinyint 1      
EmployeeId pEmpID 11      
EarningCode pCode 3      
DepartmentId pDeptID 10      
StateCode nvarchar 2      
LocalCode nvarchar 4      
LaborClass nvarchar 3      
Rate pDecimal 13      
Pieces pDecimal 13      
Hours pDecimal 13      
Amount pDecimal 13      
TransDate datetime 8      
SUIState nvarchar 2      
SeqNo nvarchar 3      
CustId pCustID 10      
ProjId nvarchar 10      
PhaseId nvarchar 10      
TaskId nvarchar 10      
CheckNumber pCheckNum 10      
Voided bit 1      
DeptAllocId nvarchar 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
PaYear smallint 2      
EmployeeId pEmpID 11      
DeductCode pCode 3      
DepartmentId pDeptID 10      
LaborClass nvarchar 3      
Hours pDecimal 13 0    
Amount pDecimal 13 0    
TransDate datetime 8      
SeqNo nvarchar 3      
Note nvarchar 255      
PostedYn bit 1 0    
PostRun pPostRun 14      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CheckId int 4      
Id int 4      
PaYear smallint 2      
PostRun pPostRun 14      
PaMonth tinyint 1      
EmployeeId pEmpID 11      
DeductCode pCode 3      
DepartmentId pDeptID 10      
LaborClass nvarchar 3      
Hours pDecimal 13      
Amount pDecimal 13      
TransDate datetime 8      
SeqNo nvarchar 3      
Note nvarchar 255      
CheckNumber pCheckNum 10      
Voided bit 1      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
EmployeeId pEmpID 11      
BoxA nvarchar 255      
BoxB nvarchar 17      
BoxC nvarchar 50      
BoxC1 nvarchar 70      
BoxC2 nvarchar 50      
BoxD int 4 0    
BoxE nvarchar 70      
BoxE1 nvarchar 70      
BoxF nvarchar 100      
BoxF1 nvarchar 25      
BoxF2 nvarchar 2      
BoxF3 nvarchar 10      
BoxF4 nvarchar 20      
Box1 pDecimal 13 0    
Box2 pDecimal 13 0    
Box3 pDecimal 13 0    
Box4 pDecimal 13 0    
Box5 pDecimal 13 0    
Box6 pDecimal 13 0    
Box7 pDecimal 13 0    
Box8 pDecimal 13 0    
Box9 pDecimal 13 0    
Box10 pDecimal 13 0    
Box11 pDecimal 13 0    
Box12 pDecimal 13 0    
Box13Line1 pDecimal 13 0    
Box13LineDesc1 nvarchar 2      
Box13Line2 pDecimal 13 0    
Box13LineDesc2 nvarchar 2      
Box13Line3 pDecimal 13 0    
Box13LineDesc3 nvarchar 2      
Box13Line4 pDecimal 13 0    
Box13LineDesc4 nvarchar 2      
Box14Line1 pDecimal 13 0    
Box14LineDesc1 nvarchar 10      
Box14Line2 pDecimal 13 0    
Box14LineDesc2 nvarchar 10      
Box14Line3 pDecimal 13 0    
Box14LineDesc3 nvarchar 10      
Box15a bit 1 0    
Box15b bit 1 0    
Box15c bit 1 0    
Box15d bit 1 0    
Box15E bit 1 0    
Box15F bit 1 0    
Box15G bit 1 0    
Box16A nvarchar 2      
Box16b nvarchar 20      
Box17 pDecimal 13 0    
Box18 pDecimal 13 0    
Box19 nvarchar 30      
Box20 pDecimal 13 0    
Box21 pDecimal 13 0    
Box19a nvarchar 30      
Box20a pDecimal 13 0    
Box21a pDecimal 13 0    
AddnlBox13 bit 1 0    
AddnlBox14 bit 1 0    
FirstLine bit 1 0    
NJFLIAmt pDecimal 13      
Counter int 4      
Column Name Column Type Length Default Value Description Enumeration
RecNo smallint 2      
RecType nvarchar 2      
RecPosition smallint 2      
RecLength smallint 2 0    
RecTitle nvarchar 50      
RecValue nvarchar 1000      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
LineRecord nvarchar 2048 0    
Column Name Column Type Length Default Value Description Enumeration
RecordType nchar 2      
Title nvarchar 50      
Position smallint 2      
Length smallint 2 0    
Note nvarchar 50      
Column Name Column Type Length Default Value Description Enumeration
PayrollNum smallint 2 -1    
PaYear smallint 2      
CurrentYn bit 1 0    
ts timestamp 8