Difference between revisions of "SSMT: Task View-Users"
Jump to navigation
Jump to search
(New page: ==Description== This category is used to assign task views to users into TouchWorks via the SSMT tool. Below are the descriptions of each ...) |
John.Buckley (talk | contribs) |
||
(7 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 | + | 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 |
− | + | 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: | + | Limitations: Must be an existing username |
− | * ''' | + | * '''Name''' - Task View Name. This is the unique identifier for the task view. |
− | Limitations: | + | Limitations: Must be an existing task name |
− | * ''' | + | * '''Task Owner''' - (?) |
− | Limitations: Must | + | Limitations: Must match the UN that created the Task if other than IDX Admin |
− | * ''' | + | * '''Subsystem''' - CF |
− | Limitations: | + | Limitations: |
− | * ''' | + | * '''Subset''' - WF |
− | Limitations: | + | Limitations: |
− | * ''' | + | * '''Section''' - TaskList |
− | Limitations: | + | Limitations: |
− | * ''' | + | * '''OrganizationID''' - (?) |
− | Limitations: | + | 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 (?) | |
− | |||
− | |||
− | Limitations: 'N' or 'Y' | ||
− | |||
− | |||
− |
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 (?)