SQL-027: Employee-leave retrieval¶

This document describes SQL-027, the employee-leave retrieval statement or call used by SAIF.Business.

Classification¶

Field	Value
SQL ID	SQL-027
Operation type	Read
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsEmployeeLeave`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve`

Parameters¶

This SQL statement has no explicit parameters in the provided findings.

Tables¶

Table	Access	Columns used
EMPLOYEE_LEAVE	SELECT	See sample SQL and source implementation.

Sample SQL¶

SELECT EL.EMPLOYEE_LEAVE_SEQ_NUM AS EmployeeLeaveSeqNum,
       EL.EMPLOYEE_EMPLID AS EmployeeEmplid,
       EL.LEAVE_TYPE_CODE AS LeaveTypeCode,
       EL.SYSTEM_TYPE_CODE AS SystemTypeCode,
       EL.BEGIN_DATE AS BeginDate,
       EL.END_DATE AS EndDate,
       EL.CREATE_DATE AS CreateDate,
       EL.CREATE_USER AS CreateUser,
       EL.UPDATE_DATE AS UpdateDate,
       EL.UPDATE_USER AS UpdateUser
  FROM EMPLOYEE_LEAVE EL
 WHERE EL.EMPLOYEE_LEAVE_SEQ_NUM = :EmployeeLeaveSeqNum

Operations and processes¶

Employee leave persistence

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Business\SAIF.Business\clsEmployeeLeave.vb