Bookshelf v7.8: Field Names for Marketing Integration Components

Table 28 contains a list of Marketing integration objects, their components, and field names.

Table 28. Field Names for Marketing Integration Components
Parent Integration Object	Parent Integration Component	Name	Data Type	Length
Analytics Account	Account	Attribute 66	DTYPE_TEXT	100
		Attribute 67	DTYPE_TEXT	100
		Attribute 68	DTYPE_TEXT	100
		Attribute 69	DTYPE_TEXT	100
		Attribute 70	DTYPE_TEXT	100
		Attribute 71	DTYPE_TEXT	100
		Attribute 72	DTYPE_TEXT	100
		Attribute 73	DTYPE_NUMBER
		Attribute 74	DTYPE_NUMBER
		Attribute 75	DTYPE_NUMBER
		Attribute 76	DTYPE_NUMBER
		Attribute 77	DTYPE_NUMBER
		Attribute 78	DTYPE_NUMBER
		Attribute 79	DTYPE_NUMBER
		Attribute 80	DTYPE_NUMBER
Analytics Account (continued)	Account (continued)	Attribute 81	DTYPE_NUMBER
		Id	DTYPE_ID	30
		Integration Id	DTYPE_TEXT	30
		Location	DTYPE_TEXT	50
		Name	DTYPE_TEXT	100
Analytics Contact	Contact	Attribute 49	DTYPE_TEXT	100
		Attribute 50	DTYPE_TEXT	100
		Attribute 51	DTYPE_TEXT	100
		Attribute 52	DTYPE_TEXT	100
		Attribute 53	DTYPE_TEXT	100
		Attribute 54	DTYPE_TEXT	100
		Attribute 55	DTYPE_TEXT	100
		Attribute 56	DTYPE_NUMBER
		Attribute 57	DTYPE_NUMBER
		Attribute 58	DTYPE_NUMBER
		Attribute 59	DTYPE_NUMBER
		Attribute 60	DTYPE_NUMBER
		Attribute 61	DTYPE_NUMBER
		Attribute 62	DTYPE_NUMBER
		Attribute 63	DTYPE_NUMBER
		Attribute 64	DTYPE_NUMBER
		First Name	DTYPE_TEXT	50
		Id	DTYPE_ID	30
		Integration Id	DTYPE_TEXT	30
		Last Name	DTYPE_TEXT	50
		Person UId	DTYPE_TEXT	100
Analytics Household	Household	Attribute 48	DTYPE_TEXT	100
		Attribute 49	DTYPE_TEXT	100
		Attribute 50	DTYPE_TEXT	100
		Attribute 51	DTYPE_TEXT	100
		Attribute 52	DTYPE_TEXT	100
		Attribute 53	DTYPE_TEXT	100
		Attribute 54	DTYPE_TEXT	100
		Attribute 55	DTYPE_NUMBER
		Attribute 56	DTYPE_NUMBER
		Attribute 57	DTYPE_NUMBER
		Attribute 58	DTYPE_NUMBER
		Attribute 59	DTYPE_NUMBER
		Attribute 60	DTYPE_NUMBER
		Attribute 61	DTYPE_NUMBER
		Attribute 62	DTYPE_NUMBER
		Attribute 63	DTYPE_NUMBER
		Household Name	DTYPE_TEXT	50
		Household Number	DTYPE_TEXT	100
		Id	DTYPE_ID	30
		Integration Id	DTYPE_TEXT	30
Marketing Contact	Account	Account Location	DTYPE_TEXT	50
		Account Name	DTYPE_TEXT	100
		Home Page	DTYPE_TEXT	100
		Id	DTYPE_TEXT	30
		Integration Id	DTYPE_TEXT	30
		Main Fax Number	DTYPE_TEXT
		Main Phone Number	DTYPE_TEXT
		Region	DTYPE_TEXT	25
