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} |