Entity Definition

Logical Name : SocialNetworkHandle
Physical Name : PA_SCL_NTWRK_HNDL

Identifies a user ID that is associated with a party for a particular social network provider like Tweet, Facebook, LinkedIn, MySpace, etc. Allows parties to known to a retailer to be associated with postings, comments, tweets, likes, dislike, etc. posted on to social networks.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
SocialNetworkUserID (PK) The token ID for a social network user. This is an internal "dumb" unique ID not the user ID appearing in a social network See UserProfileID. ID_SCL_NTWRK_HNDL Identity integer
UserProfileID (AK) The name or handle used by the Party when signing into the InternetBasedService ID_SCL_NTWRK_USR DescriptionShort varchar(255)
SocialNetworkID (AK)(FK) Token ID of the InternetBasedService (i.e. Social Network, Blog, etc.) ID_SCL_NTWRK Identity integer SocialNetworkService(PA_SCL_NTWRK)


Parent Entity Verb Phrase Child Entity
SocialNetworkService is accessed as SocialNetworkHandle
SocialNetworkHandle is name used for SiteContactMethod
SocialNetworkHandle is a PartyContactMethod

Logical Views containing SocialNetworkHandle

Logical View
Logical 02341 - Retail Transaction - Change for Charities View
Logical 06310 - Party - Role View
Logical 06320 - Party - Address and Contact View
Logical 07010 - Customer Account Information Extended
Logical 07019 - Party-Consumer-Customer Household View
Logical 07030 - Customer Segment Independent Characteristics