Payroll Tables in sql database

118 Views

Commonly Used Tables:
1 – Employee Master
2 – Address Master
3 – Tax Information Master
4– Pay Code Master
5– Deduction Master
6 – Benefit Master
7 – State Tax Master
8 – Local Tax Master
9 – Employee Summary
10 – Year End Header
11– Year End Wage
12– Work Master
13– Work Master Detail
14– Work Header
15 – Payroll Activity
16– Payroll Batches
17 – Transactions
18 – Transaction Batch Activity
19 – Manual Check
20 – Manual Check Detail
21 – Keys Master
22 – Check History
23– Transaction History
24 – Transaction History Header
25 – Distribution History Header
26 – Distribution History Detail
27 – Departments
28– Positions
29– Payroll Posting Accounts
30 – Deduction Setup
31 – Employee Count (in system database)

INACTIVE:
0 – No
1 – Yes

DEDNFREQ (Deduction Frequency):
1 – Weekly
2 – Biweekly
3 – Semimonthly
4 – Monthly
5 – Quarterly
6 – Semiannually
7 – Annually
8 – Daily/Miscellaneous

VARDEDTN (Transaction Required):
0 – No
1 – Yes

UPRACTYP (Payroll Account Type):
1 – Gross Pay (DR)
2 – Federal Tax Withholding (CR)
3 – State Tax Withholding (CR)
4 – Local Tax Withholding (CR)
5 – Deduction Withholding (CR)
6 – Employer’s Tax Expense (DR)
7 – Benefits Expense (DR)
8 – Benefits Payable (CR)
9 – Taxable Benefits Expense (DR)
10 – Taxable Benefits Payable (CR)
11 – SUTA Payable (CR)
12 – FUTA Payable (CR)
13 – W/Comp Tax Expense (DR)
14 – W/Comp Tax Payable (CR)

PYRLRTYP (Payroll Record Type):
1 – Pay Codes
2 – Deductions
3 – Benefits
4 – State Taxes
5 – Local Taxes

PAYTYPE (Pay Type):
1 – Hourly
2 – Salary
3 – Piecework
4 – Commission
5 – Business Expense
6 – Overtime
7 – Double Time
8 – Vacation
9 – Sick
10 – Holiday
11 – Pension
12 – Other
13 – Earned Income Credit
14 – Charged Tips
15 – Reported Tips
16 – Minimum Wage Balance

Skip to toolbar