Marketing Contact (continued)	Account Address	Address Name	DTYPE_TEXT	100
		City	DTYPE_TEXT	50
		Country	DTYPE_TEXT	50
		Id	DTYPE_TEXT	30
		Integration Id	DTYPE_TEXT	30
		Postal Code	DTYPE_TEXT	30
		State	DTYPE_TEXT	10
		Street Address	DTYPE_TEXT	200
		Street Address 2	DTYPE_TEXT	100
	Account Organization	Organization	DTYPE_TEXT	50
	Campaign Contact	Campaign Id	DTYPE_ID
		Completion Date	DTYPE_TEXT
		Distribution Id	DTYPE_ID
		Key 1	DTYPE_TEXT	30
		Key 2	DTYPE_TEXT	30
		Key 3	DTYPE_TEXT	30
		Key 4	DTYPE_TEXT	30
		Key 5	DTYPE_TEXT	30
		Key 6	DTYPE_TEXT	30
		Key 7	DTYPE_TEXT	30
		Load Number	DTYPE_NUMBER
		Load Wave Id	DTYPE_ID
		Scalability Batch Number	DTYPE_NUMBER
		Segment Id	DTYPE_ID
		Source Code	DTYPE_TEXT	75
		Token Number	DTYPE_NUMBER
Marketing Contact (continued)	Contact	Cellular Phone #	DTYPE_TEXT
		Email Address	DTYPE_TEXT	50
		Fax Phone #	DTYPE_TEXT
		First Name	DTYPE_TEXT	50
		Gender	DTYPE_TEXT	30
		Home Phone #	DTYPE_TEXT
		Id	DTYPE_ID	30
		Integration Id	DTYPE_TEXT	30
		Job Title	DTYPE_TEXT	75
		Last Name	DTYPE_TEXT	50
		Middle Name	DTYPE_TEXT	50
		Person UId	DTYPE_TEXT	100
		Preferred Communications	DTYPE_TEXT	30
		Salutation	DTYPE_TEXT	15
		Status	DTYPE_TEXT	30
		Work Phone #	DTYPE_TEXT
	Contact Address	Id	DTYPE_TEXT	30
		Integration Id	DTYPE_TEXT	30
		Personal Address Name	DTYPE_TEXT	100
		Personal City	DTYPE_TEXT	50
		Personal Country	DTYPE_TEXT	50
		Personal Postal Code	DTYPE_TEXT	30
		Personal State	DTYPE_TEXT	10
		Personal Street Address	DTYPE_TEXT	200
		Personal Street Address 2	DTYPE_TEXT	100
	Contact Organization	Organization	DTYPE_TEXT	50
Marketing Contact (continued)	Household	Fax Number	DTYPE_TEXT
		Household Name	DTYPE_TEXT	50
		Household Number	DTYPE_TEXT	100
		Household Size	DTYPE_NUMBER
		Household Wealth	DTYPE_TEXT
		Id	DTYPE_ID	30
		Income	DTYPE_TEXT
		Integration Id	DTYPE_TEXT	30
		Phone Number	DTYPE_TEXT
		Revenue	DTYPE_TEXT
	Household Organization	Organization	DTYPE_TEXT	50
Marketing Person	Campaign Contact	Account Id	DTYPE_ID
		Campaign Id	DTYPE_ID
		Completion Date	DTYPE_TEXT
		Contact Id	DTYPE_ID
		Distribution Id	DTYPE_ID
		Household Id	DTYPE_ID
		Key 1	DTYPE_TEXT	30
		Key 2	DTYPE_TEXT	30
		Key 3	DTYPE_TEXT	30
		Key 4	DTYPE_TEXT	30
		Key 5	DTYPE_TEXT	30
		Key 6	DTYPE_TEXT	30
		Key 7	DTYPE_TEXT	30
		Load Number	DTYPE_NUMBER
		Load Wave Id	DTYPE_ID
		Prospect Id	DTYPE_ID
		Scalability Batch Number	DTYPE_NUMBER
		Segment Id	DTYPE_ID
		Source Code	DTYPE_TEXT	75
		Token Number	DTYPE_NUMBER
