Difference between revisions of "SSMT: Task View-Users"
Jump to navigation
Jump to search
John.Buckley (talk | contribs) |
|||
| 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 | ||
| Line 15: | Line 16: | ||
* '''Task Owner''' - (?) | * '''Task Owner''' - (?) | ||
| − | Limitations: Must match the UN that created the Task if other than | + | Limitations: Must match the UN that created the Task if other than IDX Admin |
* '''Subsystem''' - CF | * '''Subsystem''' - CF | ||
| Line 34: | Line 35: | ||
* '''Create (Y N)''' - adds the row to the existing table | * '''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 (?) | Limitations: 'N' or 'Y'. Set to Y only for the rows that are added. Do not change extracted rows from Y to N (?) | ||
| − | |||
| − | |||
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 (?)