OPERATOR table
Employee information is exported from the EMPLOYEE and EMPQUAL tables (
Hansen.Resources.Employee and Hansen.Resources.Qualification objects). The export includes employees whose job class matches the job class specified in the Inspection Exchange Setup form.
This table shows the property of the Employee or Qualification object that each column in the OPERATOR table maps to.
| Access DB column | IPS property |
|---|---|
| CERTNO | Hansen.Resources.Qualification.CertificationNumber |
| CERTTYPE | Hansen.Resources.Qualification.QualificationType.Code |
| CODE | Hansen.Resources.Employee.EmployeeID |
| CREWLEAD | Hansen.Resources.Employee.IsCrewLeader |
| FIRSTNAME | Hansen.Resources.Employee.Contact.Identity.FirstName |
| LASTNAME | Hansen.Resources.Employee.Contact.Identity.LastName |
| NAME | Hansen.Resources.Employee.Contact.Identity.FullName |
| OPERGROUP | {JobClass} |