SQL-028: Pk82029 titan select employee leave

This document describes SQL-028, the pk82029 titan select employee leave statement or call used by SAIF.Business.

Classification

Field	Value
SQL ID	SQL-028
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	WCIS_DBA
Command type	StoredProcedure
Business object	clsEmployeeLeaveCollection
Criteria property	N/A
Lifecycle method	GetEmployeeLeave

Parameters

Parameter	Direction	Type	Max length	Description
:SystemTypeCode, :StartDate	Input	String / Date	5 / N/A	Employee-leave collection filter

Tables

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

Sample SQL

pk82029_titan.select_employee_leave(:SystemTypeCode, :StartDate)

Operations and processes

• Employee leave persistence

Sources

• Business\SAIF.Business\clsEmployeeLeave.vb