Transaction Database Paper

Every organization produces mass amounts of data, which can help lead and direct the organization in the right direction. However, this data needs to be converted into informational reports and must be easily accessible for the data to be useful. For example, the payroll system for the City of Commerce contains data, which can be used to enforce policies more effectively and maximize control over labor expenses, if used correctly. However, with its current process, …

…contributions, or deduction codes as the payroll processing requirements change, without modifying any existing programs within the payroll system. Furthermore, all payroll costs are expensed to a specific sub-ledger based on the cost distribution entered on an employee's timecard. In addition, all payroll expenses are automatically charged to the General Ledger based on the nature of expense and the cost sub-ledger distribution. Below is an illustration of the payroll system showing the relationship between entities.