Footprints Data Model

Table
Table Name User Profile
Table Definition A container for Permissions and Settings (the composite parts are the associated Role and the User Preferences). The permissions for a User to access a particular container according to the capabilities defined. In most cases this will be more defined in a subcategory. Example: Shared User Profile This profile will be shared between multiple users that access the system with the same User ID.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
User Profile Id The automatically generated primary key of the user_prof table. LONG Yes
User Profile Name The name of the User Profile. VARCHAR(255) No
Role Group Id A Foreign Key to the Role Group table. A system level user profile can have a role group, which will have the effect of assigning a collection of workspace, cmdb, and address book roles at the container role level. LONG No
Definition Id A Foreign Key to the Definition table. Optionally, the container that owns the profile. LONG Yes
Application Role Id A Foreign Key to the Application Role table. The User Profile is the means for setting the default role at the system and workspace levels, and is also the role of a Unique User Profile tied to a application user. LONG No
Is Built In Indicates that this instance of User Profile is a built-in instance that cannot be changed by the end user. BOOLEAN No
Template User Profile Id A Foreign Key to the User Profile table. This will not be a navigable key in the object model. This indicates which Template User Profile was used to create a built-in template in case some features concerning new properties added to later release of the system will need to be added to existing templates. LONG No
User Type Id A Foreign Key to the User Type table. INTEGER No
tmpl_level_name The value of a Built_in_level, stored as a string. VARCHAR(255) No
Customer Authentication Type Id A Foreign Key to the Customer Authentication Type table. INTEGER No
Agent Authentication Type Id A Foreign Key to the Agent Authentication Type table. INTEGER No
Is System Indicates if this is a system level profile. BOOLEAN Yes
Definition Subtype Id A Foreign Key to the Definition Subtype table. INTEGER No
Delete Date The value of a User Profile, stored as a date. DATE No
Last Login date time of last login in UTC. DATE No