Subject Area : 070 - User
Subject Area Name Definition
070 - User The agent or customer application user and types.
ER Diagram Name Physical Display Level
Logical Column
Physical Column
Physical Name Entity/Table Name Logical Only Do Not Generate Definition
agent Agent true true a user authorized to use the FootPrints agent functions, which enable the agent to provide services to the customer. These include the ability to edit, escalate, and close tickets.
Physical Name Attribute/Column Name Definition Physical Data Type
lic_type_id License Type Id A Foreign Key to the License Type table. bigint
app_user_id Application User Id A Foreign Key to the Application User table. bigint
anonymous_cust Anonymous Customer true true a generic guest user account for users that do not have a unique identity in the system. Typically, this user has read only access to browse the knowledge base.
Physical Name Attribute/Column Name Definition Physical Data Type
app_user_id Application User Id A Foreign Key to the Application User table. bigint
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.
Physical Name Attribute/Column Name Definition Physical Data Type
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
app_user_prof_link Application User Profile Link false The link between the application user and the user profile.
Physical Name Attribute/Column Name Definition Physical Data Type
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
cust Customer true true a user authorized to use the FootPrints customer functions. This includes the ability to enter requests, and interact with requests as they are worked by Agents.
Physical Name Attribute/Column Name Definition Physical Data Type
cust_login_type_id Customer Login Type Id A Foreign Key to the Customer Login Type table. int
app_user_id Application User Id A Foreign Key to the Application User table. bigint
cust_login_type Customer Login Type false A lookup table for the customer login type. It identifies the method of authenticating customer users.
Physical Name Attribute/Column Name Definition Physical Data Type
cust_login_type_name Customer Login Type Name The name of the Customer Login Type. varchar(255)
cust_login_type_id Customer Login Type Id The automatically generated primary key of the cust_login_type table. int
lic_type License Type false A lookup table for the type of FootPrints license. Must be secure from tampering.
Physical Name Attribute/Column Name Definition Physical Data Type
lic_type_id License Type Id The automatically generated primary key of the lic_type table. bigint
shared_cust Shared Customer true true A shared customer does not have a unique identity at login, but uses a customer account with permissions according to this shared customer identity.
Physical Name Attribute/Column Name Definition Physical Data Type
app_user_id Application User Id A Foreign Key to the Application User table. bigint
unique_cust Unique Customer true true A unique customer has a unique identity in the system either before identification or once authentication is performed.
Physical Name Attribute/Column Name Definition Physical Data Type
app_user_id Application User Id A Foreign Key to the Application User table. bigint
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.
Physical Name Attribute/Column Name Definition Physical Data Type
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)