CompanyStructure:
  0: {title: 'XYZCompany', description: '', lft: 1, rgt: 2, id: 1, parnt: 0}
  1: {title: 'Marketing', description: '', lft: 0, rgt: 0, id: 2, parnt: 1}
  2: {title: 'Production', description: '', lft: 0, rgt: 0, id: 3, parnt: 1}
  3: {title: 'HR', description: '', lft: 0, rgt: 0, id: 4, parnt: 1}

Location:
  0: {loc_code: 'LOC001', loc_name: 'Houston', loc_country: 'US', loc_add: 'Houston', loc_zip: 1234}
  1: {loc_code: 'LOC002', loc_name: 'London', loc_country: 'GB', loc_add: 'London', loc_zip: 9874}

JobTitle:
  0: {id: 'JOB001', name: 'Marketing Executive', description: 'ME'}
  1: {id: 'JOB002', name: 'Production Manager', description: 'PM'}

LeaveType:
  0: {leaveTypeId: 'LTY001', leaveTypeName: 'Casual', availableFlag: 1, leaveRules: '<leaveRule>1</leaveRule>'}
  1: {leaveTypeId: 'LTY002', leaveTypeName: 'Medical', availableFlag: 1, leaveRules: '<leaveRule>2</leaveRule>'}
  2: {leaveTypeId: 'LTY003', leaveTypeName: 'Company', availableFlag: 0, leaveRules: '<leaveRule>3</leaveRule>'}

Employee:
  0: {empNumber: 1, firstName: 'Kayla', lastName: 'Abbey', work_station: 2, job_title_code: 'JOB001', emp_status: 'EST000'}
  1: {empNumber: 2, firstName: 'Ashley', lastName: 'Abel', work_station: 2, emp_status: NULL}
  2: {empNumber: 3, firstName: 'Tyler', lastName: 'Abraham', work_station: 3, job_title_code: 'JOB002', emp_status: 'EST001'}
  3: {empNumber: 4, firstName: 'Landon', lastName: 'Abrahams', emp_status: NULL}
  4: {empNumber: 5, firstName: 'James', lastName: 'Abrahamson', job_title_code: 'JOB001', emp_status: NULL}

EmpLocation:
  0: {empNumber: 1, loc_code: 'LOC001'}
  1: {empNumber: 4, loc_code: 'LOC001'}
  2: {empNumber: 5, loc_code: 'LOC002'}

ReportingMethod:
  0: {reportingMethodId: '1', reportingMethodName: 'reportingMethodName1'}

ReportTo:
  0: {supervisorId: 1, subordinateId: 2, reportingMethodId: 1}
  1: {supervisorId: 1, subordinateId: 5, reportingMethodId: 1}
  2: {supervisorId: 3, subordinateId: 4, reportingMethodId: 1}

LeavePeriod:
  0: {leave_period_id: 1, leave_period_start_date: '2011-01-01', leave_period_end_date: '2011-12-31'}
  
EmployeeLeaveEntitlement:
  0: {leave_type_id: 'LTY001', employee_id: 1, leave_period_id: 1, no_of_days_allotted: 0, leave_taken: 0, leave_brought_forward: 0, leave_carried_forward: 0}
  1: {leave_type_id: 'LTY001', employee_id: 2, leave_period_id: 1, no_of_days_allotted: 0, leave_taken: 0, leave_brought_forward: 0, leave_carried_forward: 0}
  2: {leave_type_id: 'LTY001', employee_id: 3, leave_period_id: 1, no_of_days_allotted: 0, leave_taken: 0, leave_brought_forward: 0, leave_carried_forward: 0}
  3: {leave_type_id: 'LTY001', employee_id: 4, leave_period_id: 1, no_of_days_allotted: 0, leave_taken: 0, leave_brought_forward: 0, leave_carried_forward: 0}
  4: {leave_type_id: 'LTY001', employee_id: 5, leave_period_id: 1, no_of_days_allotted: 0, leave_taken: 0, leave_brought_forward: 0, leave_carried_forward: 0}
  5: {leave_type_id: 'LTY002', employee_id: 1, leave_period_id: 1, no_of_days_allotted: 0, leave_taken: 0, leave_brought_forward: 0, leave_carried_forward: 0}
  6: {leave_type_id: 'LTY002', employee_id: 2, leave_period_id: 1, no_of_days_allotted: 0, leave_taken: 0, leave_brought_forward: 0, leave_carried_forward: 0}
  7: {leave_type_id: 'LTY002', employee_id: 3, leave_period_id: 1, no_of_days_allotted: 0, leave_taken: 0, leave_brought_forward: 0, leave_carried_forward: 0}
  8: {leave_type_id: 'LTY002', employee_id: 4, leave_period_id: 1, no_of_days_allotted: 0, leave_taken: 0, leave_brought_forward: 0, leave_carried_forward: 0}
  9: {leave_type_id: 'LTY002', employee_id: 5, leave_period_id: 1, no_of_days_allotted: 0, leave_taken: 0, leave_brought_forward: 0, leave_carried_forward: 0}
  10: {leave_type_id: 'LTY003', employee_id: 1, leave_period_id: 1, no_of_days_allotted: 0, leave_taken: 0, leave_brought_forward: 0, leave_carried_forward: 0}
  11: {leave_type_id: 'LTY003', employee_id: 2, leave_period_id: 1, no_of_days_allotted: 0, leave_taken: 0, leave_brought_forward: 0, leave_carried_forward: 0}
  12: {leave_type_id: 'LTY003', employee_id: 3, leave_period_id: 1, no_of_days_allotted: 0, leave_taken: 0, leave_brought_forward: 0, leave_carried_forward: 0}
  13: {leave_type_id: 'LTY003', employee_id: 4, leave_period_id: 1, no_of_days_allotted: 0, leave_taken: 0, leave_brought_forward: 0, leave_carried_forward: 0}
  14: {leave_type_id: 'LTY003', employee_id: 5, leave_period_id: 1, no_of_days_allotted: 0, leave_taken: 0, leave_brought_forward: 0, leave_carried_forward: 0}