SQL-003: Insert PERSON for clsContact¶
This statement supports clsContact by executing a create operation against PERSON.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-003 |
| Operation type | Create |
| Execution method | Inline |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsContact |
| Criteria property | InsertSQL |
| Lifecycle method | BeforeInsert |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:Name |
Input | String | 50 | Formatted contact name |
:IsActive |
Input | String (Y/N) | 1 | Active flag |
:IsPrimary |
Input | String (Y/N) | 1 | Primary flag |
:LastName |
Input | String | 50 | Formatted last-name search string or contact last name |
:FirstName |
Input | String | 50 | Formatted first-name search string or contact first name |
:MiddleInitial |
Input | String | 1 | Middle initial |
:MarriedName |
Input | String | 50 | Married name |
:MaidenName |
Input | String | 50 | Maiden name |
:NickName |
Input | String | 50 | Nickname |
:AliasName |
Input | String | 50 | Alias name |
:DriversLicenseNumber |
Input | Unknown | 15 | Driver license number |
:DriversLicenseState |
Input | String | 2 | Driver license state |
:BirthDate |
Input | Date | N/A | Birth date |
:TaxID |
Input | Decimal | 11 | Federal tax identifier |
:GenderCode |
Input | String | 5 | Gender code |
:EthnicGroupCode |
Input | String | 5 | Ethnic-group code |
:UpdateUser |
Input | Date | 30 | Audit update user |
:UpdateDate |
Input | Date | N/A | Audit update timestamp |
:NameExtension |
Input | String | 5 | Name suffix |
:EffectiveDate |
Input | Date | N/A | Effective date |
:ExpirationDate |
Input | Date | N/A | Expiration date |
:AnniversaryDate |
Input | Date | N/A | Anniversary date |
:PreferredName |
Input | String | 50 | Preferred name |
:NoteText |
Input | String | 100 | Free-form note text |
:ContactID |
Input | Decimal | N/A | Contact primary key |
:CreateDate |
Input | Date | N/A | Audit create timestamp |
:CreateUser |
Input | String | 30 | Audit create user |
Tables¶
| Table | Access | Columns used |
|---|---|---|
| PERSON | INSERT | ACTIVE_FLAG, ALIAS_NAME, ANNIVERSARY_DATE, BIRTH_DATE, CREATE_DATE, CREATE_USER, DRIVERS_LICENSE_NUM, DRIVERS_LICENSE_STATE, EFF_DT, ETHNIC_GROUP_CODE, EXP_DT, FIRST_NAME, GENDER_CODE, LAST_NAME, MAIDEN_NAME, MARRIED_NAME, MIDDLE_INITIAL, NAME, NAME_EXTENSION, NICK_NAME, NOTE_TEXT, PERSON_SEQ_NUM, PREFERRED_NAME, PRIMARY_FLAG, TAX_ID, UPDATE_DATE, UPDATE_USER |
Sample SQL¶
Insert into PERSON ( PERSON_SEQ_NUM, NAME, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, MARRIED_NAME, MAIDEN_NAME, NICK_NAME, ALIAS_NAME, DRIVERS_LICENSE_NUM, DRIVERS_LICENSE_STATE, BIRTH_DATE, TAX_ID, GENDER_CODE, ETHNIC_GROUP_CODE, CREATE_DATE, CREATE_USER, UPDATE_USER, UPDATE_DATE, NAME_EXTENSION, EFF_DT, EXP_DT, ACTIVE_FLAG, PRIMARY_FLAG, ANNIVERSARY_DATE, PREFERRED_NAME, NOTE_TEXT ) Values ( :ContactID, :Name, :LastName, :FirstName, :MiddleInitial, :MarriedName, :MaidenName, :NickName, :AliasName, :DriversLicenseNumber, :DriversLicenseState, :BirthDate, :TaxID, :GenderCode, :EthnicGroupCode, :CreateDate, :CreateUser, :UpdateUser, :UpdateDate, :NameExtension, :EffectiveDate, :ExpirationDate, :IsActive, :IsPrimary, :AnniversaryDate, :PreferredName, :NoteText)
Operations and processes¶
Note: Statements marked with
**could not be confirmed; treat as unknown until verified.
Sources¶
Business\SAIF.Business.CustomerContact\Contact\clsContact.vb