14
The User Dimension
The User dimension tracks the authenticated users of a site. Users may be authenticated either through the authentication mechanisms provided by the Web server or through an application-specific authentication method.
This chapter contains the following topics:
User Dimension Hierarchies
The User dimension contains the following hierarchies:
The sections that follow list all levels in each hierarchy, followed by a diagram that provides a graphical representation of the hierarchy.
The User Age Gender Hierarchy
This hierarchy contains the following levels, listed from top to bottom. For details about the attributes of each level, see User Dimension Levels.
Figure 14-1 The User Age Gender Level Hierarchy
Text description of the illustration user-age.gif
The User Company Hierarchy
This hierarchy contains the following levels, listed from top to bottom. For details about the attributes of each level, see User Dimension Levels.
Figure 14-2 The User Company Level Hierarchy
Text description of the illustration user-com.gif
The User Geography Hierarchy
This hierarchy contains the following levels, listed from top to bottom. For details about the attributes of each level, see User Dimension Levels.
- Region
- Country
- State
- User
Figure 14-3 The User Geography Level Hierarchy
Text description of the illustration user-geo.gif
User Dimension Levels
The User dimension is comprised of the following levels. For each level, information about each attribute (column name) is provided in the following format:
- Attribute: Description (example value)
In addition to the pre-defined attributes, the levels contains five "generic" attributes that can be defined by the user.
CLK_L_AGE_GROUP
- Age_Group_Code: Identifying code of the age group to which the user belongs; natural key. (20-29, 30-39, ...)
- Age_Group_Name: Name of the age group to which the user belongs. (Ages 20 to 29, Ages 30 to 39, ...)
- Age_Group_Attributes 1-5: Age group level user-defined attributes.
CLK_L_GENDER
- Gender_Code: Identifying code of the gender and age group of the user; natural key. (F30-39, M30-39)
- Gender_Name: Name of the gender and age group of the user. (Female aged 30 to 39, Male aged 30 to 39, ...)
- Gender_Attributes 1-5: Gender level user-defined attributes.
CLK_L_INDUSTRY
- Industry_Code: Identifying code of the industry sector in which the user works; natural key. (User-defined)
- Industry_Name: Name of the industry sector in which the user works. (User-defined)
- Industry_Attributes 1-5: Industry level user-defined attributes.
CLK_L_COMPANY
- Company_Code: Identifying code of the company for which the user works; natural key. (ORCL)
- Company_Name: Name of the company for which the user works. (Oracle Corp.)
- Company_Type: Type of company for which the user works. (User-defined)
- Company_Attributes 1-5: Company level user-defined attributes.
CLK_L_REGION
- Region_Code: Identifying code of the world region; natural key. (EUROPE, MIDDLE_EAST, PACIFIC_ISLANDS)
- Region_Name: Name of the world region in which a country is located. (Europe, Middle East, Pacific Islands)
- Region_Attributes 1-5: Region level user-defined attributes.
CLK_L_COUNTRY
- Country_Code: Two-letter ISO code of the country. (us, au, ch)
- Country_Name: Name of the country. (United States, Australia, China)
- Country_Attributes 1-5: Country level user-defined attributes.
CLK_L_STATE
- State_Code: Identifying code of the state; natural key. (NJ, AK)
- State_Name: Name of the state (or province). (New Jersey, Alaska)
- State_Attributes 1-5: State level user-defined attributes.
CLK_L_USER
- User_Auth_Group: The group (or realm) in which this user's authentication name is unique; natural key. (User-defined)
- User_Auth_Name: Unique user name for authentication purposes; natural key. (dianes, jazure, csws350)
- User_Customer_Code: User-defined external system customer key. (User-defined)
- User_EDW_Customer_Key: Enterprise Data Warehouse (EDW) trading partner key. (0, 1, 2, 3...)
- User_Type: The type of user; category into which the user is classified. (User-defined)
- User_Whole_Name: User's full name or pseudonym. (Camille W. Adams)
- User_First_Name: First name of the user. (Camille)
- User_Middle_Name: Middle name of the user. (W or Wayne)
- User_Last_Name: Last name of the user. . (Adams)
- User_Marital_Status: Marital status of the user. (Married, Single...)
- User_Job_Role: Status code returned from the Web server; natural key. (User-defined)
- User_City: City of the postal address (Costa Mesa)
- User_Postal_Code: Zip code of the postal address. (92626)
- User_Primary_Phone: Primary phone number of the user, including extension. (605-555-5555 5212)
- User_Home_Phone: Home phone number of the user, including extension. (605-555-5555 5212)
- User_Mobile_Phone: Mobile or cell phone number of the user, including extension. (605-555-5555 5212)
- User_Work_Phone: Work phone number of the user, including extension. (605-555-5555 5212)
- User_Email_Address: The user's email address. (dianes@oracle.com)
- User_Website_URL: The URL of the user's Web site (http://www.domain.com/~user)
- User_Subscription_Level: Level of service to which the user is subscribed. (free, OPP_Software, premium)
- User_Reg_Date: Date the user registered in Coordinated Universal Time (UTC) excluding any hour, minute, or second components (26-JAN-2002)
- User_Reg_Method: Method by which the user registered. (Web form, email, mail...)
- User_Attributes 1-5: User level user-defined attributes