Table 38. Fields for Output File Layout Components
Field
|
Comment
|
Alignment
|
Select the alignment for the Output File Layouts field. The options are Left and Right. For example, you might want the name and address of the contact to be aligned at left and a code to appear at right.
|
Database Field
|
If the Type is field, click the Field select button. In the Pick Fields dialog box, select a database field and click OK.
|
Field Format
|
(Optional) The default is the native format for the stored data.
Choose a format value (mask) to assign to a field. Options are MM/DD/YY and YYYYMMDD, (999) 999-9999 (phone number), 999-99-9999 (SSN), AAAAA (ZIP), AAAAA-AAAA (ZIP+4).
Your administrator should set up this list of values to conform to your business and regional needs.
|
Measure Name
|
If the Type is a measure, click the Measure select button. In the Pick Measures dialog box, select a measure and click OK.
|
Number of Values
|
Type a number that controls the number of values that appear in the list for this field. The maximum number of values is 50000.
For example, if vehicle name (Veh_Name) is the field value, and you are only interested in the first two vehicles per household, you would add 2 values here. When the list is distributed, two fields are created to hold this information.
Another example is if a consumer has two addresses associated with his or her account. If the value of the Address field format is 1, only the primary address associated with the consumer appears on the list.
|
Seed List Column
|
Choose the seed list column name that closely matches the Database Field or Measure. For example, the field entry might be customer.first name and the seed list column name, FRST_NAME.
If you copy a list format without seeds and then attach a seed list to the format, make sure you complete this field in the copied list format.
|
Seed List Default
|
If there is no close match for the seed column name, type a series of numerals as a default.
If you copy an output file layout without seeds and then attach a seed list to the layout, make sure you complete this field in the copied list format.
|
Sequence
|
This field is automatically populated as you add output file layout components.
- To change the sequence after saving a component, select the component and click Move Up or Move Down.
- If you delete a component, reorder the remaining components by clicking the menu button and choosing Resequence.
|
Type
|
Choose the component type. Options are Measure, Source Code, and Field.
|
Width
|
A default value is automatically added. The default output when generating a list is ASCII. ASCII format has a maximum record width of 4K.
When you send list files to vendors you can indicate that you want to use fixed-width output instead of ASCII. To use a fixed-width output, you can specify EBCDIC as the form in the Campaign Waves view (Campaigns screen, Waves view tab, List Distribution list).
To change the Width value, click the calculator button and type a numerical value not to exceed 2,000, for fixed-width output.
|