Difference between revisions of "SSMT: Task View-Users"
Jump to navigation
Jump to search
John.Buckley (talk | contribs) |
|||
(6 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
+ | [[Category:SSMT|Task View-Users]] | ||
==Description== | ==Description== | ||
This category is used to assign task views to users via the [[SSMT 101: How to Load and Extract using SSMT|SSMT]] tool. Below are the descriptions of each column based on 11.1.1 | This category is used to assign task views to users via the [[SSMT 101: How to Load and Extract using SSMT|SSMT]] tool. Below are the descriptions of each column based on 11.1.1 | ||
− | ==Column | + | Stored Procedures used: |
+ | *Extracting data: IMPGetUserTaskViews | ||
+ | *Loading data: IMPSetUserTaskViews | ||
+ | |||
+ | ==Column Listing and Descriptions:== | ||
* '''*HDRAUsername''' - The task view will appear in this user's dropdown | * '''*HDRAUsername''' - The task view will appear in this user's dropdown | ||
Limitations: Must be an existing username | Limitations: Must be an existing username | ||
− | * '''Name''' - | + | * '''Name''' - Task View Name. This is the unique identifier for the task view. |
Limitations: Must be an existing task name | Limitations: Must be an existing task name | ||
* '''Task Owner''' - (?) | * '''Task Owner''' - (?) | ||
− | Limitations: | + | Limitations: Must match the UN that created the Task if other than IDX Admin |
− | * '''Subsystem''' - | + | * '''Subsystem''' - CF |
Limitations: | Limitations: | ||
− | * '''Subset''' - | + | * '''Subset''' - WF |
Limitations: | Limitations: | ||
− | * '''Section''' - | + | * '''Section''' - TaskList |
Limitations: | Limitations: | ||
Latest revision as of 00:31, 27 November 2012
Description
This category is used to assign task views to users via the SSMT tool. Below are the descriptions of each column based on 11.1.1
Stored Procedures used:
- Extracting data: IMPGetUserTaskViews
- Loading data: IMPSetUserTaskViews
Column Listing and Descriptions:
- *HDRAUsername - The task view will appear in this user's dropdown
Limitations: Must be an existing username
- Name - Task View Name. This is the unique identifier for the task view.
Limitations: Must be an existing task name
- Task Owner - (?)
Limitations: Must match the UN that created the Task if other than IDX Admin
- Subsystem - CF
Limitations:
- Subset - WF
Limitations:
- Section - TaskList
Limitations:
- OrganizationID - (?)
Limitations:
- IsDefault - Sets view as default view for the user
Limitations: Must be Y or N. Only one row per user can be Y
- Create (Y N) - adds the row to the existing table
Limitations: 'N' or 'Y'. Set to Y only for the rows that are added. Do not change extracted rows from Y to N (?)