Subject Area : 080 - User Profile |
# | Name | Definition | ER Diagram | Entity/Table | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | ||||||||||||||||||||||||||||||||||||||||||||||||||
. | 080 - User Profile | The user profile contains user preferences. This subject area shows the various types of profiles that are defined. | Details.. | Details.. |
# | Name | Physical Display Level | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | Logical | Column | ||||||||||||||||||||||||||||||||||||||||||||||||
. | Physical | Column |
# | Physical Name | Name | Logical Only | Do Not Generate | Definition | Attribute/Column | ||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 20 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | agent_authcn_type | Agent Authentication Type | false | An indicator to distinguish whether this profile is for an agent (including the workspace administartor) or a system administrator. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | agent_prof | Agent Profile | true | true | Agent profiles are different from the customer profiles by the choice of the preference and role that is chosen. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | anonymous_cust_prof | Anonymous Customer Profile | true | true | A type of workspace user profile that is used for the Anonymous Customer feature. Customers have read only access to the Knowledgebase and Solutions via the customer portal. This is required, but can be an empty profile specifying no anonymous access. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | app_role | Application Role | false | A User Security Role within Footprints. This includes Agent Users and Customer Users, and includes Role settings at the Instance and Container level. Workspace Role and CMDB Role may both be implemented as Container Role. The Role has associated Rights and Permissions, and is a way of granting Roles and Permissions to a User. There is some conceptual overlap between the User Profile and the Role. The User is assigned a single Role as part of the User Profile, and a User can only have one System Role and one Workspace Role. The User Profile can have property settings that override the Role Settings. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | app_user | Application User | false | A user authorized to use the FootPrints system. The user is either a Customer User or an Agent User. The application user holds the minimum information needed to identify the user and associate the user with a user profile, where user settings are stored. A contact is not necessarily an application user. An application user entry is required in order for the user to access any online functions. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | app_user_prof_link | Application User Profile Link | false | The link between the application user and the user profile. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | auto_add_cust_prof | Auto Add Customer Profile | true | true | A type of user profile that is used for the Auto Add Customer feature. An assignment of roles to workspaces that applies to a customer based on administrator assignment or criteria available from the Customer Authentication method (such as LDAP). | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | cust_authcn_type | Customer Authentication Type | false | false | An indicator to distinguish whether this profile is for a unique customer profile (including the specific customer profile) or if it requires a special authentication technique (i.e. Anonymous Customer Profile has read only access to the knowledge base without having to be authenticated). | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | cust_prof | Customer Profile | true | true | Customer profiles are different from the agent profiles by the choice of the preference and role that is chosen. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | defn | Definition | false | A definition holds the structural and behavioral information needed for an application element that is configuarable by the system designer and/or the end user at definition time. Current Footrpints uses a combination of directories, files, tables, and programming code to represent this information. The new FootPrints will provide all of the same information within the definition. The definition can be persisted in a structure that is isolated at the Instance Level. The data for the definition will be stored as Configuration Settings associated with the Definition Version. See the database views v_defn_ver_active, v_cntnr_item_field. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | defn_subtype | Definition Subtype | false | The subtype of the definition used as a discriminator for the class of definition. Each subtype will have different configuration settings and associated definitions. These include associated built-in field definitions for item subtypes. See the database view v_defn_subtype. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | defn_type | Definition Type | false | The scope of the Template chosen from Instance, Container Group, Container, Item, Field. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | role_grp | Role Group | false | (Not used, but referenced in Java code that must be removed before table deletion.) The role group will contain the roles that the user has for each of the workspaces that the user has access. The user will always have a role group even if the administrator chooses the Perl Footprints functionality. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | shared_cust_prof | Shared Customer Profile | true | true | A user profile that is shared among a group of many users. It is used for shared customer authentication. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | standard_agent_prof | Standard Agent Profile | true | true | Permissions for a User to access a workspace according to the capabilities defined in the role. Also, configuration settings for the User in that workspace. This is no more than a default built in profile with the name of "Workspace Administrator" which can be changed later by the System Administrator. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | sys_admin_prof | System Administration Profile | true | true | Permissions for a User to access the FootPrints system according to the capabilities defined in the role. Also, configuration settings for the User. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | unique_cust_prof | Unique Customer Profile | true | true | A user profile for a single unique user. This profile can be created by an administrator for agents and customers. It also can be created via auto-add for customers only. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | user_prof | User Profile | false |
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. |
Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | user_type | User Type | false | Indicates whether this entity is of an agent type or a customer type. Also CMDB and GUEST. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | wksp_admin_prof | Workspace Administration Profile | true | true | Permissions for a User to access a workspace according to the capabilities defined in the role. Also, configuration settings for the User in that workspace. This is no more than a default built in profile with the name of "Workspace Administrator" which can be changed later by the System Administrator. | Details.. |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | agent_authcn_type_name | Agent Authentication Type Name | The name of the Agent Authentication Type. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | agent_authcn_type_id | Agent Authentication Type Id | The automatically generated primary key of the agent_authcn_type table. | int |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | user_prof_id | User Profile Id | A Foreign Key to the User Profile table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | agent_authcn_type_id | Agent Authentication Type Id | A Foreign Key to the Agent Authentication Type table. | int |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | user_prof_id | User Profile Id | A Foreign Key to the User Profile table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 11 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | app_role_id | Application Role Id | The automatically generated primary key of the app_role table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | tmpl_app_role_id | Template Application Role Id | A Foreign Key to the Application Role table. This indicates which Template Role was used to create a built-in role in case some features concerning new properties added to later release of the system will need to be added to existing templates. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | app_role_name | Application Role Name | The name of the Application Role. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | admin_type_id | Administrator Type Id | A Foreign Key to the Administrator Type table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | is_built_in | Is Built In | Indicates that this instance of Application Role is a built-in instance that cannot be changed by the end user. | bit | ||||||||||||||||||||||||||||||||||||||||||||||
. | app_role_descr | Application Role Description | A descriptive name of the Application Role. This descriptive name may be localized. | varchar(1024) | ||||||||||||||||||||||||||||||||||||||||||||||
. | user_type_id | User Type Id | A Foreign Key to the User Type table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_subtype_id | Definition Subtype Id | A Foreign Key to the Definition Subtype table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | tmpl_app_role_id | Template Application Role Id | A Foreign Key to the Application Role table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | tmpl_level_name | tmpl_level_name | The value of a Built_in_level, stored as a string. | varchar(255) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 8 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | pwd | Password | This space intentionally left blank. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | user_name | User Name | The name of the Application User. | nvarchar(4000) | ||||||||||||||||||||||||||||||||||||||||||||||
. | cust_login_type_id | Customer Login Type Id | A Foreign Key to the Customer Login Type table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | app_user_id | Application User Id | The automatically generated primary key of the app_user table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | lic_type_id | License Type Id | A Foreign Key to the License Type table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | user_login | User Login | The login name used to access the Application. This may not be filled in if external application security is used. | nvarchar(4000) | ||||||||||||||||||||||||||||||||||||||||||||||
. | email_addr | Email Address | An email address for the Application User. | nvarchar(4000) | ||||||||||||||||||||||||||||||||||||||||||||||
. | delete_date | Delete Date | The value of a Application User, stored as a date. | datetime |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | user_prof_id | User Profile Id | A Foreign Key to the User Profile table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | app_user_prof_link_id | Application User Profile Link Id | The automatically generated primary key of the app_user_prof_link table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | app_user_id | Application User Id | A Foreign Key to the Application User table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | user_prof_id | User Profile Id | A Foreign Key to the User Profile table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | cust_authcn_type_id | Customer Authentication Type Id | The automatically generated primary key of the cust_authcn_type table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | cust_authcn_type_name | Customer Authentication Type Name | The name of the Customer Authentication Type. | varchar(255) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | user_prof_id | User Profile Id | A Foreign Key to the User Profile table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | cust_authcn_type_id | Customer Authentication Type Id | A Foreign Key to the Customer Authentication Type table. | int |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 7 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | The automatically generated primary key of the defn table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_name | Definition Name | The name of the Definition. | nvarchar(4000) | ||||||||||||||||||||||||||||||||||||||||||||||
. | dsble_date | Disabled Date | The date that this instance of Definition is logically deleted and disabled. | datetime | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_guid | Definition GUID | A Global Unique IDentifier search key for the Definition, composed of letters and numbers. It is computed by the client and typically used in unstructured data. | varchar(50) | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_type_name | Definition Type Name | The unique string identifier for an instance of Definition Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_subtype_id | Definition Subtype Id | A Foreign Key to the Definition Subtype table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | tmpl_export_guid | Template Export GUID | The value of a Definition, stored as a string. | VARCHAR(50) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 6 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_subtype_name | Definition Subtype Name | The name of the Definition Subtype. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_subtype_descr | Definition Subtype Description | A descriptive name of the Definition Subtype. This descriptive name may be localized. | varchar(512) | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_subtype_id | Definition Subtype Id | The automatically generated primary key of the defn_subtype table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_parent_subtype_id | definition parent subtype id | A Foreign Key to the Definition Subtype table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_type_name | Definition Type Name | The unique string identifier for an instance of Definition Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | max_in_parent | Maximum In Parent | A Foreign Key to the Definition Subtype table. | int |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | defn_type_name | Definition Type Name | The unique string identifier for an instance of Definition Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_type_descr | Definition Type Description | A descriptive name of the Definition Type. This descriptive name may be localized. | varchar(512) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | role_grp_id | Role Group Id | The automatically generated primary key of the role_grp table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | role_grp_name | Role Group Name | The name of the Role Group. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | role_grp_descr | Role Group Description | A descriptive name of the Role Group. This descriptive name may be localized. | varchar(512) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | user_prof_id | User Profile Id | A Foreign Key to the User Profile table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | user_prof_id | User Profile Id | A Foreign Key to the User Profile table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | user_prof_id | User Profile Id | A Foreign Key to the User Profile table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | is_sys_admin | Is System Administrator | Indicates if Is System Administrator. | char(1) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | user_prof_id | User Profile Id | A Foreign Key to the User Profile table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 15 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | user_prof_id | User Profile Id | The automatically generated primary key of the user_prof table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | tmpl_user_prof_id | 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. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | role_grp_id | 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. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. Optionally, the container that owns the profile. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | app_role_id | 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. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | agent_authcn_type_id | Agent Authentication Type Id | A Foreign Key to the Agent Authentication Type table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | user_prof_name | User Profile Name | The name of the User Profile. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | is_built_in | Is Built In | Indicates that this instance of User Profile is a built-in instance that cannot be changed by the end user. | bit | ||||||||||||||||||||||||||||||||||||||||||||||
. | user_type_id | User Type Id | A Foreign Key to the User Type table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | cust_authcn_type_id | Customer Authentication Type Id | A Foreign Key to the Customer Authentication Type table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | is_sys | Is System | Indicates if this is a system level profile. | bit | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_subtype_id | Definition Subtype Id | A Foreign Key to the Definition Subtype table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | delete_date | Delete Date | The value of a User Profile, stored as a date. | datetime | ||||||||||||||||||||||||||||||||||||||||||||||
. | last_login | Last Login | date time of last login in UTC. | datetime | ||||||||||||||||||||||||||||||||||||||||||||||
. | tmpl_level_name | tmpl_level_name | The value of a Built_in_level, stored as a string. | varchar(255) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | user_type_name | User Type Name | The name of the User Type. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | user_type_id | User Type Id | The automatically generated primary key of the user_type table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | user_type_descr | User Type Description | A descriptive name of the User Type. This descriptive name may be localized. | varchar(512) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 1 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | user_prof_id | User Profile Id | A Foreign Key to the User Profile table. | bigint |