SQL-025: Employee adjunct lookups*¶
This document describes SQL-025, the employee adjunct lookups* statement or call used by SAIF.Business.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-025 |
| Operation type | Read |
| Execution method | Inline |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsEmployeeData |
| Criteria property | N/A |
| Lifecycle method | GetDeskLocation, GetMobilePhone |
Parameters¶
This SQL statement has no explicit parameters in the provided findings.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| ADP_EMPLOYEE | SELECT | See sample SQL and source implementation. |
| ADP_EMPLOYEE_PHONE_VIEW | SELECT | See sample SQL and source implementation. |
Sample SQL¶
SELECT desk_location_name FROM adp_employee WHERE user_id = :inMailID
SELECT P.PHONE_NUM FROM adp_employee_phone_view p WHERE P.EMPLOYER_EMPLID = :empId AND P.PHONE_CODE = 'C1'
Operations and processes¶
Note: Statements marked with
*are inferred from code behavior rather than explicit documentation or comments; statements marked with**could not be confirmed and should be treated as unknown until verified.
Sources¶
Business\SAIF.Business\clsEmployeeData.vb