SSIS Components for Oracle Eloqua

Build 24.0.8963

ContactField

Retrieve Contact Fields.

Table Specific Information

The EmailAddress column is required to INSERT INTO or to update the Contact table. For example,

UPDATE [Contact] SET emailAddress = '[email protected]', firstName = 'test' WHERE ID = ?

Columns

Name Type Description
ID [KEY] Long The unique identifier for the contact field.
Name String The name of the contact field.
UpdateType String The update rule for when to update this field.
CheckedValue String The checked value of the contact field.
DataType String The data type of the contact field.
DefaultValue String The default value for the contact field.
Description String The description of the contact field.
DisplayType String The display type of the contact field.
FolderId Long The folder Id of the contact field.
InternalName String The country of the contact field.
IsReadOnly Boolean Identifies whether the contact field is read-only.
IsRequired Boolean Identifies whether the contact field is required.
IsStandard Boolean Identifies whether the contact field is standard.
OptionListId Long The Id of the option list for the contact field.
OutputFormatId Long The Id of the output format for the contact field.
ScheduledFor String The date and time scheduled for the contact field.
SourceTemplatedId Long The Id of the source template for the contact field
UncheckedValue String The unchecked value of the contact field.
Permissions String The permissions of the contact field.
CreatedAt Datetime Date the contact field was created.
CreatedBy String The Id of the user who created the contact field.
AccessedAt Datetime Date the contact field was accessed.
CurrentStatus String The current status of the contact field.
Depth String The depth of the contact field.
UpdatedAt Datetime Date the contact field was updated.
UpdatedBy String The Id of the user who last updated the contact field.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963