Marketing Prospect	Campaign Contact	Call Completed	DTYPE_TEXT
		Campaign Id	DTYPE_ID
		Completion Date	DTYPE_TEXT
		Distribution Id	DTYPE_ID
		Key 1	DTYPE_TEXT	30
		Key 2	DTYPE_TEXT	30
		Key 3	DTYPE_TEXT	30
		Key 4	DTYPE_TEXT	30
		Key 5	DTYPE_TEXT	30
		Key 6	DTYPE_TEXT	30
		Key 7	DTYPE_TEXT	30
		Load Number	DTYPE_NUMBER
		Load Wave Id	DTYPE_ID
		Prospect Id	DTYPE_ID
		Scalability Batch Number	DTYPE_NUMBER
		Segment Id	DTYPE_ID
		Token Number	DTYPE_NUMBER
	Prospect	Account	DTYPE_TEXT
		Account Id	DTYPE_ID
		Alias	DTYPE_TEXT
		Alternate Phone #	DTYPE_TEXT
		Annual Revenue	DTYPE_NUMBER
		Assistant	DTYPE_TEXT
		Assistant Phone #	DTYPE_TEXT
		Birth Date	DTYPE_DATETIME
		Cellular Phone #	DTYPE_TEXT
		City	DTYPE_TEXT
		Comment	DTYPE_TEXT
		Country	DTYPE_TEXT
Marketing Prospect (continued)	Prospect (continued)	County	DTYPE_TEXT
		Disable DataCleansing	DTYPE_TEXT
		DUNS Number	DTYPE_ID
		Email Address	DTYPE_TEXT
		Employee At Site	DTYPE_NUMBER
		Employee Total	DTYPE_NUMBER
		Expiration Date	DTYPE_TEXT
		Fax Phone #	DTYPE_TEXT
		First Name	DTYPE_TEXT
		Gender	DTYPE_TEXT	30
		Hide DUNS Number Flag	DTYPE_TEXT
		Home Page	DTYPE_TEXT	100
		Home Phone #	DTYPE_TEXT
		Id	DTYPE_ID	30
		Job Title	DTYPE_TEXT
		Last Name	DTYPE_TEXT
		Line of Business	DTYPE_TEXT	50
		Maiden Name	DTYPE_TEXT
		Manager Name	DTYPE_TEXT
		Marital Status Code	DTYPE_TEXT
		Middle Name	DTYPE_TEXT
		Nationality	DTYPE_TEXT
		Postal Code	DTYPE_TEXT
		Preferred Communications	DTYPE_TEXT	30
		Preferred Language Name	DTYPE_TEXT
		Primary Account Location	DTYPE_TEXT
		Primary SIC Code	DTYPE_TEXT	30
Marketing Prospect (continued)	Prospect (continued)	Primary SIC Id	DTYPE_ID
		Product Interest	DTYPE_TEXT	100
		Prospective Contact UId	DTYPE_TEXT	100
		Province	DTYPE_TEXT
		Public	DTYPE_TEXT	1
		Race	DTYPE_TEXT
		Salutation	DTYPE_TEXT
		Social Security Number	DTYPE_TEXT
		Source Name	DTYPE_TEXT	100
		State	DTYPE_TEXT
		Street Address	DTYPE_TEXT
		Street Address 2	DTYPE_TEXT
		Suppress Call Flag	DTYPE_TEXT
		Suppress Email Flag	DTYPE_TEXT
		Suppress Fax Flag	DTYPE_TEXT
		Suppress Mail Flag	DTYPE_TEXT
		Time Zone	DTYPE_TEXT
		Work Phone #	DTYPE_TEXT
		Year Started	DTYPE_NUMBER

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