Home HR & RecruitingPayroll Processing System

Payroll Processing System

Payroll system with pay periods, deductions, benefits, tax withholding, direct deposit, and pay stub generation

SchemaVerse

HR & RecruitingPostgreSQLAudit LogHRNormalized

payroll-system.dbml

12 tables|11 relations

employees

idinteger

employee_numbervarchar(50)

*UQ

first_namevarchar(100)

last_namevarchar(100)

emailvarchar(255)

*UQ

ssn_last4varchar(4)

date_of_birthdate

hire_datedate

termination_datedate

employment_statusvarchar(20)

created_attimestamp

updated_attimestamp

pay_periods

idinteger

period_typevarchar(20)

start_datedate

end_datedate

pay_datedate

statusvarchar(20)

approved_byinteger

approved_attimestamp

created_attimestamp

updated_attimestamp

payroll_runs

idinteger

pay_period_idinteger

FK*

run_numberinteger

run_typevarchar(20)

statusvarchar(20)

total_gross_paydecimal(15,2)

total_net_paydecimal(15,2)

total_deductionsdecimal(15,2)

total_employer_taxesdecimal(15,2)

employee_countinteger

processed_byinteger

processed_attimestamp

approved_byinteger

approved_attimestamp

created_attimestamp

updated_attimestamp

payslips

idinteger

payroll_run_idinteger

FK*

employee_idinteger

FK*

base_salarydecimal(10,2)

overtime_hoursdecimal(5,2)

overtime_paydecimal(10,2)

bonusdecimal(10,2)

commissiondecimal(10,2)

gross_paydecimal(10,2)

total_deductionsdecimal(10,2)

total_taxesdecimal(10,2)

net_paydecimal(10,2)

payment_methodvarchar(20)

payment_datedate

statusvarchar(20)

notestext

created_attimestamp

updated_attimestamp

deduction_types

idinteger

codevarchar(50)

*UQ

namevarchar(100)

categoryvarchar(50)

descriptiontext

is_pre_taxboolean

is_employer_contributionboolean

calculation_methodvarchar(50)

is_activeboolean

created_attimestamp

updated_attimestamp

deductions

idinteger

payslip_idinteger

FK*

deduction_type_idinteger

FK*

calculation_basedecimal(10,2)

rate_percentagedecimal(5,2)

amountdecimal(10,2)

employer_contributiondecimal(10,2)

created_attimestamp

benefits

idinteger

namevarchar(200)

benefit_typevarchar(50)

providervarchar(200)

descriptiontext

is_activeboolean

created_attimestamp

updated_attimestamp

benefit_enrollments

idinteger

employee_idinteger

FK*

benefit_idinteger

FK*

coverage_levelvarchar(50)

employee_contributiondecimal(10,2)

employer_contributiondecimal(10,2)

start_datedate

end_datedate

statusvarchar(20)

created_attimestamp

updated_attimestamp

tax_brackets

idinteger

yearinteger

filing_statusvarchar(50)

min_incomedecimal(12,2)

max_incomedecimal(12,2)

tax_rate_percentagedecimal(5,2)

base_taxdecimal(10,2)

created_attimestamp

tax_withholdings

idinteger

payslip_idinteger

FK*

tax_typevarchar(50)

taxable_incomedecimal(10,2)

tax_rate_percentagedecimal(5,2)

amountdecimal(10,2)

created_attimestamp

bank_accounts

idinteger

employee_idinteger

FK*

account_typevarchar(20)

routing_numbervarchar(9)

account_number_last4varchar(4)

bank_namevarchar(200)

is_primaryboolean

allocation_percentagedecimal(5,2)

is_activeboolean

created_attimestamp

updated_attimestamp

bonus_payments

idinteger

employee_idinteger

FK*

bonus_typevarchar(50)

amountdecimal(10,2)

reasontext

approved_byinteger

approved_attimestamp

pay_period_idinteger

statusvarchar(20)

paid_attimestamp

created_attimestamp

updated_attimestamp

React Flow

About this Schema

Overview

Comprehensive payroll processing system. Handles pay period management, salary/hourly calculations, tax withholding, benefit deductions, direct deposit, and historical pay stub records.

Key Design Decisions

Pay Period Types: Support weekly, bi-weekly, semi-monthly, monthly
Deduction Management: Pre-tax and post-tax deductions
Tax Calculation: Withholding based on tax brackets and allowances
Direct Deposit: Bank account management and ACH processing

Tables

12 tables covering employees, pay periods, earnings, deductions, benefits, tax withholding, direct deposit, and pay stubs. Payroll compliance foundation.

Comments

Loading comments...