SQL-046: Pk82029 titan update employee leave

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

Classification

Field	Value
SQL ID	SQL-046
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	WCIS_DBA
Command type	StoredProcedure
Business object	clsEmployeeLeave
Criteria property	UpdateSQL
Lifecycle method	BeforeUpdate

Parameters

Parameter	Direction	Type	Max length	Description
SQL-002 parameter set plus :UPDATE_USER_in	Input	Mixed	Mixed	Employee leave update contract

Tables

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

Sample SQL

pk82029_titan.update_employee_leave(:employee_leave_seq_num_in, :employee_emplid_in, :leave_type_code_in, :system_type_code_in, :begin_date_in, :end_date_in, :UPDATE_USER_in)

Operations and processes

• Employee leave persistence

Business rules

• BR-SB-001: Employee leave requires investigator, reason, begin date, and end date
• BR-SB-002: Employee leave dates must stay within allowed ranges and ordering
• BR-SB-013: Employee leave updates expect single-row success

Sources

• Business\SAIF.Business\clsEmployeeLeave.vb