project QadFinancials > class BMfgEngineer > business logic query EngineerByEmployee
Description
Query to fetch the engineer attached to the employee
Parameters
| icDomainCode | character | |
| icEmployee | character | |
query condition
each eng_mstr where
eng_mstr.eng_domain = icDomainCode AND
eng_mstr.eng_addr = icEmployee
query resultset tqEngineerByEmployee
| field name | data type | db field | description |
|---|
| tceng_addr | character | eng_mstr.eng_addr | Engineer |
| tceng_code | character | eng_mstr.eng_code | Engineer Code |
| tceng_domain | character | eng_mstr.eng_domain | Domain |
Internal usage
QadFinancials