Skip to content

SQL-042: Insert w c i s employee

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

Classification

Field Value
SQL ID SQL-042
Operation type Insert
Execution method IDataRequest.SQLStatement (CommandType.Text)
Database Oracle
Schema [unqualified]**
Command type Text
Business object clsWCISEmployee
Criteria property InsertSQL
Lifecycle method BeforeInsert / AfterInsert

Parameters

Parameter Direction Type Max length Description
:UserName Input bound from UserName 30 Bound in clsWCISEmployee.BeforeInsert (line 470)
:LastName Input bound from LastName 25 Bound in clsWCISEmployee.BeforeInsert (line 448)
:FirstName Input bound from m_FirstName 20 Bound in clsWCISEmployee.BeforeInsert (line 450)
:MiddleInitial Input bound from m_MiddleInitial 1 Bound in clsWCISEmployee.BeforeInsert (line 451)
:EmployeeNumber Input bound from EmployeeNumber - Bound in clsWCISEmployee.BeforeInsert (line 449)
:DepartmentCode Input bound from m_DepartmentCode 5 Bound in clsWCISEmployee.BeforeInsert (line 452)
:UnitCode Input bound from m_UnitCode 5 Bound in clsWCISEmployee.BeforeInsert (line 453)
:EmployeeStatusCode Input bound from m_EmployeeStatusCode 5 Bound in clsWCISEmployee.BeforeInsert (line 454)
:PhoneExtension Input bound from m_PhoneExtension 4 Bound in clsWCISEmployee.BeforeInsert (line 455)
:EmployeeClassCode Input bound from m_EmployeeClassCode 5 Bound in clsWCISEmployee.BeforeInsert (line 456)
:DivertBankFlag Input bound from m_DivertBankFlag 1 Bound in clsWCISEmployee.BeforeInsert (line 457)
:Supervisor Input bound from m_Supervisor 30 Bound in clsWCISEmployee.BeforeInsert (line 458)
:CreateUser Input bound from m_CreateUser 30 Bound in clsWCISEmployee.BeforeInsert (line 459)
:CreateDate Input bound from m_CreateDate - Bound in clsWCISEmployee.BeforeInsert (line 460)
:UpdateUser Input bound from m_UpdateUser 30 Bound in clsWCISEmployee.BeforeInsert (line 461)
:UpdateDate Input bound from m_UpdateDate - Bound in clsWCISEmployee.BeforeInsert (line 462)
:EmployeeIdentifierCode Input bound from m_EmployeeIdentifierCode 2 Bound in clsWCISEmployee.BeforeInsert (line 463)
:PhoneNum Input bound from m_PhoneNum 12 Bound in clsWCISEmployee.BeforeInsert (line 464)
:UWUnitCode Input bound from m_UWUnitCode 5 Bound in clsWCISEmployee.BeforeInsert (line 465)
:PrinterID Input bound from m_PrinterID 10 Bound in clsWCISEmployee.BeforeInsert (line 466)
:CopyCount Input bound from m_CopyCount - Bound in clsWCISEmployee.BeforeInsert (line 467)
:OutputFunction Input bound from m_OutputFunction 10 Bound in clsWCISEmployee.BeforeInsert (line 468)
:PositionTitle Input bound from m_PositionTitle 65 Bound in clsWCISEmployee.BeforeInsert (line 469)

Tables

Table Access Columns used
WCIS_EMPLOYEE INSERT See sample SQL

Sample SQL

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

Business rules

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