SQL-024: Wcis employee fallback¶
This document describes SQL-024, the wcis employee fallback statement or call used by SAIF.Business.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-024 |
| Operation type | Read |
| Execution method | Inline |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsEmployeeData |
| Criteria property | WCISEmployeeSQL |
| Lifecycle method | BeforeRetrieve |
Parameters¶
This SQL statement has no explicit parameters in the provided findings.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| WCIS_EMPLOYEE | SELECT | See sample SQL and source implementation. |
Sample SQL¶
SELECT USER_NAME AS UserID, EMPLOYEE_LAST_NAME AS LastName, EMPLOYEE_FIRST_NAME AS FirstName,
EMPLOYEE_INITIAL AS MiddleName, PHONE_NUM AS Phone, PHONE_EXT AS PhoneExtension,
POSITION_TITLE AS Descr, DECODE(NVL(EMPLOYEE_STATUS_CODE,'IN'),'IN','T','A') AS EmplStatus
FROM WCIS_EMPLOYEE
WHERE USER_NAME = :UserID
Operations and processes¶
Note: Statements marked with
**could not be confirmed; treat as unknown until verified.
Sources¶
Business\SAIF.Business\clsEmployeeData.vb