INF2004F Summary Notes.docx

It is then credited for the amount of all labour cost

Info icon This preview shows pages 19–21. Sign up to view the full content.

employees in a particular period. It is then credited for the amount of all labour cost allocated to various expense categories) the payroll clearing account should have a zero balance- if not, indicates a processing error Write protection- eliminate possibility of overwriting or erasing existing data Concurrent update- locking records or fields when they are being updated so multiple users aren’t updating at the same time Reconciliation Data transmission controls - check sums- hash of file transmitted, comparison made of hash before and after transmission - when data re transmitted the sending device can calculate a hash of the file (checksum), the receiving device performs the same calculation and sends the result to the sending device. If the 2 hashes agree, the transaction is presumed to be accurate otherwise the file is resent - parity checking- bit added to each character transmitted, the characters can be verified for accuracy - subschema restricting access- restricts access to what you’re allowed to see e.g. peoplesoft- as a student, you’re given a subschema to view data only specific to you, can’t access what professors see Data transmission controls (check sum, parity checks) Check sums – sending device’s result of calculation of hash (checksum) & receiving device’s hash using same calculation must match and agree to be accurate data Parity checking – bits added to each character & characters verified for accuracy Run-to-run: Purpose is to ensure that no records are lost, unprocessed or processed more than once for each of the computer runs (processes) that the records must flow through Run to run totals= totals such as record counts, batch totals and or hash totals obtained at the end of one processing run are distributed to the next run and compared to corresponding totals produced at the end of the second run
Image of page 19

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

E.g. the beginning balances on the receivable ledger plus the sales invoices (processing run 1) less the cheques received (processing run 2) should equal the closing balances on the receivable ledger Run to run control totals are totals of key fields- in this case the totals of the receivables balances- taken when the receivables are posted. If the totals are recalculated and compared with the previous balance, this would detect alterations between postings. Both record counts and sequence checking would only detect missing records. They wouldn’t detect situations where balances are altered but the number of records is unchanged. Range checks would only detect when the balances are outside a predetermined value range and not changes to the balances within those ranges Controls over referential integrity Ensure the integrity of master files by identifying the following anomalies during processing: - Duplicate master file records - Master file record to be deleted has current transactions on file - Changes to key fields will invalidate record links Referential integrity: - Ensure that every foreign key value must match a primary key value in an associated table
Image of page 20
Image of page 21
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern