Subject Area : 071 - Team |
# | Name | Definition | ER Diagram | Entity/Table | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | ||||||||||||||||||||||||||||||||||||||||||||||||||
. | 071 - Team | Describe the Team of Agent Application Users and the Relationship to Assignment. | Details.. | Details.. |
# | Name | Physical Display Level | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | Logical | Column | ||||||||||||||||||||||||||||||||||||||||||||||||
. | Physical | Column |
# | Physical Name | Name | Logical Only | Do Not Generate | Definition | Attribute/Column | ||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 9 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | agent_team | Agent Team | false | The list of Agent team members for a given team. | 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.. | |||||||||||||||||||||||||||||||||||||||||||||
. | asgnmt | Assignment | false | The current state and historical record of responsibility for a ticket. Regular assignments involve all parties that share responsibility for the ticket and are interested potentially in notifications. Primary Assignments additionally indicate that one and only one userid is responsible for the ticket for a span of time. A userid will have a span of Primary Assignment that is within the boundaries of his regular non-Primary Assignment. It is expected that an individual would have a single large span of time, possibly the life of the ticket, as a regular assignment. The individual may have zero, one, or more periods of PrimaryAssignment, stored as additional records. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | asgnmt_type | Assignment Type | false |
The assignment type indicates the notification level of the assignment. The current types consist of the following: Regular Assignment, CC Assignment, Primary Assignment . |
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.. | |||||||||||||||||||||||||||||||||||||||||||||
. | item | Item | true | true | The Item is the abstract class for Issue, Configuration Item, Address Book entry, and other information items that are the main information entities in FootPrints. The Item structure and behavior is defined by its Definition. The Item is namespaced, identified by, and logically stored in the single parent container. It can be referenced in the same manner both inside and outside the container. The Item is the storage model and the implementation for the Item Definition. There are many important specializations of the Item class, and there even more Template definitions of Container/Item that provide an end-user application experience to the End-User. The Item implementation must implement flexible schema in an easy to manage, well engineered, and high performing way. The item can store user-defined and user-named fields defined in its definition. The Item could implement the nice-to-have features such as an inheritance model for Item subtypes, and have the ability to represent collections of subordinate items. The Item data can be imported, exported, or synchronized with external data sources. The Item data can be linked and synchronized with other items in the same Instance. | Details.. | ||||||||||||||||||||||||||||||||||||||||||||
. | team | Team | false | A team is a group of application users that can be used in Team level assignments. | Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | team_email_notifn_type | Team Email Notification Type | false |
When Issues are assigned to this team, all members of the team will Receive email notifications for all activity on the Issue: Always Only when no individual agents are assigned Never (Note that email to members will follow the workspace preferences for assignees defined on the Mail Preferences page. Also, any individual assignees will receive mail according to the workspace preferences regardless of what teams are assigned.) |
Details.. | |||||||||||||||||||||||||||||||||||||||||||||
. | team_item_association | Team Item Association | false |
This contains the association between the team, the team assignment method and the item types. This is new functionality, as oposed to the current application that sets the assignment method directly on the team. The change was due to the new concept of multiple items in a workspace. |
Details.. |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | team_id | Team Id | A Foreign Key to the Team table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | agent_team_id | Agent Team Id | The automatically generated primary key of the agent_team table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | gets_individual_asgnmt_for_tea | Gets Individual Assignment for Team |
Indicates if this Agent Team() row is logically deleted. Igor S asked that this be nullable, and has not been able to find a place in the current Java code where it is being set at all. If the column will be used in the future a null can mean false, or the code can be changed to explicily set it to false. dnoble 12-4-12 |
bit | ||||||||||||||||||||||||||||||||||||||||||||||
. | app_user_id | Application User Id | A Foreign Key to the Application User table. | bigint |
# | 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 | 13 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | asgnmt_id | Assignment Id | The automatically generated primary key of the asgnmt table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | item_defn_id | Item Definition Id | A Foreign Key to the Definition table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | team_id | Team Id | A Foreign Key to the Team table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | begin_date | Begin Date | The value of a Assignment, stored as a date. | datetime | ||||||||||||||||||||||||||||||||||||||||||||||
. | end_date | End Date | The value of a Assignment, stored as a date. | datetime | ||||||||||||||||||||||||||||||||||||||||||||||
. | asgnmt_type_id | Assignment Type Id | A Foreign Key to the Assignment Type table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | app_user_id | Application User Id | A Foreign Key to the Application User table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | cc_email_addr | CC Email Address | Cannot be used with TeamId,App_user_id, can only be used with CC Assignment | nvarchar(4000) | ||||||||||||||||||||||||||||||||||||||||||||||
. | sort_order | Sort Order | The value of a Assignment stored as boolean. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | item_id | Item Id | A Foreign Key to the Item table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | is_team | Is Team | Special clarifying field of "Is Team Level Assignment" to state that the Team does not have to be immediately resolved to a Team+Individual. | bit | ||||||||||||||||||||||||||||||||||||||||||||||
. | delete_txn_id | Delete Transaction Id | A unique incremental transaction identifier that indicates a soft delete. The id is generated via id generation, and may or may not correspond to the audit trail transaction id. This method of marking the soft delete allows for a unique index to be created on the Workspace Definition Id, Team Name, and Delete Transaction Id to enforce no duplicates in the live copies, and it allows multiple soft deleted rows with the same team name. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | field_id | Field Id | A Foreign Key to the Definition table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | asgnmt_type_id | Assignment Type Id | The automatically generated primary key of the asgnmt_type table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | asgnmt_type_name | Assignment Type Name | The name of the Assignment Type. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | asgnmt_type_descr | Assignment Type Description | A descriptive name of the Assignment Type. This descriptive name may be localized. | varchar(512) |
# | 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 | 4 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | item_key | Item Key | A search key for the Item, composed of letters and numbers. | varchar(255) | ||||||||||||||||||||||||||||||||||||||||||||||
. | item_id | Item Id | The automatically generated primary key of the item table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | cntnr_id | Container Id | A Foreign Key to the Container table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | item_defn_id | Item Definition Id | A Foreign Key to the Definition table for an instance of type Definition. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 5 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | team_id | Team Id | The automatically generated primary key of the team table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | team_name | Team Name | The name of the Team. | nvarchar(4000) | ||||||||||||||||||||||||||||||||||||||||||||||
. | wksp_defn_id | Workspace Definition Id | A Foreign Key to the Definition table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | team_email_notifn_type_id | Team Email Notification Type Id | A Foreign Key to the Team Email Notification Type table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | team_lead_app_user_id | Team Lead Application User Id | A Foreign Key to the Application User table. | bigint |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 3 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | team_email_notifn_type_id | Team Email Notification Type Id | The automatically generated primary key of the team_email_notifn_type table. | int | ||||||||||||||||||||||||||||||||||||||||||||||
. | team_email_notifn_type_descr | Team Email Notification Type Description | A descriptive name of the Team Email Notification Type. This descriptive name may be localized. | varchar(512) | ||||||||||||||||||||||||||||||||||||||||||||||
. | team_email_notifn_type_name | Team Email Notification Type Name | The name of the Team Email Notification Type. | varchar(255) |
# | Physical Name | Name | Definition | Physical Data Type | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Total | 2 | |||||||||||||||||||||||||||||||||||||||||||||||||
. | team_id | Team Id | A Foreign Key to the Team table. | bigint | ||||||||||||||||||||||||||||||||||||||||||||||
. | defn_id | Definition Id | A Foreign Key to the Definition table. | bigint |