Array processing programming assignment 2 Input Record Layout Report Layout Page 1 of 4 Array processing programming assignment 2 Program Name Page 2 of 4 Two level Tables Narrative This program illustrates two level tables and PERFORM VARYING in two dimensions Incoming employee records are checked for one of three locations and one of two performance levels producing six location performance combinations The average salary for each of these six combinations is computed Input File EMPLOYEE FILE PRJ13 03 dat 01 EMPLOYEE RECORD IN 10 EMP SOC SEC NUM 10 EMP NAME AND INITIALS 10 EMP DATE OF BIRTH 05 EMP PERSONAL INFO PlC X 9 PlC X 16 15 EMP BIRTH MONTH 9 2 15 EMP BIRTH YEAR 05 EMP COMPANY INFO 10 EMP DATE OF HIRE 15 EMP HIRE MONTH 15 EMP HIRE YEAR 10 EMP LOCATION CODE 10 EMP EDUCATION CODE 10 EMP TITLE DATA 15 EMP TITLE CODE 15 EMP TITLE DATE 10 EMP PERFORMANCE 10 EMP SALARY PlC 9 4 PlC 9 2 PlC 9 4 PlC 9 2 PlC X PlC X 3 PlC 9 6 PlC 9 PlC 9 5 PlC Array processing programming assignment 2 Page 3 of 4 Processing Requirements 1 Read a file of employee records 2 For each record read determine if the employee is in Miami code 30 Los Angeles code 60 or New York code 80 and has a performance rating of 1 high performance or 2 low performance Any employee meeting both requirements that is an employee with a valid location and performance rating is a qualified employee No further processing is necessary for nonqualified employees LOCATION PERFORMANCE AVERAGE SALARY REPORT LOCATION MIAMI LOS ANGELES NEW YORK HIGH PERFORMANCE AVG SAL EMPS ZZ ZZ9 99 ZZ9 ZZ ZZ9 99 ZZ9 ZZ ZZ9 99 ZZ9 MMM DD YYYY LOW PERFORMANCE AVG SAL EMPS ZZ ZZ9 99 ZZ9 ZZ ZZ9 99 ZZ9 ZZ ZZ9 99 ZZ9 Array processing programming assignment 2 Page 4 of 4 3 Establish 2 level table to compute salary statistics for the 6 location performance combinations Level 1For Branch Rows 1 2 and 3 are for Miami Los Angeles and New York Level 2 for Performance High or Low recording total salaries and the number of employees respectively 4 For each qualified employee a Determine the appropriate row column i e location performance combination b Increment the total of all employee salaries for that row column combination by this employee s salary c Increment the number of employees in that row column combination by 1 5 When all employees have been processed divide the total salaries for each combination by the number of employees in that combination producing the average salary for that combination Produce the required report shown in the report layout Note Your date routine must be changed to report the alpha abbreviation of the month