SQL-143: Update w c i s employee¶

Update w c i s employee in the context of clsWCISEmployee.

Classification¶

Field	Value
SQL ID	SQL-143
Operation type	Update
Execution method	IDataRequest.SQLStatement (CommandType.Text)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsWCISEmployee`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate / AfterUpdate`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:UserName`	Input	bound from `UserName`	30	Bound in `clsWCISEmployee.BeforeUpdate` (line 550)
`:LastName`	Input	bound from `LastName`	25	Bound in `clsWCISEmployee.BeforeUpdate` (line 528)
`:FirstName`	Input	bound from `m_FirstName`	20	Bound in `clsWCISEmployee.BeforeUpdate` (line 530)
`:MiddleInitial`	Input	bound from `m_MiddleInitial`	1	Bound in `clsWCISEmployee.BeforeUpdate` (line 531)
`:EmployeeNumber`	Input	bound from `EmployeeNumber`	-	Bound in `clsWCISEmployee.BeforeUpdate` (line 529)
`:DepartmentCode`	Input	bound from `m_DepartmentCode`	5	Bound in `clsWCISEmployee.BeforeUpdate` (line 532)
`:UnitCode`	Input	bound from `m_UnitCode`	5	Bound in `clsWCISEmployee.BeforeUpdate` (line 533)
`:EmployeeStatusCode`	Input	bound from `m_EmployeeStatusCode`	5	Bound in `clsWCISEmployee.BeforeUpdate` (line 534)
`:PhoneExtension`	Input	bound from `m_PhoneExtension`	4	Bound in `clsWCISEmployee.BeforeUpdate` (line 535)
`:EmployeeClassCode`	Input	bound from `m_EmployeeClassCode`	5	Bound in `clsWCISEmployee.BeforeUpdate` (line 536)
`:DivertBankFlag`	Input	bound from `m_DivertBankFlag`	1	Bound in `clsWCISEmployee.BeforeUpdate` (line 537)
`:Supervisor`	Input	bound from `m_Supervisor`	30	Bound in `clsWCISEmployee.BeforeUpdate` (line 538)
`:CreateUser`	Input	bound from `m_CreateUser`	30	Bound in `clsWCISEmployee.BeforeUpdate` (line 539)
`:CreateDate`	Input	bound from `m_CreateDate`	-	Bound in `clsWCISEmployee.BeforeUpdate` (line 540)
`:UpdateUser`	Input	bound from `m_UpdateUser`	30	Bound in `clsWCISEmployee.BeforeUpdate` (line 541)
`:UpdateDate`	Input	bound from `m_UpdateDate`	-	Bound in `clsWCISEmployee.BeforeUpdate` (line 542)
`:EmployeeIdentifierCode`	Input	bound from `m_EmployeeIdentifierCode`	2	Bound in `clsWCISEmployee.BeforeUpdate` (line 543)
`:PhoneNum`	Input	bound from `m_PhoneNum`	12	Bound in `clsWCISEmployee.BeforeUpdate` (line 544)
`:UWUnitCode`	Input	bound from `m_UWUnitCode`	5	Bound in `clsWCISEmployee.BeforeUpdate` (line 545)
`:PrinterID`	Input	bound from `m_PrinterID`	10	Bound in `clsWCISEmployee.BeforeUpdate` (line 546)
`:CopyCount`	Input	bound from `m_CopyCount`	-	Bound in `clsWCISEmployee.BeforeUpdate` (line 547)
`:OutputFunction`	Input	bound from `m_OutputFunction`	10	Bound in `clsWCISEmployee.BeforeUpdate` (line 548)
`:PositionTitle`	Input	bound from `m_PositionTitle`	65	Bound in `clsWCISEmployee.BeforeUpdate` (line 549)

Tables¶

Table	Access	Columns used
WCIS_EMPLOYEE	UPDATE	See sample SQL

Sample SQL¶

UPDATE
  WCIS_EMPLOYEE
SET
  USER_NAME = :UserName,
  EMPLOYEE_LAST_NAME = :LastName,
  EMPLOYEE_FIRST_NAME = :FirstName,
  EMPLOYEE_INITIAL = :MiddleInitial,
  EMPLOYEE_NUM = :EmployeeNumber,
  DEPT_CODE = :DepartmentCode,
  UNIT_CODE = :UnitCode,
  EMPLOYEE_STATUS_CODE = :EmployeeStatusCode,
  PHONE_EXT = :PhoneExtension,
  EMPLOYEE_CLASS_CODE = :EmployeeClassCode,
  DIVERT_BANK_FLAG = :DivertBankFlag,
  SUPERVISOR = :Supervisor,
  CREATE_USER = :CreateUser,
  CREATE_DATE = :CreateDate,
  UPDATE_USER = :UpdateUser,
  UPDATE_DATE = :UpdateDate,
  EMPLOYEE_IDENTIFIER_CODE = :EmployeeIdentifierCode,
  PHONE_NUM = :PhoneNum,
  UW_UNIT_CODE = :UWUnitCode,
  PRINTER_ID = :PrinterID,
  COPY_COUNT = :CopyCount,
  OUTPUT_FUNCTION = :OutputFunction,
  POSITION_TITLE = :PositionTitle
WHERE
  WCIS_EMPLOYEE.USER_NAME = :UserName

Business rules¶

BR-033: New sequence values for writable entities are obtained

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Business\SAIF.Business.Policy.Core\clsWCISEmployee.vb