2) Entity Selections: Employees Departments Payroll Salary Based Employees (Job Codes)
Hourly Based Employees (Job Codes)
Deductions Holidays Sick days Bonus As part of this process, a data dictionary of each table is needed which will offer documentation of more detailed information about the data to be used to support this University Payroll
Database. >>Forms: Based on tables created requiring input, a form should be created for each. For extended use of forms, teams should consider that forms can also be used for various operations including navigation via a switchboard.
>>Queries: Based on tables created and data entered, create queries as needed to support minimum output of commonly seen information on payroll stubs including the employee’s calculated gross pay, calculated deductions, and calculated net pay.
>>>Reports: Based on tables created requiring input and any queries including calculations using formulas and functions, at a very minimum create and design a payroll stub report. This report should include: Employee’s calculated gross pay (Current and Year to Date) Employee’s calculated deductions from taxes or any applicable deductions (Current and Year to Date) Employee’s calculated net pay after deductions (Curreiqunt and Year to Date)