SQL-016: Insert PHONE for clsPhoneInfo

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

Classification

Field	Value
SQL ID	SQL-016
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
:ForeignNumber	Input	Unknown	30	Foreign phone number
: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, FOREIGN_NUMBER, 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, FOREIGN_NUMBER, COUNTRY_CODE, LONG_DISTANCE_FLAG, UPDATE_DATE, UPDATE_USER ) Values ( :PhoneID, :PhoneCode, :PhoneNumber, :EffectiveDate, :ExpirationDate, :ActiveFlag, :PrimaryFlag, :NoteText, :AreaCode, :PhonePrefix, :PhoneExtension, :ForeignFlag, :ForeignNumber, :CountryCode, :LongDistanceFlag, Null, Null)

Operations and processes

• Phone info CRUD and linking

Business rules

• BR-007: Phone records require an ID and formatted value

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

Sources

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