Assume that you are working with a payroll application that produces weekly paychecks, including pay stubs. Listed in the table below are 20 data elements that appear on the paycheck/ pay stub. For each numbered item, indicate the immediate (versus ultimate) source of the item. For instance, the immediate source of the number of exemptions for an employee would be the employee master data, as opposed to the ultimate source, which is the W-4 form filed by the employee. Some items may have more than one source, as in the case of item 1. You have the following choices: 

E = employee master data 

T = time records (these are in machine- readable form and show, for each employee for each day, the time punched in the morning, out at lunch, in after lunch, and out in the evening) 

H = table of hourly wage rates (i.e., wage rate “class” and hourly rate for each class) 

W = table of state and federal income tax withholding amounts plus FICA tax rate and annual “cutoff” amount for FICA wages 

CG = computer generated (such as a date or time of day supplied by the system) 

CC = computer calculated 

CO = console operator (such as batch totals or a date to be used) Arrange your answer as follows:

Item No ........... Source

1 ............. E

2 .............?

Etc

The items to be considered are as follows:

Number ............ Description

1 ............. Social security number

2 ............. Employee name

3 ............. Employee address

4 ............. Employee identification number

5 ............. Pay rate classification

6 ............. Regular hours worked

7 ............. Hours worked

8 ............. Hourly pay rate

9 ............. Regular earnings

10 ............Overtime earnings

11 ............Total earnings

12 ............Deduction for state income tax

13 ............Deduction for FICA tax

14 ............Deduction for federal income tax

15 ............Union dues withheld (flat amount based on length of service)

16 ............Net pay

17 ............Check number (same number is also preprinted on each check form)

18 ............Year-to-date amounts for items 11 through 14

19 ............Pay period end date

20 ............Date of check (employees are paid on Wednesday for the week ended the previous Friday)