Entity Definition

Logical Name : SiteContactMethod
Physical Name : CO_MTH_CNCT_STE

Associative entity denoting how a Site may be contacted for a particular purpose.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ContactPurposeTypeCode (FK)(PK) A retailer defined code denoting a reason for contacting a Party. CD_TYP_CNCT_PRPS Code2 char(2) ContactPurposeType(CO_TYP_CNCT_PRPS)
ContactMethodTypeCode (FK)(PK) A retailer assigned code denoting a method of contacting a Party. Suggested values include: WorkPhone, HomePhone, WorkFax, HomeFax, Mobile, Pager. CD_TYP_CNCT_MTH Code6 char(6) ContactMethodType(CO_TYP_CNCT_MTH)
BuildingID (PK) Building ID used where there may be more than one building or structure at a site. This is designed to handle multitenant sites like shopping centers, malls and other venues with more than one structure. ID_BLDNG IdentityGTIN integer
AddressID (FK) A unique system allocated identifier for the Address. ID_ADS Identity integer Address(LO_ADS)
EmailAddressID (FK) A unique system assigned identifier for an electronic address for sending messages. ID_EM_ADS Identity integer EmailAddress(LO_EML_ADS)
TelephoneID (FK) A unique system assigned identifier for this Telephone number ID_PH Identity integer Telephone(LO_PH)
WebSiteID (FK) Token ID for a WebSite entity instance. ID_WB_STE Identity integer WebSite(LO_WB_STE)
SocialNetworkUserID (FK) 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 SocialNetworkHandle(PA_SCL_NTWRK_HNDL)
SiteID (FK) Token ID for a Site ID_STE Identity integer Site(LO_STE)


Parent Entity Verb Phrase Child Entity
SocialNetworkHandle is name used for SiteContactMethod
WebSite is destination of SiteContactMethod
Address is used by SiteContactMethod
ContactMethodType categorizes SiteContactMethod
Telephone is used by SiteContactMethod
ContactPurposeType defines SiteContactMethod
Site is reached via SiteContactMethod
EmailAddress is used by SiteContactMethod

Logical Views containing SiteContactMethod

Logical View
Logical 02110 - Item Inventory - Location View
Logical 06320 - Party - Address and Contact View
Logical 10100 - Enterprise - Locations Macro View
Logical 10108 - Enterprise - Physical Locations View
Logical 10108 - Enterprise - Physical Locations View