business logic query EmployeeForDomain

Description

Will return all employees with the same code within the same domain as the selected company.

each Employee where

Employee.Company_Id = iiCompanyId AND
Employee.EmployeeCode = icEmployeeCode AND
rowid(Employee) <> to-rowid(icSkipRowid)

first Company (inner-join) where

Company.Company_Id = iiCompanyId AND
Company.Company_ID = Employee.Company_ID AND
Company.Domain_ID = iiDomainId

field name	data type	db field	description
tiCompany_ID	integer	Employee.Company_ID	Link to Company
tiDomain_ID	integer	Company.Domain_ID	Domain
tiEmployee_ID	integer	Employee.Employee_ID	Record ID
tcEmployeeCode	character	Employee.EmployeeCode	Employee Code. A code that identifies an employee. The code cannot match any other employee in the current entity or any other entities in the current domain. If you leave the Employee Code field blank, the system automatically generates a number for the record based on the sequence defined in Employee Autonumber Create.

QadFinancials