Application Controls, a Case Study

Only available on StudyMode
  • Download(s) : 203
  • Published : December 16, 2012
Open Document
Text Preview
A.
1. Main Inputs and Data to the system are:

* Clock CardsPayroll number
Department
Week Number
Name
Hours worked
Salary

* TimesheetsPayroll Number
Department
Week Number
Name
Holiday Hours
Overtime Hours
Hours Worked
Rate per hour
Salary

* Variance ReturnsDepartment
Period (Month/Week number)
Budgeted Salary to be paid (weekly/monthly)
Actual Salary Paid (weekly/monthly)
Variance

* Commission RatesPayroll Number
Department
Name
Sales
Rate (%)
Commission Pay

* Batch Header RecordsBatch Number
Batch Type
Batch Date
Batch Description
Batch Count
Batch Amount

* Productivity ReportDepartment
Period
Budget Cost/Forecasted Sales
Actual Cost/Sales
Efficiency Rate

2. Batching of data input and batch fields

* Clock CardsBatch <50
Batch Header showing
Job Code
Input Type Code
Week Number
Total Number of Records
Total Hours worked

* TimesheetsBatch<50
Batch Header showing
Job Code
Input Type Code
Job Description
Week number
Total Number of Records
Total Number of Hours worked
Total Amount Paid

* Commission RatesBatch <50
Batch Header showing
Job code
Input Type Code
Job Description
Period Number
Total Number of Records
Total Sales
Total Commission Pay

3. Validation of data at the data preparation stage
* Clock cardsPayroll number check digit
Week number range (1-53)
Hours worked range checked
Record format check
Record completeness check

* TimesheetsPayroll number check
Week number range (1-55)
Hours worked check (including OT and Holiday)
Record format check
Record completeness check
Hourly rate update check

* Commission RatesPayroll number check
Sales for the period check
Commission rate update check
Record format check
Record completeness check

* Batch Posting/inputBatch Total record check
Batch Total amount...
tracking img