SQL-002: Insert ADDRESS for clsAddressInfo

This statement supports clsAddressInfo by executing a create operation against ADDRESS.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:AddressID	Input	Decimal	N/A	Address primary key
:AddressCode	Input	String	5	Address type code
:AddressLine1	Input	String	40	Address line 1
:AddressLine2	Input	String	40	Address line 2
:AddressLine3	Input	String	40	Address line 3
:AddressLine4	Input	String	40	Address line 4
:CityName	Input	String	30	City name
:StateCode	Input	String	2	State code
:ZipCode	Input	String	5	Postal code
:ZipCodeExtension	Input	String	4	Postal code extension
:CountryCode	Input	Integer	5	Country code
:ForeignAddressFlag	Input	String (Y/N)	1	Foreign-address flag
:ForeignPostalCode	Input	String	15	Foreign postal code
:CreateDate	Input	Date	N/A	Audit create timestamp
:CreateUser	Input	String	30	Audit create user
: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
:CountyCode	Input	Integer	5	County code
:LocationName	Input	String	100	Location name

Tables

Table	Access	Columns used
ADDRESS	INSERT	ACTIVE_FLAG, ADDRESS_CODE, ADDRESS_LINE1, ADDRESS_LINE2, ADDRESS_LINE3, ADDRESS_LINE4, ADDRESS_SEQ_NUM, CITY_NAME, COUNTRY_CODE, COUNTY_CODE, CREATE_DATE, CREATE_USER, EFF_DT, EXP_DT, FOREIGN_ADDRESS_FLAG, FOREIGN_POSTAL_CODE, LOCATION_NAME, NOTE_TEXT, PRIMARY_FLAG, STATE, UPDATE_DATE, UPDATE_USER, ZIP_CODE, ZIP_CODE_EXT

Sample SQL

Insert into ADDRESS ( ADDRESS_SEQ_NUM, ADDRESS_CODE, ADDRESS_LINE1, ADDRESS_LINE2, ADDRESS_LINE3, ADDRESS_LINE4, CITY_NAME, STATE, ZIP_CODE, ZIP_CODE_EXT, COUNTRY_CODE, FOREIGN_ADDRESS_FLAG, FOREIGN_POSTAL_CODE, CREATE_DATE, CREATE_USER, UPDATE_USER, UPDATE_DATE, EFF_DT, EXP_DT, ACTIVE_FLAG, PRIMARY_FLAG, NOTE_TEXT, COUNTY_CODE, LOCATION_NAME ) Values ( :AddressID, :AddressCode, :AddressLine1, :AddressLine2, :AddressLine3, :AddressLine4, :CityName, :StateCode, :ZipCode, :ZipCodeExtension, :CountryCode, :ForeignAddressFlag, :ForeignPostalCode, :CreateDate, :CreateUser, NULL, NULL, :EffectiveDate, :ExpirationDate, :ActiveFlag, :PrimaryFlag, :NoteText, :CountyCode, :LocationName)

Operations and processes

• Address info CRUD and linking

Business rules

• BR-005: Address records require an ID and address type

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

Sources

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