Siebel Marketing Installation and Administration Guide > Creating Source Code and Vendor Profiles >

Creating Source Code Formats

The Source Code Formats view defines a source code format, specifies the individual components that are included, and determines how these components are arranged or sequenced.

After creating a source code format, you can use the source code in the following ways:

  • Include in an export list.
  • Embed as a personalization element in an email offer.
  • As input in the customer-facing Web Marketing home page (in the applet named Do you have another offer?).
  • As a direct input to a response from any of the Response views.

The Source Code Formats list shows available source code formats. The All Components list displays details of the source code format selected in the list and is used to create the structure of the source code grouping, or format. The All Components list contains the computed length of each source code (maximum of 75 characters).

By clicking Move Up or Move Down, you can rearrange components in the format. If you delete components (for example, component 2 and component 4 of 5), click the menu button and choose Resequence to reorder the remaining components before saving the record.

To create source code formats

  1. Navigate to Administration - Marketing screen > Source Code Formats.
  2. In the Source Code Formats list, create a new record.
  3. Enter a name and a description for the Source Code Format.
  4. When you save the source code format, the new format appears in the Source Code Formats list.

To define source code format components

  1. Navigate to Administration - Marketing screen > Source Code Formats.
  2. In the Source Code Formats list, select a source code format.
  3. In the All Components list, create a new record.
  4. Complete the fields for the component, using the following information as a guide.


    Shows the available fields from the business component. For a list of available business components, see the Type row in this table.

    Constant Value

    Specifies an optional constant value to be inserted in the source code. This is editable only when the Type field is set to Constant.

    Default Value

    Inserted when the input value is NULL. You can provide a default value for any source code component. For example, if you included Campaign Member Country, you could insert a value for any members with no Country in their profile.


    Sequence determines the position of the code component in the source code format. Sequence is automatically set when source code components are added to the format. Use Move Up, Move Down or Resequence to adjust the order.


    The Type field shows the business component used as the source of the field. The supported components are Campaign, Campaign Member, Offer, Program, Segment, Stage, and Wave. When you select one of these types, you must also select the Attribute.

    The Type field also supports inserting a Constant, Numeric Sequence, or Alphanumeric Sequence. You can not use both a Numeric Sequence and an Alphanumeric Sequence in the same source code.

    • Constant. A fixed value that is the same for all campaign members. You can have more than one constant in the source code format. For example, you can use a constant to insert a spacing character such as a hyphen (-).
    • Numeric Sequence. Inserts a running count in the source code for each campaign member in a campaign wave. The value uses a standard integer sequence of 1,2,3...9,10,11....N.
    • Alphanumeric Sequence. Similar to Numeric Sequence, except that the values include integers and letters of the alphabet. For example, 1,2,3....9,A,B,C....,X,Y,Z,10,11, and so on.

    The source code generator adds a prefix of zeros (0) to the numeric sequence and alphanumeric sequence based on the width of the field. For example, if the width is 4, the values are 0001, 0002, 0003, and so on.


    The width of the source code component is automatically added. However, you can change the width. The maximum width for the entire source code format is 75 characters. The following is a list of examples:

    • If the source code width for a component is 16 characters and you specify 6 as the width in this field, the individual source code for the component is truncated to the first six characters.
    • If the component's code has a width of 10 characters, and you specify 20 as the width, 10 blank spaces appear in your source code format.
  5. Save the component.

    NOTE:  Repeat Step 3 through Step 5 to add more components, one row at a time.

  6. Adjust the sequence of the components by clicking Move Up and Move Down.

    To reorder deleted components before saving the changes, click the menu button and choose Resequence.

    Modifications in the Source Code Format are reflected the next time a program snapshot is built. For information about how to associate a source code with a stage, read Siebel Marketing User Guide.

Siebel Marketing Installation and Administration Guide Copyright © 2006, Oracle. All rights reserved.