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.

SSIS Components for Oracle Eloqua

ContactField

Table Specific Information

Columns