IDENTITY_ATTRIBUTES (Non-partitioned)

The IDENTITY_ATTRIBUTES table contains information about a person’s identity. Data is stored in this table when any of these actions occur:

• Identity events created in SAS Customer Intelligence 360 are triggered, and the events contain a customer_id or login_id. This includes identity events sent through the JavaScript API and the mobile SDK. For more information, see Managing User Identities in SAS Customer Intelligence 360: Administration Guide.
• External events are sent to SAS Customer Intelligence 360 using either the external API gateway or the on-premises API gateway. The events must contain a subject_id, login_id, or customer_id. For more information, see About Injecting Content and Events in SAS Customer Intelligence 360: Administration Guide and Injecting an External Event into SAS Customer Intelligence 360 in SAS Customer Intelligence 360: Administration Guide.
• Customer data is imported into SAS Customer Intelligence 360. For more information, see Importing and Exporting Identity Data in SAS Customer Intelligence 360: Administration Guide.

The categories for this table are DESTINATIONS, DISCOVER, ENGAGEDIGITAL, ENGAGEEMAIL, ENGAGEDIRECT, ENGAGEWEB, and ENGAGEMOBILE. For more information, see Categories for Data Tables in SAS Customer Intelligence 360: Administration Guide.

IDENTITY_ATTRIBUTES

Column Name	Data Type	Description	Schema First Introduced
identifier_type_id	VARCHAR(36)	Type of identity, which is usually linked with the source of the identity. These are the possible values: customer_id login_id subject_id	1
user_identifier_val	VARCHAR(5000)	Identifier value, commonly referred to as the channel user ID. The value of this column is immutable.	1
identity_id	VARCHAR(36)	Alphanumeric number that represents a customer	1
entrytime	TIMESTAMP	UTC datetimestamp mapped or merged in the SAS Customer Intelligence 360 identity service.	1
processed_dttm	TIMESTAMP	Internal UTC datetimestamp of when the record was loaded.	1