Employee Payroll Records

Employee Payroll Records Layout

Field 1	Field 2	Field 3	Field 4
Employee Number	Employee Name	Hourly Wage	Hours Worked

Using the Employee Payroll Records

• The records are made available to your programs with this function:

openEmployeePayrollRecords();

• The function returns the records so you need to store them in a variable:

let records;
records = openEmployeePayrollRecords();

• After the openEmployeePayrollRecords() function has been run you have access to the first record's data. You will retrieve each part of one record with a different function. Here are the functions:

records.getEmployeeNumber();
records.getEmployeeName();
records.getEmployeeHourlyWage();
records.getEmployeeHoursWorked();

• Notice that you need to have "records." in front of each of the functions.

• When you want to read the next record you use the following function. It will make the next record available and you then use the above functions to retrieve the data. This function returns true if there was a next record and false if the end of the record set has been reached.

records.readNextRecord();

---

Example Usage

Here's an example of how the Employee Payroll Records are used.

/*
  This is file /unit04/employeePayrollRecords.js.
  It contains the JavaScript code for "Employee Payroll Records".
  File: /unit04/employeePayrollRecords.html
*/
function employeePayrollRecords() {
    "use strict";

    let employeeNumber;
    let employeeName;
    let hourlyWage;
    let hoursWorked;
    let records;

    // Open the Employee Payroll Records and make them
    // available to the script
    records = openEmployeePayrollRecords();

    // Read the next record, test to see if there
    // is a next record and then output it
    while (records.readNextRecord()) {
        employeeNumber = records.getEmployeeNumber();
        employeeName = records.getEmployeeName();
        hourlyWage = records.getEmployeeHourlyWage();
        hoursWorked = records.getEmployeeHoursWorked();

        document.write(employeeNumber + "\t" + employeeName
                + "\t" + hourlyWage + "\t" + hoursWorked + "<br />");
    }
}

---

Employee Payroll Records Data