SSIS Components for Oracle Eloqua

Build 24.0.9060

ContactSegmentData

Retrieve Contact Segment Data. Note: The pseudo column SegmentID must be specified to retrieve the data of this table. This SegmentID can be retrieved from the ContactSegment table's ID column.

Columns

Name Type Description
ID [KEY] Int64 The unique identifier of the content segment data.
AccountName String This field is generated dynamically and corresponds to the AccountName field in the API.
BouncebackDate String This field is generated dynamically and corresponds to the BouncebackDate field in the API.
IsBounceback Boolean This field is generated dynamically and corresponds to the IsBounceback field in the API.
IsSubscribed Boolean This field is generated dynamically and corresponds to the IsSubscribed field in the API.
SubscriptionDate Datetime This field is generated dynamically and corresponds to the SubscriptionDate field in the API.
UnsubscriptionDate Datetime This field is generated dynamically and corresponds to the UnsubscriptionDate field in the API.
CreatedAt Datetime This field is generated dynamically and corresponds to the CreatedAt field in the API.
CreatedBy String This field is generated dynamically and corresponds to the CreatedBy field in the API.
AccessedAt Datetime This field is generated dynamically and corresponds to the AccessedAt field in the API.
CurrentStatus String This field is generated dynamically and corresponds to the CurrentStatus field in the API.
Depth String This field is generated dynamically and corresponds to the Depth field in the API.
UpdatedAt Datetime This field is generated dynamically and corresponds to the UpdatedAt field in the API.
UpdatedBy String This field is generated dynamically and corresponds to the UpdatedBy field in the API.
Email Address String This field is generated dynamically and corresponds to the Email Address field in the API.
First Name String This field is generated dynamically and corresponds to the First Name field in the API.
Last Name String This field is generated dynamically and corresponds to the Last Name field in the API.
Company String This field is generated dynamically and corresponds to the Company field in the API.
Email Display Name String This field is generated dynamically and corresponds to the Email Display Name field in the API.
Address 1 String This field is generated dynamically and corresponds to the Address 1 field in the API.
Address 2 String This field is generated dynamically and corresponds to the Address 2 field in the API.
Address 3 String This field is generated dynamically and corresponds to the Address 3 field in the API.
City String This field is generated dynamically and corresponds to the City field in the API.
State or Province String This field is generated dynamically and corresponds to the State or Province field in the API.
Zip or Postal Code String This field is generated dynamically and corresponds to the Zip or Postal Code field in the API.
Country String This field is generated dynamically and corresponds to the Country field in the API.
Business Phone String This field is generated dynamically and corresponds to the Business Phone field in the API.
Mobile Phone String This field is generated dynamically and corresponds to the Mobile Phone field in the API.
Fax String This field is generated dynamically and corresponds to the Fax field in the API.
Title String This field is generated dynamically and corresponds to the Title field in the API.
Salutation String This field is generated dynamically and corresponds to the Salutation field in the API.
Salesperson String This field is generated dynamically and corresponds to the Salesperson field in the API.
SFDC Contact ID String This field is generated dynamically and corresponds to the SFDC Contact ID field in the API.
SFDC Lead ID String This field is generated dynamically and corresponds to the SFDC Lead ID field in the API.
Date Created Datetime This field is generated dynamically and corresponds to the Date Created field in the API.
Date Modified Datetime This field is generated dynamically and corresponds to the Date Modified field in the API.
Eloqua Contact ID String This field is generated dynamically and corresponds to the Eloqua Contact ID field in the API.
SFDC Account ID String This field is generated dynamically and corresponds to the SFDC Account ID field in the API.
Last Modified by CRM System Datetime This field is generated dynamically and corresponds to the Last Modified by CRM System field in the API.
Last SFDC Campaign ID String This field is generated dynamically and corresponds to the Last SFDC Campaign ID field in the API.
Last SFDC Campaign Status String This field is generated dynamically and corresponds to the Last SFDC Campaign Status field in the API.
Company Revenue String This field is generated dynamically and corresponds to the Company Revenue field in the API.
SFDC Email Opt Out String This field is generated dynamically and corresponds to the SFDC Email Opt Out field in the API.
Lead Source - Most Recent String This field is generated dynamically and corresponds to the Lead Source - Most Recent field in the API.
Lead Source - Original String This field is generated dynamically and corresponds to the Lead Source - Original field in the API.
Industry String This field is generated dynamically and corresponds to the Industry field in the API.
Annual Revenue String This field is generated dynamically and corresponds to the Annual Revenue field in the API.
Lead Status String This field is generated dynamically and corresponds to the Lead Status field in the API.
Job Role String This field is generated dynamically and corresponds to the Job Role field in the API.
Lead Score - High Value Website Content Double This field is generated dynamically and corresponds to the Lead Score - High Value Website Content field in the API.
Lead Score Date - Engagement - Most Recent Datetime This field is generated dynamically and corresponds to the Lead Score Date - Engagement - Most Recent field in the API.
Integrated Marketing and Sales Funnel Stage String This field is generated dynamically and corresponds to the Integrated Marketing and Sales Funnel Stage field in the API.
Product/Solution of Interest String This field is generated dynamically and corresponds to the Product/Solution of Interest field in the API.
Region String This field is generated dynamically and corresponds to the Region field in the API.
PURL Name (Default Hypersite) String This field is generated dynamically and corresponds to the PURL Name (Default Hypersite) field in the API.
Lead Rating - Combined String This field is generated dynamically and corresponds to the Lead Rating - Combined field in the API.
Email Address Domain String This field is generated dynamically and corresponds to the Email Address Domain field in the API.
First and Last Name String This field is generated dynamically and corresponds to the First and Last Name field in the API.
Company Size String This field is generated dynamically and corresponds to the Company Size field in the API.
Lead Score - Last High Touch Event Date Datetime This field is generated dynamically and corresponds to the Lead Score - Last High Touch Event Date field in the API.
Lead Rating - Profile (Explicit) String This field is generated dynamically and corresponds to the Lead Rating - Profile (Explicit) field in the API.
Lead Rating - Engagement (Implicit) String This field is generated dynamically and corresponds to the Lead Rating - Engagement (Implicit) field in the API.
Lead Score - Profile (Explicit) Double This field is generated dynamically and corresponds to the Lead Score - Profile (Explicit) field in the API.
Lead Score - Engagement (Implicit) Double This field is generated dynamically and corresponds to the Lead Score - Engagement (Implicit) field in the API.
Lead Score Date - Profile - Most Recent Datetime This field is generated dynamically and corresponds to the Lead Score Date - Profile - Most Recent field in the API.
Employees Double This field is generated dynamically and corresponds to the Employees field in the API.
Territory String This field is generated dynamically and corresponds to the Territory field in the API.
Lead Score String This field is generated dynamically and corresponds to the Lead Score field in the API.
PURL Name String This field is generated dynamically and corresponds to the PURL Name field in the API.
MD5 Hashed Email Address String This field is generated dynamically and corresponds to the MD5 Hashed Email Address field in the API.
SHA256 Hashed Email Address String This field is generated dynamically and corresponds to the SHA256 Hashed Email Address field in the API.
MD5 Hashed Business Phone String This field is generated dynamically and corresponds to the MD5 Hashed Business Phone field in the API.
SHA256 Hashed Business Phone String This field is generated dynamically and corresponds to the SHA256 Hashed Business Phone field in the API.
MD5 Hashed Mobile Phone String This field is generated dynamically and corresponds to the MD5 Hashed Mobile Phone field in the API.
SHA256 Hashed Mobile Phone String This field is generated dynamically and corresponds to the SHA256 Hashed Mobile Phone field in the API.
onlineInsertTest String This field is generated dynamically and corresponds to the onlineInsertTest field in the API.
Survey Initial Meeting Date & Time Datetime This field is generated dynamically and corresponds to the Survey Initial Meeting Date & Time field in the API.
TestColumn1 String This field is generated dynamically and corresponds to the TestColumn1 field in the API.
TestColumn2 String This field is generated dynamically and corresponds to the TestColumn2 field in the API.
TestColumn3 String This field is generated dynamically and corresponds to the TestColumn3 field in the API.
TestColumn4 String This field is generated dynamically and corresponds to the TestColumn4 field in the API.
TestColumn5 String This field is generated dynamically and corresponds to the TestColumn5 field in the API.

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