4 - IS Audit and Input Controls

A product code must begin with two characters busi

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: • Examples: – A SIN only contains digits. SIN only contains digits – A UBC student number must be a 8-digit number. – A product code must begin with two characters. BUSI 335 Copyright © 2009-10 Y.M. Cheung, W. Tan, C. Woo and P. Bera 37 BUSI 335 • Reasonableness check: The system checks to see if selected fields fall checks to see if selected fields fall within specified limits. – Examples: • An employee’s gross pay cannot exceed six figures. • Existence check: The technique ensures the validity of data by comparing it to the data files/tables. – Examples: • Product code should be one of the valid product codes. Copyright © 2009-10 Y.M. Cheung, W. Tan, C. Woo and P. Bera 38 Check Digit Example: SIN Digit Example: SIN Field Level (cont…) Level (cont…) Example Example: Employee's social insurance number (SIN): 550 911 895 Formula: • Recipient's SIN (Exclude the check digit, position 9, from calculation) 55091189 5 9 1 9 • Multiply every second digit by 2 x2 x2 x2 x2 10 18 2 18 • Cross add the resulting digits ( 1 + 0 + 1 + 8 + 2 + 1 + 8 ) = 21 add the resul...
View Full Document

This document was uploaded on 03/04/2014 for the course COMM 335 at UBC.

Ask a homework question - tutors are online