SQL-002: Pk82029 titan insert employee leave

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

Classification

Field	Value
SQL ID	SQL-002
Operation type	Create
Execution method	Stored procedure
Database	Oracle
Schema	WCIS_DBA
Command type	StoredProcedure
Business object	clsEmployeeLeave
Criteria property	InsertSQL
Lifecycle method	BeforeInsert

Parameters

Parameter	Direction	Type	Max length	Description
:employee_leave_seq_num_in, :employee_emplid_in, :leave_type_code_in, :system_type_code_in, :begin_date_in, :end_date_in, :CREATE_USER_in	Input	Mixed	Mixed	Insert contract for employee leave

Tables

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

Sample SQL

pk82029_titan.Insert_employee_leave(
    :employee_leave_seq_num_in,
    :employee_emplid_in,
    :leave_type_code_in,
    :system_type_code_in,
    :begin_date_in,
    :end_date_in,
    :CREATE_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

Sources

• Business\SAIF.Business\clsEmployeeLeave.vb