Skip to content

SQL-017: Insert PHONE for clsPhoneInfo

This statement supports clsPhoneInfo by executing a create operation against PHONE.

Classification

Field Value
SQL ID SQL-017
Operation type Create
Execution method Inline
Database Oracle
Schema [unqualified]**
Command type Text
Business object clsPhoneInfo
Criteria property InsertSQL
Lifecycle method BeforeInsert

Parameters

Parameter Direction Type Max length Description
:PhoneID Input Decimal N/A Phone primary key
:PhoneCode Input String 5 Phone type code
:PhoneNumber Input String 25 Phone number text
:EffectiveDate Input Date N/A Effective date
:ExpirationDate Input Date N/A Expiration date
:ActiveFlag Input String (Y/N) 1 Active flag
:PrimaryFlag Input String (Y/N) 1 Primary flag
:NoteText Input String 100 Free-form note text
:AreaCode Input String 10 Area code
:PhonePrefix Input String 10 Phone prefix
:PhoneExtension Input String 10 Phone extension
:ForeignFlag Input String (Y/N) 1 Foreign-phone flag
:CountryCode Input Integer 5 Country code
:LongDistanceFlag Input String (Y/N) 1 Long-distance flag

Tables

Table Access Columns used
PHONE INSERT ACTIVE_FLAG, AREA_CODE, COUNTRY_CODE, EFF_DT, EXP_DT, FOREIGN_FLAG, LONG_DISTANCE_FLAG, NOTE_TEXT, PHONE_CODE, PHONE_EXTENSION, PHONE_NUM, PHONE_PREFIX, PHONE_SEQ_NUM, PRIMARY_FLAG, UPDATE_DATE, UPDATE_USER

Sample SQL

Insert into PHONE ( PHONE_SEQ_NUM, PHONE_CODE, PHONE_NUM, EFF_DT, EXP_DT, ACTIVE_FLAG, PRIMARY_FLAG, NOTE_TEXT, AREA_CODE, PHONE_PREFIX, PHONE_EXTENSION, FOREIGN_FLAG, COUNTRY_CODE, LONG_DISTANCE_FLAG, UPDATE_DATE, UPDATE_USER ) Values ( :PhoneID, :PhoneCode, :PhoneNumber, :EffectiveDate, :ExpirationDate, :ActiveFlag, :PrimaryFlag, :NoteText, :AreaCode, :PhonePrefix, :PhoneExtension, :ForeignFlag, :CountryCode, :LongDistanceFlag, Null, Null)

Operations and processes

Business rules

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

  • Business\SAIF.Business.CustomerContact\InfoItems\clsPhoneInfo.vb