Reference no: EM131969768

Write a program that will provide a list of their employees with the following information:

Field Size Type Additional Information
Employee Number 5 Alphanumeric
Employee Name 20 Alphanumeric
Position Title (PT) 10 Alphanumeric
Salary Level (SL) 2 Numeric Range of 01 to 03
Annual Salary (AS) 6 Numeric Appropriate dollar signs ($) and commas (,) must appear in the report. Remove all leading zeros.
Annual Bonus (AB) 6 Numeric Appropriate dollar signs ($) and commas (,) must appear in the report. Remove all leading zeros.
Date of Entry (DOE) 8 Alphanumeric or Numeric zz/zz/zzzz
Tenure (TEN) 2 Numeric Range of 00 to 99
Eligible (EL) 1 Alphanumeric Y or N
Salary Increase 6 Numeric Appropriate dollar signs ($) and commas (,) must appear in the report. Remove all leading zeros.

(2 ).Salary Level Categories: . Level 1: $30,000 to $48,999 . Level 2: $49,000 to $78,999 . Level 3: $79,000 to $100,000

PRIMARY REPORT (output #1) The primary report should only contain records with no errors. "Date of Entry" is generated in the code; the date is not part of the data file.

Employee Promotion Eligibility . Employees are eligible for promotion if they have worked for the company, called "tenure", for at least 5 years. . If the employee is eligible for promotion, a "Y" must appear in the "Eligible" field for those employees in the output. . If the employee is not eligible for promotion, an "N" must appear in the "Eligible" field for those employees in the output. Also, the salary increase field must be $000,000. . If an employee is eligible for promotion, calculate 9% of the Annual Salary and enter the value in the Salary Increase field.

Employee Salary Information . If the salary level = 3, then the annual bonus is 7% of annual salary.

ERROR REPORT (output #2) Unfortunately, numerous errors had been entered into the data. You must identify the type of error and create an error report that explains that error. Only records containing errors can appear in the error report. The following errors need to be identified, by writing data validation code, to identify the following:

Produce an error report that provides the following information:

(1) Some records have incorrect salary data. For example, salaries at level 2 should be within the range of $49,000 to $78,999 inclusive. Unfortunately, someone entered values above or below that range. Identify these records and provide an explanation below each record that says:

ERROR #1: The above record contains a salary that is out of range for level 2.

(2) Some records have the Position Title field blank. Position titles must be complete to ensure the records are accurate. Identify these records and provide an explanation below each record that says:

ERROR #2: The above record is missing position title data.